PRCR_UPD_TMP1Q

#	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	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
5	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
6	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
8	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
9	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
10	REPORT_ENTITY	Character(5)	VARCHAR2(5) NOT NULL	Reporting Entity ID
11	ITM_SETID	Character(5)	VARCHAR2(5) NOT NULL	Item SetID
12	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
13	CATEGORY_ID	Character(5)	VARCHAR2(5) NOT NULL	Category ID
14	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
15	SHIPTO_SETID	Character(5)	VARCHAR2(5) NOT NULL	ShipTo SetID
16	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
17	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
18	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency
19	PAID_AMT_GROSS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Paid Amount
20	PAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount