MRP计算错误
金蝶云社区-songmin
songmin
1人赞赏了该文章 518次浏览 未经作者许可,禁止转载编辑于2018年09月02日 14:34:51
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.F_PAEZ_WLJCCJXH, T_BD_MATERIAL.F_PAEZ_WLJCSCCJ, T_BD_MATERIAL.F_PAEZ_WLKCHJH, T_BD_MATERIAL.F_PAEZ_WLJCZRR 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.FSUITE, t_BD_MaterialBase.FCOSTPRICERATE, t_BD_MaterialBase.FMATERIALID FROM t_