PV_POLINE_FS_VW

(SQL View)
 Index Back

Purchase Order Line Item


SELECT BUSINESS_UNIT ,PO_ID ,LINE_NBR ,CANCEL_STATUS ,CHANGE_STATUS ,ITM_SETID ,INV_ITEM_ID ,ITM_ID_VNDR ,VNDR_CATALOG_ID ,CATEGORY_ID ,CHNG_ORD_SEQ ,UNIT_OF_MEASURE ,QTY_TYPE ,PRICE_DT_TYPE ,MFG_ID ,MFG_ITM_ID ,CNTRCT_SETID ,CNTRCT_ID ,CNTRCT_LINE_NBR ,CNTRCT_RATE_MULT ,CNTRCT_RATE_DIV ,RFQ_ID ,RFQ_LINE_NBR ,INSPECT_CD ,ROUTING_ID ,RECV_REQ ,PRICE_CAN_CHANGE ,WTHD_SW ,WTHD_CD ,CONFIG_CODE ,CP_TEMPLATE_ID ,DESCR254_MIXED FROM PS_PO_LINE

  • 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 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

    Default Value: A

    5 CHANGE_STATUS Character(1) VARCHAR2(1) NOT NULL Change Order Status
    C=Changed
    U=Unchanged

    Default Value: U

    6 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
    7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: %EDIT_ITEM_ID

    8 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
    9 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
    10 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID

    Prompt Table: ITM_CAT_TBL

    11 CHNG_ORD_SEQ Number(3,0) SMALLINT NOT NULL Change Order Sequence Number
    12 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: %EDIT_UOM

    13 QTY_TYPE Character(1) VARCHAR2(1) NOT NULL Quantity to Use for Prices
    L=Line Quantity
    S=Schedule Quantity

    Default Value: S

    14 PRICE_DT_TYPE Character(1) VARCHAR2(1) NOT NULL Date to Use for Prices
    D=Due Date
    P=PO Date

    Default Value: P

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

    Prompt Table: MANUFACTURER

    16 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
    17 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID
    18 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

    Prompt Table: PO_CNTRCT_SRCH

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

    Prompt Table: %EDIT_CNTRCT_LN

    20 CNTRCT_RATE_MULT Number(16,8) DECIMAL(15,8) NOT NULL Contract Rate Multiplier
    21 CNTRCT_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Contract Rate Divider
    22 RFQ_ID Character(10) VARCHAR2(10) NOT NULL RFQ ID
    23 RFQ_LINE_NBR Number(5,0) INTEGER NOT NULL RFQ Line
    24 INSPECT_CD Character(1) VARCHAR2(1) NOT NULL Inspection Required
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    25 ROUTING_ID Character(10) VARCHAR2(10) NOT NULL Inspection Routing ID

    Prompt Table: ROUTING_HDR

    26 RECV_REQ Character(1) VARCHAR2(1) NOT NULL Receiving Required
    N=Optional
    X=Do Not
    Y=Required

    Y/N Table Edit

    Default Value: N

    27 PRICE_CAN_CHANGE Character(1) VARCHAR2(1) NOT NULL Price Can Be Changed on Order
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

    28 WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding Applicable Flag
    B=Global and 1099
    G=Global
    T=1099
    29 WTHD_CD Character(5) VARCHAR2(5) NOT NULL Withholding Code
    30 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
    31 CP_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID Field
    32 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description