
/************工程采固单编码规则预置************/
DELETE FROM t_cr_coderule WHERE FID = '06G8NQ6RMXDC';
INSERT INTO t_cr_coderule(FID,FSTATUS,FDISABLERID,FRULETYPE,FMODIFYTIME,FENABLE,FDISABLEDATE,FNUMBER,FCTRLMODE,FEXAMPLELENGTH,FISUPDATERECOVER,FBIZOBJECTID,FCREATORID,FEXAMPLE,FMASTERID,FSPLITSIGN,FAPPMODE,FMODIFIERID,FCREATETIME) VALUES ('06G8NQ6RMXDC','C',null,null,{ts'2019-08-30  11:24:10'},'1',null,' ','1',' ','0','fa_engineeringbill',484155825233856519,' ','06G8NQ6RMXDC','-','1',484155825233856519,{ts'2019-08-30  11:16:56'}); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '06G8NQ70FK+G';
INSERT INTO t_cr_coderule_l(FPKID,FNAME,FLOCALEID,FID) VALUES ('06G8NQ70FK+G','金蝶工程转固单规则','zh_CN','06G8NQ6RMXDC'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '06G9B9/RN6NX';
INSERT INTO t_cr_coderuleentry(FCUTSTYLE,FISVISABLE,FENTRYID,FVALUEATRIBUTE,FADDCHAR,FADDSTYLE,FID,FSTEP,FATTRIBUTETYPE,FFORMAT,FSETTINGVALUE,FINITIAL,FLENGTH,FSPLITSIGN,FSEQ,FISSPLITSIGN,FISSORTITEM,FATTUSINGMODE) VALUES ('1','1','06G9B9/RN6NX','org.number',' ','1','06G8NQ6RMXDC',1,'8',' ',' ',1,8,' ',0,'0','1','3'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '06G9B9/RN6NY';
INSERT INTO t_cr_coderuleentry(FCUTSTYLE,FISVISABLE,FENTRYID,FVALUEATRIBUTE,FADDCHAR,FADDSTYLE,FID,FSTEP,FATTRIBUTETYPE,FFORMAT,FSETTINGVALUE,FINITIAL,FLENGTH,FSPLITSIGN,FSEQ,FISSPLITSIGN,FISSORTITEM,FATTUSINGMODE) VALUES ('1','1','06G9B9/RN6NY',' ',' ','1','06G8NQ6RMXDC',1,'1','GCZG',' ',1,8,'-',1,'1','0','1'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '06G9B9/RN6NZ';
INSERT INTO t_cr_coderuleentry(FCUTSTYLE,FISVISABLE,FENTRYID,FVALUEATRIBUTE,FADDCHAR,FADDSTYLE,FID,FSTEP,FATTRIBUTETYPE,FFORMAT,FSETTINGVALUE,FINITIAL,FLENGTH,FSPLITSIGN,FSEQ,FISSPLITSIGN,FISSORTITEM,FATTUSINGMODE) VALUES ('1','1','06G9B9/RN6NZ','createtime',' ','1','06G8NQ6RMXDC',1,'2','yyMMdd',' ',1,8,'-',2,'1','0','1'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '06G9B9/RN6O+';
INSERT INTO t_cr_coderuleentry(FCUTSTYLE,FISVISABLE,FENTRYID,FVALUEATRIBUTE,FADDCHAR,FADDSTYLE,FID,FSTEP,FATTRIBUTETYPE,FFORMAT,FSETTINGVALUE,FINITIAL,FLENGTH,FSPLITSIGN,FSEQ,FISSPLITSIGN,FISSORTITEM,FATTUSINGMODE) VALUES ('1','1','06G9B9/RN6O+',' ',' ','1','06G8NQ6RMXDC',1,'16',' ',' ',1,4,'-',3,'1','0','1'); 
