采购订单收货计划

代码示例

SELECT t0.DocEntry as 采购订单,
       t0.DocNum,
       t0.CardCode as 供应商,
       t0.CardName as 名称,
       t0.NumAtCard,
       t0.DocDate,
       t1.ShipDate,
       t1.ItemCode,
       t1.Dscription as 描述,
       t1.Quantity as 原始数量,
       t1.OpenCreQty as 未交货数量,
       t2.SlpName
  FROM OPOR t0
       INNER JOIN POR1 t1
          ON t0.DocEntry = t1.DocEntry
       LEFT OUTER JOIN OSLP t2
          ON t0.SlpCode = t2.SlpCode
 WHERE t0.CANCELED = 'N' AND t0.DocStatus <> 'C' AND t1.OpenCreQty <> 0
ORDER BY t1.ShipDate