-- 账单池编码规则
DELETE FROM t_cr_coderule WHERE FID = '410VMMG2C2A8';
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','410VMMG2C2A8','0',NULL,'0',{ts'2024-04-16  00:00:00'},'er_billingpool','1','0','1','1',NULL,'0','410VMMG2C2A8','-','1',NULL,'0','C','410V=J=L/F8B',' ','1',13466739,'0',{ts'2024-04-16  00:00:00'},13466739);

DELETE FROM t_cr_coderule_l WHERE FPKID = '410VMMG5YY8E';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('410VMMG2C2A8','410VMMG5YY8E','zh_CN','账单池');

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '410VMMHO/4KZ';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('410VMMG2C2A8',1,'1',' ','0','410VMMHO/4KZ',1,'1','1',0,8,'1','BP',' ','1',' ','0',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '410VMMHO/4L+';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('410VMMG2C2A8',1,'2','-','0','410VMMHO/4L+',1,'1',' ',1,8,'1','yyyyMMdd',' ','1','createtime','1',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '410VMMHO/4L/';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('410VMMG2C2A8',1,'16','-','0','410VMMHO/4L/',1,'1',' ',2,8,'1',' ',' ','1',' ','1',' ');


DELETE FROM t_cr_coderule WHERE FID = '4141WP1TZ202';
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','4141WP1TZ202','0',NULL,'0',{ts'2024-04-17  00:00:00'},'er_bd_billingpoolcfg','1','0','1','1',NULL,'0','4141WP1TZ202','-','1',NULL,'0','C','4141TW531X26',' ','1',13466739,'0',{ts'2024-04-17  00:00:00'},13466739);


DELETE FROM t_cr_coderule_l WHERE FPKID = '4141WP1TUXS=';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('4141WP1TZ202','4141WP1TUXS=','zh_CN','账单池配置');

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '4141WP3=ZQ3=';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('4141WP1TZ202',1,'1',' ','0','4141WP3=ZQ3=',1,'1','1',0,8,'1','BPCFG',' ','1',' ','0',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '4141WP3=ZQ3A';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('4141WP1TZ202',1,'2','-','0','4141WP3=ZQ3A',1,'1',' ',1,8,'1','yyyyMMdd',' ','1','createtime','1',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '4141WP3=ZQ3B';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('4141WP1TZ202',1,'16','-','0','4141WP3=ZQ3B',1,'1',' ',2,8,'1',' ',' ','1',' ','1',' ');
