--IM_MDC_MFTFEEDORDER_M1生产补料单
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518911498217366528;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518911497814712320,'库存组织','0','1','1',1518911498217366528,'0',100,'org','org','0','库存组织',1); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518911498217366529;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518911497814712320,'物料明细.物料编码','0','1','1',1518911498217366529,'1',95,'billentry.material','material','0','物料',2); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518911498217366530;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518911497814712320,'物料明细.计量单位','0','1','1',1518911498217366530,'1',85,'billentry.unit','unit','0','库存单位',3); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518911498217366531;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518911497814712320,'物料明细.数量','0','0','1',1518911498217366531,'1',15,'billentry.qty','avbqty','0','可用量(库存单位)',4); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518911498217366532;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518911497814712320,'物料明细.仓库','0','1','0',1518911498217366532,'1',90,'billentry.warehouse','warehouse','0','仓库',5); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518911498217366533;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518911497814712320,'物料明细.仓位','0','1','0',1518911498217366533,'1',85,'billentry.location','location','0','仓位',6); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518911498217366534;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518911497814712320,'物料明细.出库货主类型','0','1','1',1518911498217366534,'1',90,'billentry.outownertype','ownertype','0','货主类型',7); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518911498217366535;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518911497814712320,'物料明细.出库货主','0','1','1',1518911498217366535,'1',85,'billentry.outowner','owner','0','货主',8); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518911498217366536;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518911497814712320,'物料明细.出库保管者类型','0','1','1',1518911498217366536,'1',90,'billentry.outkeepertype','keepertype','0','保管者类型',9); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518911498217366537;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518911497814712320,'物料明细.出库保管者','0','1','1',1518911498217366537,'1',85,'billentry.outkeeper','keeper','0','保管者',10); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518911498217366538;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518911497814712320,'物料明细.辅助属性','0','1','0',1518911498217366538,'1',90,'billentry.auxpty','auxpty','0','辅助属性',11); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518911498217366539;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518911497814712320,'物料明细.出库库存类型','0','1','1',1518911498217366539,'1',90,'billentry.outinvtype','invtype','0','库存类型',12); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518911498217366540;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518911497814712320,'物料明细.出库库存状态','0','1','1',1518911498217366540,'1',90,'billentry.outinvstatus','invstatus','0','库存状态',13); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518911498217366541;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518911497814712320,'物料明细.批号','1','0','0',1518911498217366541,'1',85,'billentry.lotnumber','lotnum','0','批号',14); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518911498217366542;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518911497814712320,'物料明细.生产日期','1','0','0',1518911498217366542,'1',80,'billentry.producedate','producedate','0','生产日期',15); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518911498217366543;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518911497814712320,'物料明细.到期日期','1','0','0',1518911498217366543,'1',75,'billentry.expirydate','expirydate','0','有效期至',16); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518911498217366544;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518911497814712320,'物料明细.项目号','0','1','0',1518911498217366544,'1',85,'billentry.project','project','0','项目',17); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518911498217366545;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518911497814712320,'物料明细.配置号','0','1','0',1518911498217366545,'1',85,'billentry.configuredcode','configuredcode','0','配置号',18); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518911498217366546;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518911497814712320,'物料明细.跟踪号','0','1','0',1518911498217366546,'1',85,'billentry.tracknumber','tracknumber','0','跟踪号',19); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518911498217366547;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518911497814712320,'物料明细.基本单位','0','1','0',1518911498217366547,'1',90,'billentry.baseunit','baseunit','0','基本单位',20); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518911498217366548;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518911497814712320,'物料明细.辅助单位','0','1','0',1518911498217366548,'1',85,'billentry.unit2nd','unit2nd','0','辅助单位',21); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518911498217366549;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518911497814712320,'物料明细.基本数量','0','0','0',1518911498217366549,'1',20,'billentry.baseqty','avbbaseqty','0','可用量(基本单位)',22); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518911498217366550;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518911497814712320,'物料明细.辅助数量','0','0','0',1518911498217366550,'1',10,'billentry.qtyunit2nd','avbqty2nd','0','可用量(辅助单位)',23); 

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

