GL_EXT_DATE_TMP (SQL Table)	Index Back
GL Explosion Join Table Explosion Join Table for HR Accounting Line (HR_ACCTG_LINE) table

GL_EXT_DATE_TMP

(SQL Table)

GL Explosion Join Table

Explosion Join Table for HR Accounting Line (HR_ACCTG_LINE) table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OLD_VAL_TO_SEQ Character(50) VARCHAR2(50) NOT NULL OLD VALUE

2 NEW_VAL_TO_SEQ Character(50) VARCHAR2(50) NOT NULL NEW VALUE

3 POSTED_DATE Date(10) DATE Specifies the date that a journal entry is posted. This field is maintained by the posting program of PeopleSoft General Ledger.

4 JOURNAL_DATE_ORIG Date(10) DATE Orignial Journal Date

5 ADB_DATE Date(10) DATE Specifies the daily date to use when Average Daily Balancing is activated. The date is determined by the daily calendar associated with the General Ledger Business Unit to which the journal is posted. When ADB processing is not activated, the ADB_Date defaults to the date on the Journal Header (JOURNAL_DATE).

6 TRANSACTION_DATE Date(10) DATE Transaction Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OLD_VAL_TO_SEQ	Character(50)	VARCHAR2(50) NOT NULL	OLD VALUE
2	NEW_VAL_TO_SEQ	Character(50)	VARCHAR2(50) NOT NULL	NEW VALUE
3	POSTED_DATE	Date(10)	DATE	Specifies the date that a journal entry is posted. This field is maintained by the posting program of PeopleSoft General Ledger.
4	JOURNAL_DATE_ORIG	Date(10)	DATE	Orignial Journal Date
5	ADB_DATE	Date(10)	DATE	Specifies the daily date to use when Average Daily Balancing is activated. The date is determined by the daily calendar associated with the General Ledger Business Unit to which the journal is posted. When ADB processing is not activated, the ADB_Date defaults to the date on the Journal Header (JOURNAL_DATE).
6	TRANSACTION_DATE	Date(10)	DATE	Transaction Date