--PMM 商品管理编码规则
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '18ZPNVDQ+WVY';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FSETTINGVALUE,FADDSTYLE,FISSPLITSIGN,FVALUEATRIBUTE,FADDCHAR) VALUES ('18ZPNVD1M+IB',1,'1',' ','0','18ZPNVDQ+WVY','1',1,' ',0,'1',8,'SP',' ','1','0',' ',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '18ZPNVDQ+WVZ';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FSETTINGVALUE,FADDSTYLE,FISSPLITSIGN,FVALUEATRIBUTE,FADDCHAR) VALUES ('18ZPNVD1M+IB',1,'16','-','0','18ZPNVDQ+WVZ','1',1,' ',1,'1',8,' ',' ','1','1',' ',' '); 


DELETE FROM T_CR_CodeRule WHERE FID = '18ZPNVD1M+IB';
INSERT INTO T_CR_CodeRule(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FISUPDATERECOVER,FENABLE,FISAPPORG,FISSERIALNUMBER,FISCHECKCODE,FID,FCTRLMODE,FSPLITSIGN,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','18ZPNVD1M+IB','0','0',{ts'2020-12-08  13:42:41'},'pmm_prodmanage','0','1','0','1','0','18ZPNVD1M+IB','1','-','0','C','18ZPKAWQ6I/5',' ',0,'0',{ts'2020-12-08  13:42:41'},0); 

DELETE FROM T_CR_CodeRule_l WHERE FPKID = '18ZPNVD1HYA3';
INSERT INTO T_CR_CodeRule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('18ZPNVD1M+IB','18ZPNVD1HYA3','zh_CN','pmm商品管理编码规则'); 
DELETE FROM T_CR_CodeRule_l WHERE FPKID = '18ZPNVD1HYA2';
INSERT INTO T_CR_CodeRule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('18ZPNVD1M+IB','18ZPNVD1HYA2','zh_TW','pmm商品管理編碼規則'); 

--上架审批编码规则
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '19468RIUZ72K';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FSETTINGVALUE,FADDSTYLE,FISSPLITSIGN,FVALUEATRIBUTE,FADDCHAR) VALUES ('19468RI/AGBZ',1,'1',' ','0','19468RIUZ72K','1',1,'1',0,'1',8,'SJ',' ','1','0',' ',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '19468RIUZ72L';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FSETTINGVALUE,FADDSTYLE,FISSPLITSIGN,FVALUEATRIBUTE,FADDCHAR) VALUES ('19468RI/AGBZ',1,'2','-','1','19468RIUZ72L','1',1,' ',1,'1',8,'yyMMdd',' ','1','1','createtime',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '19468RIUZ72M';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FSETTINGVALUE,FADDSTYLE,FISSPLITSIGN,FVALUEATRIBUTE,FADDCHAR) VALUES ('19468RI/AGBZ',1,'16','-','0','19468RIUZ72M','1',1,' ',2,'1',4,' ',' ','1','1',' ',' '); 


DELETE FROM T_CR_CodeRule WHERE FID = '19468RI/AGBZ';
INSERT INTO T_CR_CodeRule(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FISUPDATERECOVER,FENABLE,FISAPPORG,FISSERIALNUMBER,FISCHECKCODE,FID,FCTRLMODE,FSPLITSIGN,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','19468RI/AGBZ','0','0',{ts'2020-12-10  10:28:33'},'pmm_prodaudit','0','1','0','1','0','19468RI/AGBZ','1','-','0','C','19465Z+5TVAW',' ',0,'0',{ts'2020-12-10  10:28:33'},0); 

DELETE FROM T_CR_CodeRule_l WHERE FPKID = '19468RI/EF6Z';
INSERT INTO T_CR_CodeRule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('19468RI/AGBZ','19468RI/EF6Z','zh_CN','上架审批编码规则'); 
DELETE FROM T_CR_CodeRule_l WHERE FPKID = '19468RI/EF6Y';
INSERT INTO T_CR_CodeRule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('19468RI/AGBZ','19468RI/EF6Y','zh_TW','上架審批編碼規則'); 

