
-- 库存事务 scm库

--增加库存事务--3652-表头
DELETE FROM t_im_invschemes WHERE FID = 1046873570090720256;
INSERT INTO t_im_invschemes(FISNOTUPDATE,FOUTOWNERTYPE,FISINUPDATE,FOUTKEEPERTYPE,FDESCRIPTION,FMASTERID,FBILLFORMID,FOWNERTYPE,FTRANSCEIVERTYPEID,FCREATETIME,FENABLE,FINVDC,FISOUTUPDATE,FDISABLERID,FID,FISFORWARDAMOUNT,FOUTINVSTATUSID,FDISABLEDATE,FNUMBER,FGROUPID,FNAME,FMODIFIERID,FISPRESET,FMODIFYTIME,FKEEPERTYPE,FCREATORID,FINVSTATUSID) 
VALUES ('0','bos_org','0','bos_org','委外倒冲领料',1046873570090720256,'im_mdc_omproorder',' ',687618054456301568,{ts'2020-12-15  09:48:15'},'1','A','1',0,1046873570090720256,'1',691928582720825344,NULL,'3652',988397277544630272,'委外倒冲领料',870736664283096064,'1',{ts'2020-12-15  09:50:54'},' ',870736664283096064,0); 

DELETE FROM t_im_invschemes_l WHERE FPKID = '19KFTSM5PGDE';
INSERT INTO t_im_invschemes_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1046873570090720256,'19KFTSM5PGDE','zh_CN','委外倒冲领料','委外倒冲领料'); 
DELETE FROM t_im_invschemes_l WHERE FPKID = '19KFTSM5PGDF';
INSERT INTO t_im_invschemes_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1046873570090720256,'19KFTSM5PGDF','zh_TW','委外倒衝領料','委外倒衝領料'); 


--出库库存类型出库更新单据体
DELETE FROM T_IM_OUTINVTYPEENTRY WHERE FENTRYID = 1046873570124274688;
INSERT INTO T_IM_OUTINVTYPEENTRY(FID,FOUTINVTYPEID,FENTRYID,FSEQ,FISDEFAULT) VALUES (1046873570090720256,688884005529250816,1046873570124274688,1,'1'); 
DELETE FROM T_IM_OUTINVTYPEENTRY WHERE FENTRYID = 1046873570124274689;
INSERT INTO T_IM_OUTINVTYPEENTRY(FID,FOUTINVTYPEID,FENTRYID,FSEQ,FISDEFAULT) VALUES (1046873570090720256,688884099724930048,1046873570124274689,2,'0'); 


--关联业务类型
DELETE FROM t_im_biztypeentry WHERE FENTRYID = 1046873570124624898;
INSERT INTO t_im_biztypeentry(FID,FBIZTYPEID,FENTRYID,FSEQ,FALLOWMANUALADD) VALUES (1046873570090720256,966651870204521472,1046873570124624898,1,'1'); 

