-- 更新 物料类销售退货检验（不更新库存） 4102 为禁用
update t_im_invschemes set FENABLE = 0 WHERE FID = 1576164122117026816;
-- scm库执行以下数据["物料类销售请检","物料类销售退货检验（更新库存）","物料类销售退货质检出库（可用）","物料类库存请检"]
DELETE FROM T_IM_INVSCHEMES WHERE FID = 1672381435694147584;
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','bos_org','1','bos_org',' ',1672381435694147584,'im_saloutbill','bd_customer',1576001318999415808,{ts'2023-04-27  00:00:00'},'1','A','1',0,1672381435694147584,'1',0,NULL,'420','物料类销售退货质检出库（可用）','0',452663424212569088,'1',1625948903029587968,'1','2',{ts'2023-04-27  00:00:00'},'bos_org',1625948903029587968,0); 
DELETE FROM T_IM_INVSCHEMES WHERE FID = 1672370804282622976;
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','bos_org','1','bos_org',' ',1672370804282622976,'im_invinspectbill','bos_org',1575990703282992128,{ts'2023-04-27  00:00:00'},'1','A','1',0,1672370804282622976,'0',0,NULL,'450','物料类库存请检','0',1576004359660100608,'0',1625948903029587968,'1','2',{ts'2023-06-07  00:00:00'},'bos_org',1625948903029587968,0); 
DELETE FROM T_IM_INVSCHEMES WHERE FID = 1576121557565168640;
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',' ',' ',1576121557565168640,'im_invinspectbill','bd_customer',687619869340030976,{ts'2022-12-15  00:00:00'},'1','A','0',0,1576121557565168640,'0',0,NULL,'4101','物料类销售退货检验（更新库存）','0',1576004359660100608,'0',1625948903029587968,'1','0',{ts'2023-06-07  00:00:00'},'bos_org',1155582543786049536,0); 
DELETE FROM T_IM_INVSCHEMES WHERE FID = 1576083779586372608;
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','bos_org','1','bos_org',' ',1576083779586372608,'im_invinspectbill','bos_org',1575990703282992128,{ts'2022-12-15  00:00:00'},'1','A','1',0,1576083779586372608,'1',0,NULL,'410','物料类销售请检','0',1576004359660100608,'0',1155582543786049536,'1','2',{ts'2022-12-21  00:00:00'},'bos_org',1155582543786049536,0); 
DELETE FROM T_IM_INVSCHEMES_L WHERE FPKID = '2YKVGJ+LMPJH';
INSERT INTO T_IM_INVSCHEMES_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1576083779586372608,'2YKVGJ+LMPJH','zh_CN',' ','物料类销售请检'); 
DELETE FROM T_IM_INVSCHEMES_L WHERE FPKID = '2YKVGJ+LMPJI';
INSERT INTO T_IM_INVSCHEMES_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1576083779586372608,'2YKVGJ+LMPJI','zh_TW',' ','物料類銷售請檢'); 
DELETE FROM T_IM_INVSCHEMES_L WHERE FPKID = '2YL0IU6ZISTU';
INSERT INTO T_IM_INVSCHEMES_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1576121557565168640,'2YL0IU6ZISTU','zh_CN',' ','物料类销售退货检验（更新库存）'); 
DELETE FROM T_IM_INVSCHEMES_L WHERE FPKID = '2YL0IU6ZISTV';
INSERT INTO T_IM_INVSCHEMES_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1576121557565168640,'2YL0IU6ZISTV','zh_TW',' ','物料類銷售退貨檢驗（更新庫存）'); 
DELETE FROM T_IM_INVSCHEMES_L WHERE FPKID = '38E5=F405JI7';
INSERT INTO T_IM_INVSCHEMES_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1672370804282622976,'38E5=F405JI7','zh_CN',' ','物料类库存请检'); 
DELETE FROM T_IM_INVSCHEMES_L WHERE FPKID = '38E5=F405JI8';
INSERT INTO T_IM_INVSCHEMES_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1672370804282622976,'38E5=F405JI8','zh_TW',' ','物料類庫存請檢'); 
DELETE FROM T_IM_INVSCHEMES_L WHERE FPKID = '38E79XH2ZEYX';
INSERT INTO T_IM_INVSCHEMES_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1672381435694147584,'38E79XH2ZEYX','zh_CN',' ','物料类销售退货质检出库（可用）'); 
DELETE FROM T_IM_INVSCHEMES_L WHERE FPKID = '38E79XH2ZEYY';
INSERT INTO T_IM_INVSCHEMES_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1672381435694147584,'38E79XH2ZEYY','zh_TW',' ','物料類銷售退貨質檢出庫（可用）'); 
DELETE FROM T_IM_INVTYPEENTRY WHERE FENTRYID = 1672370804324566016;
INSERT INTO T_IM_INVTYPEENTRY(FID,FENTRYID,FSEQ,FISDEFAULT,FINVTYPEISPRESET,FINVTYPEID) VALUES (1672370804282622976,1672370804324566016,1,'1','1',688884005529250816); 
DELETE FROM T_IM_INVTYPEENTRY WHERE FENTRYID = 1672381435719313408;
INSERT INTO T_IM_INVTYPEENTRY(FID,FENTRYID,FSEQ,FISDEFAULT,FINVTYPEISPRESET,FINVTYPEID) VALUES (1672381435694147584,1672381435719313408,1,'1','1',688884005529250816); 
DELETE FROM T_IM_INVTYPEENTRY WHERE FENTRYID = 1576083779921916928;
INSERT INTO T_IM_INVTYPEENTRY(FID,FENTRYID,FSEQ,FISDEFAULT,FINVTYPEISPRESET,FINVTYPEID) VALUES (1576083779586372608,1576083779921916928,1,'1','1',688884005529250816); 
DELETE FROM T_IM_INVTYPEENTRY WHERE FENTRYID = 1576121557909101568;
INSERT INTO T_IM_INVTYPEENTRY(FID,FENTRYID,FSEQ,FISDEFAULT,FINVTYPEISPRESET,FINVTYPEID) VALUES (1576121557565168640,1576121557909101568,1,'1','1',688884005529250816); 
DELETE FROM T_IM_OUTINVTYPEENTRY WHERE FENTRYID = 1672370804324689922;
INSERT INTO T_IM_OUTINVTYPEENTRY(FOUTINVTYPEISPRESET,FID,FOUTINVTYPEID,FENTRYID,FSEQ,FISDEFAULT) VALUES ('1',1672370804282622976,688884005529250816,1672370804324689922,1,'1'); 
DELETE FROM T_IM_OUTINVTYPEENTRY WHERE FENTRYID = 1672381435719189506;
INSERT INTO T_IM_OUTINVTYPEENTRY(FOUTINVTYPEISPRESET,FID,FOUTINVTYPEID,FENTRYID,FSEQ,FISDEFAULT) VALUES ('1',1672381435694147584,688884005529250816,1672381435719189506,1,'1'); 
DELETE FROM T_IM_OUTINVTYPEENTRY WHERE FENTRYID = 0;
INSERT INTO T_IM_OUTINVTYPEENTRY(FOUTINVTYPEISPRESET,FID,FOUTINVTYPEID,FENTRYID,FSEQ,FISDEFAULT) VALUES ('1',0,688884312753630208,0,0,'0'); 
DELETE FROM T_IM_OUTINVTYPEENTRY WHERE FENTRYID = 1576083779922025474;
INSERT INTO T_IM_OUTINVTYPEENTRY(FOUTINVTYPEISPRESET,FID,FOUTINVTYPEID,FENTRYID,FSEQ,FISDEFAULT) VALUES ('1',1576083779586372608,688884005529250816,1576083779922025474,1,'1'); 
DELETE FROM T_IM_BIZTYPEENTRY WHERE FENTRYID = 1576083779921916929;
INSERT INTO T_IM_BIZTYPEENTRY(FBIZTYPEID,FID,FENTRYID,FBIZTYPEISPRESET,FSEQ,FALLOWMANUALADD) VALUES (422876630176775168,1576083779586372608,1576083779921916929,'1',1,'0'); 
DELETE FROM T_IM_BIZTYPEENTRY WHERE FENTRYID = 1576121557908993026;
INSERT INTO T_IM_BIZTYPEENTRY(FBIZTYPEID,FID,FENTRYID,FBIZTYPEISPRESET,FSEQ,FALLOWMANUALADD) VALUES (688855385217756160,1576121557565168640,1576121557908993026,'1',1,'0'); 
DELETE FROM T_IM_BIZTYPEENTRY WHERE FENTRYID = 1672370804324566017;
INSERT INTO T_IM_BIZTYPEENTRY(FBIZTYPEID,FID,FENTRYID,FBIZTYPEISPRESET,FSEQ,FALLOWMANUALADD) VALUES (1655704625694647296,1672370804282622976,1672370804324566017,'1',1,'1'); 
DELETE FROM T_IM_BIZTYPEENTRY WHERE FENTRYID = 1672381435719313409;
INSERT INTO T_IM_BIZTYPEENTRY(FBIZTYPEID,FID,FENTRYID,FBIZTYPEISPRESET,FSEQ,FALLOWMANUALADD) VALUES (688855385217756160,1672381435694147584,1672381435719313409,'1',1,'0'); 
DELETE FROM T_IM_INVSTATUSENTRY WHERE FENTRYID = 1576083779922025475;
INSERT INTO T_IM_INVSTATUSENTRY(FID,FENTRYID,FSEQ,FISDEFAULT,FINVSTATUSISPRESET,FINVSTATUSID) VALUES (1576083779586372608,1576083779922025475,1,'1','1',691930349319792640); 
DELETE FROM T_IM_INVSTATUSENTRY WHERE FENTRYID = 1576121557909101569;
INSERT INTO T_IM_INVSTATUSENTRY(FID,FENTRYID,FSEQ,FISDEFAULT,FINVSTATUSISPRESET,FINVSTATUSID) VALUES (1576121557565168640,1576121557909101569,1,'1','1',691930349319792640); 
DELETE FROM T_IM_INVSTATUSENTRY WHERE FENTRYID = 1672370804324689923;
INSERT INTO T_IM_INVSTATUSENTRY(FID,FENTRYID,FSEQ,FISDEFAULT,FINVSTATUSISPRESET,FINVSTATUSID) VALUES (1672370804282622976,1672370804324689923,1,'1','1',691930349319792640); 
DELETE FROM T_IM_INVSTATUSENTRY WHERE FENTRYID = 1672381435719189507;
INSERT INTO T_IM_INVSTATUSENTRY(FID,FENTRYID,FSEQ,FISDEFAULT,FINVSTATUSISPRESET,FINVSTATUSID) VALUES (1672381435694147584,1672381435719189507,1,'1','1',691930349319792640); 
DELETE FROM T_IM_OUTINVSTATUSENTRY WHERE FENTRYID = 1576083779921916930;
INSERT INTO T_IM_OUTINVSTATUSENTRY(FID,FOUTINVSTATUSID,FENTRYID,FSEQ,FISDEFAULT,FOUTINVSTATUSISPRESET) VALUES (1576083779586372608,691928582720825344,1576083779921916930,1,'1','1'); 
DELETE FROM T_IM_OUTINVSTATUSENTRY WHERE FENTRYID = 1672370804324566018;
INSERT INTO T_IM_OUTINVSTATUSENTRY(FID,FOUTINVSTATUSID,FENTRYID,FSEQ,FISDEFAULT,FOUTINVSTATUSISPRESET) VALUES (1672370804282622976,691928582720825344,1672370804324566018,1,'1','1'); 
DELETE FROM T_IM_OUTINVSTATUSENTRY WHERE FENTRYID = 1672381435719313410;
INSERT INTO T_IM_OUTINVSTATUSENTRY(FID,FOUTINVSTATUSID,FENTRYID,FSEQ,FISDEFAULT,FOUTINVSTATUSISPRESET) VALUES (1672381435694147584,691928582720825344,1672381435719313410,1,'1','1'); 

