-- scm库执行以下数据[null]
DELETE FROM T_IM_BILLFIELDSETTING WHERE FID = 1463044354011565056;
INSERT INTO T_IM_BILLFIELDSETTING(FID,FCREATETIME,FBILL,FENABLE,FMODIFIERID,FMODIFYTIME,FSTATUS,FCREATORID) VALUES (1463044354011565056,{ts'2022-07-12  00:00:00'},'im_ospurinbill','1',1155582543786049536,{ts'2022-07-12  00:00:00'},'C',1155582543786049536); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838720;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.qty',1463044354011565056,'billentry',1463044354103838720,'1',1,'qty','物料明细.数量'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838721;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.baseqty',1463044354011565056,'billentry',1463044354103838721,'1',2,'baseqty','物料明细.基本数量'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838722;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.qtyunit2nd',1463044354011565056,'billentry',1463044354103838722,'1',3,'qtyunit2nd','物料明细.辅助数量'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838723;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.discountamount',1463044354011565056,'billentry',1463044354103838723,'1',4,'discountamount','物料明细.折扣额'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838724;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.taxamount',1463044354011565056,'billentry',1463044354103838724,'1',5,'taxamount','物料明细.税额'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838725;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.curtaxamount',1463044354011565056,'billentry',1463044354103838725,'1',6,'curtaxamount','物料明细.税额(本位币)'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838726;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.amount',1463044354011565056,'billentry',1463044354103838726,'1',7,'amount','物料明细.金额'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838727;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.curamount',1463044354011565056,'billentry',1463044354103838727,'1',8,'curamount','物料明细.金额(本位币)'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838728;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.amountandtax',1463044354011565056,'billentry',1463044354103838728,'1',9,'amountandtax','物料明细.价税合计'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838729;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.curamountandtax',1463044354011565056,'billentry',1463044354103838729,'1',10,'curamountandtax','物料明细.价税合计(本位币)'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838730;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.remainreturnqty',1463044354011565056,'billentry',1463044354103838730,'1',11,'remainreturnqty','物料明细.未退库数量'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838731;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.remainreturnbaseqty',1463044354011565056,'billentry',1463044354103838731,'1',12,'remainreturnbaseqty','物料明细.未退库基本数量'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838732;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.remainjoinpriceqty',1463044354011565056,'billentry',1463044354103838732,'1',13,'remainjoinpriceqty','物料明细.剩余应付数量'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838733;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.remainjoinpricebaseqty',1463044354011565056,'billentry',1463044354103838733,'1',14,'remainjoinpricebaseqty','物料明细.剩余应付基本数量'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838734;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.returnqty',1463044354011565056,'billentry',1463044354103838734,'1',15,'returnqty','物料明细.已退库数量'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838735;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.returnbaseqty',1463044354011565056,'billentry',1463044354103838735,'1',16,'returnbaseqty','物料明细.已退库基本数量'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838736;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.joinpriceqty',1463044354011565056,'billentry',1463044354103838736,'1',17,'joinpriceqty','物料明细.应付数量'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838737;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.joinpricebaseqty',1463044354011565056,'billentry',1463044354103838737,'1',18,'joinpricebaseqty','物料明细.应付基本数量'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838738;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.verifyqty',1463044354011565056,'billentry',1463044354103838738,'1',19,'verifyqty','物料明细.已核销数量'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838739;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.verifybaseqty',1463044354011565056,'billentry',1463044354103838739,'1',20,'verifybaseqty','物料明细.已核销基本数量'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838740;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.unverifyqty',1463044354011565056,'billentry',1463044354103838740,'1',21,'unverifyqty','物料明细.未核销数量'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838741;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.unverifybaseqty',1463044354011565056,'billentry',1463044354103838741,'1',22,'unverifybaseqty','物料明细.未核销基本数量'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838742;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.vmisettleqty',1463044354011565056,'billentry',1463044354103838742,'1',23,'vmisettleqty','物料明细.VMI已结算数量'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838743;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.vmisettlebaseqty',1463044354011565056,'billentry',1463044354103838743,'1',24,'vmisettlebaseqty','物料明细.VMI已结算基本数量'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838744;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.vmiremainsettleqty',1463044354011565056,'billentry',1463044354103838744,'1',25,'vmiremainsettleqty','物料明细.VMI剩余结算数量'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838745;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.vmiremainsettlebaseqty',1463044354011565056,'billentry',1463044354103838745,'1',26,'vmiremainsettlebaseqty','物料明细.VMI剩余结算基本数量'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838746;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.intercostamt',1463044354011565056,'billentry',1463044354103838746,'1',27,'intercostamt','物料明细.计成本金额'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838747;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.curdeductibleamt',1463044354011565056,'billentry',1463044354103838747,'1',28,'curdeductibleamt','物料明细.可抵扣税额'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838748;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.osverifyqty',1463044354011565056,'billentry',1463044354103838748,'1',29,'osverifyqty','物料明细.委外已核销数量'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838749;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.osverifybaseqty',1463044354011565056,'billentry',1463044354103838749,'1',30,'osverifybaseqty','物料明细.委外已核销基本数量'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838750;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.osunverifyqty',1463044354011565056,'billentry',1463044354103838750,'1',31,'osunverifyqty','物料明细.委外未核销数量'); 
DELETE FROM T_IM_FIELDSETTINGENTRY WHERE FENTRYID = 1463044354103838751;
INSERT INTO T_IM_FIELDSETTINGENTRY(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.osunverifybaseqty',1463044354011565056,'billentry',1463044354103838751,'1',32,'osunverifybaseqty','物料明细.委外未核销基本数量'); 

-- scm库执行以下数据["委外采购退、补、换货"]
DELETE FROM T_IM_INVSCHEMES WHERE FID = 1991989188433761280;
INSERT INTO T_IM_INVSCHEMES(FISNOTUPDATE,FOUTOWNERTYPE,FISINUPDATE,FOUTKEEPERTYPE,FDESCRIPTION,FMASTERID,FBILLFORMID,FOWNERTYPE,FTRANSCEIVERTYPEID,FCREATETIME,FENABLE,FINVDC,FISOUTUPDATE,FDISABLERID,FID,FISFORWARDAMOUNT,FOUTINVSTATUSID,FDISABLEDATE,FNUMBER,FNAME,FZEROCOST,FGROUPID,FBIZDIRECTION,FMODIFIERID,FISPRESET,FTRANSCEIVER,FMODIFYTIME,FKEEPERTYPE,FCREATORID,FINVSTATUSID) VALUES ('0',' ','1',' ',' ',1991989188433761280,'im_ospurinbill',' ',687617195957770240,{ts'2024-07-11  00:00:00'},'1','A','0',0,1991989188433761280,'1',0,NULL,'1231','委外采购退、补、换货','0',1443534772293861376,'1',13466739,'1','0',{ts'2024-07-11  00:00:00'},' ',13466739,0); 
DELETE FROM T_IM_INVSCHEMES_L WHERE FPKID = '48OEM4JF27JR';
INSERT INTO T_IM_INVSCHEMES_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1991989188433761280,'48OEM4JF27JR','zh_CN',' ','委外采购退、补、换货'); 
DELETE FROM T_IM_INVSCHEMES_L WHERE FPKID = '48OEM4JF27JS';

