PRCR_UPD_TMPC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PRCR_YEAR	Number(4,0)	SMALLINT NOT NULL	Procurement Year
3	PRCR_PERIOD	Number(3,0)	SMALLINT NOT NULL	Procurement Period
4	ITM_SETID	Character(5)	VARCHAR2(5) NOT NULL	Item SetID
5	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
6	CATEGORY_ID	Character(5)	VARCHAR2(5) NOT NULL	Category ID
7	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
8	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
9	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
10	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit
11	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
13	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
14	UNIT_MEASURE_WT	Character(3)	VARCHAR2(3) NOT NULL	Weight UOM
15	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
16	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
17	REPORT_ENTITY	Character(5)	VARCHAR2(5) NOT NULL	Reporting Entity ID
18	SHIPTO_SETID	Character(5)	VARCHAR2(5) NOT NULL	ShipTo SetID
19	NUM_OF_ORDERS	Number(7,0)	INTEGER NOT NULL	Number of Orders