DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1889780870550895616;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FRETURNCOLNO,FMATCH,FINVACCCOLNO,FSEQ,FRETURNCOL) VALUES (1889299098499143680,'物料明细.物料编码','0','1','1',1889780870550895616,'1',95,'billentry.materialmasterid','material',' ','1','物料',4,' '); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1889299100294305792;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FRETURNCOLNO,FMATCH,FINVACCCOLNO,FSEQ,FRETURNCOL) VALUES (1889299098499143680,'需求组织','0','1','1',1889299100294305792,'0',100,'org','org',' ','0','库存组织',1,' '); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1889310959051455489;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FRETURNCOLNO,FMATCH,FINVACCCOLNO,FSEQ,FRETURNCOL) VALUES (1889299098499143680,'物料明细.数量','0','0','0',1889310959051455489,'1',15,'billentry.qty','avbqty',' ','0','可用量(库存单位)',3,' '); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1889310959051455488;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FRETURNCOLNO,FMATCH,FINVACCCOLNO,FSEQ,FRETURNCOL) VALUES (1889299098499143680,'物料明细.计量单位','0','1','0',1889310959051455488,'1',85,'billentry.unit','unit',' ','0','库存单位',2,' '); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1889798267156544512;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FRETURNCOLNO,FMATCH,FINVACCCOLNO,FSEQ,FRETURNCOL) VALUES (1889299098499143680,'物料明细.辅助单位','0','1','0',1889798267156544512,'1',85,'billentry.auxunit','unit2nd',' ','0','辅助单位',5,' '); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1889798267156544513;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FRETURNCOLNO,FMATCH,FINVACCCOLNO,FSEQ,FRETURNCOL) VALUES (1889299098499143680,'物料明细.基本单位','0','1','0',1889798267156544513,'1',90,'billentry.baseunit','baseunit',' ','0','基本单位',6,' '); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1889798267156544514;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FRETURNCOLNO,FMATCH,FINVACCCOLNO,FSEQ,FRETURNCOL) VALUES (1889299098499143680,'物料明细.基本数量','0','0','0',1889798267156544514,'1',20,'billentry.baseqty','avbbaseqty',' ','0','可用量(基本单位)',7,' '); 
DELETE FROM t_im_invquerymapping WHERE FENTRYID = 1889798267156544515;
INSERT INTO t_im_invquerymapping(FID,FSRCBILLCOLNO,FFRISTOUT,FQFILTER,FFIELDMUSTINPUT,FENTRYID,FUPDATE,FRETURNORDER,FSRCBILLCOL,FINVACCCOL,FRETURNCOLNO,FMATCH,FINVACCCOLNO,FSEQ,FRETURNCOL) VALUES (1889299098499143680,'物料明细.辅助数量','0','0','0',1889798267156544515,'1',10,'billentry.auxqty','avbqty2nd',' ','0','可用量(辅助单位)',8,' '); 
DELETE FROM t_im_invqueryconf WHERE FID = 1889299098499143680;
INSERT INTO t_im_invqueryconf(FMIDDLEINSERT,FSRCBILLOBJ,FUSETYPE,FQTYRULE,FRETURNTYPE,FMATCHSHORTAGE,FNEWDEAL,FMASTERID,FUNITTRAN,FOPERATEKEY,FCREATETIME,FENABLE,FSRCBILLENTRY,FPROQTYFIELD,FPROQTY2NDFIELD,FID,FENTRYNOUPDATEFIELDKEY,FPLUGINNAME,FSTATUS,FNUMBER,FMUSTSELECTENTRY,FACTIONID,FMODIFIERID,FISPRESET,FMODIFYTIME,FDEALTYPE,FSRCBILLENTRYNAME,FSAVESHORTAGEROW,FCREATORID,FFILTERPLUGINNAME) VALUES ('0','pm_requirapplybill','A','minrule','multi','popconfirm','1',1889299098499143680,'0','qinvacc',{ts'2024-02-20  00:00:00'},'1','billentry','avbqty','avbqty',1889299098499143680,' ',' ','A','PM_REQUIRAPPLYBILL_S','0',' ',1,'1',{ts'2024-02-21  00:00:00'},'systemdeal','物料明细','0',1,' '); 
DELETE FROM t_im_invqueryconf_l WHERE FID = 1889299098499143680 and FLOCALEID = 'zh_CN';
INSERT INTO t_im_invqueryconf_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1889299098499143680,'3Y1FE7QQ4ZE0','zh_CN',' ','PM_REQUIRAPPLYBILL_S'); 
DELETE FROM t_im_invqueryconf_l WHERE FID = 1889299098499143680 and FLOCALEID = 'zh_TW';
INSERT INTO t_im_invqueryconf_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1889299098499143680,'3Y1FE7QQ4ZE1','zh_TW',' ','PM_REQUIRAPPLYBILL_S'); 
