PV_POLINE_EC_VW

(SQL View)
 Index Back

Purchase Order Line Item


SELECT DISTINCT A.BUSINESS_UNIT_REQ , A.REQ_ID , A.BUSINESS_UNIT , A.PO_ID , B.LINE_NBR , B.INV_ITEM_ID , B.EIP_CTL_ID , B.DESCR254_MIXED , B.ITM_ID_VNDR , B.VNDR_CATALOG_ID , B.UNIT_OF_MEASURE , B.MFG_ID , B.MFG_ITM_ID , B.CNTRCT_ID , B.CNTRCT_LINE_NBR , B.RELEASE_NBR , B.RFQ_ID , B.RFQ_LINE_NBR , B.ACK_STATUS , B.PROCESS_FLG , B.PO_LINE_CHNG_COUNT , B.PO_LINE_BO_COUNT , A.VENDOR_ID FROM PS_PV_REQ_POA_VW A , PS_PO_LINE_EC B WHERE A.BUSINESS_UNIT= B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID

  • Parent record: PO_HDR_EC

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT_REQ Character(5) VARCHAR2(5) NOT NULL Requesting Business Unit
    2 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    4 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: PURCH_ITEM_VW

    7 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
    8 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    9 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
    10 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
    11 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: UNITS_TBL

    12 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

    Prompt Table: PO_SSPOA_MFG_VW

    13 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID

    Prompt Table: PO_SSPOAMFGIDVW

    14 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

    Prompt Table: PO_CNTRCT_SRCH

    15 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr

    Prompt Table: CNTRCT_LN_SRCH

    16 RELEASE_NBR Number(5,0) INTEGER NOT NULL Release Number
    17 RFQ_ID Character(10) VARCHAR2(10) NOT NULL RFQ ID
    18 RFQ_LINE_NBR Number(5,0) INTEGER NOT NULL RFQ Line
    19 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
    20 PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL Processing Flag

    Default Value: N

    21 PO_LINE_CHNG_COUNT Number(3,0) SMALLINT NOT NULL Line and Schedule Changes
    22 PO_LINE_BO_COUNT Number(3,0) SMALLINT NOT NULL Backorder Count
    23 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier