--增加库存事务分组’委外领料单’ ’工序委外领料单’
delete from t_im_invschemegroup where fid ='988397277544630272';
insert into t_im_invschemegroup (FID, FNUMBER, FPARENTID, FLEVEL, FLONGNUMBER, FISLEAF, FENABLE, FSTATUS, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE, FMASTERID, FNAME, FFULLNAME)
values ('988397277544630272', 'omOut', '0', '1', 'omOut', '1', '1', 'C', '1', {ts'2020-09-25 10:34:02'}, '1',  {ts'2020-09-25 10:34:02'}, '0', null, '988397277544630272', '委外领料单', '委外领料单');

delete from t_im_invschemegroup_l where fpkid ='12D=S0L5127M';
insert into t_im_invschemegroup_l (FPKID, FID, FLOCALEID, FNAME, FFULLNAME)
values ('12D=S0L5127M', '988397277544630272', 'zh_CN', '委外领料单', '委外领料单');

delete from t_im_invschemegroup_l where fpkid ='12D=S0L5127N';
insert into t_im_invschemegroup_l (FPKID, FID, FLOCALEID, FNAME, FFULLNAME)
values ('12D=S0L5127N', '988397277544630272', 'zh_TW', '委外領料單', ' ');


DELETE FROM t_im_invschemes WHERE FID = 1234607078681610240;
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,ftransceiver) VALUES ('0','bos_org','0','bos_org',' ',1234607078681610240,'im_mdc_omoutbill',' ',687618054456301568,{ts'2021-08-31  00:00:00'},'1','A','1',0,1234607078681610240,'1',0,NULL,'367',988397277544630272,'普通委外领料',17526091,'1',{ts'2021-08-31  00:00:00'},' ',17526091,0,'1'); 
DELETE FROM t_im_invschemes WHERE FID = 1234608103266191360;
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,ftransceiver) VALUES ('0','bos_org','0','bos_org',' ',1234608103266191360,'im_mdc_omreturnbill',' ',687618334946187264,{ts'2021-08-31  00:00:00'},'1','A','1',0,1234608103266191360,'1',0,NULL,'3671',988397277544630272,'普通委外退料',17526091,'1',{ts'2021-08-31  00:00:00'},' ',17526091,0,'1'); 
DELETE FROM t_im_invschemes WHERE FID = 1234608882995693568;
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,ftransceiver) VALUES ('0','bos_org','0','bos_org',' ',1234608882995693568,'im_mdc_omoutbill',' ',687618054456301568,{ts'2021-08-31  00:00:00'},'1','A','1',0,1234608882995693568,'1',0,NULL,'3672',988397277544630272,'倒冲委外领料',17526091,'1',{ts'2021-08-31  00:00:00'},' ',17526091,0,'1'); 
DELETE FROM t_im_invschemes WHERE FID = 1234609588754574336;
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,ftransceiver) VALUES ('0','bos_org','0','bos_org',' ',1234609588754574336,'im_mdc_omfeedbill',' ',687618054456301568,{ts'2021-08-31  00:00:00'},'1','A','1',0,1234609588754574336,'1',0,NULL,'368',988397277544630272,'普通委外补料',17526091,'1',{ts'2021-08-31  00:00:00'},' ',17526091,0,'1'); 


DELETE FROM t_im_invschemes_l WHERE FPKID = '1VMW/NJKRVC6';
INSERT INTO t_im_invschemes_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1234607078681610240,'1VMW/NJKRVC6','zh_CN',' ','普通委外领料'); 
DELETE FROM t_im_invschemes_l WHERE FPKID = '1VMW/NJKRVC7';
INSERT INTO t_im_invschemes_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1234607078681610240,'1VMW/NJKRVC7','zh_TW',' ','普通委外領料'); 
DELETE FROM t_im_invschemes_l WHERE FPKID = '1VMW73NDVREN';
INSERT INTO t_im_invschemes_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1234608103266191360,'1VMW73NDVREN','zh_CN',' ','普通委外退料'); 
DELETE FROM t_im_invschemes_l WHERE FPKID = '1VMW73NDVREO';
INSERT INTO t_im_invschemes_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1234608103266191360,'1VMW73NDVREO','zh_TW',' ','普通委外退料'); 
DELETE FROM t_im_invschemes_l WHERE FPKID = '1VMWBT8J0M5U';
INSERT INTO t_im_invschemes_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1234608882995693568,'1VMWBT8J0M5U','zh_CN',' ','倒冲委外领料'); 
DELETE FROM t_im_invschemes_l WHERE FPKID = '1VMWBT8J0M5V';
INSERT INTO t_im_invschemes_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1234608882995693568,'1VMWBT8J0M5V','zh_TW',' ','倒衝委外領料'); 
DELETE FROM t_im_invschemes_l WHERE FPKID = '1VMWGYTTU6SY';
INSERT INTO t_im_invschemes_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1234609588754574336,'1VMWGYTTU6SY','zh_CN',' ','普通委外补料'); 
DELETE FROM t_im_invschemes_l WHERE FPKID = '1VMWGYTTU6SZ';
INSERT INTO t_im_invschemes_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1234609588754574336,'1VMWGYTTU6SZ','zh_TW',' ','普通委外補料'); 


DELETE FROM T_IM_OUTINVTYPEENTRY WHERE FENTRYID = 1234607078975211520;
INSERT INTO T_IM_OUTINVTYPEENTRY(FID,FOUTINVTYPEID,FENTRYID,FSEQ,FISDEFAULT) VALUES (1234607078681610240,688884005529250816,1234607078975211520,1,'1'); 
DELETE FROM T_IM_OUTINVTYPEENTRY WHERE FENTRYID = 1234607078975211521;
INSERT INTO T_IM_OUTINVTYPEENTRY(FID,FOUTINVTYPEID,FENTRYID,FSEQ,FISDEFAULT) VALUES (1234607078681610240,688884099724930048,1234607078975211521,2,'0'); 
DELETE FROM T_IM_OUTINVTYPEENTRY WHERE FENTRYID = 1234608103274579968;
INSERT INTO T_IM_OUTINVTYPEENTRY(FID,FOUTINVTYPEID,FENTRYID,FSEQ,FISDEFAULT) VALUES (1234608103266191360,688884005529250816,1234608103274579968,1,'1'); 
DELETE FROM T_IM_OUTINVTYPEENTRY WHERE FENTRYID = 1234608103274579969;
INSERT INTO T_IM_OUTINVTYPEENTRY(FID,FOUTINVTYPEID,FENTRYID,FSEQ,FISDEFAULT) VALUES (1234608103266191360,688884099724930048,1234608103274579969,2,'0'); 
DELETE FROM T_IM_OUTINVTYPEENTRY WHERE FENTRYID = 1234608883012470784;
INSERT INTO T_IM_OUTINVTYPEENTRY(FID,FOUTINVTYPEID,FENTRYID,FSEQ,FISDEFAULT) VALUES (1234608882995693568,688884005529250816,1234608883012470784,1,'1'); 
DELETE FROM T_IM_OUTINVTYPEENTRY WHERE FENTRYID = 1234608883012470785;
INSERT INTO T_IM_OUTINVTYPEENTRY(FID,FOUTINVTYPEID,FENTRYID,FSEQ,FISDEFAULT) VALUES (1234608882995693568,688884099724930048,1234608883012470785,2,'0'); 
DELETE FROM T_IM_OUTINVTYPEENTRY WHERE FENTRYID = 1234609588762962944;
INSERT INTO T_IM_OUTINVTYPEENTRY(FID,FOUTINVTYPEID,FENTRYID,FSEQ,FISDEFAULT) VALUES (1234609588754574336,688884005529250816,1234609588762962944,1,'1'); 
DELETE FROM T_IM_OUTINVTYPEENTRY WHERE FENTRYID = 1234609588762962945;
INSERT INTO T_IM_OUTINVTYPEENTRY(FID,FOUTINVTYPEID,FENTRYID,FSEQ,FISDEFAULT) VALUES (1234609588754574336,688884099724930048,1234609588762962945,2,'0'); 

DELETE FROM t_im_biztypeentry WHERE FENTRYID = 1234607078975335426;
INSERT INTO t_im_biztypeentry(FID,FBIZTYPEID,FENTRYID,FSEQ,FALLOWMANUALADD) VALUES (1234607078681610240,966651870204521472,1234607078975335426,1,'1'); 
DELETE FROM t_im_biztypeentry WHERE FENTRYID = 1234608103274703874;
INSERT INTO t_im_biztypeentry(FID,FBIZTYPEID,FENTRYID,FSEQ,FALLOWMANUALADD) VALUES (1234608103266191360,990500657985463296,1234608103274703874,1,'1'); 
DELETE FROM t_im_biztypeentry WHERE FENTRYID = 1234608883012594688;
INSERT INTO t_im_biztypeentry(FID,FBIZTYPEID,FENTRYID,FSEQ,FALLOWMANUALADD) VALUES (1234608882995693568,966651870204521472,1234608883012594688,1,'1'); 
DELETE FROM t_im_biztypeentry WHERE FENTRYID = 1234609588762839042;
INSERT INTO t_im_biztypeentry(FID,FBIZTYPEID,FENTRYID,FSEQ,FALLOWMANUALADD) VALUES (1234609588754574336,966651870204521472,1234609588762839042,1,'1'); 


DELETE FROM t_im_outinvstatusentry WHERE FENTRYID = 1234607078975211522;
INSERT INTO t_im_outinvstatusentry(FID,FOUTINVSTATUSID,FENTRYID,FSEQ,FISDEFAULT,FOUTINVSTATUSISPRESET) VALUES (1234607078681610240,691928582720825344,1234607078975211522,1,'1','0'); 
DELETE FROM t_im_outinvstatusentry WHERE FENTRYID = 1234608103274579970;
INSERT INTO t_im_outinvstatusentry(FID,FOUTINVSTATUSID,FENTRYID,FSEQ,FISDEFAULT,FOUTINVSTATUSISPRESET) VALUES (1234608103266191360,691928582720825344,1234608103274579970,1,'1','0'); 
DELETE FROM t_im_outinvstatusentry WHERE FENTRYID = 1234608883012470786;
INSERT INTO t_im_outinvstatusentry(FID,FOUTINVSTATUSID,FENTRYID,FSEQ,FISDEFAULT,FOUTINVSTATUSISPRESET) VALUES (1234608882995693568,691928582720825344,1234608883012470786,1,'1','0'); 
DELETE FROM t_im_outinvstatusentry WHERE FENTRYID = 1234609588762962946;
INSERT INTO t_im_outinvstatusentry(FID,FOUTINVSTATUSID,FENTRYID,FSEQ,FISDEFAULT,FOUTINVSTATUSISPRESET) VALUES (1234609588754574336,691928582720825344,1234609588762962946,1,'1','0'); 

