--领料出库单获取价格预制数据
DELETE FROM t_im_costpriceconf WHERE FID = 1467430907727064064;
INSERT INTO t_im_costpriceconf(FID,FFILTERJSON_TAG,FOPERATIONNAME,FOPERATION,FISCOSTMAINACCOUNT,FFILTERFORMULA_TAG,FDESCRIPTION,FBILLENTRYKEY,FMASTERID,FSTATUS,FFILTERJSON,FBILLENTRY,FNAME,FNUMBER,FCREATETIME,FIMBILL,FCOSTACCOUNT,FFILTERFORMULA,FENABLE,FMODIFIERID,FISPRESET,FACCOUNTTYPE,FMODIFYTIME,FCREATORID) VALUES (1467430907727064064,'{"filterRow":[{"id":"2N2X0EBA=NJX","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2N2X0EBA=G52","value":"C"}],"baseDataIds":[]},{"id":"2N2X0EBA=NJY","leftBracket":"","compareType":"67","fieldName":"purchasedqty","rightBracket":"","logic":"0","value":[{"id":"2N2X0EBA=G53","value":"0"}],"baseDataIds":[]},{"id":"2N2X0EBA=NJZ","leftBracket":"","compareType":"67","fieldName":"purchasedamount","rightBracket":"","logic":"0","value":[{"id":"2N2X0EBA=G54","value":"0"}],"baseDataIds":[]}],"forList":false}','获取成本','setprice','1','( billstatus = (''C'')   and    purchasedqty = 0   and    purchasedamount = 0 )',' ','billentry',1467430907727064064,'C',' ','物料明细','IM_MATERIALREQOUTBILL_S1','IM_MATERIALREQOUTBILL_S1',{ts'2022-07-18  00:00:00'},'im_materialreqoutbill',0,' ','1',1241107427621864448,'1',0,{ts'2022-08-08  00:00:00'},1241107427621864448); 



DELETE FROM t_im_costpriceconf_l WHERE FPKID = '2L8A4XRCD18/';
INSERT INTO t_im_costpriceconf_l(FID,FPKID,FLOCALEID,FOPERATIONNAME,FNAME) VALUES (1467430907727064064,'2L8A4XRCD18/','zh_CN','获取成本','IM_MATERIALREQOUTBILL_S1'); 
DELETE FROM t_im_costpriceconf_l WHERE FPKID = '2L8A4XRCD180';
INSERT INTO t_im_costpriceconf_l(FID,FPKID,FLOCALEID,FOPERATIONNAME,FNAME) VALUES (1467430907727064064,'2L8A4XRCD180','zh_TW','獲取成本','IM_MATERIALREQOUTBILL_S1'); 
DELETE FROM t_im_costpriceconf_l WHERE FPKID = '2QDJCG=0GB+P';
INSERT INTO t_im_costpriceconf_l(FID,FPKID,FLOCALEID,FOPERATIONNAME,FNAME) VALUES (1467430907727064064,'2QDJCG=0GB+P','en_US','Acquisition Cost','IM_MATERIALREQOUTBILL_S1'); 

DELETE FROM t_im_costcolsmapentry WHERE FENTRYID = 1467430907869670400;
INSERT INTO t_im_costcolsmapentry(FID,FENTRYID,FSEQ,FCOSTRECORDFIELDKEY,FIMBILLFIELDKEY,FIMBILLFIELD,FCOSTRECORDFIELD) VALUES (1467430907727064064,1467430907869670400,1,'entry.unitactualcost','billentry.price','物料明细.单价','单据体.单位实际成本'); 
DELETE FROM t_im_costcolsmapentry WHERE FENTRYID = 1467431850640146432;
INSERT INTO t_im_costcolsmapentry(FID,FENTRYID,FSEQ,FCOSTRECORDFIELDKEY,FIMBILLFIELDKEY,FIMBILLFIELD,FCOSTRECORDFIELD) VALUES (1467430907727064064,1467431850640146432,2,'entry.actualcost','billentry.amount','物料明细.金额','单据体.实际成本'); 


