PO_SSPOAMFGIDVW

(SQL View)
Index Back

SELECT SETID , INV_ITEM_ID ,MFG_ID ,MFG_ITM_ID FROM PS_ITEM_MFG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: MST_ITM_VW4

3 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

Prompt Table: MANUFACTURER

4 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID