ITEM_UOM_CAT_WS

(SQL View)
Index Back

Item Cat UOM view


SELECT A.SETID , A.CATEGORY_ID , A.INV_ITEM_ID , B.UNIT_OF_MEASURE FROM PS_MASTER_ITEM_TBL A , PS_INV_ITEM_UOM B WHERE A.SETID = B.SETID AND A.INV_ITEM_ID = B.INV_ITEM_ID

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

Default Value: OPR_DEF_TBL_FS.SETID

2 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID

Prompt Table: CAT_CATEGORY_VW

3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
4 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage