PO_LN_ORDER_VW

(SQL View)
 Index Back

Purchase Order Line Order View

01/25/2012 JAMANI 13545345 Ensured that the quantity invoiced is converted into purchase order UOM in Activity summary page.

SELECT L.BUSINESS_UNIT , L.PO_ID , L.LINE_NBR , L.CANCEL_STATUS , L.CHANGE_STATUS , L.ITM_SETID , L.INV_ITEM_ID , L.DESCR254_MIXED , L.UNIT_OF_MEASURE , L.QTY_TYPE , L.CNTRCT_ID , L.CNTRCT_LINE_NBR , L.AMT_ONLY_FLG , L.RECV_REQ , SUM(S.QTY_PO) , S.CONVERSION_RATE , SUM(S.MERCHANDISE_AMT) , S.CURRENCY_CD FROM PS_PO_LINE L , PS_PO_LINE_SHIP S WHERE L.BUSINESS_UNIT = S.BUSINESS_UNIT AND L.PO_ID = S.PO_ID AND L.LINE_NBR = S.LINE_NBR AND S.CANCEL_STATUS <> 'X' GROUP BY L.BUSINESS_UNIT, L.PO_ID, L.LINE_NBR, L.CANCEL_STATUS, L.CHANGE_STATUS, L.ITM_SETID, L.INV_ITEM_ID, L.DESCR254_MIXED, L.UNIT_OF_MEASURE, L.QTY_TYPE, L.CNTRCT_ID, L.CNTRCT_LINE_NBR, L.AMT_ONLY_FLG, L.RECV_REQ, S.CONVERSION_RATE,S.CURRENCY_CD

  • 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 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    4 CANCEL_STATUS Character(1) VARCHAR2(1) NOT NULL Cancel Status
    A=Active
    C=Closed
    D=Denied
    H=Hold
    O=Open
    P=Pending Approval
    X=Canceled
    5 CHANGE_STATUS Character(1) VARCHAR2(1) NOT NULL Change Order Status
    C=Changed
    U=Unchanged
    6 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
    7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    8 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    9 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    10 QTY_TYPE Character(1) VARCHAR2(1) NOT NULL Quantity to Use for Prices
    L=Line Quantity
    S=Schedule Quantity
    11 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
    12 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
    13 AMT_ONLY_FLG Character(1) VARCHAR2(1) NOT NULL Amount Only
    N=No
    Y=Yes
    14 RECV_REQ Character(1) VARCHAR2(1) NOT NULL Receiving Required
    N=Optional
    X=Do Not
    Y=Required
    15 QTY_ORDERED Signed Number(16,4) DECIMAL(14,4) NOT NULL Order Qty
    16 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
    17 AMT_ORDERED Number(27,3) DECIMAL(26,3) NOT NULL Amount Ordered
    18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code