zgandsy的专栏

原创 SQL写物料需求

Select a.PRD_NO As [货品代号], b.Name As [货品名称], a.STA_DD AS [开始日期],a.end_dd as [结束日期],a.QTY_GR as [毛需求],a.QTY_RCV as [计划收到],a.QTY_OUT as [计划发出],a.QTY_WH as [可分配库存],a.QTY_NON as [净需求],a.QTY_FPO as [已下达计划量