DELETE FROM t_im_invqueryconf_l WHERE FPKID = '2RJZ22V1A+G3';
INSERT INTO t_im_invqueryconf_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1518911497814712320,'2RJZ22V1A+G3','zh_CN',' ','IM_MDC_MFTFEEDORDER_M1'); 
DELETE FROM t_im_invqueryconf_l WHERE FPKID = '2RJZ22V1A+G4';
INSERT INTO t_im_invqueryconf_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1518911497814712320,'2RJZ22V1A+G4','zh_TW',' ','IM_MDC_MFTFEEDORDER_M1'); 
--IM_MDC_MFTPROORDER_M1 生产领料单
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518907169586690048;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518907169276312576,'库存组织','0','1','1',1518907169586690048,'0',100,'org','org','0','库存组织',1); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518907169586690049;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518907169276312576,'物料明细.物料编码','0','1','1',1518907169586690049,'1',95,'billentry.material','material','0','物料',2); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518907169586690050;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518907169276312576,'物料明细.计量单位','0','1','1',1518907169586690050,'1',85,'billentry.unit','unit','0','库存单位',3); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518907169586690051;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518907169276312576,'物料明细.数量','0','0','1',1518907169586690051,'1',15,'billentry.qty','avbqty','0','可用量(库存单位)',4); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518907169586690052;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518907169276312576,'物料明细.仓库','0','1','0',1518907169586690052,'1',90,'billentry.warehouse','warehouse','0','仓库',5); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518907169586690053;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518907169276312576,'物料明细.仓位','0','1','0',1518907169586690053,'1',85,'billentry.location','location','0','仓位',6); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518907169586690054;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518907169276312576,'物料明细.出库货主类型','0','1','1',1518907169586690054,'1',90,'billentry.outownertype','ownertype','0','货主类型',7); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518907169586690055;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518907169276312576,'物料明细.出库货主','0','1','1',1518907169586690055,'1',85,'billentry.outowner','owner','0','货主',8); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518907169586690056;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518907169276312576,'物料明细.出库保管者类型','0','1','1',1518907169586690056,'1',90,'billentry.outkeepertype','keepertype','0','保管者类型',9); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518907169586690057;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518907169276312576,'物料明细.出库保管者','0','1','1',1518907169586690057,'1',85,'billentry.outkeeper','keeper','0','保管者',10); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518907169586690058;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518907169276312576,'物料明细.辅助属性','0','1','0',1518907169586690058,'1',90,'billentry.auxpty','auxpty','0','辅助属性',11); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518907169586690059;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518907169276312576,'物料明细.出库库存类型','0','1','1',1518907169586690059,'1',90,'billentry.outinvtype','invtype','0','库存类型',12); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518907169586690060;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518907169276312576,'物料明细.出库库存状态','0','1','1',1518907169586690060,'1',90,'billentry.outinvstatus','invstatus','0','库存状态',13); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518907169586690061;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518907169276312576,'物料明细.批号','1','0','0',1518907169586690061,'1',85,'billentry.lotnumber','lotnum','0','批号',14); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518907169586690062;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518907169276312576,'物料明细.生产日期','1','0','0',1518907169586690062,'1',80,'billentry.producedate','producedate','0','生产日期',15); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518907169586690063;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518907169276312576,'物料明细.到期日期','1','0','0',1518907169586690063,'1',75,'billentry.expirydate','expirydate','0','有效期至',16); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518907169586690064;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518907169276312576,'物料明细.项目号','0','1','0',1518907169586690064,'1',85,'billentry.project','project','0','项目',17); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518907169586690065;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518907169276312576,'物料明细.配置号','0','1','0',1518907169586690065,'1',85,'billentry.configuredcode','configuredcode','0','配置号',18); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518907169586690066;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518907169276312576,'物料明细.跟踪号','0','1','0',1518907169586690066,'1',85,'billentry.tracknumber','tracknumber','0','跟踪号',19); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518907169586690067;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518907169276312576,'物料明细.基本单位','0','1','0',1518907169586690067,'1',90,'billentry.baseunit','baseunit','0','基本单位',20); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518907169586690068;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518907169276312576,'物料明细.辅助单位','0','1','0',1518907169586690068,'1',85,'billentry.unit2nd','unit2nd','0','辅助单位',21); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518907169586690069;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518907169276312576,'物料明细.基本数量','0','0','0',1518907169586690069,'1',20,'billentry.baseqty','avbbaseqty','0','可用量(基本单位)',22); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518907169586690070;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518907169276312576,'物料明细.辅助数量','0','0','0',1518907169586690070,'1',10,'billentry.qtyunit2nd','avbqty2nd','0','可用量(辅助单位)',23); 

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

