INV_ITMUOM_VW

(SQL View)
 Index Back

Partial list of valid UOM

10/11/03 RML Created new view to show item UOM that is not in itm_vndr_uom table; used in dynamic view itm_any_uom_vw

SELECT A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , C.SETID , C.INV_ITEM_ID , C.UNIT_OF_MEASURE , B.DESCR , C.DFLT_UOM_STOCK FROM PS_VENDOR_LOC_VW A , PS_UNITS_TBL B , PS_INV_ITEM_UOM C ,PS_UOM_TYPE_INV D WHERE B.UNIT_OF_MEASURE = C.UNIT_OF_MEASURE AND D.SETID = C.SETID AND D.INV_ITEM_ID = C.INV_ITEM_ID AND D.UNIT_OF_MEASURE = C.UNIT_OF_MEASURE AND D.INV_UOM_TYPE = 'ORDR' AND NOT EXISTS( SELECT 'x' FROM PS_ITM_VNDR_UOM x WHERE x.setid = c.setid AND x.inv_item_id = c.inv_item_id AND x.unit_of_measure = c.unit_of_measure AND x.vendor_setid = a.vendor_setid AND x.vendor_id = a.vendor_id)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
4 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
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
8 DFLT_UOM Character(1) VARCHAR2(1) NOT NULL Vendor Default UOM

Y/N Table Edit