DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1641417655774743552;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1641417655716023296,'库存组织','0','1','0',1641417655774743552,'0',100,'invorg','org','0','库存组织',1); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1641417655774743553;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1641417655716023296,'物料明细.物料编码','0','1','0',1641417655774743553,'1',95,'billentry.material','material','1','物料',2); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1641417655774743554;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1641417655716023296,'物料明细.货主类型','0','1','0',1641417655774743554,'0',90,'billentry.supplymode','ownertype','0','货主类型',3); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1641417655774743555;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1641417655716023296,'物料明细.货主','0','1','0',1641417655774743555,'0',85,'billentry.supplierid','owner','0','货主',4); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1641417655774743556;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1641417655716023296,'物料明细.供货仓库','0','1','0',1641417655774743556,'1',90,'billentry.warehouse','warehouse','0','仓库',5); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1641417655774743557;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1641417655716023296,'物料明细.供货仓位','0','1','0',1641417655774743557,'1',85,'billentry.location','location','0','仓位',6); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1641417655774743558;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1641417655716023296,'物料明细.辅助属性','0','1','0',1641417655774743558,'1',90,'billentry.auxpty','auxpty','1','辅助属性',7); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1641417655774743559;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1641417655716023296,'物料明细.基本单位','0','1','0',1641417655774743559,'1',90,'billentry.baseunit','baseunit','0','基本单位',8); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1641417655774743560;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1641417655716023296,'物料明细.计量单位','0','1','0',1641417655774743560,'1',85,'billentry.unit','unit','0','库存单位',9); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1641417655774743561;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1641417655716023296,'物料明细.辅助单位','0','1','0',1641417655774743561,'1',85,'billentry.unit2nd','unit2nd','0','辅助单位',10); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1641417655774743562;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1641417655716023296,'物料明细.生产日期','0','1','0',1641417655774743562,'1',80,'billentry.producedate','producedate','1','生产日期',11); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1641417655774743563;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1641417655716023296,'物料明细.到期日期','0','1','0',1641417655774743563,'1',75,'billentry.expirydate','expirydate','1','有效期至',12); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1641417655774743564;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1641417655716023296,'物料明细.项目号','0','1','0',1641417655774743564,'1',85,'billentry.project','project','0','项目',13); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1641417655774743565;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1641417655716023296,'物料明细.核准基本数量','0','0','0',1641417655774743565,'1',20,'billentry.auditbaseqty','avbbaseqty','0','可用量(基本单位)',14); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1641417655774743566;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1641417655716023296,'物料明细.核准数量','0','0','0',1641417655774743566,'1',15,'billentry.auditqty','avbqty','0','可用量(库存单位)',15); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1641417655774743567;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1641417655716023296,'物料明细.核准辅助数量','0','0','0',1641417655774743567,'1',10,'billentry.qtyunit2nd','avbqty2nd','0','可用量(辅助单位)',16); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1641417655774743568;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1641417655716023296,'物料明细.批号','0','1','0',1641417655774743568,'1',85,'billentry.lotnumber','lotnum','1','批号',17); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1641417655774743569;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1641417655716023296,'物料明细.配置号','0','1','0',1641417655774743569,'1',85,'billentry.configuredcode','configuredcode','0','配置号',18); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1641417655774743570;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FMATCH,FINVACCCOLNO,FSEQ) VALUES (1641417655716023296,'物料明细.跟踪号','0','1','0',1641417655774743570,'1',85,'billentry.tracknumber','tracknumber','0','跟踪号',19); 

DELETE FROM t_im_invqueryconf WHERE FID = 1641417655716023296;
INSERT INTO t_im_invqueryconf(FMIDDLEINSERT,FSRCBILLOBJ,FUSETYPE,FQTYRULE,FRETURNTYPE,FMATCHSHORTAGE,FNEWDEAL,FMASTERID,FUNITTRAN,FOPERATEKEY,FCREATETIME,FENABLE,FSRCBILLENTRY,FPROQTYFIELD,FID,FENTRYNOUPDATEFIELDKEY,FPLUGINNAME,FSTATUS,FNUMBER,FACTIONID,FMODIFIERID,FISPRESET,FMODIFYTIME,FDEALTYPE,FSRCBILLENTRYNAME,FSAVESHORTAGEROW,FCREATORID,FFILTERPLUGINNAME) VALUES ('0','im_mdc_mftomreqapplybill','A','minrule','multi','popconfirm','1',1641417655716023296,'0','scmcinvquery',{ts'2023-03-15  00:00:00'},'1','billentry','avbqty',1641417655716023296,'noupdateinvfields',' ','A','IM_MDC_MFTOMREQAPPLYBILL_S1',' ',1367951115215224832,'1',{ts'2023-03-15  00:00:00'},'systemdeal','物料明细','0',1367951115215224832,' '); 

DELETE FROM t_im_invqueryconf_l WHERE FPKID = '34LVUCM1ONJH';
INSERT INTO t_im_invqueryconf_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1641417655716023296,'34LVUCM1ONJH','zh_CN',' ','IM_MDC_MFTOMREQAPPLYBILL_S1'); 
DELETE FROM t_im_invqueryconf_l WHERE FPKID = '34LVUCM1ONJI';
INSERT INTO t_im_invqueryconf_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1641417655716023296,'34LVUCM1ONJI','zh_TW',' ','IM_MDC_MFTOMREQAPPLYBILL_S1'); 