DELETE FROM t_im_invqueryconf_l WHERE FPKID = '2RJY9JOODAXG';
INSERT INTO t_im_invqueryconf_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1518907169276312576,'2RJY9JOODAXG','zh_CN',' ','IM_MDC_MFTPROORDER_M1'); 
DELETE FROM t_im_invqueryconf_l WHERE FPKID = '2RJY9JOODAXH';
INSERT INTO t_im_invqueryconf_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1518907169276312576,'2RJY9JOODAXH','zh_TW',' ','IM_MDC_MFTPROORDER_M1'); 


--IM_MDC_OMFEEDBILL_M1 委外补料单
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518917311975695360;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518917311765979136,'库存组织','0','1','1',1518917311975695360,'0',100,'org','org','0','库存组织',1); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518917311975695361;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518917311765979136,'物料明细.物料编码','0','1','1',1518917311975695361,'1',95,'billentry.material','material','0','物料',2); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518917311975695362;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518917311765979136,'物料明细.计量单位','0','1','1',1518917311975695362,'1',85,'billentry.unit','unit','0','库存单位',3); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518917311975695363;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518917311765979136,'物料明细.数量','0','0','1',1518917311975695363,'1',15,'billentry.qty','avbqty','0','可用量(库存单位)',4); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518917311975695364;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518917311765979136,'物料明细.仓库','0','1','0',1518917311975695364,'1',90,'billentry.warehouse','warehouse','0','仓库',5); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518917311975695365;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518917311765979136,'物料明细.仓位','0','1','0',1518917311975695365,'1',85,'billentry.location','location','0','仓位',6); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518917311975695366;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518917311765979136,'物料明细.出库货主类型','0','1','1',1518917311975695366,'1',90,'billentry.outownertype','ownertype','0','货主类型',7); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518917311975695367;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518917311765979136,'物料明细.出库货主','0','1','1',1518917311975695367,'1',85,'billentry.outowner','owner','0','货主',8); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518917311975695368;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518917311765979136,'物料明细.出库保管者类型','0','1','1',1518917311975695368,'1',90,'billentry.outkeepertype','keepertype','0','保管者类型',9); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518917311975695369;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518917311765979136,'物料明细.出库保管者','0','1','1',1518917311975695369,'1',85,'billentry.outkeeper','keeper','0','保管者',10); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518917311975695370;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518917311765979136,'物料明细.辅助属性','0','1','0',1518917311975695370,'1',90,'billentry.auxpty','auxpty','0','辅助属性',11); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518917311975695371;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518917311765979136,'物料明细.出库库存类型','0','1','1',1518917311975695371,'1',90,'billentry.outinvtype','invtype','0','库存类型',12); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518917311975695372;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518917311765979136,'物料明细.出库库存状态','0','1','1',1518917311975695372,'1',90,'billentry.outinvstatus','invstatus','0','库存状态',13); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518917311975695373;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518917311765979136,'物料明细.批号','1','0','0',1518917311975695373,'1',85,'billentry.lotnumber','lotnum','0','批号',14); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518917311975695374;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518917311765979136,'物料明细.生产日期','1','0','0',1518917311975695374,'1',80,'billentry.producedate','producedate','0','生产日期',15); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518917311975695375;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518917311765979136,'物料明细.到期日期','1','0','0',1518917311975695375,'1',75,'billentry.expirydate','expirydate','0','有效期至',16); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518917311975695376;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518917311765979136,'物料明细.项目号','0','1','0',1518917311975695376,'1',85,'billentry.project','project','0','项目',17); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518917311975695377;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518917311765979136,'物料明细.配置号','0','1','0',1518917311975695377,'1',85,'billentry.configuredcode','configuredcode','0','配置号',18); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518917311975695378;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518917311765979136,'物料明细.跟踪号','0','1','0',1518917311975695378,'1',85,'billentry.tracknumber','tracknumber','0','跟踪号',19); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518917311975695379;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518917311765979136,'物料明细.基本单位','0','1','0',1518917311975695379,'1',90,'billentry.baseunit','baseunit','0','基本单位',20); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518917311975695380;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518917311765979136,'物料明细.辅助单位','0','1','0',1518917311975695380,'1',85,'billentry.unit2nd','unit2nd','0','辅助单位',21); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518917311975695381;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518917311765979136,'物料明细.基本数量','0','0','0',1518917311975695381,'1',20,'billentry.baseqty','baseqty','0','库存量（基本单位）',22); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518917311975695382;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518917311765979136,'物料明细.辅助数量','0','0','0',1518917311975695382,'1',10,'billentry.qtyunit2nd','qty2nd','0','库存量（辅助单位）',23); 

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

