-- 计提规则编码规则
DELETE FROM t_cr_coderule WHERE FID = '3U7QPXS7E=A6';
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,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','3U7QPXS7E=A6','0',NULL,'0',{ts'2024-01-08  00:00:00'},'tctb_jtgz_rules','1','0','1','1',NULL,'0','3U7QPXS7E=A6','-','1',NULL,'0','C','3U7QMS86TTLP',' ',1648459672342195200,'0',{ts'2024-01-08  00:00:00'},0);

DELETE FROM t_cr_coderule_l WHERE FPKID = '3U7QPXSA2LJX';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3U7QPXS7E=A6','3U7QPXSA2LJX','zh_CN','计提规则');

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '3U7QPXUMP2AI';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3U7QPXS7E=A6',1,'1',' ','0','3U7QPXUMP2AI',1,'1','1',0,8,'1','JTGZ',' ','1',' ','0',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '3U7QPXUMP2AJ';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3U7QPXS7E=A6',1,'16','-','0','3U7QPXUMP2AJ',1,'1',' ',1,6,'1',' ',' ','1',' ','1',' ');

--计提规则共享方案编码规则
DELETE FROM t_cr_coderule WHERE FID = '3Q/R83NEH4X9';
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,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','3Q/R83NEH4X9','0',NULL,'0',{ts'2023-11-22  00:00:00'},'tctb_jtgz_shareplan','1','0','1','1',NULL,'0','3Q/R83NEH4X9','-','1',NULL,'0','C','3Q/R66QKZD0E',' ',13466739,'0',{ts'2023-11-22  00:00:00'},0);

DELETE FROM t_cr_coderule_l WHERE FPKID = '3Q/R83NI7R/U';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3Q/R83NEH4X9','3Q/R83NI7R/U','zh_CN','共享计提规则');

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '3Q/R83QDIF1O';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3Q/R83NEH4X9',1,'1',' ','0','3Q/R83QDIF1O',1,'1','1',0,8,'1','JTGZFA',' ','1',' ','0',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '3Q/R83QDIF1P';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3Q/R83NEH4X9',1,'16','-','0','3Q/R83QDIF1P',1,'1',' ',1,4,'1',' ',' ','1',' ','1',' ');
