MRP运算报错
金蝶云社区-云社区用户cT0o5100
云社区用户cT0o5100
0人赞赏了该文章 505次浏览 未经作者许可,禁止转载编辑于2016年09月20日 08:39:41

MRP运算时报错:
source:SELECT T_BD_MATERIAL.FMATERIALID, T_BD_MATERIAL.FMasterId, T_BD_MATERIAL.FDOCUMENTSTATUS, T_BD_MATERIAL.FFORBIDSTATUS, T_BD_MATERIAL.FNUMBER, T_BD_MATERIAL.FCREATEORGID, T_BD_MATERIAL.FUSEORGID, T_BD_MATERIAL.FCREATORID, T_BD_MATERIAL.FMODIFIERID, T_BD_MATERIAL.FCREATEDATE, T_BD_MATERIAL.FMODIFYDATE, T_BD_MATERIAL.FMNEMONICCODE, T_BD_MATERIAL.FFORBIDDERID, T_BD_MATERIAL.FFORBIDDATE, T_BD_MATERIAL.FAPPROVEDATE, T_BD_MATERIAL.FAPPROVERID, T_BD_MATERIAL.FIMAGE, T_BD_MATERIAL.FOLDNUMBER, T_BD_MATERIAL.FMATERIALGROUP, T_BD_MATERIAL.FPLMMATERIALID, T_BD_MATERIAL.FMATERIALSRC, T_BD_MATERIAL.FIMAGEFILESERVER, T_BD_MATERIAL.FIMGSTORAGETYPE, T_BD_MATERIAL.FISSALESBYNET, T_BD_MATERIAL.FNOTBOM, T_BD_MATERIAL.FRATE, T_BD_MATERIAL.F_PABG_DECIMAL FROM T_BD_MATERIAL WHERE T_BD_MATERIAL.FMATERIALID = @PKValue;
SELECT T_BD_MATERIAL_L.FPkId, T_BD_MATERIAL_L.FLocaleId, T_BD_MATERIAL_L.FNAME, T_BD_MATERIAL_L.FDESCRIPTION, T_BD_MATERIAL_L.FSPECIFICATION, T_BD_MATERIAL_L.FMATERIALID FROM T_BD_MATERIAL_L INNER JOIN T_BD_MATERIAL ON T_BD_MATERIAL_L.FMATERIALID = T_BD_MATERIAL.FMATERIALID WHERE T_BD_MATERIAL.FMATERIALID = @PKValue;
SELECT t_BD_MaterialBase.FEntryId, t_BD_MaterialBase.FERPCLSID, t_BD_MaterialBase.FISINVENTORY, t_BD_MaterialBase.FISSALE, t_BD_MaterialBase.FISASSET, t_BD_MaterialBase.FISSUBCONTRACT, t_BD_MaterialBase.FISPRODUCE, t_BD_MaterialBase.FISPURCHASE, t_BD_MaterialBase.FISREALTIMEACCOUT, t_BD_MaterialBase.FBASEUNITID, t_BD_MaterialBase.FTAXTYPE, t_BD_MaterialBase.FTYPEID, t_BD_MaterialBase.FCATEGORYID, t_BD_MaterialBase.FTAXRATEID, t_BD_MaterialBase.FBARCODE, t_BD_MaterialBase.FWEIGHTUNITID, t_BD_MaterialBase.FVOLUMEUNITID, t_BD_MaterialBase.FGROSSWEIGHT, t_BD_MaterialBase.FNETWEIGHT, t_BD_MaterialBase.FLENGTH, t_BD_MaterialBase.FVOLUME, t_BD_MaterialBase.FWIDTH, t_BD_MaterialBase.FHEIGHT, t_BD_MaterialBase.FCONFIGTYPE, t_BD_MaterialBase.FMATERIALID FROM t_BD_MaterialBase INNER JOIN T_BD_MATERIAL ON t_BD_MaterialBase.FMATERIALID = T_BD_MATERIAL.FMATERIALID WHERE