DELETE FROM t_im_invqueryconf_l WHERE FPKID = '2RK+5G1VC2XE';
INSERT INTO t_im_invqueryconf_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1518917311765979136,'2RK+5G1VC2XE','zh_CN',' ','IM_MDC_OMFEEDBILL_M1'); 
DELETE FROM t_im_invqueryconf_l WHERE FPKID = '2RK+5G1VC2XF';
INSERT INTO t_im_invqueryconf_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1518917311765979136,'2RK+5G1VC2XF','zh_TW',' ','IM_MDC_OMFEEDBILL_M1'); 


--IM_MDC_OMOUTBILL_M1 委外领料单
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518925466566696960;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518925466466034688,'库存组织','0','1','1',1518925466566696960,'0',100,'org','org','0','库存组织',1); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518925466566696961;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518925466466034688,'物料明细.物料编码','0','1','1',1518925466566696961,'1',95,'billentry.material','material','0','物料',2); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518925466566696962;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518925466466034688,'物料明细.计量单位','0','1','1',1518925466566696962,'1',85,'billentry.unit','unit','0','库存单位',3); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518925466566696963;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518925466466034688,'物料明细.数量','0','0','1',1518925466566696963,'1',15,'billentry.qty','avbqty','0','可用量(库存单位)',4); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518925466566696964;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518925466466034688,'物料明细.仓库','0','1','0',1518925466566696964,'1',90,'billentry.warehouse','warehouse','0','仓库',5); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518925466566696965;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518925466466034688,'物料明细.仓位','0','1','0',1518925466566696965,'1',85,'billentry.location','location','0','仓位',6); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518925466566696966;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518925466466034688,'物料明细.出库货主类型','0','1','1',1518925466566696966,'1',90,'billentry.outownertype','ownertype','0','货主类型',7); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518925466566696967;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518925466466034688,'物料明细.出库货主','0','1','1',1518925466566696967,'1',85,'billentry.outowner','owner','0','货主',8); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518925466566696968;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518925466466034688,'物料明细.出库保管者类型','0','1','1',1518925466566696968,'1',90,'billentry.outkeepertype','keepertype','0','保管者类型',9); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518925466566696969;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518925466466034688,'物料明细.出库保管者','0','1','1',1518925466566696969,'1',85,'billentry.outkeeper','keeper','0','保管者',10); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518925466566696970;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518925466466034688,'物料明细.辅助属性','0','1','0',1518925466566696970,'1',90,'billentry.auxpty','auxpty','0','辅助属性',11); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518925466566696971;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518925466466034688,'物料明细.出库库存类型','0','1','1',1518925466566696971,'1',90,'billentry.outinvtype','invtype','0','库存类型',12); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518925466566696972;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518925466466034688,'物料明细.出库库存状态','0','1','1',1518925466566696972,'1',90,'billentry.outinvstatus','invstatus','0','库存状态',13); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518925466566696973;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518925466466034688,'物料明细.批号','1','0','0',1518925466566696973,'1',85,'billentry.lotnumber','lotnum','0','批号',14); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518925466566696974;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518925466466034688,'物料明细.生产日期','1','0','0',1518925466566696974,'1',80,'billentry.producedate','producedate','0','生产日期',15); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518925466566696975;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518925466466034688,'物料明细.到期日期','1','0','0',1518925466566696975,'1',75,'billentry.expirydate','expirydate','0','有效期至',16); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518925466566696976;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518925466466034688,'物料明细.项目号','0','1','0',1518925466566696976,'1',85,'billentry.project','project','0','项目',17); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518925466566696977;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518925466466034688,'物料明细.配置号','0','1','0',1518925466566696977,'1',85,'billentry.configuredcode','configuredcode','0','配置号',18); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518925466566696978;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518925466466034688,'物料明细.跟踪号','0','1','0',1518925466566696978,'1',85,'billentry.tracknumber','tracknumber','0','跟踪号',19); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518925466566696979;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518925466466034688,'物料明细.基本单位','0','1','0',1518925466566696979,'1',90,'billentry.baseunit','baseunit','0','基本单位',20); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518925466566696980;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518925466466034688,'物料明细.辅助单位','0','1','0',1518925466566696980,'1',85,'billentry.unit2nd','unit2nd','0','辅助单位',21); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518925466566696981;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518925466466034688,'物料明细.基本数量','0','0','0',1518925466566696981,'1',20,'billentry.baseqty','avbbaseqty','0','可用量(基本单位)',22); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518925466566696982;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518925466466034688,'物料明细.辅助数量','0','0','0',1518925466566696982,'1',10,'billentry.qtyunit2nd','avbqty2nd','0','可用量(辅助单位)',23); 

