采购计划视图

SELECT TOP (1000) a.[PurchaseOrder]
      ,a.[POLine]
      ,a.[docno]
      ,a.[DocType]
      ,a.[DocLineNo]
      ,a.[ItemCode]
      ,a.[ItemName]
      ,a.[ItemSpesc]
      ,a.[CreatedOn]
      ,a.[InvUom]
      ,a.[Qty]
      ,a.[FinallyPriceTC]
      ,a.[price]
      ,a.[NetMnyFC]
      ,a.[TotalMnyTC]
      ,a.[NetMnyTC]
      ,a.[TotalTaxTC]
      ,a.[Memo]
      ,a.[RcvQtyTU]
      ,a.[UnRcvQtyTU]
      ,a.[RejectQtyTU]
      ,b.ReqQtyCU 计划需求数
      ,b.PlanArriveDate 计划到货日期
  FROM [EMPCSK].[dbo].[ZZ_PM_PoLine] a 
  left join [EMPCSK].[dbo].[PM_POShipLine] b on b.[POLine]=a.[POLine]
  where a.[docno]='PO02406080003'