ATS考勤2.9考勤计算（请假单）

T_ATS_HOLY(请假单)
是否主键	字段名	字段描述	数据类型	长度	可空	缺省值	备注
✓	FID	主键	int			0
	FBILLNO	请假单号	nvarchar	30	✓
	FBILLTYPEID	单据类型	nvarchar	36	✓
	FMGRCENTERID	人事管理中心	int		✓
	FFORBIDSTATUS	作废状态	char	1	✓
	FAUDITORID	审核人	int		✓
	FCREATORID	创建人	int		✓
	FDOCUMENTSTATUS	单据状态	char	1	✓
	FMODIFYDATE	修改日期	datetime		✓
	FFORBIDDATE	作废日期	datetime		✓
	FAUDITDATE	审核日期	datetime		✓
	FCREATEDATE	创建日期	datetime		✓
	FMODIFIERID	修改人	int		✓
	FFORBIDDERID	作废人	int		✓
	FPRIMARYORGID	主业务组织	int		✓
	FSTAFFID	员工信息	int		✓
	FPERSONID	人员信息	int		✓
	FDOCID	职员姓名	int		✓
	FHOLYTYPE	假期类型	int		✓
	FPLANTIMESPAN	计划时间长度	decimal	19,6	✓
	FHOLYTYPEUNIT	假期单位	nvarchar	30	✓
	FSTARTDATE	开始日期	datetime		✓
	FREALTIMESPAN	实际时间长度	decimal	19,6	✓
	FENDDATE	结束日期	datetime		✓
	FAPPLYDATE	申请日期	datetime		✓
	FSTARTTIME	开始时间	datetime		✓
	FENDTIME	结束时间	datetime		✓
	FREALSTARTTIME	请假开始时间	datetime		✓
	FREALENDTIME	请假结束时间	datetime		✓
	FISWHOLEDAY	是否整天	nvarchar	30	✓

--建表脚本--

create table T_ATS_HOLY(

FID int not null comment '主键'

,FBILLNO nvarchar(30) default null comment '请假单号'

,FBILLTYPEID nvarchar(36) default null comment '单据类型'

,FMGRCENTERID int default null comment '人事管理中心'

,FFORBIDSTATUS char(1) default null comment '作废状态'

,FAUDITORID int default null comment '审核人'

,FCREATORID int default null comment '创建人'

,FDOCUMENTSTATUS char(1) default null comment '单据状态'

,FMODIFYDATE datetime default null comment '修改日期'

,FFORBIDDATE datetime default null comment '作废日期'

,FAUDITDATE datetime default null comment '审核日期'

,FCREATEDATE datetime default null comment '创建日期'

,FMODIFIERID int default null comment '修改人'

,FFORBIDDERID int default null comment '作废人'

,FPRIMARYORGID int default null comment '主业务组织'

,FSTAFFID int default null comment '员工信息'

,FPERSONID int default null comment '人员信息'

,FDOCID int default null comment '职员姓名'

,FHOLYTYPE int default null comment '假期类型'

,FPLANTIMESPAN decimal(19,6) default null comment '计划时间长度'

,FHOLYTYPEUNIT nvarchar(30) default null comment '假期单位'

,FSTARTDATE datetime default null comment '开始日期'

,FREALTIMESPAN decimal(19,6) default null comment '实际时间长度'

,FENDDATE datetime default null comment '结束日期'

,FAPPLYDATE datetime default null comment '申请日期'

,FSTARTTIME datetime default null comment '开始时间'

,FENDTIME datetime default null comment '结束时间'

,FREALSTARTTIME datetime default null comment '请假开始时间'

,FREALENDTIME datetime default null comment '请假结束时间'

,FISWHOLEDAY nvarchar(30) default null comment '是否整天'

,primary key (FID)

) comment = '请假单'

--查询--

select FID as "fid",FBILLNO as "fbillno",FBILLTYPEID as "fbilltypeid",FMGRCENTERID as "fmgrcenterid",FFORBIDSTATUS as "fforbidstatus",FAUDITORID as "fauditorid",FCREATORID as "fcreatorid",FDOCUMENTSTATUS as "fdocumentstatus",FMODIFYDATE as "fmodifydate",FFORBIDDATE as "fforbiddate",FAUDITDATE as "fauditdate",FCREATEDATE as "fcreatedate",FMODIFIERID as "fmodifierid",FFORBIDDERID as "fforbidderid",FPRIMARYORGID as "fprimaryorgid",FSTAFFID as "fstaffid",FPERSONID as "fpersonid",FDOCID as "fdocid",FHOLYTYPE as "fholytype",FPLANTIMESPAN as "fplantimespan",FHOLYTYPEUNIT as "fholytypeunit",FSTARTDATE as "fstartdate",FREALTIMESPAN as "frealtimespan",FENDDATE as "fenddate",FAPPLYDATE as "fapplydate",FSTARTTIME as "fstarttime",FENDTIME as "fendtime",FREALSTARTTIME as "frealstarttime",FREALENDTIME as "frealendtime",FISWHOLEDAY as "fiswholeday" from T_ATS_HOLY

--查询(中文字段)--

select FID as "主键",FBILLNO as "请假单号",FBILLTYPEID as "单据类型",FMGRCENTERID as "人事管理中心",FFORBIDSTATUS as "作废状态",FAUDITORID as "审核人",FCREATORID as "创建人",FDOCUMENTSTATUS as "单据状态",FMODIFYDATE as "修改日期",FFORBIDDATE as "作废日期",FAUDITDATE as "审核日期",FCREATEDATE as "创建日期",FMODIFIERID as "修改人",FFORBIDDERID as "作废人",FPRIMARYORGID as "主业务组织",FSTAFFID as "员工信息",FPERSONID as "人员

ATS考勤2.9考勤计算（请假单）

ATS考勤2.9考勤计算（请假单）

相关阅读

栏目

最新发布

热门标签