
--历史用量运算日志编码规则
DELETE FROM T_CR_CodeRule WHERE FID = '2M=QLUGNAYFH';
INSERT INTO T_CR_CodeRule(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FISUNIQUE,FMASTERID,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FISUPDATERECOVER,FENABLE,FISAPPORG,FISSERIALNUMBER,FISCHECKCODE,FID,FCTRLMODE,FSPLITSIGN,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','0','2M=QLUGNAYFH','0',{ts'2018-08-08  18:08:08'},'mds_hisusecalclog','0','1','0','1','0','2M=QLUGNAYFH','1','-','0','C','2M=QJ6R5ECCT',' ','0',1,'0',{ts'2018-08-08  18:08:08'},0); 

DELETE FROM T_CR_CodeRule_l WHERE FPKID = '2M=QLUGNB+G9';
INSERT INTO T_CR_CodeRule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2M=QLUGNAYFH','2M=QLUGNB+G9','zh_CN','历史用量运算日志'); 

DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '2M=QLUIE7U38';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2M=QLUGNAYFH',1,'1',' ','0','2M=QLUIE7U38',1,'1','1',0,8,'1','TYLS','1',' ',' ','0',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '2M=QLUIE7U39';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2M=QLUGNAYFH',1,'9','-','1','2M=QLUIE7U39',1,'1',' ',1,8,'1','yyyyMMdd','1',' ',' ','1',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '2M=QLUIE7U3=';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2M=QLUGNAYFH',1,'16','-','0','2M=QLUIE7U3=',1,'1',' ',2,8,'1',' ','1',' ',' ','1',' '); 


--通用件自定义清单编码规则
DELETE FROM T_CR_CodeRule WHERE FID = '2M09B3Z/U9DR';
INSERT INTO T_CR_CodeRule(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FISUNIQUE,FMASTERID,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FISUPDATERECOVER,FENABLE,FISAPPORG,FISSERIALNUMBER,FISCHECKCODE,FID,FCTRLMODE,FSPLITSIGN,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','0','2M09B3Z/U9DR','0',{ts'2018-08-08  18:08:08'},'mds_general','0','1','0','1','0','2M09B3Z/U9DR','1','-','0','C','2M095UH729P+',' ','0',1,'0',{ts'2018-08-08  18:08:08'},0); 

DELETE FROM T_CR_CodeRule_l WHERE FPKID = '2M09B3Z/U8QH';
INSERT INTO T_CR_CodeRule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2M09B3Z/U9DR','2M09B3Z/U8QH','zh_CN','通用件自定义清单'); 

DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '2M09B4+P2QW+';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2M09B3Z/U9DR',1,'1',' ','0','2M09B4+P2QW+',1,'1','1',0,8,'1','TYJQD','1',' ',' ','0',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '2M09B4+P2QW/';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2M09B3Z/U9DR',1,'9','-','1','2M09B4+P2QW/',1,'1',' ',1,8,'1','yyyyMMdd','1',' ',' ','1',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '2M09B4+P2QW0';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2M09B3Z/U9DR',1,'16','-','0','2M09B4+P2QW0',1,'1',' ',2,8,'1',' ','1',' ',' ','1',' '); 


--物料备货信息编码规则
DELETE FROM T_CR_CodeRule WHERE FID = '2M42/MKN6LE9';
INSERT INTO T_CR_CodeRule(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FISUNIQUE,FMASTERID,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FISUPDATERECOVER,FENABLE,FISAPPORG,FISSERIALNUMBER,FISCHECKCODE,FID,FCTRLMODE,FSPLITSIGN,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','0','2M42/MKN6LE9','0',{ts'2018-08-08  18:08:08'},'mds_materialbackup','0','1','0','1','0','2M42/MKN6LE9','1','-','0','C','2M41XQE7XHH7',' ','0',1,'0',{ts'2018-08-08  18:08:08'},0); 

DELETE FROM T_CR_CodeRule_l WHERE FPKID = '2M42/MKQU0=0';
INSERT INTO T_CR_CodeRule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2M42/MKN6LE9','2M42/MKQU0=0','zh_CN','物料备货信息'); 

DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '2M42/MLO25IX';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2M42/MKN6LE9',1,'1',' ','0','2M42/MLO25IX',1,'1','1',0,8,'1','BHXX','1',' ',' ','0',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '2M42/MLO25IY';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2M42/MKN6LE9',1,'9','-','1','2M42/MLO25IY',1,'1',' ',1,8,'1','yyyyMMdd','1',' ',' ','1',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '2M42/MLO25IZ';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2M42/MKN6LE9',1,'16','-','0','2M42/MLO25IZ',1,'1',' ',2,8,'1',' ','1',' ',' ','1',' '); 