DELETE FROM T_IM_INVTYPEENTRY WHERE FENTRYID = 1991989188609922048;
INSERT INTO T_IM_INVTYPEENTRY(FID,FENTRYID,FSEQ,FISDEFAULT,FKEEPERTYPE1,FINVTYPEISPRESET,FOWNERTYPE1,FINVTYPEID) VALUES (1991989188433761280,1991989188609922048,1,'1','bos_org','0','bos_org',688884005529250816); 
DELETE FROM T_IM_BIZTYPEENTRY WHERE FENTRYID = 1991989320545947648;
INSERT INTO T_IM_BIZTYPEENTRY(FBIZTYPEID,FID,FENTRYID,FBIZTYPEISPRESET,FSEQ,FALLOWMANUALADD) VALUES (1442619247460089856,1991989188433761280,1991989320545947648,'0',1,'1'); 
DELETE FROM T_IM_BIZTYPEENTRY WHERE FENTRYID = 1991989320545947649;
INSERT INTO T_IM_BIZTYPEENTRY(FBIZTYPEID,FID,FENTRYID,FBIZTYPEISPRESET,FSEQ,FALLOWMANUALADD) VALUES (1991983860619105280,1991989188433761280,1991989320545947649,'0',2,'1'); 
DELETE FROM T_IM_INVSTATUSENTRY WHERE FENTRYID = 1991989188609921026;
INSERT INTO T_IM_INVSTATUSENTRY(FID,FENTRYID,FSEQ,FISDEFAULT,FINVSTATUSISPRESET,FINVSTATUSID) VALUES (1991989188433761280,1991989188609921026,1,'1','0',691928582720825344); 
