DELETE FROM T_CR_CodeRule WHERE FID = '0QY03KAOM0DS';
INSERT INTO T_CR_CodeRule(FID,FCTRLMODE,FSPLITSIGN,FEXAMPLE,FDISABLEDATE,FAPPMODE,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FISUPDATERECOVER,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('0QY03KAOM0DS','1','-',' ',NULL,'2','0QY03KAOM0DS','C',' ',NULL,' ',{ts'2020-04-27  10:55:01'},'bei_transdetail','0',13466739,'1',{ts'2020-05-06  10:51:35'},13466739,NULL); 


DELETE FROM T_CR_CodeRule WHERE FID = '0RQDG4412EKG';
INSERT INTO T_CR_CodeRule(FID,FCTRLMODE,FSPLITSIGN,FEXAMPLE,FDISABLEDATE,FAPPMODE,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FISUPDATERECOVER,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('0RQDG4412EKG','1','-',' ',NULL,'2','0RQDG4412EKG','C',' ',NULL,' ',{ts'2020-05-06  11:43:28'},'bei_betransdetail_imp','0',13466739,'1',{ts'2020-05-06  11:43:28'},13466739,NULL); 


DELETE FROM T_CR_CodeRule WHERE FID = '0RQCJBROFSPH';
INSERT INTO T_CR_CodeRule(FID,FCTRLMODE,FSPLITSIGN,FEXAMPLE,FDISABLEDATE,FAPPMODE,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FISUPDATERECOVER,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('0RQCJBROFSPH','1','-',' ',NULL,'2','0RQCJBROFSPH','C',' ',NULL,' ',{ts'2020-05-06  11:33:43'},'bei_transdetail_cas','0',13466739,'1',{ts'2020-05-06  11:33:43'},13466739,NULL); 


DELETE FROM T_CR_CodeRule_L WHERE FPKID = '0QY03KAOM+D0';
INSERT INTO T_CR_CodeRule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('0QY03KAOM0DS','0QY03KAOM+D0','zh_CN','交易明细编码'); 
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '0QY03KAOM+D/';
INSERT INTO T_CR_CodeRule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('0QY03KAOM0DS','0QY03KAOM+D/','zh_TW','交易明細編碼'); 


DELETE FROM T_CR_CodeRule_L WHERE FPKID = '0RQDG4412FY/';
INSERT INTO T_CR_CodeRule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('0RQDG4412EKG','0RQDG4412FY/','zh_CN','离线明细引入编码规则'); 
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '0RQDG4412FY+';
INSERT INTO T_CR_CodeRule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('0RQDG4412EKG','0RQDG4412FY+','zh_TW','離線明細引入編碼規則'); 


DELETE FROM T_CR_CodeRule_L WHERE FPKID = '0RQCJBROFRC/';
INSERT INTO T_CR_CodeRule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('0RQCJBROFSPH','0RQCJBROFRC/','zh_CN','银行收付处理编码规则'); 
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '0RQCJBROFRC+';
INSERT INTO T_CR_CodeRule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('0RQCJBROFSPH','0RQCJBROFRC+','zh_TW','銀行收付處理編碼規則'); 


DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '0RQ9KU6TMEFZ';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0QY03KAOM0DS',1,'2',' ','0','0RQ9KU6TMEFZ',1,'1','1',0,8,'1','yyyyMMdd',' ','1','createtime','0',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '0RQ9KU6TMEG+';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0QY03KAOM0DS',1,'16','-','0','0RQ9KU6TMEG+',1,'1','1',1,10,'1',' ',' ','1',' ','1',' '); 


DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '0RQDG44I7HJ0';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0RQDG4412EKG',1,'2',' ','0','0RQDG44I7HJ0',1,'1','1',0,8,'1','yyyyMMdd',' ','1','createtime','0',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '0RQDG44I7HJ1';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0RQDG4412EKG',1,'16','-','0','0RQDG44I7HJ1',1,'1','1',1,10,'1',' ',' ','1',' ','1',' '); 


DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '0RQCJBSPBBU4';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0RQCJBROFSPH',1,'2',' ','0','0RQCJBSPBBU4',1,'1','1',0,8,'1','yyyyMMdd',' ','1','createtime','0',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '0RQCJBSPBBU5';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0RQCJBROFSPH',1,'16','-','0','0RQCJBSPBBU5',1,'1','1',1,10,'1',' ',' ','1',' ','1',' '); 

