数据表:T_PA_ADJUSTBILLENTRY(调薪单明细表)

T_PA_ADJUSTBILLENTRY(调薪单明细表):描述

名称

T_PA_ADJUSTBILLENTRY(调薪单明细表)

代码

T_PA_ADJUSTBILLENTRY

注释

 

模型

PA

主键

PK_PA_ADJUSTBILLENTRY


T_PA_ADJUSTBILLENTRY(调薪单明细表):列规格定义

名称

代码

数据类型

长度

强制

注释

调薪单内码

FID

int

 

FALSE

 

分录内码

FENTRYID

int

 

TRUE

 

顺序号

FORDERNUMBER

nvarchar(50)

50

FALSE

 

调薪项目

FPAYITEMID

int

 

FALSE

 

调前值

FOLDVALUE

nvarchar(50)

50

FALSE

 

薪酬标准表id

FITEMSALARYSTANDARDID

int

 

FALSE

 

调后值

FNEWVALUE

nvarchar(50)

50

FALSE

 

生效日期

FSTARTDATE

datetime

 

FALSE

 

调整额度

FADJUSTAMOUNT

decimal(23,10)

23

FALSE

 

调整比例

FADJUSTRATIO

nvarchar(50)

50

FALSE

 

薪级id

FSALARYSCALEID

int

 

FALSE

 

薪级项目id

FSCALEITEMID

int

 

FALSE

 

参考范围

FREFERSCOPE

nvarchar(50)

50

FALSE

 

输入类型

FINPUTTYPE

char(1)

1

FALSE

 

初始值类型

FSTARTVALTYPE

char(1)

1

FALSE

 

是否可编辑

FISEDITABLE

char(1)

1

FALSE

 

是否必填

FISREQUIRED

char(1)

1

FALSE

 

值类型

FVALUETYPE

char(1)

1

FALSE

 

薪酬标准id

FSALARYSTANDARDID

int

 

FALSE

 

薪酬标准物理表名

FSTDTABLENAME

nvarchar(50)

50

FALSE

 

控制限制类型

FCONTROLTYPE

char(1)

1

FALSE

 

非标准表是否必填

FISNOSTDREQUIRED

char(1)

1

FALSE

 


T_PA_ADJUSTBILLENTRY(调薪单明细表):脚本代码

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_ADJUSTBILLENTRY') and o.name = 'FK_T_PA_ADJUSTSALARYBILLENTRY')
alter table T_PA_ADJUSTBILLENTRY
drop constraint FK_T_PA_ADJUSTSALARYBILLENTRY
go

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_ADJUSTBILLENTRY_L') and o.name = 'FK_T_PA_ADJ_FK_PA_ADJ_T_PA_ADJ')
alter table T_PA_ADJUSTBILLENTRY_L
drop constraint FK_T_PA_ADJ_FK_PA_ADJ_T_PA_ADJ
go

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

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

/*==============================================================*/
/* Table: T_PA_ADJUSTBILLENTRY */
/*==============================================================*/
create table T_PA_ADJUSTBILLENTRY (
FID int null,
FENTRYID int not null default 0,
FORDERNUMBER nvarchar(50) null,
FPAYITEMID int null,
FOLDVALUE nvarchar(50) null,
FITEMSALARYSTANDARDID int null,
FNEWVALUE nvarchar(50) null,
FSTARTDATE datetime null,
FADJUSTAMOUNT decimal(23,10) null,
FADJUSTRATIO nvarchar(50) null,
FSALARYSCALEID int null,
FSCALEITEMID int null,
FREFERSCOPE nvarchar(50) null,
FINPUTTYPE char(1) null,
FSTARTVALTYPE char(1) null,
FISEDITABLE char(1) null,
FISREQUIRED char(1) null,
FVALUETYPE char(1) null,
FSALARYSTANDARDID int null,
FSTDTABLENAME nvarchar(50) null,
FCONTROLTYPE char(1) null,
FISNOSTDREQUIRED char(1) null,
constraint PK_PA_ADJUSTYBILLENTRY primary key (FENTRYID)
)
go

/*==============================================================*/
/* Index: IDX_PA_ADJUSTBILLENTRY */
/*==============================================================*/
create index IDX_PA_ADJUSTBILLENTRY on T_PA_ADJUSTBILLENTRY (
FID ASC
)
go

alter table T_PA_ADJUSTBILLENTRY
add constraint FK_T_PA_ADJUSTSALARYBILLENTRY foreign key (FID)
references T_PA_ADJUSTSALARYBILL (FID)
go


T_PA_ADJUSTBILLENTRY(调薪单明细表):键值定义

名称

代码

主要的

PK_PA_ADJUSTBILLENTRY

PK_PA_ADJUSTBILLENTRY

TRUE


T_PA_ADJUSTBILLENTRY(调薪单明细表):索引定义

名称

代码

唯一的

群集器

主要的

外键

候选键

表格

IDX_PA_ADJUSTBILLENTRY

IDX_PA_ADJUSTBILLENTRY

FALSE

FALSE

FALSE

TRUE

FALSE

T_PA_ADJUSTBILLENTRY(调薪单明细表)