-- 汇总核定单编码规则
DELETE FROM T_CR_CODERULE WHERE FID = '37TUOV1WWQ3K';
INSERT INTO T_CR_CODERULE(FFILTERCONDITION,FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID,FCONDITIONDESC) VALUES (' ',' ','2','1','0','37TUOV1WWQ3K','0',NULL,'0',{ts'2023-04-20  00:00:00'},'hpdi_summaryvbill','1','0','0','1',NULL,'0','37TUOV1WWQ3K','-','1',NULL,'0','C','37TUJZADEE3Q',' ','1',1632628417327399936,'0',{ts'2023-04-20  00:00:00'},0,' '); 

DELETE FROM T_CR_CODERULE_L WHERE FPKID = '37TUOV1WUNAT';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('37TUOV1WWQ3K','37TUOV1WUNAT','zh_CN','薪酬核定单_单据编号'); 

DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '37TUOV2MX0NO';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('37TUOV1WWQ3K',1,'1',' ','0','37TUOV2MX0NO',1,'1','1',0,8,'1','HD',' ','1',' ','0',' '); 
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '37TUOV2MX0NP';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('37TUOV1WWQ3K',1,'9','-','1','37TUOV2MX0NP',1,'1',' ',1,8,'1','yyyyMMdd',' ','1',' ','1',' '); 
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '37TUOV2MX0NQ';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('37TUOV1WWQ3K',1,'16','-','0','37TUOV2MX0NQ',1,'1',' ',2,5,'1',' ',' ','1',' ','1',' '); 



