DELETE FROM T_IM_INVQUERYCONF WHERE FID = 1541317546354190336;
INSERT INTO T_IM_INVQUERYCONF(FMIDDLEINSERT,FSRCBILLOBJ,FUSETYPE,FQTYRULE,FRETURNTYPE,FNEWDEAL,FDESCRIPTION,FMASTERID,FUNITTRAN,FOPERATEKEY,FCREATETIME,FENABLE,FSRCBILLENTRY,FPROQTYFIELD,FID,FENTRYNOUPDATEFIELDKEY,FPLUGINNAME,FSTATUS,FNUMBER,FNAME,FACTIONID,FMODIFIERID,FISPRESET,FMODIFYTIME,FDEALTYPE,FSRCBILLENTRYNAME,FCREATORID,FFILTERPLUGINNAME) VALUES ('0','im_osmaterialreqoutbill','B','minrule','single','1',' ',1541317546354190336,'0','matchingruleout',{ts'2022-10-28  00:00:00'},'1','billentry','avbqty',1541317546354190336,'noupdateinvfields',' ','A','IM_OSMATERIALREQOUTBILL_M1','IM_OSMATERIALREQOUTBILL_M1',' ',0,'1',{ts'2022-10-28  00:00:00'},'systemdeal','物料明细',0,' '); 

DELETE FROM T_IM_INVQUERYCONF_L WHERE FPKID = '2UA=JL+T+B2D';
INSERT INTO T_IM_INVQUERYCONF_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1541317546354190336,'2UA=JL+T+B2D','zh_CN',' ','IM_OSMATERIALREQOUTBILL_M1'); 
DELETE FROM T_IM_INVQUERYCONF_L WHERE FPKID = '2UA=JL+T+B2E';
INSERT INTO T_IM_INVQUERYCONF_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1541317546354190336,'2UA=JL+T+B2E','zh_TW',' ','IM_OSMATERIALREQOUTBILL_M1'); 

DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1541317546513573888;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1541317546354190336,'库存组织','0','1','1',1541317546513573888,'0',100,'org','org','0','库存组织',1); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1541317546513573889;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1541317546354190336,'物料明细.物料编码','0','1','1',1541317546513573889,'1',95,'billentry.material','material','0','物料',2); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1541317546513573890;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1541317546354190336,'物料明细.计量单位','0','1','1',1541317546513573890,'1',85,'billentry.unit','unit','0','库存单位',3); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1541317546513573891;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1541317546354190336,'物料明细.数量','0','0','1',1541317546513573891,'1',15,'billentry.qty','avbqty','0','可用量(库存单位)',4); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1541317546513573892;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1541317546354190336,'物料明细.仓库','0','1','0',1541317546513573892,'1',90,'billentry.warehouse','warehouse','0','仓库',5); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1541317546513573893;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1541317546354190336,'物料明细.仓位','0','1','0',1541317546513573893,'1',85,'billentry.location','location','0','仓位',6); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1541317546513573894;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1541317546354190336,'物料明细.出库货主类型','0','1','1',1541317546513573894,'1',90,'billentry.outownertype','ownertype','0','货主类型',7); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1541317546513573895;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1541317546354190336,'物料明细.出库货主','0','1','1',1541317546513573895,'1',85,'billentry.outowner','owner','0','货主',8); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1541317546513573896;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1541317546354190336,'物料明细.出库保管者类型','0','1','1',1541317546513573896,'1',90,'billentry.outkeepertype','keepertype','0','保管者类型',9); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1541317546513573897;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1541317546354190336,'物料明细.出库保管者','0','1','1',1541317546513573897,'1',85,'billentry.outkeeper','keeper','0','保管者',10); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1541317546513573898;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1541317546354190336,'物料明细.辅助属性','0','1','0',1541317546513573898,'1',90,'billentry.auxpty','auxpty','0','辅助属性',11); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1541317546513573899;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1541317546354190336,'物料明细.出库库存类型','0','1','1',1541317546513573899,'1',90,'billentry.outinvtype','invtype','0','库存类型',12); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1541317546513573900;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1541317546354190336,'物料明细.出库库存状态','0','1','1',1541317546513573900,'1',90,'billentry.outinvstatus','invstatus','0','库存状态',13); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1541317546513573901;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1541317546354190336,'物料明细.批号','1','0','0',1541317546513573901,'1',85,'billentry.lotnumber','lotnum','0','批号',14); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1541317546513573902;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1541317546354190336,'物料明细.生产日期','1','0','0',1541317546513573902,'1',80,'billentry.producedate','producedate','0','生产日期',15); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1541317546513573903;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1541317546354190336,'物料明细.到期日期','1','0','0',1541317546513573903,'1',75,'billentry.expirydate','expirydate','0','有效期至',16); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1541317546513573904;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1541317546354190336,'物料明细.项目号','0','1','0',1541317546513573904,'1',85,'billentry.project','project','0','项目',17); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1541317546513573905;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1541317546354190336,'物料明细.配置号','0','1','0',1541317546513573905,'1',85,'billentry.configuredcode','configuredcode','0','配置号',18); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1541317546513573906;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1541317546354190336,'物料明细.跟踪号','0','1','0',1541317546513573906,'1',85,'billentry.tracknumber','tracknumber','0','跟踪号',19); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1541317546513573907;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1541317546354190336,'物料明细.基本单位','0','1','0',1541317546513573907,'1',90,'billentry.baseunit','baseunit','0','基本单位',20); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1541317546513573908;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1541317546354190336,'物料明细.辅助单位','0','1','0',1541317546513573908,'1',85,'billentry.unit2nd','unit2nd','0','辅助单位',21); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1541317546513573909;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1541317546354190336,'物料明细.基本数量','0','0','0',1541317546513573909,'1',20,'billentry.baseqty','avbbaseqty','0','可用量(基本单位)',22); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1541317546513573910;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1541317546354190336,'物料明细.辅助数量','0','0','0',1541317546513573910,'1',10,'billentry.qtyunit2nd','avbqty2nd','0','可用量(辅助单位)',23); 
