---销售报价单编码规则
DELETE FROM t_cr_coderule WHERE FID = '12NB1YEPL8RV';
INSERT INTO t_cr_coderule(FID, FNUMBER, FRULETYPE, FBIZOBJECTID, FSPLITSIGN, FCTRLMODE, FAPPMODE, FEXAMPLE, FEXAMPLELENGTH, FENABLE, FSTATUS, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE, FMASTERID, FISUPDATERECOVER,FISNONBREAK,FISCHECKCODE,FISAPPCONDITION,FISAPPORG,FISLOG,FISSERIALNUMBER,FISUNIQUE,FISMODIFIABLE,FISADDVIEW) VALUES ('12NB1YEPL8RV','12N=VXR=GMML',NULL,'sm_quotationbill','-','1','2',' ',' ','1','C',1,{ts'2018-08-08 18:08:00'},1,{ts'2018-08-08 18:08:00'},'0',NULL,'12NB1YEPL8RV',0,0,0,0,0,0,1,0,0,1); 


---销售报价单编码规则多语言
DELETE FROM t_cr_coderule_l WHERE FPKID = '11O6AX17C532';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('12NB1YEPL8RV','11O6AX17C532','zh_CN','销售报价单编码规则'); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '11O6AX17C531';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('12NB1YEPL8RV','11O6AX17C531','zh_TW','銷售報價單編碼規則'); 

---销售报价单编码规则分录

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '11O6AX3FCW=S';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('12NB1YEPL8RV',1,'1',' ','0','11O6AX3FCW=S',1,'1',' ',0,8,'1','XSBJ',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '11O6AX3FCW=T';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('12NB1YEPL8RV',1,'2','-','1','11O6AX3FCW=T',1,'1','1',1,8,'1','yyMMdd',' ','1','bizdate','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '11O6AX3FCW=U';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('12NB1YEPL8RV',1,'16','-','0','11O6AX3FCW=U',1,'1','1',2,6,'1',' ',' ','1',' ','1',' '); 

