
-- 编码规则 sys库
DELETE FROM t_cr_coderule WHERE fid = '1UL3KD673I4M';
INSERT INTO t_cr_coderule(fexample,fappmode,fisaddview,fisappcondition,fmasterid,fisunique,fruletype,fismodifiable,fcreatetime,fbizobjectid,fisupdaterecover,fenable,fisapporg,fisserialnumber,fdisablerid,fischeckcode,fid,fsplitsign,fctrlmode,fdisabledate,fislog,fstatus,fnumber,fexamplelength,fisfast,fmodifierid,fisnonbreak,fmodifytime,fcreatorid) VALUES (' ','2','1','0','1UL3KD673I4M','0',NULL,'0',{ts'2021-08-19  00:00:00'},'im_mdc_backdifshare','0','1','0','1',NULL,'0','1UL3KD673I4M','-','1',NULL,'0','C','1UL3IXW5ZN06',' ','0',0,'0',{ts'2021-08-19  00:00:00'},0); 

DELETE FROM t_cr_coderule_l WHERE fpkid = '1UL3KD673ITW';
INSERT INTO t_cr_coderule_l(fid,fpkid,flocaleid,fname) VALUES ('1UL3KD673I4M','1UL3KD673ITW','zh_CN','领料差异分摊'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1UL3KD6Z3UOQ';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1UL3KD673I4M',1,'1',' ','0','1UL3KD6Z3UOQ',1,'1','1',0,8,'1','PDCYFT',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1UL3KD6Z3UOR';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1UL3KD673I4M',1,'16','-','0','1UL3KD6Z3UOR',1,'1',' ',1,6,'1',' ',' ','1',' ','1',' '); 



DELETE FROM t_cr_coderule WHERE fid = '1S2/YP+4VA1N';
INSERT INTO t_cr_coderule(fexample,fappmode,fisaddview,fisappcondition,fmasterid,fisunique,fruletype,fismodifiable,fcreatetime,fbizobjectid,fisupdaterecover,fenable,fisapporg,fisserialnumber,fdisablerid,fischeckcode,fid,fsplitsign,fctrlmode,fdisabledate,fislog,fstatus,fnumber,fexamplelength,fisfast,fmodifierid,fisnonbreak,fmodifytime,fcreatorid) VALUES (' ','2','1','0','1S2/YP+4VA1N','0',NULL,'0',{ts'2021-07-22  00:00:00'},'im_mdc_diffsharedetail','0','1','0','0',NULL,'0','1S2/YP+4VA1N','-','1',NULL,'0','C','1S2/W21G0OVK',' ','0',0,'0',{ts'2021-07-22  00:00:00'},0); 

DELETE FROM t_cr_coderule_l WHERE fpkid = '1S2/YP+4XQAJ';
INSERT INTO t_cr_coderule_l(fid,fpkid,flocaleid,fname) VALUES ('1S2/YP+4VA1N','1S2/YP+4XQAJ','zh_CN','领料差异分摊明细'); 

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1S2/YP/9C=CT';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1S2/YP+4VA1N',1,'1',' ','0','1S2/YP/9C=CT',1,'1','1',0,8,'1','DCCYFTMX',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1S2/YP/9C=CU';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1S2/YP+4VA1N',1,'9','-','0','1S2/YP/9C=CU',1,'1',' ',1,8,'1','yyyyMMdd',' ','1',' ','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1S2/YP/9C=CV';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1S2/YP+4VA1N',1,'10','-','0','1S2/YP/9C=CV',1,'1',' ',2,8,'1',' ',' ','1',' ','1',' '); 


DELETE FROM t_cr_coderule WHERE fid = '1S2050RO1WT4';
INSERT INTO t_cr_coderule(fexample,fappmode,fisaddview,fisappcondition,fmasterid,fisunique,fruletype,fismodifiable,fcreatetime,fbizobjectid,fisupdaterecover,fenable,fisapporg,fisserialnumber,fdisablerid,fischeckcode,fid,fsplitsign,fctrlmode,fdisabledate,fislog,fstatus,fnumber,fexamplelength,fisfast,fmodifierid,fisnonbreak,fmodifytime,fcreatorid) VALUES (' ','2','1','0','1S2050RO1WT4','0',NULL,'0',{ts'2021-07-22  00:00:00'},'im_mdc_backdiffshare_log','0','1','0','0',NULL,'0','1S2050RO1WT4','-','1',NULL,'0','C','1S203PS+0=UY',' ','0',0,'0',{ts'2021-07-22  00:00:00'},0); 

DELETE FROM t_cr_coderule_l WHERE fpkid = '1S2050RO4A10';
INSERT INTO t_cr_coderule_l(fid,fpkid,flocaleid,fname) VALUES ('1S2050RO1WT4','1S2050RO4A10','zh_CN','领料差异分摊日志'); 

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1S2050S46ZRP';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1S2050RO1WT4',1,'1',' ','0','1S2050S46ZRP',1,'1','1',0,8,'1','DCCYFTRZ',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1S2050S46ZRQ';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1S2050RO1WT4',1,'10','-','0','1S2050S46ZRQ',1,'1',' ',1,8,'1',' ',' ','1',' ','1',' '); 
