PO_LN_ORD_VW4A

(SQL View)
Index Back

PO Line Order View for SCMT

08/08/12 CREATED TO SUM AMT_OPEN FOR PO

SELECT L.BUSINESS_UNIT , L.PO_ID , SUM(L.QTY_PO) , SUM(L.AMT_ORDERED) , SUM(L.AMT_OPEN) FROM PS_PO_LN_ORDER_VW4 L GROUP BY L.BUSINESS_UNIT , L.PO_ID

  • Parent record: PO_HDR_FS
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    3 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
    4 AMT_ORDERED Number(27,3) DECIMAL(26,3) NOT NULL Amount Ordered
    5 AMT_OPEN Signed Number(28,3) DECIMAL(26,3) NOT NULL Open Amount