
-- 缺失记录编码规则
DELETE FROM T_CR_CodeRule WHERE FID = '2VUV/Z/9C0IP';
INSERT INTO T_CR_CodeRule(FID,FSPLITSIGN,FCTRLMODE,FEXAMPLE,FAPPMODE,FDISABLEDATE,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FENABLE,FMODIFIERID,FISUPDATERECOVER,FMODIFYTIME,FISSERIALNUMBER,FCREATORID,FDISABLERID) VALUES ('2VUV/Z/9C0IP','-','1',' ','2',NULL,'2VUV/Z/9C0IP','C','2VUUR2L0OIK5',NULL,' ',{ts'2022-11-14  00:00:00'},'bei_missingreord','1',1551347118827001856,'0',{ts'2022-12-16  00:00:00'},'1',0,NULL);

DELETE FROM T_CR_CodeRule_L WHERE FPKID = '2VUV/Z/9ECEA';
INSERT INTO T_CR_CodeRule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2VUV/Z/9C0IP','2VUV/Z/9ECEA','zh_CN','缺失记录');

DELETE FROM T_CR_CodeRuleEntry WHERE FID = '2VUV/Z/9C0IP';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '2YOXR6JYRUYC';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2VUV/Z/9C0IP',1,'1',' ','0','2YOXR6JYRUYC',1,'1','1',0,8,'1','QSJL',' ','1',' ','0',' ');
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '2YOXR6JYRUYD';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2VUV/Z/9C0IP',1,'8','-','0','2YOXR6JYRUYD',1,'1','3',1,8,'1',' ',' ','1','company.number','1',' ');
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '2YOXR6JYRUYE';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2VUV/Z/9C0IP',1,'9','-','1','2YOXR6JYRUYE',1,'1',' ',2,8,'1','yyyyMMdd',' ','1',' ','1',' ');
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '2YOXR6JYRUYF';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2VUV/Z/9C0IP',1,'16','-','0','2YOXR6JYRUYF',1,'1',' ',3,5,'1',' ',' ','1',' ','1',' ');