-- scm库执行以下数据["物料类采购检验（更新库存）"]
DELETE FROM T_IM_INVSCHEMES WHERE FID = 1670325985754608640;
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','bd_supplier','1','bos_org',' ',1670325985754608640,'im_invinspectbill','bd_supplier',1703748165661935616,{ts'2023-04-24  00:00:00'},'1','A','1',0,1670325985754608640,'0',0,NULL,'440','物料类采购检验（更新库存）','0',1576004359660100608,'0',1625948903029587968,'1','2',{ts'2023-06-09  00:00:00'},'bos_org',1625948903029587968,0); 
DELETE FROM T_IM_INVSCHEMES_L WHERE FPKID = '385C7WEHD0J8';
INSERT INTO T_IM_INVSCHEMES_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1670325985754608640,'385C7WEHD0J8','zh_CN',' ','物料类采购检验（更新库存）'); 
DELETE FROM T_IM_INVSCHEMES_L WHERE FPKID = '385C7WEHD0J9';
INSERT INTO T_IM_INVSCHEMES_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1670325985754608640,'385C7WEHD0J9','zh_TW',' ','物料類采購檢驗（更新庫存）'); 
DELETE FROM T_IM_INVTYPEENTRY WHERE FENTRYID = 1672372044865595392;
INSERT INTO T_IM_INVTYPEENTRY(FID,FENTRYID,FSEQ,FISDEFAULT,FINVTYPEISPRESET,FINVTYPEID) VALUES (1670325985754608640,1672372044865595392,1,'1','1',688884217048001536); 
DELETE FROM T_IM_OUTINVTYPEENTRY WHERE FENTRYID = 1688327459566519296;
INSERT INTO T_IM_OUTINVTYPEENTRY(FOUTINVTYPEISPRESET,FID,FOUTINVTYPEID,FENTRYID,FSEQ,FISDEFAULT) VALUES ('1',1670325985754608640,688884217048001536,1688327459566519296,1,'1'); 
DELETE FROM T_IM_BIZTYPEENTRY WHERE FENTRYID = 1672366678203295744;
INSERT INTO T_IM_BIZTYPEENTRY(FBIZTYPEID,FID,FENTRYID,FBIZTYPEISPRESET,FSEQ,FALLOWMANUALADD) VALUES (422857170485263360,1670325985754608640,1672366678203295744,'1',1,'0'); 
DELETE FROM T_IM_INVSTATUSENTRY WHERE FENTRYID = 1672372044865471488;
INSERT INTO T_IM_INVSTATUSENTRY(FID,FENTRYID,FSEQ,FISDEFAULT,FINVSTATUSISPRESET,FINVSTATUSID) VALUES (1670325985754608640,1672372044865471488,1,'1','1',691930349319792640); 
DELETE FROM T_IM_OUTINVSTATUSENTRY WHERE FENTRYID = 1688327459566643200;
INSERT INTO T_IM_OUTINVSTATUSENTRY(FID,FOUTINVSTATUSID,FENTRYID,FSEQ,FISDEFAULT,FOUTINVSTATUSISPRESET) VALUES (1670325985754608640,691930349319792640,1688327459566643200,1,'1','1'); 

