DELETE FROM t_cr_coderule WHERE FID = '26CDFBSZ/H7B';
INSERT INTO t_cr_coderule(FID,FSPLITSIGN,FCTRLMODE,FEXAMPLE,FAPPMODE,FDISABLEDATE,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FENABLE,FMODIFIERID,FISUPDATERECOVER,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('26CDFBSZ/H7B','-','1',' ','2',NULL,'26CDFBSZ/H7B','C','XSTJ',NULL,' ',{ts'2018-08-08 18:08:08'},'sm_salepriceadjust','1',1,'0',{ts'2018-08-08 18:08:08'},1,NULL); 


DELETE FROM t_cr_coderuleentry WHERE FID = '26CDFBSZ/H7B';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('26CDFBSZ/H7B',1,'1',' ','0','26CDFBUF04=J',1,'1','1',0,8,'1','XSTJ',' ','1',' ','0',' '); 
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('26CDFBSZ/H7B',1,'9','-','0','26CDFBUF04=K',1,'1',' ',1,8,'1','yyMMdd',' ','1',' ','1',' '); 
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('26CDFBSZ/H7B',1,'16','-','0','26CDFBUF04=L',1,'1',' ',2,6,'1',' ',' ','1',' ','1',' '); 

DELETE FROM t_cr_coderule_l WHERE FPKID = '26CDFBSZ/GJ3';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('26CDFBSZ/H7B','26CDFBSZ/GJ3','zh_CN','销售基价调整单编码规则'); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '26CDFBSZ/GJ2';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('26CDFBSZ/H7B','26CDFBSZ/GJ2','zh_TW','銷售基價調整單編碼規則'); 
