
DELETE FROM t_cr_coderule WHERE fid = '1VD9//TLKSR=';
INSERT INTO t_cr_coderule(fid,fctrlmode,fsplitsign,fexample,fdisabledate,fappmode,fmasterid,fstatus,fnumber,fruletype,fexamplelength,fcreatetime,fbizobjectid,fenable,fisupdaterecover,fmodifierid,fmodifytime,fcreatorid,fdisablerid) VALUES ('1VD9//TLKSR=','1','-',' ',NULL,'2','1VD9//TLKSR=','C','1VD8Y4OPF555',NULL,' ',{ts'2021-08-28  00:00:00'},'ifm_currentintbill','1','0',13466739,{ts'2021-09-06  00:00:00'},13466739,NULL); 
DELETE FROM t_cr_coderule_l WHERE fpkid = '1VD9//TLJ1EN';
INSERT INTO t_cr_coderule_l(fid,fpkid,flocaleid,fname) VALUES ('1VD9//TLKSR=','1VD9//TLJ1EN','zh_CN','存款结息处理'); 
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1W6LQH+YJLU9';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fcutstyle,fstep,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1VD9//TLKSR=',1,'8',' ','0','1W6LQH+YJLU9','1',1,'3',0,'1',8,' ','1',' ','batchno','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1W6LQH+YJLU=';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fcutstyle,fstep,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1VD9//TLKSR=',1,'1',' ','0','1W6LQH+YJLU=','1',1,' ',1,'1',8,'DE','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1W6LQH+YJLUB';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fcutstyle,fstep,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1VD9//TLKSR=',1,'16',' ','0','1W6LQH+YJLUB','1',1,' ',3,'1',6,' ','1',' ',' ','0',' '); 


DELETE FROM t_cr_coderule WHERE fid = '1VNF98I0VKXX';
INSERT INTO t_cr_coderule(fid,fctrlmode,fsplitsign,fexample,fdisabledate,fappmode,fmasterid,fstatus,fnumber,fruletype,fexamplelength,fcreatetime,fbizobjectid,fmodifierid,fisupdaterecover,fenable,fmodifytime,fcreatorid,fdisablerid) VALUES ('1VNF98I0VKXX','1','-',' ',NULL,'2','1VNF98I0VKXX','C','1VNF5706X5JH',NULL,' ',{ts'2021-08-31  00:00:00'},'ifm_intbill_batch_current',0,'0','1',{ts'2021-08-31  00:00:00'},0,NULL); 
DELETE FROM t_cr_coderule_l WHERE fpkid = '1VNF98I4H1TG';
INSERT INTO t_cr_coderule_l(fid,fpkid,flocaleid,fname) VALUES ('1VNF98I0VKXX','1VNF98I4H1TG','zh_CN','存款结息处理批量编码规则'); 
DELETE FROM t_cr_coderule_l WHERE fpkid = '1VNF98I4H1TF';
INSERT INTO t_cr_coderule_l(fid,fpkid,flocaleid,fname) VALUES ('1VNF98I0VKXX','1VNF98I4H1TF','zh_TW','存款結息處理批量編碼規則'); 
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1VNF98JMHN6M';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fcutstyle,fstep,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1VNF98I0VKXX',1,'1',' ','0','1VNF98JMHN6M','1',1,'1',0,'1',8,'BD','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1VNF98JMHN6N';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fcutstyle,fstep,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1VNF98I0VKXX',1,'2',' ','0','1VNF98JMHN6N','1',1,' ',1,'1',8,'yyyyMMdd','1',' ','createtime','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1VNF98JMHN6O';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fcutstyle,fstep,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1VNF98I0VKXX',1,'16',' ','0','1VNF98JMHN6O','1',1,' ',2,'1',7,' ','1',' ',' ','0',' '); 


DELETE FROM t_cr_coderule WHERE fid = '1W6C4X8N/T7Q';
INSERT INTO t_cr_coderule(fid,fctrlmode,fsplitsign,fexample,fdisabledate,fappmode,fmasterid,fstatus,fnumber,fruletype,fexamplelength,fcreatetime,fbizobjectid,fmodifierid,fisupdaterecover,fenable,fmodifytime,fcreatorid,fdisablerid) VALUES ('1W6C4X8N/T7Q','1','-',' ',NULL,'2','1W6C4X8N/T7Q','C','1W6C2YM0WTTN',NULL,' ',{ts'2021-09-06  00:00:00'},'ifm_intbill_batch_loan',0,'0','1',{ts'2021-09-06  00:00:00'},0,NULL); 
DELETE FROM t_cr_coderule_l WHERE fpkid = '1W6C4X8N/VXR';
INSERT INTO t_cr_coderule_l(fid,fpkid,flocaleid,fname) VALUES ('1W6C4X8N/T7Q','1W6C4X8N/VXR','zh_CN','贷款结息处理'); 
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1W6C4X96S=CT';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fcutstyle,fstep,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1W6C4X8N/T7Q',1,'1',' ','0','1W6C4X96S=CT','1',1,'1',0,'1',8,'BL','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1W6C4X96S=CU';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fcutstyle,fstep,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1W6C4X8N/T7Q',1,'9','-','0','1W6C4X96S=CU','1',1,' ',1,'1',8,'yyyyMMdd','1',' ',' ','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1W6C4X96S=CV';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fcutstyle,fstep,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1W6C4X8N/T7Q',1,'16','-','0','1W6C4X96S=CV','1',1,' ',2,'1',7,' ','1',' ',' ','1',' '); 

DELETE FROM t_cr_coderule WHERE fid = '1W=ONLUF/U1I';
INSERT INTO t_cr_coderule(fid,fctrlmode,fsplitsign,fexample,fdisabledate,fappmode,fmasterid,fstatus,fnumber,fruletype,fexamplelength,fcreatetime,fbizobjectid,fmodifierid,fisupdaterecover,fenable,fmodifytime,fcreatorid,fdisablerid) VALUES ('1W=ONLUF/U1I','1','-',' ',NULL,'2','1W=ONLUF/U1I','C','1W=OATQX8PX/',NULL,' ',{ts'2021-09-07  00:00:00'},'ifm_interestbill',13466739,'0','1',{ts'2021-09-08  00:00:00'},0,NULL); 
DELETE FROM t_cr_coderule_l WHERE fpkid = '1W=ONLUF/SQ0';
INSERT INTO t_cr_coderule_l(fid,fpkid,flocaleid,fname) VALUES ('1W=ONLUF/U1I','1W=ONLUF/SQ0','zh_CN','贷款结息处理编码规则'); 
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1WC9K3ZNIDET';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1W=ONLUF/U1I',1,'8',' ','0','1WC9K3ZNIDET',1,'1','3',0,'1',8,' ','1',' ','batchno','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1WC9K3ZNIDEU';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1W=ONLUF/U1I',1,'1',' ','0','1WC9K3ZNIDEU',1,'1','1',1,'1',8,'DE','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1WC9K3ZNIDEV';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1W=ONLUF/U1I',1,'16',' ','0','1WC9K3ZNIDEV',1,'1',' ',2,'1',6,' ','1',' ',' ','0',' '); 