-- scm库执行以下数据["其他出库（不参与存货核算）"]
DELETE FROM T_IM_INVSCHEMES WHERE FID = 1702944797339203584;
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','bd_customer','0','bos_org',' ',1702944797339203584,'im_otheroutbill',' ',739535399801672704,{ts'2023-06-08  00:00:00'},'1','A','1',0,1702944797339203584,'0',0,NULL,'3555','其他出库（不参与存货核算）','0',376675775438408704,'0',1625948903029587968,'1','1',{ts'2023-06-08  00:00:00'},' ',1625948903029587968,0); 
DELETE FROM T_IM_INVSCHEMES_L WHERE FPKID = '3B5MXLM3J881';
INSERT INTO T_IM_INVSCHEMES_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1702944797339203584,'3B5MXLM3J881','zh_CN',' ','其他出库（不参与存货核算）'); 
DELETE FROM T_IM_INVSCHEMES_L WHERE FPKID = '3B5MXLM3J882';
INSERT INTO T_IM_INVSCHEMES_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1702944797339203584,'3B5MXLM3J882','zh_TW',' ','其他出庫（不參與存貨核算）'); 
DELETE FROM T_IM_OUTINVTYPEENTRY WHERE FENTRYID = 1702944797599250432;
INSERT INTO T_IM_OUTINVTYPEENTRY(FOUTINVTYPEISPRESET,FID,FOUTINVTYPEID,FENTRYID,FSEQ,FISDEFAULT) VALUES ('1',1702944797339203584,688884005529250816,1702944797599250432,1,'1'); 
DELETE FROM T_IM_BIZTYPEENTRY WHERE FENTRYID = 1702947906400598016;
INSERT INTO T_IM_BIZTYPEENTRY(FBIZTYPEID,FID,FENTRYID,FBIZTYPEISPRESET,FSEQ,FALLOWMANUALADD) VALUES (739548857603766272,1702944797339203584,1702947906400598016,'1',1,'0'); 
DELETE FROM T_IM_OUTINVSTATUSENTRY WHERE FENTRYID = 1702944797599251458;
INSERT INTO T_IM_OUTINVSTATUSENTRY(FID,FOUTINVSTATUSID,FENTRYID,FSEQ,FISDEFAULT,FOUTINVSTATUSISPRESET) VALUES (1702944797339203584,691930349319792640,1702944797599251458,1,'1','1'); 

