ITM_VNDR_UM_VW2

(SQL View)
 Index Back

Item Supplier UOM View


select A.SETID, A.INV_ITEM_ID, A.VENDOR_SETID, A.VENDOR_ID, A.VNDR_LOC, A.UNIT_OF_MEASURE, B.DESCR from PS_ITM_VNDR_UOM A, PS_UNITS_TBL B where A.UNIT_OF_MEASURE = B.UNIT_OF_MEASURE

  • Related Language Record: ITM_VN_UM_VW2LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: ITM_PURCH_VW

    3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

    Prompt Table: SP_SETID_NONVW

    4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VNDR_VNDSET_VW

    5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    6 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description