DELETE FROM T_CR_CODERULE WHERE FID = '0ZXKJDR8542D';
INSERT INTO T_CR_CODERULE(FID,FSPLITSIGN,FCTRLMODE,FEXAMPLE,FAPPMODE,FDISABLEDATE,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FENABLE,FMODIFIERID,FISUPDATERECOVER,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('0ZXKJDR8542D','-','1',' ','1',NULL,'0ZXKJDR8542D','C',' ',NULL,' ',{ts'2020-08-06  09:50:01'},'er_expensesharebill','1',13466739,'0',{ts'2020-08-06  09:50:01'},13466739,NULL); 

DELETE FROM T_CR_CODERULE_L WHERE FPKID = '0ZXKJDR899NZ';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('0ZXKJDR8542D','0ZXKJDR899NZ','zh_CN','费用分摊单编号规则');
DELETE FROM T_CR_CODERULE_L WHERE FPKID = '0ZXKJDR899NY';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('0ZXKJDR8542D','0ZXKJDR899NY','zh_TW','費用分攤單編碼規則'); 

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '0ZXKJDTYA5O9';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0ZXKJDR8542D',1,'1',' ','0','0ZXKJDTYA5O9',1,'1',' ',0,8,'1','FT',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '0ZXKJDTYA5O=';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0ZXKJDR8542D',1,'2','-','1','0ZXKJDTYA5O=',1,'1','1',1,8,'1','yyMMdd',' ','1','bizdate','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '0ZXKJDTYA5OA';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0ZXKJDR8542D',1,'16','-','0','0ZXKJDTYA5OA',1,'1','1',2,4,'1',' ',' ','1',' ','1',' '); 

