GL_ADB_POST_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
3	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
4	DATE_CODE	Character(1)	VARCHAR2(1) NOT NULL	This field defines codes for Date field used in Journal lines record. The Different date fields can be used as the basis for alternate Posting to satisfy Trade Date/Settlement date requirements.
5	DATE_CODE2	Character(1)	VARCHAR2(1) NOT NULL	This field defines codes for Date field used in Journal lines record. The Different date fields can be used as the basis for alternate Posting to satisfy Trade Date/Settlement date requirements.
6	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
7	SETID_ACCOUNT	Character(5)	VARCHAR2(5) NOT NULL	Account Table Setid
8	DTTM_STAMP_SEC	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
9	CURRENT_DATE1	Date(10)	DATE	12/20/01 EGS (CN#PL900-1): Added 10/07/02 JC (CN#PL880-1): Added FROM_DATE label
10	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
11	FISCAL_YEAR2	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
12	ACCOUNTING_PERIOD2	Number(3,0)	SMALLINT NOT NULL	Accounting Period
13	FIELDNAME1	Character(18)	VARCHAR2(18) NOT NULL	Field Name 1
14	FIELDNAME2	Character(18)	VARCHAR2(18) NOT NULL	Fieldname 2
15	RECNAME_ADBLD_TAO	Character(15)	VARCHAR2(15) NOT NULL	Ledger ADB Tmp
16	ADB_STATUTORY_RPT	Character(1)	VARCHAR2(1) NOT NULL	Maintain Balances by Date Code
17	AE_APPSTATUS	Number(1,0)	SMALLINT NOT NULL	AE Application Warning Status