-- 先删后加模拟报价单编码规则
DELETE FROM T_CR_CODERULE WHERE FID = '2J/IZFRQ78CY';
INSERT INTO T_CR_CODERULE(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FISCHECKCODE,FID,FCTRLMODE,FSPLITSIGN,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','2J/IZFRQ78CY','0','0',{ts'2018-08-08 18:08:00'},'sm_simulatequote','1','0','0','1','0','2J/IZFRQ78CY','1','-','0','C','2J/IIE89O1R9',' ','0',1,'0',{ts'2018-08-08 18:08:00'},0);

DELETE FROM T_CR_CODERULE_L WHERE FID = '2J/IZFRQ78CY';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2J/IZFRQ78CY','2J/IZFRQ7916','zh_CN','模拟报价单编码规则');
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2J/IZFRQ78CY','2J/JS4E4=GDR','zh_TW','模擬報價單編碼規則');

DELETE FROM T_CR_CODERULEENTRY WHERE FID='2J/IZFRQ78CY';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2J/IZFRQ78CY',1,'1',' ','0','2J/IZFT3LG9M',1,'1','1',0,8,'1','MNBJ','1',' ',' ','0',' ');
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2J/IZFRQ78CY',1,'2','-','1','2J/IZFT3LG9N',1,'1',' ',1,8,'1','yyMMdd','1',' ','bizdate','1',' ');
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2J/IZFRQ78CY',1,'16','-','0','2J/IZFT3LG9O',1,'1',' ',2,6,'1',' ','1',' ',' ','1',' ');
