PC_MULTICUR_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	AE_EXISTS	Character(1)	VARCHAR2(1) NOT NULL	Exists
3	RECNAME_SOURCE	Character(15)	VARCHAR2(15) NOT NULL	Source Recname
4	RECNAME_TARGET	Character(15)	VARCHAR2(15) NOT NULL	Target Recname
5	RECNAME_TMP	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name
6	FIELDNAME_FROM_CUR	Character(18)	VARCHAR2(18) NOT NULL	From Currency
7	FIELDNAME_FROM_AMT	Character(18)	VARCHAR2(18) NOT NULL	From Amount
8	FIELDNAME_TO_CUR	Character(18)	VARCHAR2(18) NOT NULL	To Currency
9	FIELDNAME_TO_AMT	Character(18)	VARCHAR2(18) NOT NULL	To Amount
10	FIELDNAME_RT_TYPE	Character(18)	VARCHAR2(18) NOT NULL	Rate Type
11	FIELDNAME_CUREFFDT	Character(18)	VARCHAR2(18) NOT NULL	Currency Effective Date
12	BU_CUR_SW	Character(1)	VARCHAR2(1) NOT NULL	Currency Override
13	WORK_CNT	Number(10,0)	DECIMAL(10) NOT NULL	Count of Anything
14	COUNT_LINES	Number(15,0)	DECIMAL(15) NOT NULL	Count of Lines
15	LOGMSGDTLFLG	Number(1,0)	SMALLINT NOT NULL	Log Message Detail?
16	CHECK_ROW_COUNT	Character(1)	VARCHAR2(1) NOT NULL	Display Count
17	CURR_EFFDT	Date(10)	DATE	Current Benefit Program Effdt
18	CURR_END_DT	Date(10)	DATE	End Date
19	CURR_FROM_CUR	Character(3)	VARCHAR2(3) NOT NULL	From Currency Code
20	CURR_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
21	CURR_RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
22	CURR_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.
23	CURR_TO_CUR	Character(3)	VARCHAR2(3) NOT NULL	To Currency Code
24	PREV_EFFDT	Date(10)	DATE	Effective Date
25	PREV_END_DT	Date(10)	DATE	End Date
26	PREV_FROM_CUR	Character(3)	VARCHAR2(3) NOT NULL	From Currency Code
27	PREV_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
28	PREV_RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
29	PREV_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.
30	PREV_TO_CUR	Character(3)	VARCHAR2(3) NOT NULL	To Currency Code
31	ROWNBR	Number(7,0)	INTEGER NOT NULL	Row number
32	TOTALROWS	Number(7,0)	INTEGER NOT NULL	Row number
33	CUR_RT_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Exchange Rate Source T=Use Exchange Rate Tables U=User Specified Default Value: T
34	EXIST	Character(1)	VARCHAR2(1) NOT NULL	Exist