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-11-22  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_coderule_l WHERE FPKID = '210TIJPS/358';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1VD9//TLKSR=','210TIJPS/358','zh_TW','存款結息處理預置編碼規則'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '210TIJQSWM93';
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',' ','1','210TIJQSWM93','1',1,'3',0,'1',8,' ','1',' ','batchno','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '210TIJQSWM94';
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','210TIJQSWM94','1',1,' ',1,'1',8,'DE','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '210TIJQSWM95';
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','210TIJQSWM95','1',1,' ',2,'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,FENABLE,FISUPDATERECOVER,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('1VNF98I0VKXX','1','-',' ',NULL,'2','1VNF98I0VKXX','C','1VNF5706X5JH',NULL,' ',{ts'2021-08-31  00:00:00'},'ifm_intbill_batch_current','1','0',13466739,{ts'2021-11-22  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_coderuleentry WHERE FENTRYID = '210TKWXBJJ1D';
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','210TKWXBJJ1D','1',1,'1',0,'1',8,'BD','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '210TKWXBJJ1E';
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',' ','1','210TKWXBJJ1E','1',1,' ',1,'1',8,'yyyyMMdd','1',' ','createtime','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '210TKWXBJJ1F';
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','210TKWXBJJ1F','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,FENABLE,FISUPDATERECOVER,FMODIFIERID,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','1','0',13466739,{ts'2021-11-22  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_coderule_l WHERE FPKID = '210TMQPKBDWI';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1W6C4X8N/T7Q','210TMQPKBDWI','zh_TW','貸款結息處理預置編碼規則'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '210TNZ43ZZ/U';
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','210TNZ43ZZ/U','1',1,'1',0,'1',8,'BL','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '210TNZ43ZZ/V';
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',' ','1','210TNZ43ZZ/V','1',1,' ',1,'1',8,'yyyyMMdd','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '210TNZ43ZZ/W';
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','210TNZ43ZZ/W','1',1,' ',2,'1',7,' ','1',' ',' ','1',' '); 


DELETE FROM t_cr_coderule WHERE FID = '1WX5XXX8U589';
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 ('1WX5XXX8U589','1','-',' ',NULL,'2','1WX5XXX8U589','C','1WX5VE41EF6L',NULL,' ',{ts'2021-09-14  00:00:00'},'ifm_intbill_batch_pre','1','0',13466739,{ts'2021-11-22  00:00:00'},0,NULL); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '1WX5XXX8TVSX';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1WX5XXX8U589','1WX5XXX8TVSX','zh_CN','预提利息批量处理预置编码规则'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '210T7VFMHD7T';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1WX5XXX8U589',1,'1',' ','0','210T7VFMHD7T','1',1,'1',0,'1',8,'AI','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '210T7VFMHD7U';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1WX5XXX8U589',1,'2',' ','1','210T7VFMHD7U','1',1,' ',1,'1',8,'yyyyMMdd','1',' ','createtime','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '210T7VFMHD7V';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1WX5XXX8U589',1,'16',' ','0','210T7VFMHD7V','1',1,' ',2,'1',7,' ','1',' ',' ','0',' '); 


DELETE FROM t_cr_coderule WHERE FID = '1X22BJRPH2MF';
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 ('1X22BJRPH2MF','1','-',' ',NULL,'2','1X22BJRPH2MF','C','1X228IYLYN9K',NULL,' ',{ts'2021-09-16  00:00:00'},'ifm_preinterestbill','1','0',13466739,{ts'2021-11-22  00:00:00'},0,NULL); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '1X22BJRPH19Z';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1X22BJRPH2MF','1X22BJRPH19Z','zh_CN','预提利息处理预置编码规则'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '210WSJH88/Q7';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1X22BJRPH2MF',1,'8',' ','1','210WSJH88/Q7','1',1,'3',0,'1',8,' ','1',' ','batchno','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '210WSJH88/Q8';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1X22BJRPH2MF',1,'1',' ','0','210WSJH88/Q8','1',1,'1',1,'1',8,'DE','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '210WSJH88/Q9';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1X22BJRPH2MF',1,'16',' ','0','210WSJH88/Q9','1',1,' ',2,'1',6,' ','1',' ',' ','0',' '); 