DELETE FROM t_im_invqueryconf WHERE FID = 1518925466466034688;
INSERT INTO t_im_invqueryconf(FMIDDLEINSERT,FSRCBILLOBJ,FUSETYPE,FQTYRULE,FRETURNTYPE,FNEWDEAL,FMASTERID,FUNITTRAN,FOPERATEKEY,FCREATETIME,FENABLE,FSRCBILLENTRY,FPROQTYFIELD,FID,FENTRYNOUPDATEFIELDKEY,FPLUGINNAME,FSTATUS,FNUMBER,FACTIONID,FMODIFIERID,FISPRESET,FMODIFYTIME,FDEALTYPE,FSRCBILLENTRYNAME,FCREATORID,FFILTERPLUGINNAME) VALUES ('0','im_mdc_omoutbill','B','minrule','single','1',1518925466466034688,'0','matchingruleout',{ts'2022-09-27  00:00:00'},'1','billentry','avbqty',1518925466466034688,'noupdateinvfields',' ','A','IM_MDC_OMOUTBILL_M1',' ',1169547541692294144,'1',{ts'2022-10-08  00:00:00'},'systemdeal','物料明细',1252726957368457216,' '); 

DELETE FROM t_im_invqueryconf_l WHERE FPKID = '2RK/OWJ9N700';
INSERT INTO t_im_invqueryconf_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1518925466466034688,'2RK/OWJ9N700','zh_CN',' ','IM_MDC_OMOUTBILL_M1'); 
DELETE FROM t_im_invqueryconf_l WHERE FPKID = '2RK/OWJ9N701';
INSERT INTO t_im_invqueryconf_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1518925466466034688,'2RK/OWJ9N701','zh_TW',' ','IM_MDC_OMOUTBILL_M1'); 


