数据表:T_PA_SALARYACTHISTORYRNTRY(薪酬账户变更历史明细)

T_PA_SALARYACTHISTORYRNTRY(薪酬账户变更历史明细):描述

名称

T_PA_SALARYACTHISTORYRNTRY(薪酬账户变更历史明细)

代码

T_PA_SALARYACTHISTORYRNTRY

注释

 

模型

PA

主键

PK_PA_SALARYACTHISENTRY


T_PA_SALARYACTHISTORYRNTRY(薪酬账户变更历史明细):列规格定义

名称

代码

数据类型

长度

强制

注释

薪酬账户历史内码

FID

int

 

FALSE

 

分录内码

FENTRYID

int

 

TRUE

 

薪酬标准

FSALARYSTANDARDID

int

 

FALSE

 

项目值

FPAYITEMVALUE

decimal(23,10)

23

FALSE

 

生效日期

FSTARTDATE

datetime

 

FALSE

 

停用日期

FENDDATE

datetime

 

FALSE

 

数据来源

FDATASOURCE

varchar(20)

20

FALSE

 

薪酬标准表

FSALARYSTANDID

int

 

FALSE

 

单据编号

FBILLNUMBER

nvarchar(50)

50

FALSE

 

薪酬项目

FPAYITEMID

int

 

FALSE

 


T_PA_SALARYACTHISTORYRNTRY(薪酬账户变更历史明细):脚本代码

if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('T_PA_SALARYACTHISTORYRNTRY') and o.name = 'FK_T_PA_SALARYACTHISTORYENTRY')
alter table T_PA_SALARYACTHISTORYRNTRY
drop constraint FK_T_PA_SALARYACTHISTORYENTRY
go

if exists (select 1
from sysindexes
where id = object_id('T_PA_SALARYACTHISTORYRNTRY')
and name = 'IDX_PA_SALARYACTHISENTRY'
and indid > 0
and indid < 255)
drop index T_PA_SALARYACTHISTORYRNTRY.IDX_PA_SALARYACTHISENTRY
go

if exists (select 1
from sysobjects
where id = object_id('T_PA_SALARYACTHISTORYRNTRY')
and type = 'U')
drop table T_PA_SALARYACTHISTORYRNTRY
go

/*==============================================================*/
/* Table: T_PA_SALARYACTHISTORYRNTRY */
/*==============================================================*/
create table T_PA_SALARYACTHISTORYRNTRY (
FID int null,
FENTRYID int not null default 0,
FSALARYSTANDARDID int null,
FPAYITEMVALUE decimal(23,10) null,
FSTARTDATE datetime null,
FENDDATE datetime null,
FDATASOURCE varchar(20) null,
FSALARYSTANDID int null,
FBILLNUMBER nvarchar(50) null,
FPAYITEMID int null,
constraint PK_T_PA_SALARYACTHISTORYRNTRY primary key (FENTRYID)
)
go

/*==============================================================*/
/* Index: IDX_PA_SALARYACTHISENTRY */
/*==============================================================*/
create index IDX_PA_SALARYACTHISENTRY on T_PA_SALARYACTHISTORYRNTRY (
FID ASC
)
go

alter table T_PA_SALARYACTHISTORYRNTRY
add constraint FK_T_PA_SALARYACTHISTORYENTRY foreign key (FID)
references T_PA_SALARYACCOUNTHISTORY (FID)
go


T_PA_SALARYACTHISTORYRNTRY(薪酬账户变更历史明细):键值定义

名称

代码

主要的

PK_PA_SALARYACTHISENTRY

PK_PA_SALARYACTHISENTRY

TRUE


T_PA_SALARYACTHISTORYRNTRY(薪酬账户变更历史明细):索引定义

名称

代码

唯一的

群集器

主要的

外键

候选键

表格

IDX_PA_SALARYACTHISENTRY

IDX_PA_SALARYACTHISENTRY

FALSE

FALSE

FALSE

TRUE

FALSE

T_PA_SALARYACTHISTORYRNTRY(薪酬账户变更历史明细)