DELETE FROM t_cr_coderuleentry WHERE FID = '1VD9//TLKSR=';
DELETE FROM t_cr_coderuleentry WHERE FID = '1VNF98I0VKXX';
DELETE FROM t_cr_coderuleentry WHERE FID = '1W6C4X8N/T7Q';
DELETE FROM t_cr_coderuleentry WHERE FID = '1WX5XXX8U589';
DELETE FROM t_cr_coderuleentry WHERE FID = '1X22BJRPH2MF';

DELETE FROM t_cr_coderule WHERE FID = '1VD9//TLKSR=';
INSERT INTO t_cr_coderule(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','0','0','1VD9//TLKSR=','0',NULL,'0',{ts'2021-08-28  00:00:00'},'ifm_currentintbill','1','0','0','1',NULL,'0','1VD9//TLKSR=','-','1',NULL,'0','C','1VD8Y4OPF555',' ','0',13466739,'0',{ts'2021-11-22  00:00:00'},13466739); 
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,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1VD9//TLKSR=',1,'8',' ','1','210TIJQSWM93',1,'1','3',0,8,'1',' ',' ','1','batchno','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '210TIJQSWM94';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1VD9//TLKSR=',1,'1',' ','0','210TIJQSWM94',1,'1',' ',1,8,'1','DE',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '210TIJQSWM95';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1VD9//TLKSR=',1,'16',' ','0','210TIJQSWM95',1,'1',' ',2,6,'1',' ',' ','1',' ','0',' '); 

DELETE FROM t_cr_coderule WHERE FID = '1VNF98I0VKXX';
INSERT INTO t_cr_coderule(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','0','0','1VNF98I0VKXX','0',NULL,'0',{ts'2021-08-31  00:00:00'},'ifm_intbill_batch_current','1','0','0','1',NULL,'0','1VNF98I0VKXX','-','1',NULL,'0','C','1VNF5706X5JH',' ','0',13466739,'0',{ts'2021-11-22  00:00:00'},0); 
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,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1VNF98I0VKXX',1,'1',' ','0','210TKWXBJJ1D',1,'1','1',0,8,'1','BD',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '210TKWXBJJ1E';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1VNF98I0VKXX',1,'2',' ','1','210TKWXBJJ1E',1,'1',' ',1,8,'1','yyyyMMdd',' ','1','createtime','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '210TKWXBJJ1F';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1VNF98I0VKXX',1,'16',' ','0','210TKWXBJJ1F',1,'1',' ',2,7,'1',' ',' ','1',' ','0',' '); 

DELETE FROM t_cr_coderule WHERE FID = '1W6C4X8N/T7Q';
INSERT INTO t_cr_coderule(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','0','0','1W6C4X8N/T7Q','0',NULL,'0',{ts'2021-09-06  00:00:00'},'ifm_intbill_batch_loan','1','0','0','1',NULL,'0','1W6C4X8N/T7Q','-','1',NULL,'0','C','1W6C2YM0WTTN',' ','0',13466739,'0',{ts'2021-11-22  00:00:00'},0); 
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,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1W6C4X8N/T7Q',1,'1',' ','0','210TNZ43ZZ/U',1,'1','1',0,8,'1','BL',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '210TNZ43ZZ/V';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1W6C4X8N/T7Q',1,'9',' ','1','210TNZ43ZZ/V',1,'1',' ',1,8,'1','yyyyMMdd',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '210TNZ43ZZ/W';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1W6C4X8N/T7Q',1,'16','-','0','210TNZ43ZZ/W',1,'1',' ',2,7,'1',' ',' ','1',' ','1',' '); 

DELETE FROM t_cr_coderule WHERE FID = '1WX5XXX8U589';
INSERT INTO t_cr_coderule(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','1WX5XXX8U589','0',NULL,'0',{ts'2021-09-14  00:00:00'},'ifm_intbill_batch_pre','1','0','0','1',NULL,'0','1WX5XXX8U589','-','1',NULL,'0','C','1WX5VE41EF6L',' ','0',13466739,'0',{ts'2021-11-23  00:00:00'},0); 
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 = '213BJ8JH1YI/';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1WX5XXX8U589',1,'1',' ','0','213BJ8JH1YI/',1,'1','1',0,8,'1','AI',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '213BJ8JH1YI0';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1WX5XXX8U589',1,'2',' ','1','213BJ8JH1YI0',1,'1',' ',1,8,'1','yyyyMMdd',' ','1','createtime','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '213BJ8JH1YI1';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1WX5XXX8U589',1,'16',' ','0','213BJ8JH1YI1',1,'1',' ',2,7,'1',' ',' ','1',' ','0',' '); 

DELETE FROM t_cr_coderule WHERE FID = '1X22BJRPH2MF';
INSERT INTO t_cr_coderule(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','1X22BJRPH2MF','0',NULL,'0',{ts'2021-09-16  00:00:00'},'ifm_preinterestbill','1','0','0','1',NULL,'0','1X22BJRPH2MF','-','1',NULL,'0','C','1X228IYLYN9K',' ','0',13466739,'0',{ts'2021-11-22  00:00:00'},0); 
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,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1X22BJRPH2MF',1,'8',' ','1','210WSJH88/Q7',1,'1','3',0,8,'1',' ',' ','1','batchno','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '210WSJH88/Q8';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1X22BJRPH2MF',1,'1',' ','0','210WSJH88/Q8',1,'1','1',1,8,'1','DE',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '210WSJH88/Q9';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1X22BJRPH2MF',1,'16',' ','0','210WSJH88/Q9',1,'1',' ',2,6,'1',' ',' ','1',' ','0',' '); 

