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

DELETE FROM T_IM_INVQUERYCONF_L WHERE FPKID = '3+BYJ452R8=U';
INSERT INTO T_IM_INVQUERYCONF_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1590502448689068032,'3+BYJ452R8=U','zh_CN',' ','IM_MDC_MFTOMREQAPPLYBILL_M1'); 
DELETE FROM T_IM_INVQUERYCONF_L WHERE FPKID = '3+BYJ452R8=V';
INSERT INTO T_IM_INVQUERYCONF_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1590502448689068032,'3+BYJ452R8=V','zh_TW',' ','IM_MDC_MFTOMREQAPPLYBILL_M1'); 

DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1590502448848451584;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1590502448689068032,'库存组织','0','1','1',1590502448848451584,'0',100,'invorg','org','0','库存组织',1); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1590502448848451585;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1590502448689068032,'物料明细.物料编码','0','1','1',1590502448848451585,'1',95,'billentry.material','material','0','物料',2); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1590502448848451586;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1590502448689068032,'物料明细.计量单位','0','1','1',1590502448848451586,'1',85,'billentry.unit','unit','0','库存单位',3); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1590502448848451587;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1590502448689068032,'物料明细.申请数量','0','0','1',1590502448848451587,'1',15,'billentry.qty','avbqty','0','可用量(库存单位)',4); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1590502448848451588;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1590502448689068032,'物料明细.供货仓库','0','1','0',1590502448848451588,'1',90,'billentry.warehouse','warehouse','0','仓库',5); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1590502448848451589;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1590502448689068032,'物料明细.供货仓位','0','1','0',1590502448848451589,'1',85,'billentry.location','location','0','仓位',6); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1590502448848451590;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1590502448689068032,'物料明细.货主类型','0','1','1',1590502448848451590,'1',90,'billentry.supplymode','ownertype','0','货主类型',7); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1590502448848451591;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1590502448689068032,'物料明细.货主','0','1','1',1590502448848451591,'1',85,'billentry.supplierid','owner','0','货主',8); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1590502448848451592;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1590502448689068032,'物料明细.辅助属性','0','1','0',1590502448848451592,'1',90,'billentry.auxpty','auxpty','0','辅助属性',9); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1590570021526975488;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1590502448689068032,'物料明细.批号','1','0','0',1590570021526975488,'1',85,'billentry.lotnumber','lotnum','0','批号',10); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1590570021526975489;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1590502448689068032,'物料明细.生产日期','1','0','0',1590570021526975489,'1',80,'billentry.producedate','producedate','0','生产日期',11); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1590570021526975490;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1590502448689068032,'物料明细.到期日期','1','0','0',1590570021526975490,'1',75,'billentry.expirydate','expirydate','0','有效期至',12); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1590570021526975491;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1590502448689068032,'物料明细.项目号','0','1','0',1590570021526975491,'1',85,'billentry.project','project','0','项目',13); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1590570021526975492;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1590502448689068032,'物料明细.配置号','0','1','0',1590570021526975492,'1',85,'billentry.configuredcode','configuredcode','0','配置号',14); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1590570021526975493;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1590502448689068032,'物料明细.跟踪号','0','1','0',1590570021526975493,'1',85,'billentry.tracknumber','tracknumber','0','跟踪号',15); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1590570021526975494;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1590502448689068032,'物料明细.基本单位','0','1','0',1590570021526975494,'1',90,'billentry.baseunit','baseunit','0','基本单位',16); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1590570021526975495;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1590502448689068032,'物料明细.辅助单位','0','1','0',1590570021526975495,'1',85,'billentry.unit2nd','unit2nd','0','辅助单位',17); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1590570021526975496;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1590502448689068032,'物料明细.申请基本数量','0','0','0',1590570021526975496,'1',20,'billentry.baseqty','avbbaseqty','0','可用量(基本单位)',18); 
DELETE FROM T_IM_INVQUERYMAPPING WHERE FENTRYID = 1590570021526975497;
INSERT INTO T_IM_INVQUERYMAPPING(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1590502448689068032,'物料明细.核准辅助数量','0','0','0',1590570021526975497,'1',10,'billentry.qtyunit2nd','avbqty2nd','0','可用量(辅助单位)',19); 
