PV_ITMCAT_VM_W2

#	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 Prompt Table: SP_SETID_NONVW
2	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: INV_ITEMS
3	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
4	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
5	CATEGORY_ID	Character(5)	VARCHAR2(5) NOT NULL	Category ID Prompt Table: ITM_CAT_TBL
6	VNDR_UOM	Character(3)	VARCHAR2(3) NOT NULL	Supplier Unit of Measure
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
9	ITM_ID_VNDR	Character(50)	VARCHAR2(50) NOT NULL	Vendor Item ID
10	VNDR_CATALOG_ID	Character(20)	VARCHAR2(20) NOT NULL	Vendor's Catalog Number
11	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
12	PRICE_LIST	Number(16,5)	DECIMAL(15,5) NOT NULL	Standard Price
13	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
14	CURRENCY_CD_VNDR	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
15	PRICE_VNDR	Number(16,5)	DECIMAL(15,5) NOT NULL	Vendor Price
16	MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer ID Prompt Table: MANUFACTURER
17	MFG_ITM_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer's Item ID
18	QTY_REQ	Number(16,4)	DECIMAL(15,4) NOT NULL	Requisition Quantity
19	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
20	CONVERSION_RATE	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Conversion Rate
21	UPN_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	Universal Product Number Format Type Prompt Table: PV_UPN_VN_CD_VW
22	UPN_ID	Character(20)	VARCHAR2(20) NOT NULL	Universal Product Number