ATS考勤2.12考勤计算（额度扣减记录）

--建表脚本--

create table T_ATS_LIMITDEDUCTION(

FID int not null  comment 'FID'

,FHOLYDETAILSID int default null  comment 'FHOLYDETAILSID'

,FHOLYLIMITID int default null  comment 'FHOLYLIMITID'

,FUSEDLIMIT decimal(19,6) default null  comment 'FUSEDLIMIT'

,primary key (FID)

) comment = '额度扣减记录'

--查询--

select FID as "fid",FHOLYDETAILSID as "fholydetailsid",FHOLYLIMITID as "fholylimitid",FUSEDLIMIT as "fusedlimit" from T_ATS_LIMITDEDUCTION

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

select FID as "FID",FHOLYDETAILSID as "FHOLYDETAILSID",FHOLYLIMITID as "FHOLYLIMITID",FUSEDLIMIT as "FUSEDLIMIT" from T_ATS_LIMITDE