EE_EVENTGN5_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
4	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
5	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
6	MONETARY_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
7	MONETARY_AMOUNT_01	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
8	MONETARY_AMOUNT_02	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
9	SQL_SELECT_001	Character(254)	VARCHAR2(254) NOT NULL
10	SQL_SELECT_002	Character(254)	VARCHAR2(254) NOT NULL
11	SQL_SELECT_003	Character(254)	VARCHAR2(254) NOT NULL
12	EE_PO_STEP_SQL	Character(100)	VARCHAR2(100) NOT NULL	Entry Event PO SQL
13	STEPNO	Number(5,0)	INTEGER NOT NULL	Step Number
14	RVRSL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control Reversal Flag
15	RVSL_DT_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Reversal Date Option C=Current Date P=Prior Date
16	ROW_COUNT	Number(8,0)	INTEGER NOT NULL	Number to Purge
17	STEP_NBR	Number(6,2)	DECIMAL(5,2) NOT NULL	Sequence number of step in its path
18	WHERE_CLAUSE1	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
19	EXIST	Character(1)	VARCHAR2(1) NOT NULL	Exist
20	KK_TRAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Commitment Control Foreign Key for Transaction Identification.
21	KK_TRAN_DT	Date(10)	DATE	Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID.
22	KK_TRAN_LN	Number(9,0)	DECIMAL(9) NOT NULL	Commitment Control Transaction Line number.
23	DATA_FOUND	Character(1)	VARCHAR2(1) NOT NULL	Data Found
24	EXPIRED_YEAR	Character(1)	VARCHAR2(1) NOT NULL	Expired Year