-- scm库执行以下数据["IM_INVINSPECTBILL_U1"]
DELETE FROM T_IM_INVQUERYCONF WHERE FID = 1612201098440132608;
INSERT INTO T_IM_INVQUERYCONF(FMIDDLEINSERT,FSRCBILLOBJ,FUSETYPE,FQTYRULE,FRETURNTYPE,FMATCHSHORTAGE,FNEWDEAL,FDESCRIPTION,FMASTERID,FUNITTRAN,FOPERATEKEY,FCREATETIME,FENABLE,FSRCBILLENTRY,FPROQTYFIELD,FID,FENTRYNOUPDATEFIELDKEY,FPLUGINNAME,FSTATUS,FNUMBER,FNAME,FMUSTSELECTENTRY,FACTIONID,FMODIFIERID,FISPRESET,FMODIFYTIME,FDEALTYPE,FSRCBILLENTRYNAME,FSAVESHORTAGEROW,FCREATORID,FFILTERPLUGINNAME) VALUES ('0','im_invinspectbill','A','minrule','multi','popconfirm','1',' ',1612201098440132608,'0','invbill_invquery',{ts'2023-02-03  00:00:00'},'1','billentry','avbqty',1612201098440132608,'noupdateinvfields',' ','A','IM_INVINSPECTBILL_U1','IM_INVINSPECTBILL_U1','0',' ',1625948903029587968,'1',{ts'2023-05-26  00:00:00'},'systemdeal','物料明细','0',0,' '); 
DELETE FROM T_IM_INVQUERYCONF_L WHERE FPKID = '31/WUU/OBCDI';
INSERT INTO T_IM_INVQUERYCONF_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1612201098440132608,'31/WUU/OBCDI','zh_CN',' ','IM_INVINSPECTBILL_U1'); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1612201098448521216;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1612201098440132608,'库存组织','0','1','1',1612201098448521216,'0',100,'org','org','0','库存组织',1); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1612201098448521217;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1612201098440132608,'物料明细.物料编码','0','1','1',1612201098448521217,'1',95,'billentry.material','material','1','物料',2); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1612201098448521218;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1612201098440132608,'物料明细.出库货主类型','0','1','0',1612201098448521218,'1',90,'billentry.outownertype','ownertype','1','货主类型',3); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1612201098448521219;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1612201098440132608,'物料明细.出库货主','0','1','0',1612201098448521219,'1',85,'billentry.outowner','owner','1','货主',4); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1612201098448521220;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1612201098440132608,'物料明细.出库仓库','0','1','0',1612201098448521220,'1',90,'billentry.outwarehouse','warehouse','0','仓库',5); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1612201098448521221;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1612201098440132608,'物料明细.出库仓位','0','1','0',1612201098448521221,'1',85,'billentry.outlocation','location','0','仓位',6); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1612201098448521222;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1612201098440132608,'物料明细.出库保管者类型','0','1','0',1612201098448521222,'1',90,'billentry.outkeepertype','keepertype','1','保管者类型',7); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1612201098448521223;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1612201098440132608,'物料明细.辅助属性','0','1','0',1612201098448521223,'1',90,'billentry.auxpty','auxpty','1','辅助属性',8); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1612201098448521224;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1612201098440132608,'物料明细.出库保管者','0','1','0',1612201098448521224,'1',85,'billentry.outkeeper','keeper','1','保管者',9); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1612201098448521225;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1612201098440132608,'物料明细.出库库存状态','0','1','0',1612201098448521225,'1',90,'billentry.outinvstatus','invstatus','0','库存状态',10); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1612201098448521226;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1612201098440132608,'物料明细.基本单位','0','1','0',1612201098448521226,'1',90,'billentry.baseunit','baseunit','0','基本单位',11); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1612201098448521227;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1612201098440132608,'物料明细.计量单位','0','1','0',1612201098448521227,'1',85,'billentry.unit','unit','0','库存单位',12); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1612201098448521228;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1612201098440132608,'物料明细.辅助单位','0','1','0',1612201098448521228,'1',85,'billentry.unit2nd','unit2nd','0','辅助单位',13); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1612201098448521229;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1612201098440132608,'物料明细.生产日期','0','1','0',1612201098448521229,'1',80,'billentry.producedate','producedate','0','生产日期',14); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1612201098448521230;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1612201098440132608,'物料明细.到期日期','0','1','0',1612201098448521230,'1',75,'billentry.expirydate','expirydate','0','有效期至',15); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1692071325046149120;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1612201098440132608,'物料明细.出库库存类型','0','1','0',1692071325046149120,'1',90,'billentry.outinvtype','invtype','0','库存类型',16); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1692071325046149121;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1612201098440132608,'物料明细.项目号','0','1','0',1692071325046149121,'1',85,'billentry.project','project','0','项目',17); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1692071325046149122;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1612201098440132608,'物料明细.基本数量','0','0','0',1692071325046149122,'1',20,'billentry.baseqty','avbbaseqty','0','可用量(基本单位)',18); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1692071325046149123;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1612201098440132608,'物料明细.数量','0','0','0',1692071325046149123,'1',15,'billentry.qty','avbqty','0','可用量(库存单位)',19); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1692071325046149124;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1612201098440132608,'物料明细.辅助数量','0','0','0',1692071325046149124,'1',10,'billentry.qtyunit2nd','avbqty2nd','0','可用量(辅助单位)',20); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1692071325046149125;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1612201098440132608,'物料明细.批号','0','1','0',1692071325046149125,'1',85,'billentry.lotnumber','lotnum','1','批号',21); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1692071325046149126;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1612201098440132608,'物料明细.配置号','0','1','0',1692071325046149126,'1',85,'billentry.configuredcode','configuredcode','0','配置号',22); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1692071325046149127;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1612201098440132608,'物料明细.跟踪号','0','1','0',1692071325046149127,'1',85,'billentry.tracknumber','tracknumber','0','跟踪号',23); 


