DELETE FROM T_CR_CodeRule WHERE FID = '0QY03KAOM0DS';
DELETE FROM t_cr_coderule_l WHERE FPKID = '0QY03KAOM+D0';
DELETE FROM t_cr_coderule_l WHERE FPKID = '0QY03KAOM+D/';

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '0RQ9KU6TMEG+';
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '0RQ9KU6TMEFZ';


DELETE FROM T_CR_CodeRule WHERE FID = '2TLSAI46MDC1';
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 ('2TLSAI46MDC1','1','-',' ',NULL,'2','2TLSAI46MDC1','C','2TLRRIIZQROL',NULL,' ',{ts'2022-10-20  00:00:00'},'bei_transdetail','1','0',1504371325429819392,{ts'2022-10-20  00:00:00'},0,NULL);


DELETE FROM t_cr_coderule_l WHERE FPKID = '2TLSAI46J855';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2TLSAI46MDC1','2TLSAI46J855','zh_CN','交易明细编码规则');
DELETE FROM t_cr_coderule_l WHERE FPKID = '2TLSAI46J854';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2TLSAI46MDC1','2TLSAI46J854','zh_TW','交易明細編碼規則');

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2TLSEVMXNN6M';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2TLSAI46MDC1',1,'1',' ','0','2TLSEVMXNN6M','1',1,'1',0,'1',8,'MX','1',' ',' ','0',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2TLSEVMXNN6N';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2TLSAI46MDC1',1,'9','-','0','2TLSEVMXNN6N','1',1,' ',1,'1',8,'yyyyMMdd','1',' ',' ','1',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2TLSEVMXNN6O';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2TLSAI46MDC1',1,'16','-','0','2TLSEVMXNN6O','1',1,' ',2,'1',10,' ','1',' ',' ','1',' ');


DELETE FROM T_CR_CodeRule WHERE FID = '0RQDG4412EKG';
DELETE FROM t_cr_coderule_l WHERE FPKID = '0RQDG4412FY/';
DELETE FROM t_cr_coderule_l WHERE FPKID = '0RQDG4412FY+';
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '0RQDG44I7HJ1';
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '0RQDG44I7HJ0';

DELETE FROM T_CR_CodeRule WHERE FID = '2TM2+OLBMQF4';
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 ('2TM2+OLBMQF4','1','-',' ',NULL,'2','2TM2+OLBMQF4','C','2TM1TTWWS4Q+',NULL,' ',{ts'2022-10-20  00:00:00'},'bei_betransdetail_imp','1','0',13466739,{ts'2022-10-20  00:00:00'},0,NULL);

DELETE FROM t_cr_coderule_l WHERE FPKID = '2TM2+OLBPWN2';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2TM2+OLBMQF4','2TM2+OLBPWN2','zh_CN','离线明细引入编码规则');
DELETE FROM t_cr_coderule_l WHERE FPKID = '2TM2+OLBPWN1';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2TM2+OLBMQF4','2TM2+OLBPWN1','zh_TW','離線明細引入編碼規則');

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2TM2+OMCI=JS';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2TM2+OLBMQF4',1,'1',' ','0','2TM2+OMCI=JS','1',1,'1',0,'1',8,'MXLX','1',' ',' ','0',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2TM2+OMCI=JT';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2TM2+OLBMQF4',1,'2','-','0','2TM2+OMCI=JT','1',1,' ',1,'1',8,'yyyyMMdd','1',' ','bizdate','1',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2TM2+OMCI=JU';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2TM2+OLBMQF4',1,'16','-','0','2TM2+OMCI=JU','1',1,' ',2,'1',10,' ','1',' ',' ','1',' ');
