eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: GL_EXTRACT_HISTORY

Product:	GL - General Ledger
Description:	Successful full or incremental extract requests information from the GL_BALANCES_DELTA table generated from programs like Analyzer-Extract Incremental Balances
Implementation/DBA Data:	GL.GL_EXTRACT_HISTORY

Primary Key: GL_EXTRACT_HISTORY_PK

LEDGER_ID
EXTRACT_PROGRAM_CODE
PERIOD_NAME
ACTUAL_FLAG
EXTRACT_LEVEL_CODE
BUDGET_VERSION_ID
ENCUMBRANCE_TYPE_ID
TEMPLATE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
GL_EXTRACT_HISTORY	GL_BUDGET_VERSIONS	GL_EXTRACT_HISTORY.BUDGET_VERSION_ID
GL_EXTRACT_HISTORY	GL_ENCUMBRANCE_TYPES	GL_EXTRACT_HISTORY.ENCUMBRANCE_TYPE_ID
GL_EXTRACT_HISTORY	GL_SETS_OF_BOOKS_11I	GL_EXTRACT_HISTORY.LEDGER_ID
GL_EXTRACT_HISTORY	GL_SUMMARY_TEMPLATES	GL_EXTRACT_HISTORY.TEMPLATE_ID