DELETE FROM t_cr_coderule WHERE FID = '1NMV3//MG9BN';
INSERT INTO t_cr_coderule(FID,FCTRLMODE,FSPLITSIGN,FEXAMPLE,FDISABLEDATE,FAPPMODE,FISADDVIEW,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FMODIFIERID,FISUPDATERECOVER,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('1NMV3//MG9BN','1','-',' ',NULL,'2','1','1NMV3//MG9BN','C','1NMV01O+=+BP',NULL,' ',{ts'2021-06-02  00:00:00'},'tm_forex_swaps',0,'0','1',{ts'2021-06-02  00:00:00'},0,NULL); 
DELETE FROM t_cr_coderule WHERE FID = '17QANN5AGEPV';
INSERT INTO t_cr_coderule(FID,FCTRLMODE,FSPLITSIGN,FEXAMPLE,FDISABLEDATE,FAPPMODE,FISADDVIEW,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FMODIFIERID,FISUPDATERECOVER,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('17QANN5AGEPV','1','-',' ',NULL,'2','0','17QANN5AGEPV','C','17QALEMZYQC1',NULL,' ',{ts'2020-11-24  00:00:00'},'tm_forex',0,'0','1',{ts'2020-11-24  00:00:00'},0,NULL); 
DELETE FROM t_cr_coderule WHERE FID = '17TUMLI4VGOW';
INSERT INTO t_cr_coderule(FID,FCTRLMODE,FSPLITSIGN,FEXAMPLE,FDISABLEDATE,FAPPMODE,FISADDVIEW,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FMODIFIERID,FISUPDATERECOVER,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('17TUMLI4VGOW','1','-',' ',NULL,'2','0','17TUMLI4VGOW','C','17TUIEKRSXZ5',NULL,' ',{ts'2020-11-25  00:00:00'},'tm_forex_forward',87699580,'0','1',{ts'2021-01-29  00:00:00'},0,NULL); 
DELETE FROM t_cr_coderule WHERE FID = '18+HL9SMCUE5';
INSERT INTO t_cr_coderule(FID,FCTRLMODE,FSPLITSIGN,FEXAMPLE,FDISABLEDATE,FAPPMODE,FISADDVIEW,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FMODIFIERID,FISUPDATERECOVER,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('18+HL9SMCUE5','1','-',' ',NULL,'2','0','18+HL9SMCUE5','C','18+HHK63ZW3A',NULL,' ',{ts'2020-11-27  00:00:00'},'tm_forex_swaps',87699580,'0','1',{ts'2021-01-12  00:00:00'},0,NULL); 

DELETE FROM t_cr_coderule_l WHERE FPKID = '1NMV3//MG19K';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1NMV3//MG9BN','1NMV3//MG19K','zh_CN','外汇掉期'); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '17TUMLIX+05T';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('17TUMLI4VGOW','17TUMLIX+05T','zh_CN','外汇远期'); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '18+HL9SMH+NZ';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('18+HL9SMCUE5','18+HL9SMH+NZ','zh_CN','外汇掉期'); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '17QANN5AAGFD';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('17QANN5AGEPV','17QANN5AAGFD','zh_CN','外汇即期'); 

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1NMV3/0ULNVA';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1NMV3//MG9BN',1,'1',' ','0','1NMV3/0ULNVA',1,'1','1',0,'1',8,'ForwSwap','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1NMV3/0ULNVB';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1NMV3//MG9BN',1,'9','-','0','1NMV3/0ULNVB',1,'1',' ',1,'1',8,'yyyyMMdd','1',' ',' ','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1NMV3/0ULNVC';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1NMV3//MG9BN',1,'16','-','0','1NMV3/0ULNVC',1,'1',' ',2,'1',8,' ','1',' ',' ','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1B1ON+ZZLL07';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('18+HL9SMCUE5',1,'1',' ','0','1B1ON+ZZLL07',1,'1','1',0,'1',8,'SWAP','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1B1ON+ZZLL08';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('18+HL9SMCUE5',1,'9','-','0','1B1ON+ZZLL08',1,'1',' ',1,'1',8,'yyyyMMdd','1',' ',' ','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1B1ON+ZZLL09';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('18+HL9SMCUE5',1,'16','-','0','1B1ON+ZZLL09',1,'1',' ',2,'1',8,' ','1',' ',' ','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1CKUCNB4AU69';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('17TUMLI4VGOW',1,'1',' ','0','1CKUCNB4AU69',1,'1','1',0,'1',8,'forexward','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1CKUCNB4AU6=';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('17TUMLI4VGOW',1,'9','-','0','1CKUCNB4AU6=',1,'1',' ',1,'1',8,'yyyyMMdd','1',' ',' ','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1CKUCNB4AU6A';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('17TUMLI4VGOW',1,'16','-','0','1CKUCNB4AU6A',1,'1',' ',2,'1',8,' ','1',' ',' ','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '17QANN6X3H+K';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('17QANN5AGEPV',1,'1',' ','0','17QANN6X3H+K',1,'1','1',0,'1',8,'FOREX','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '17QANN6X3H+L';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('17QANN5AGEPV',1,'9','-','0','17QANN6X3H+L',1,'1',' ',1,'1',8,'yyyyMMdd','1',' ',' ','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '17QANN6X3H+M';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('17QANN5AGEPV',1,'10','-','0','17QANN6X3H+M',1,'1',' ',2,'1',8,' ','1',' ',' ','1',' '); 

DELETE FROM t_cr_coderule WHERE FID = '15S31YWWWFMB';
INSERT INTO t_cr_coderule(FID,FCTRLMODE,FSPLITSIGN,FEXAMPLE,FDISABLEDATE,FAPPMODE,FISADDVIEW,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FMODIFIERID,FISUPDATERECOVER,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('15S31YWWWFMB','1','-',' ',NULL,'2','0','15S31YWWWFMB','C','15S3/M9U3H6M',NULL,' ',{ts'2020-11-02  00:00:00'},'tm_businessbill',206742,'0','1',{ts'2020-11-27  00:00:00'},0,NULL); 

DELETE FROM t_cr_coderule_l WHERE FPKID = '15S31YWX5HHF';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('15S31YWWWFMB','15S31YWX5HHF','zh_CN','业务处理单'); 

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '18+3CDWT8NP8';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('15S31YWWWFMB',1,'1',' ','0','18+3CDWT8NP8',1,'1','1',0,'1',8,'YWCZ','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '18+3CDWT8NP9';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('15S31YWWWFMB',1,'16','-','0','18+3CDWT8NP9',1,'1',' ',1,'1',8,' ','1',' ',' ','1',' '); 


DELETE FROM t_cr_coderule WHERE FID = '2+XB0Q6WBSR/';
INSERT INTO t_cr_coderule(FID,FCTRLMODE,FSPLITSIGN,FEXAMPLE,FDISABLEDATE,FAPPMODE,FISADDVIEW,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FMODIFIERID,FISUPDATERECOVER,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('2+XB0Q6WBSR/','1','-',' ',NULL,'2','0','2+XB0Q6WBSR/','C','2+XAPUGG9N54',NULL,' ',{ts'2021-10-29  00:00:00'},'tm_lifecycle_apply',0,'0','1',{ts'2021-10-29  00:00:00'},0,NULL); 

DELETE FROM t_cr_coderule_l WHERE FPKID = '2+XB0Q6WC=YP';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2+XB0Q6WBSR/','2+XB0Q6WC=YP','zh_CN','生命周期申请单'); 

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2+XB0Q863LF6';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2+XB0Q6WBSR/',1,'1',' ','0','2+XB0Q863LF6',1,'1','1',0,'1',8,'APPLY','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2+XB0Q863LF7';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2+XB0Q6WBSR/',1,'9','-','0','2+XB0Q863LF7',1,'1',' ',1,'1',8,'yyyyMMdd','1',' ',' ','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2+XB0Q863LF8';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2+XB0Q6WBSR/',1,'10',' ','0','2+XB0Q863LF8',1,'1',' ',2,'1',8,' ','1',' ',' ','0',' '); 

