PO_SPEND_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	REPORT_ENTITY	Character(5)	VARCHAR2(5) NOT NULL	Reporting Entity ID
5	PRCR_PER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Period Run Type R=Relative S=Specify
6	REL_START_PER	Signed Number(4,0)	DECIMAL(3) NOT NULL	Start - Cur Period Minus
7	REL_END_PER	Signed Number(4,0)	DECIMAL(3) NOT NULL	End - Cur Period Minus
8	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
9	CALENDAR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Calendar SetID
10	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID
11	START_PERIOD	Signed Number(4,0)	DECIMAL(3) NOT NULL	Start Period
12	END_PERIOD	Signed Number(4,0)	DECIMAL(3) NOT NULL	End Period
13	START_YEAR	Signed Number(5,0)	DECIMAL(4) NOT NULL	Start Year
14	END_YEAR	Signed Number(5,0)	DECIMAL(4) NOT NULL	End Year
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
16	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
17	AE_RUN_OK	Character(1)	VARCHAR2(1) NOT NULL	AE Run OK Indicator
18	START_DT	Date(10)	DATE	Start Date
19	END_DT	Date(10)	DATE	End Date
20	RT_RATE_INDEX	Character(10)	VARCHAR2(10) NOT NULL	Market Rate Index
21	DAYS_AGED_CHAR	Character(14)	VARCHAR2(14) NOT NULL	Days Aged