PV_ITMCAT2_WS

#	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	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
7	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
8	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
9	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
10	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
11	ITM_ID_VNDR	Character(50)	VARCHAR2(50) NOT NULL	Vendor Item ID
12	VNDR_CATALOG_ID	Character(20)	VARCHAR2(20) NOT NULL	Vendor's Catalog Number
13	PRICE_LIST	Number(16,5)	DECIMAL(15,5) NOT NULL	Standard Price
14	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
15	PRICE_VNDR	Number(16,5)	DECIMAL(15,5) NOT NULL	Vendor Price
16	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
17	MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer ID
18	MFG_ITM_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer's Item ID
19	ITM_VNDR_PRIORITY	Number(3,0)	SMALLINT NOT NULL	Item Vendor Priority
20	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
21	PRICE_REQ	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Date Initials Issue Description 092107 dh F-AHAYT-95051 ePro change from number to Sign to allow negative