--IM_MDC_OMFEEDORDER_M1 简单委外补料单
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518921505147336704;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518921504987954176,'库存组织','0','1','1',1518921505147336704,'0',100,'org','org','0','库存组织',1); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518921505147336705;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518921504987954176,'物料明细.物料编码','0','1','1',1518921505147336705,'1',95,'billentry.material','material','0','物料',2); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518921505147336706;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518921504987954176,'物料明细.计量单位','0','1','1',1518921505147336706,'1',85,'billentry.unit','unit','0','库存单位',3); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518921505147336707;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518921504987954176,'物料明细.数量','0','0','1',1518921505147336707,'1',15,'billentry.qty','avbqty','0','可用量(库存单位)',4); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518921505147336708;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518921504987954176,'物料明细.仓库','0','1','0',1518921505147336708,'1',90,'billentry.warehouse','warehouse','0','仓库',5); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518921505147336709;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518921504987954176,'物料明细.仓位','0','1','0',1518921505147336709,'1',85,'billentry.location','location','0','仓位',6); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518921505147336710;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518921504987954176,'物料明细.出库货主类型','0','1','1',1518921505147336710,'1',90,'billentry.outownertype','ownertype','0','货主类型',7); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518921505147336711;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518921504987954176,'物料明细.出库货主','0','1','1',1518921505147336711,'1',85,'billentry.outowner','owner','0','货主',8); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518921505147336712;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518921504987954176,'物料明细.出库保管者类型','0','1','1',1518921505147336712,'1',90,'billentry.outkeepertype','keepertype','0','保管者类型',9); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518921505147336713;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518921504987954176,'物料明细.出库保管者','0','1','1',1518921505147336713,'1',85,'billentry.outkeeper','keeper','0','保管者',10); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518921505147336714;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518921504987954176,'物料明细.辅助属性','0','1','0',1518921505147336714,'1',90,'billentry.auxpty','auxpty','0','辅助属性',11); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518921505147336715;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518921504987954176,'物料明细.出库库存类型','0','1','1',1518921505147336715,'1',90,'billentry.outinvtype','invtype','0','库存类型',12); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518921505147336716;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518921504987954176,'物料明细.出库库存状态','0','1','1',1518921505147336716,'1',90,'billentry.outinvstatus','invstatus','0','库存状态',13); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518921505147336717;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518921504987954176,'物料明细.批号','1','0','0',1518921505147336717,'1',85,'billentry.lotnumber','lotnum','0','批号',14); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518921505147336718;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518921504987954176,'物料明细.生产日期','1','0','0',1518921505147336718,'1',80,'billentry.producedate','producedate','0','生产日期',15); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518921505147336719;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518921504987954176,'物料明细.到期日期','1','0','0',1518921505147336719,'1',75,'billentry.expirydate','expirydate','0','有效期至',16); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518921505147336720;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518921504987954176,'物料明细.项目号','0','1','0',1518921505147336720,'1',85,'billentry.project','project','0','项目',17); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518921505147336721;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518921504987954176,'物料明细.配置号','0','1','0',1518921505147336721,'1',85,'billentry.configuredcode','configuredcode','0','配置号',18); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518921505147336722;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518921504987954176,'物料明细.跟踪号','0','1','0',1518921505147336722,'1',85,'billentry.tracknumber','tracknumber','0','跟踪号',19); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518921505147336723;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518921504987954176,'物料明细.基本单位','0','1','0',1518921505147336723,'1',90,'billentry.baseunit','baseunit','0','基本单位',20); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518921505147336724;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518921504987954176,'物料明细.辅助单位','0','1','0',1518921505147336724,'1',85,'billentry.unit2nd','unit2nd','0','辅助单位',21); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518921505147336725;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518921504987954176,'物料明细.基本数量','0','0','0',1518921505147336725,'1',20,'billentry.baseqty','avbbaseqty','0','可用量(基本单位)',22); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518921505147336726;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518921504987954176,'物料明细.辅助数量','0','0','0',1518921505147336726,'1',10,'billentry.qtyunit2nd','avbqty2nd','0','可用量(辅助单位)',23); 

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

DELETE FROM t_im_invqueryconf_l WHERE FPKID = '2RK+Z/QW7QFV';
INSERT INTO t_im_invqueryconf_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1518921504987954176,'2RK+Z/QW7QFV','zh_CN',' ','IM_MDC_OMFEEDORDER_M1'); 
DELETE FROM t_im_invqueryconf_l WHERE FPKID = '2RK+Z/QW7QFW';
INSERT INTO t_im_invqueryconf_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1518921504987954176,'2RK+Z/QW7QFW','zh_TW',' ','IM_MDC_OMFEEDORDER_M1'); 


