/**抵销模板编码规则**/
DELETE FROM t_cr_coderule WHERE FID = '04ZQSOLIKQM5';
INSERT INTO t_cr_coderule(FID,FSTATUS,FDISABLERID,FRULETYPE,FMODIFYTIME,FENABLE,FDISABLEDATE,FCTRLMODE,FEXAMPLELENGTH,FNUMBER,FISUPDATERECOVER,FBIZOBJECTID,FCREATORID,FEXAMPLE,FMASTERID,FSPLITSIGN,FAPPMODE,FMODIFIERID,FCREATETIME) VALUES ('04ZQSOLIKQM5','C',null,null,{ts'2019-08-13  16:39:36'},'1',null,'1',' ',' ','1','bcm_invelimtemplate',89559110,' ','04ZQSOLIKQM5','-','3',89559110,{ts'2019-08-13  14:52:40'}); 


DELETE FROM t_cr_coderule_l WHERE FPKID = '04ZQSOLIL/D=';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('04ZQSOLIKQM5','04ZQSOLIL/D=','zh_CN','权益抵销模板编码规则'); 

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '05++UUQW=Z7=';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('04ZQSOLIKQM5',1,'1',' ','0','05++UUQW=Z7=',1,'1','1',0,8,'1','ES',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '05++UUQW=Z7A';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('04ZQSOLIKQM5',1,'2',' ','0','05++UUQW=Z7A',1,'1','1',1,8,'1','yyyyMM',' ','1','createtime','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '05++UUQW=Z7B';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('04ZQSOLIKQM5',1,'16',' ','0','05++UUQW=Z7B',1,'1','1',2,2,'1',' ',' ','1',' ','0',' '); 


