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_SUMMARY_TEMPLATES

Product:	GL - General Ledger
Description:	Summary account templates
Implementation/DBA Data:	GL.GL_SUMMARY_TEMPLATES

Primary Key: GL_SUMMARY_TEMPLATES_PK

TEMPLATE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
GL_SUMMARY_TEMPLATES	GL_SETS_OF_BOOKS_11I	GL_SUMMARY_TEMPLATES.LEDGER_ID
GL_SUMMARY_TEMPLATES	GL_BUDGET_VERSIONS	GL_SUMMARY_TEMPLATES.FUNDING_BUDGET_VERSION_ID
GL_SUMMARY_TEMPLATES	GL_CODE_COMBINATIONS	GL_SUMMARY_TEMPLATES.MAX_CODE_COMBINATION_ID
GL_ACCOUNT_HIERARCHIES	GL_SUMMARY_TEMPLATES	GL_ACCOUNT_HIERARCHIES.TEMPLATE_ID
GL_ARCHIVE_BALANCES	GL_SUMMARY_TEMPLATES	GL_ARCHIVE_BALANCES.TEMPLATE_ID
GL_ARCHIVE_DAILY_BALANCES	GL_SUMMARY_TEMPLATES	GL_ARCHIVE_DAILY_BALANCES.TEMPLATE_ID
GL_BALANCES_DELTA	GL_SUMMARY_TEMPLATES	GL_BALANCES_DELTA.TEMPLATE_ID
GL_BALANCES_DELTA_INTERIM	GL_SUMMARY_TEMPLATES	GL_BALANCES_DELTA_INTERIM.TEMPLATE_ID
GL_BALANCES	GL_SUMMARY_TEMPLATES	GL_BALANCES.TEMPLATE_ID
GL_BC_PACKETS	GL_SUMMARY_TEMPLATES	GL_BC_PACKETS.TEMPLATE_ID
GL_BC_PACKETS_HISTS	GL_SUMMARY_TEMPLATES	GL_BC_PACKETS_HISTS.TEMPLATE_ID
GL_BUDGET_INTERIM	GL_SUMMARY_TEMPLATES	GL_BUDGET_INTERIM.TEMPLATE_ID
GL_CODE_COMBINATIONS	GL_SUMMARY_TEMPLATES	GL_CODE_COMBINATIONS.TEMPLATE_ID
GL_DAILY_BALANCES	GL_SUMMARY_TEMPLATES	GL_DAILY_BALANCES.TEMPLATE_ID
GL_DYNAMIC_SUMM_COMBINATIONS	GL_SUMMARY_TEMPLATES	GL_DYNAMIC_SUMM_COMBINATIONS.TEMPLATE_ID
GL_EXTRACT_HISTORY	GL_SUMMARY_TEMPLATES	GL_EXTRACT_HISTORY.TEMPLATE_ID
GL_POSTING_INTERIM	GL_SUMMARY_TEMPLATES	GL_POSTING_INTERIM.TEMPLATE_ID
GL_RECURRING_LINE_CALC_RULES	GL_SUMMARY_TEMPLATES	GL_RECURRING_LINE_CALC_RULES.TEMPLATE_ID
GL_SUMMARY_HIERARCHIES	GL_SUMMARY_TEMPLATES	GL_SUMMARY_HIERARCHIES.TEMPLATE_ID
GL_SUMMARY_HIERARCHY_INT	GL_SUMMARY_TEMPLATES	GL_SUMMARY_HIERARCHY_INT.TEMPLATE_ID
GL_TEMPORARY_COMBINATIONS	GL_SUMMARY_TEMPLATES	GL_TEMPORARY_COMBINATIONS.TEMPLATE_ID
GL_TRANSLATION_INTERIM	GL_SUMMARY_TEMPLATES	GL_TRANSLATION_INTERIM.TEMPLATE_ID
GL_ACCOUNT_HIERARCHIES	GL_SUMMARY_TEMPLATES	GL_ACCOUNT_HIERARCHIES.TEMPLATE_ID
IGC_CBC_SUMMARY_TEMPLATES	GL_SUMMARY_TEMPLATES	IGC_CBC_SUMMARY_TEMPLATES.TEMPLATE_ID
RG_DSS_REQUESTS	GL_SUMMARY_TEMPLATES	RG_DSS_REQUESTS.TEMPLATE_ID
RG_DSS_VAR_TEMPLATES	GL_SUMMARY_TEMPLATES	RG_DSS_VAR_TEMPLATES.TEMPLATE_ID