WM_IN_UPNID_VW

(SQL View)
Index Back

WM Inventory UPN IDs

Note: used in Sched PO Supplier Item Search

SELECT DISTINCT A.SETID AS ITM_SETID , A.UPN_TYPE_CD , A.UPN_ID , B.DESCR60 FROM PS_ITEM_MFG_UPN_FS A , PS_MASTER_ITEM_TBL B WHERE A.UPN_ID <> ' ' AND B.SETID = A.SETID AND B.INV_ITEM_ID = A.INV_ITEM_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
2 UPN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Universal Product Number Format Type
3 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number
4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description