PV_CP_ITM_XREF

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	PV_CP_ITM_KEY	Number(10,0)	DECIMAL(10) NOT NULL	MarketSite to Peoplesoft Item
3	PV_MS_SUP_MPID	Character(50)	VARCHAR2(50) NOT NULL	e
4	PV_CP_SPN	Character(50)	VARCHAR2(50) NOT NULL	Supplier Part Number
5	PV_CP_PART_EXT	Character(50)	VARCHAR2(50) NOT NULL	CUP Part Extension
6	PV_CP_UOM	Character(12)	VARCHAR2(12) NOT NULL	CUP Unit of Measure
7	MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer ID
8	MFG_ITM_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer's Item ID
9	PV_CP_MFR_NAME	Character(60)	VARCHAR2(60) NOT NULL	Date Initials Issues Description 07/30/07 DH F-AHAYT-L64E0 increase length to 60 chars
10	PV_CP_MPN	Character(50)	VARCHAR2(50) NOT NULL	CUP Manufacturers Part Number
11	FILENAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
12	FILE_EXTENSION	Character(4)	VARCHAR2(4) NOT NULL	File Extension
13	VNDR_CATALOG_ID	Character(20)	VARCHAR2(20) NOT NULL	Vendor's Catalog Number
14	PV_CP_DESC1	Long Character	CLOB	CUP Short Description
15	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
16	PV_CM_CATALOG_ID	Character(32)	VARCHAR2(32) NOT NULL	Catalog ID