PO_POA_LN_EVW

(SQL View)
 Index Back

POA Message Line View

SELECT BUSINESS_UNIT , PO_ID , LINE_NBR , INV_ITEM_ID , DESCR254_MIXED , ITM_ID_VNDR , VNDR_CATALOG_ID , UNIT_OF_MEASURE , MFG_ID , MFG_ITM_ID , CNTRCT_ID , CNTRCT_LINE_NBR , RELEASE_NBR , RFQ_ID , RFQ_LINE_NBR , ACK_STATUS FROM PS_PO_LINE_EC

SELECT BUSINESS_UNIT , PO_ID , LINE_NBR , INV_ITEM_ID , DESCR254_MIXED , ITM_ID_VNDR , VNDR_CATALOG_ID , UNIT_OF_MEASURE , MFG_ID , MFG_ITM_ID , CNTRCT_ID , VERSION_NBR , CAT_LINE_NBR , CNTRCT_LINE_NBR , RELEASE_NBR , RFQ_ID , RFQ_LINE_NBR , ACK_STATUS ,UPN_ID FROM PS_PO_LINE_EC

  • Parent record: PO_HDR

    • # 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 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    5 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    6 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
    7 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
    8 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    9 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
    10 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
    11 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
    12 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
    13 CAT_LINE_NBR Number(5,0) INTEGER NOT NULL Contract Category Line Number
    14 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
    15 RELEASE_NBR Number(5,0) INTEGER NOT NULL Release Number
    16 RFQ_ID Character(10) VARCHAR2(10) NOT NULL RFQ ID
    17 RFQ_LINE_NBR Number(5,0) INTEGER NOT NULL RFQ Line
    18 ACK_STATUS Character(3) VARCHAR2(3) NOT NULL Acknowledgement Status
    AC=Ack - With Detail and Change
    AD=Ack - With Detail, No Change
    AE=Ack - Exception Detail Only
    AH=Acknowledge - Hold Status
    AK=Ack - No Detail or Change
    AT=Accepted
    BP=Accepted - Partial Shipment
    DR=Accepted - Date Rescheduled
    IA=Accepted - Price Pending
    IB=Backordered
    IC=Accepted - Changes Made
    ID=Deleted
    IF=On Hold-Incomplete Description
    IH=On Hold
    IP=Accepted - Price Changed
    IQ=Accepted - Quantity Changed
    IS=Accepted - Substitution Made
    IW=On Hold - Waiver Required
    RD=Rejected With Detail
    RF=Rej - Exception Detail Only
    RJ=Rejected - No Detail
    RO=Rejected With Counter Offer
    SP=Accpted-Schedule Date Pending
    ZZ=Mutually Defined Value
    19 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number