-- scm库执行以下数据["盘点选单调整_库存请检单"]
DELETE FROM T_SBS_BILLFIELDMAP WHERE FID = 1660789947193369600;
INSERT INTO T_SBS_BILLFIELDMAP(FID,FMODIFYDATE,FTARGETOBJ,FSOURCEBILL,FMODIFIERID,FCREATEDATE,FBIZAPPID,FISENABLE,FCREATERID,FNUMBER,FNAME,FISSYSINIT) VALUES (1660789947193369600,{ts'2023-05-24  00:00:00'},'im_count_adjust_map','im_invinspectbill',1625948903029587968,{ts'2023-04-11  00:00:00'},'=9Q86DR2P+Q','1',1625948903029587968,'adjust_map_im_invinspectbill','盘点选单调整_库存请检单','1'); 
DELETE FROM T_SBS_BILLFIELDMAP_L WHERE FPKID = '37+OFYAHRKTR';
INSERT INTO T_SBS_BILLFIELDMAP_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1660789947193369600,'37+OFYAHRKTR','zh_CN','盘点选单调整_库存请检单'); 
DELETE FROM T_SBS_BILLFIELDMAP_L WHERE FPKID = '37+OFYAHRKTS';
INSERT INTO T_SBS_BILLFIELDMAP_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1660789947193369600,'37+OFYAHRKTS','zh_TW','盤點選單調整_庫存請檢單'); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1660789947193368576;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('billno',' ',1660789947193369600,'单据编号',' ','单据编号','0',1660789947193368576,1,'billno',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1660789947193368577;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('bookdate',' ',1660789947193369600,'日期',' ','记账日期','0',1660789947193368577,2,'bookdate',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712384;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('auditdate',' ',1660789947193369600,'审核日期',' ','审核时间','0',1692082575469712384,3,'auditdate',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712385;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('billtype',' ',1660789947193369600,'单据类型',' ','单据类型','0',1692082575469712385,4,'billtype',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712386;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('inorg',' ',1660789947193369600,'入库组织',' ','库存组织','0',1692082575469712386,5,'org',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712387;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('material',' ',1660789947193369600,'物料',' ','物料明细.物料编码','0',1692082575469712387,6,'billentry.material',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712388;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('auxpty',' ',1660789947193369600,'辅助属性',' ','物料明细.辅助属性','0',1692082575469712388,7,'billentry.auxpty',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712389;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('lotnumber',' ',1660789947193369600,'批号',' ','物料明细.批号','0',1692082575469712389,8,'billentry.lotnumber',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712390;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('productdate',' ',1660789947193369600,'生产日期',' ','物料明细.生产日期','0',1692082575469712390,9,'billentry.producedate',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712391;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('expirydate',' ',1660789947193369600,'到期日期',' ','物料明细.到期日期','0',1692082575469712391,10,'billentry.expirydate',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712392;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('unit',' ',1660789947193369600,'计量单位',' ','物料明细.计量单位','0',1692082575469712392,11,'billentry.unit',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712393;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('qty',' ',1660789947193369600,'数量',' ','物料明细.数量','0',1692082575469712393,12,'billentry.qty',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712394;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('baseunit',' ',1660789947193369600,'基本单位',' ','物料明细.基本单位','0',1692082575469712394,13,'billentry.baseunit',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712395;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('baseqty',' ',1660789947193369600,'数量（基本单位）',' ','物料明细.基本数量','0',1692082575469712395,14,'billentry.baseqty',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712396;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('unit2nd',' ',1660789947193369600,'辅助单位',' ','物料明细.辅助单位','0',1692082575469712396,15,'billentry.unit2nd',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712397;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('inwarehouse',' ',1660789947193369600,'入库仓库',' ','物料明细.入库仓库','0',1692082575469712397,16,'billentry.warehouse',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712398;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('inlocation',' ',1660789947193369600,'入库仓位',' ','物料明细.入库仓位','0',1692082575469712398,17,'billentry.location',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712399;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('invtype',' ',1660789947193369600,'入库库存类型',' ','物料明细.入库库存类型','0',1692082575469712399,18,'billentry.invtype',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712400;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('invstatus',' ',1660789947193369600,'入库库存状态',' ','物料明细.入库库存状态','0',1692082575469712400,19,'billentry.invstatus',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712401;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('ownertype',' ',1660789947193369600,'入库货主类型',' ','物料明细.入库货主类型','0',1692082575469712401,20,'billentry.ownertype',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712402;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('owner',' ',1660789947193369600,'入库货主',' ','物料明细.入库货主','0',1692082575469712402,21,'billentry.owner',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712403;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('keepertype',' ',1660789947193369600,'入库保管者类型',' ','物料明细.入库保管者类型','0',1692082575469712403,22,'billentry.keepertype',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712404;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('kepper',' ',1660789947193369600,'入库保管者',' ','物料明细.入库保管者','0',1692082575469712404,23,'billentry.keeper',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712405;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('project',' ',1660789947193369600,'项目号',' ','物料明细.项目号','0',1692082575469712405,24,'billentry.project',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712406;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('qtyunit2nd',' ',1660789947193369600,'数量（辅助单位）',' ','物料明细.辅助数量','0',1692082575469712406,25,'billentry.qtyunit2nd',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712407;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('outinvtype',' ',1660789947193369600,'出库库存类型',' ','物料明细.出库库存类型','0',1692082575469712407,26,'billentry.outinvtype',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712408;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('outinvstatus',' ',1660789947193369600,'出库库存状态',' ','物料明细.出库库存状态','0',1692082575469712408,27,'billentry.outinvstatus',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712409;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('outownertype',' ',1660789947193369600,'出库货主类型',' ','物料明细.出库货主类型','0',1692082575469712409,28,'billentry.outownertype',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712410;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('outowner',' ',1660789947193369600,'出库货主',' ','物料明细.出库货主','0',1692082575469712410,29,'billentry.outowner',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712411;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('outkeepertype',' ',1660789947193369600,'出库保管者类型',' ','物料明细.出库保管者类型','0',1692082575469712411,30,'billentry.outkeepertype',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712412;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('outkeeper',' ',1660789947193369600,'出库保管者',' ','物料明细.出库保管者','0',1692082575469712412,31,'billentry.outkeeper',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712413;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('configuredcode',' ',1660789947193369600,'配置号',' ','物料明细.配置号','0',1692082575469712413,32,'billentry.configuredcode',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712414;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('tracknumber',' ',1660789947193369600,'跟踪号',' ','物料明细.跟踪号','0',1692082575469712414,33,'billentry.tracknumber',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712415;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('outwarehouse',' ',1660789947193369600,'出库仓库',' ','物料明细.出库仓库','0',1692082575469712415,34,'billentry.outwarehouse',' '); 
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1692082575469712416;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('outlocation',' ',1660789947193369600,'出库仓位',' ','物料明细.出库仓位','0',1692082575469712416,35,'billentry.outlocation',' '); 