--IM_MDC_OMPROORDER_M1 简单委外领料单
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518928530229056512;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518928530120003584,'库存组织','0','1','1',1518928530229056512,'0',100,'org','org','0','库存组织',1); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518928530229056513;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518928530120003584,'物料明细.物料编码','0','1','1',1518928530229056513,'1',95,'billentry.material','material','0','物料',2); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518928530229056514;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518928530120003584,'物料明细.计量单位','0','1','1',1518928530229056514,'1',85,'billentry.unit','unit','0','库存单位',3); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518928530229056515;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518928530120003584,'物料明细.数量','0','0','1',1518928530229056515,'1',15,'billentry.qty','avbqty','0','可用量(库存单位)',4); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518928530229056516;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518928530120003584,'物料明细.仓库','0','1','0',1518928530229056516,'1',90,'billentry.warehouse','warehouse','0','仓库',5); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518928530229056517;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518928530120003584,'物料明细.仓位','0','1','0',1518928530229056517,'1',85,'billentry.location','location','0','仓位',6); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518928530229056518;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518928530120003584,'物料明细.出库货主类型','0','1','1',1518928530229056518,'1',90,'billentry.outownertype','ownertype','0','货主类型',7); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518928530229056519;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518928530120003584,'物料明细.出库货主','0','1','1',1518928530229056519,'1',85,'billentry.outowner','owner','0','货主',8); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518928530229056520;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518928530120003584,'物料明细.出库保管者类型','0','1','1',1518928530229056520,'1',90,'billentry.outkeepertype','keepertype','0','保管者类型',9); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518928530229056521;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518928530120003584,'物料明细.出库保管者','0','1','1',1518928530229056521,'1',85,'billentry.outkeeper','keeper','0','保管者',10); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518928530229056522;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518928530120003584,'物料明细.辅助属性','0','1','0',1518928530229056522,'1',90,'billentry.auxpty','auxpty','0','辅助属性',11); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518928530229056523;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518928530120003584,'物料明细.出库库存类型','0','1','1',1518928530229056523,'1',90,'billentry.outinvtype','invtype','0','库存类型',12); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518928530229056524;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518928530120003584,'物料明细.出库库存状态','0','1','1',1518928530229056524,'1',90,'billentry.outinvstatus','invstatus','0','库存状态',13); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518928530229056525;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518928530120003584,'物料明细.批号','1','0','0',1518928530229056525,'1',85,'billentry.lotnumber','lotnum','0','批号',14); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518928530229056526;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518928530120003584,'物料明细.生产日期','1','0','0',1518928530229056526,'1',80,'billentry.producedate','producedate','0','生产日期',15); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518928530229056527;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518928530120003584,'物料明细.到期日期','1','0','0',1518928530229056527,'1',75,'billentry.expirydate','expirydate','0','有效期至',16); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518928530229056528;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518928530120003584,'物料明细.项目号','0','1','0',1518928530229056528,'1',85,'billentry.project','project','0','项目',17); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518928530229056529;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518928530120003584,'物料明细.配置号','0','1','0',1518928530229056529,'1',85,'billentry.configuredcode','configuredcode','0','配置号',18); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518928530229056530;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518928530120003584,'物料明细.跟踪号','0','1','0',1518928530229056530,'1',85,'billentry.tracknumber','tracknumber','0','跟踪号',19); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518928530229056531;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518928530120003584,'物料明细.基本单位','0','1','0',1518928530229056531,'1',90,'billentry.baseunit','baseunit','0','基本单位',20); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518928530229056532;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518928530120003584,'物料明细.辅助单位','0','1','0',1518928530229056532,'1',85,'billentry.unit2nd','unit2nd','0','辅助单位',21); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518928530229056533;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518928530120003584,'物料明细.基本数量','0','0','0',1518928530229056533,'1',20,'billentry.baseqty','avbbaseqty','0','可用量(基本单位)',22); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1518928530229056534;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1518928530120003584,'物料明细.辅助数量','0','0','0',1518928530229056534,'1',10,'billentry.qtyunit2nd','avbqty2nd','0','可用量(辅助单位)',23); 

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

DELETE FROM t_im_invqueryconf_l WHERE FPKID = '2RK0977CQM58';
INSERT INTO t_im_invqueryconf_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1518928530120003584,'2RK0977CQM58','zh_CN',' ','IM_MDC_OMPROORDER_M1'); 
DELETE FROM t_im_invqueryconf_l WHERE FPKID = '2RK0977CQM59';
INSERT INTO t_im_invqueryconf_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1518928530120003584,'2RK0977CQM59','zh_TW',' ','IM_MDC_OMPROORDER_M1'); 

