--应收月末处理编码
DELETE FROM t_cr_coderule WHERE FID = '0A7FRHZGORKI';
INSERT INTO t_cr_coderule(FID,FSTATUS,FDISABLERID,FRULETYPE,FMODIFYTIME,FENABLE,FDISABLEDATE,FNUMBER,FCTRLMODE,FEXAMPLELENGTH,FISUPDATERECOVER,FBIZOBJECTID,FCREATORID,FEXAMPLE,FMASTERID,FSPLITSIGN,FAPPMODE,FMODIFIERID,FCREATETIME) VALUES ('0A7FRHZGORKI','C',null,null,{ts'2018-08-08 18:08:08'},'1',null,' ','1',' ','0','ar_liquidation',1,' ','0A7FRHZGORKI','-','2',1,{ts'2018-08-08 18:08:08'}); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '0A7FRHZGOESO';
INSERT INTO t_cr_coderule_l(FPKID,FNAME,FLOCALEID,FID) VALUES ('0A7FRHZGOESO','应收月末清理单编码规则','zh_CN','0A7FRHZGORKI'); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '0A7FRHZGOESN';
INSERT INTO t_cr_coderule_l(FPKID,FNAME,FLOCALEID,FID) VALUES ('0A7FRHZGOESN','應收月末清理單編碼規則','zh_TW','0A7FRHZGORKI'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '0A7FRI+0F8QL';
INSERT INTO t_cr_coderuleentry(FCUTSTYLE,FENTRYID,FVALUEATRIBUTE,FADDCHAR,FADDSTYLE,FID,FSTEP,FATTRIBUTETYPE,FFORMAT,FSETTINGVALUE,FINITIAL,FLENGTH,FISVISABLE,FSPLITSIGN,FSEQ,FISSPLITSIGN,FISSORTITEM,FATTUSINGMODE) VALUES ('1','0A7FRI+0F8QL',' ',' ','1','0A7FRHZGORKI',1,'1','LIQ',' ',1,8,'1',' ',0,'0','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '0A7FRI+0F8QM';
INSERT INTO t_cr_coderuleentry(FCUTSTYLE,FENTRYID,FVALUEATRIBUTE,FADDCHAR,FADDSTYLE,FID,FSTEP,FATTRIBUTETYPE,FFORMAT,FSETTINGVALUE,FINITIAL,FLENGTH,FISVISABLE,FSPLITSIGN,FSEQ,FISSPLITSIGN,FISSORTITEM,FATTUSINGMODE) VALUES ('1','0A7FRI+0F8QM','createtime',' ','1','0A7FRHZGORKI',1,'2','yyMMdd',' ',1,8,'1','-',1,'1','0','1'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '0A7FRI+0F8QN';
INSERT INTO t_cr_coderuleentry(FCUTSTYLE,FENTRYID,FVALUEATRIBUTE,FADDCHAR,FADDSTYLE,FID,FSTEP,FATTRIBUTETYPE,FFORMAT,FSETTINGVALUE,FINITIAL,FLENGTH,FISVISABLE,FSPLITSIGN,FSEQ,FISSPLITSIGN,FISSORTITEM,FATTUSINGMODE) VALUES ('1','0A7FRI+0F8QN',' ',' ','1','0A7FRHZGORKI',1,'16',' ',' ',1,4,'1','-',2,'1','0','1'); 


