EE_EVENTGN4_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RECNAME_SOURCE	Character(15)	VARCHAR2(15) NOT NULL	Source Recname
3	RECNAME_TARGET	Character(15)	VARCHAR2(15) NOT NULL	Target Recname
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
6	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
7	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
8	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.
9	KK_POSTED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Posted Amount
10	KK_FRN_POSTED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Foreign Posted Amount
11	EE_EVENT_STEP	Character(10)	VARCHAR2(10) NOT NULL	Entry Event Step
12	UNPOST_SEQ	Number(2,0)	SMALLINT NOT NULL	Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
13	ACTIVITY	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Activity
14	ADJUSTED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Proposed Adjustments for Engagement Planning
15	KK_PROCESS_PRIOR	Character(1)	VARCHAR2(1) NOT NULL	Process Prior Document
16	WHERE_CLAUSE8	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
17	SETID_LEDGER	Character(5)	VARCHAR2(5) NOT NULL	Ledger Table Setid
18	DETAIL_CALENDAR	Character(2)	VARCHAR2(2) NOT NULL	Detail Calendar
19	SETID_CALENDAR	Character(5)	VARCHAR2(5) NOT NULL	Calendar Setid
20	EE_PO_STEP_SQL	Character(100)	VARCHAR2(100) NOT NULL	Entry Event PO SQL
21	WHERE_TXT_LONG1	Long Character(4000)	CLOB	Where clause
22	FOREIGN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
23	AMT_DIFF1	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Field used for Calculation
24	AMT_DIFF2	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Field Used for Calculation
25	TEXT80	Character(80)	VARCHAR2(80) NOT NULL	80 Char text field
26	CLOSE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Close Status Indicator C=Closed O=Open
27	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
28	KK_CLOSE_PRIOR	Character(1)	VARCHAR2(1) NOT NULL	Close Prior Transaction
29	MONETARY_AMT_VCHR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Monetary Amount - VCHR BU Base