-- 仓位移动单数据脚本
--业务类型预制脚本
DELETE FROM t_bd_biztype WHERE FID = 757726917352082432;
INSERT INTO t_bd_biztype(FID,FCREATORID,FDISABLERID,FBIZCATEGORY,FMODIFYTIME,FDOMAIN,FISSALE,FCREATETIME,FDISABLEDATE,FNUMBER,FISPURCHASE,FSTATUS,FISPRESET,FMODIFIERID,FISINVENTORY,FENABLE,FMASTERID) VALUES (757726917352082432,1,0,'BZ',{ts'2019-11-12  11:08:07'},'2','0',{ts'2019-11-12  11:07:36'},null,'518','0','C','1',1,'0','1',757726917352082432); 

DELETE FROM t_bd_biztype_l WHERE FPKID = '0C16/1OWDR64';
INSERT INTO t_bd_biztype_l(FID,FPKID,FLOCALEID,FNAME,FDESCRIPTION) VALUES (757726917352082432,'0C16/1OWDR64','zh_CN','仓位移动',' '); 
DELETE FROM t_bd_biztype_l WHERE FPKID = '0C16/1OWDR65';
INSERT INTO t_bd_biztype_l(FID,FPKID,FLOCALEID,FNAME,FDESCRIPTION) VALUES (757726917352082432,'0C16/1OWDR65','zh_TW','倉位移動',' '); 

DELETE FROM t_sbd_biztypebillentity WHERE FENTRYID = 757726917385636864;
INSERT INTO t_sbd_biztypebillentity(FID,FENTRYID,FBILLFORM,FSEQ) VALUES (757726917352082432,757726917385636864,'im_locationtransfer',1); 

--单据类型预制数据脚本
DELETE FROM T_BAS_BILLTYPE WHERE FID = 757727698490869760;
INSERT INTO T_BAS_BILLTYPE(FID,FCREATORID,FDOCUMENTSTATUS,FMODIFYTIME,FCREATETIME,FDEFPRINTTEMPLATE,FNUMBER,FPRINTAFTERAUDIT,FSTATUS,FPARASETTINGXML,FLAYOUTSOLUTION,FMODIFIERID,FISDEFAULT,FBILLFORMID,FMAXPRINTCOUNT,FDEFWNREPORTTEMPLATE,FBILLCODERULEID,FENABLE,FCONTROLPRINTCOUNT,FISSYSPRESET,FBILLINITSETTING,FMASTERID) VALUES (757727698490869760,1,'0',{ts'2019-11-12  11:12:16'},{ts'2019-11-12  11:09:27'},' ','im_locationtransfer_BT_S','1','C',null,'0BC8P43C7P+8',1,'1','im_locationtransfer',1,null,' ','1','0','0',' ',757727698490869760); 

DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '0C164ROXMMJ9';
INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FNAME,FDESCRIPTION) VALUES (757727698490869760,'0C164ROXMMJ9','zh_CN','仓位移动单',' '); 
DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '0C164ROXMMJ=';
INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FNAME,FDESCRIPTION) VALUES (757727698490869760,'0C164ROXMMJ=','zh_TW','倉位移動單',' '); 


--预置编码规则
DELETE FROM T_CR_CodeRule WHERE FID = '0C+88RINK2PS';
INSERT INTO T_CR_CodeRule(FID,FCTRLMODE,FSPLITSIGN,FEXAMPLE,FAPPMODE,FDISABLEDATE,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FMODIFIERID,FISUPDATERECOVER,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('0C+88RINK2PS','1','-',' ','2',null,'0C+88RINK2PS','C',' ',null,' ',{ts'2019-11-11  14:47:54'},'im_locationtransfer',275188253840125478,'0','1',{ts'2019-11-11  14:47:54'},275188253840125478,null); 

DELETE FROM T_CR_CodeRule_l WHERE FPKID = '0C+88RIN8CIU';
INSERT INTO T_CR_CodeRule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0C+88RINK2PS','0C+88RIN8CIU','zh_CN','仓位移动单编码规则'); 
DELETE FROM T_CR_CodeRule_l WHERE FPKID = '0C+88RIN8CIT';
INSERT INTO T_CR_CodeRule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0C+88RINK2PS','0C+88RIN8CIT','zh_TW','倉位移動單編碼規則'); 

DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '0C+88RK4KQT+';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FISSPLITSIGN,FVALUEATRIBUTE,FADDCHAR) VALUES ('0C+88RINK2PS',1,'1',' ','0','0C+88RK4KQT+','1',1,' ',0,8,'1','CWYD','1',' ','0',' ',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '0C+88RK4KQT/';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FISSPLITSIGN,FVALUEATRIBUTE,FADDCHAR) VALUES ('0C+88RINK2PS',1,'2','-','1','0C+88RK4KQT/','1',1,'1',1,8,'1','yyMMdd','1',' ','1','biztime',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '0C+88RK4KQT0';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FISSPLITSIGN,FVALUEATRIBUTE,FADDCHAR) VALUES ('0C+88RINK2PS',1,'16','-','0','0C+88RK4KQT0','1',1,'1',2,6,'1',' ','1',' ','1',' ',' '); 
