WM_VITM_MFG2_VW

(SQL View)
 Index Back

WM Vndr Loc Item Mfg2 View

Note: used in Sched PO Supplier Item Search

SELECT A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.ITM_SETID , A.INV_ITEM_ID , A.MFG_ID , A.MFG_ITM_ID , A.UNIT_OF_MEASURE , CASE WHEN B.UPN_TYPE_CD IS NULL THEN ' ' ELSE B.UPN_TYPE_CD END , CASE WHEN B.UPN_ID IS NULL THEN ' ' ELSE B.UPN_ID END , A.MFG_NAME , A.PREFERRED_MFG FROM PS_WM_VITM_MFG1_VW A LEFT OUTER JOIN PS_ITEM_MFG_UPN_FS B ON B.SETID = A.ITM_SETID AND B.INV_ITEM_ID = A.INV_ITEM_ID AND B.MFG_ID = A.MFG_ID AND B.MFG_ITM_ID = A.MFG_ITM_ID AND B.UNIT_OF_MEASURE = A.UNIT_OF_MEASURE

# 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 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
7 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
8 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
9 UPN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Universal Product Number Format Type
10 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number
11 MFG_NAME Character(60) VARCHAR2(60) NOT NULL Manufacturer Name
12 PREFERRED_MFG Character(1) VARCHAR2(1) NOT NULL Item's Preferred Manufacturer

Y/N Table Edit