PV_ITM_SMFG_VW

(SQL View)
Index Back

SELECT M.SETID , M.INV_ITEM_ID , M.VENDOR_SETID , M.VENDOR_ID , M.VNDR_LOC , M.MFG_ID , M.MFG_ITM_ID , M.PREFERRED_MFG FROM PS_ITM_VENDOR_MFG M

# 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
3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VNDR_VNDSET_VW

5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
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 PREFERRED_MFG Character(1) VARCHAR2(1) NOT NULL Item's Preferred Manufacturer

Y/N Table Edit

Default Value: N