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_LEDGERS

Product:	GL - General Ledger
Description:	Ledger definition
Implementation/DBA Data:	GL.GL_LEDGERS

Primary Key: GL_LEDGERS_PK

LEDGER_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
GL_LEDGERS	GL_LEDGER_CONFIGURATIONS	GL_LEDGERS.CONFIGURATION_ID
GL_LEDGERS	GL_CODE_COMBINATIONS	GL_LEDGERS.RES_ENCUMB_CODE_COMBINATION_ID
GL_LEDGERS	GL_CODE_COMBINATIONS	GL_LEDGERS.NET_INCOME_CODE_COMBINATION_ID
GL_LEDGERS	GL_CODE_COMBINATIONS	GL_LEDGERS.ROUNDING_CODE_COMBINATION_ID
GL_LEDGERS	GL_TRANSACTION_CALENDAR	GL_LEDGERS.TRANSACTION_CALENDAR_ID
GL_LEDGERS	GL_DAILY_CONVERSION_TYPES	GL_LEDGERS.DAILY_TRANSLATION_RATE_TYPE
GL_LEDGERS	FND_FLEX_VALUE_SETS	GL_LEDGERS.BAL_SEG_COLUMN_NAME
GL_LEDGERS	FND_FLEX_VALUE_SETS	GL_LEDGERS.MGT_SEG_COLUMN_NAME
GL_LEDGERS	GL_ACCESS_SETS	GL_LEDGERS.IMPLICIT_ACCESS_SET_ID
GL_LEDGERS	GL_LEDGERS	GL_LEDGERS.IMPLICIT_LEDGER_SET_ID
GL_LEDGERS	GL_DAILY_CONVERSION_TYPES	GL_LEDGERS.PERIOD_AVERAGE_RATE_TYPE
GL_LEDGERS	GL_DAILY_CONVERSION_TYPES	GL_LEDGERS.PERIOD_END_RATE_TYPE
GL_LEDGERS	GL_AUTOREV_CRITERIA_SETS	GL_LEDGERS.CRITERIA_SET_ID
GL_LEDGERS	FND_CURRENCIES	GL_LEDGERS.CURRENCY_CODE
GL_LEDGERS	GL_CODE_COMBINATIONS	GL_LEDGERS.RET_EARN_CODE_COMBINATION_ID
GL_LEDGERS	GL_CODE_COMBINATIONS	GL_LEDGERS.CUM_TRANS_CODE_COMBINATION_ID
AR_CASH_BASIS_DISTS_ALL	GL_LEDGERS	AR_CASH_BASIS_DISTS_ALL.LEDGER_ID
GL_ACCOUNT_HIERARCHIES	GL_LEDGERS	GL_ACCOUNT_HIERARCHIES.LEDGER_ID
GL_BC_PACKETS	GL_LEDGERS	GL_BC_PACKETS.LEDGER_ID
GL_BC_PACKETS_HISTS	GL_LEDGERS	GL_BC_PACKETS_HISTS.LEDGER_ID
GL_BC_PACKET_ARRIVAL_ORDER	GL_LEDGERS	GL_BC_PACKET_ARRIVAL_ORDER.LEDGER_ID
GL_BC_PERIOD_MAP	GL_LEDGERS	GL_BC_PERIOD_MAP.LEDGER_ID
GL_INTERCOMPANY_ACCOUNTS	GL_LEDGERS	GL_INTERCOMPANY_ACCOUNTS.LEDGER_ID
GL_INTERCOMPANY_ACC_SETS	GL_LEDGERS	GL_INTERCOMPANY_ACC_SETS.LEDGER_ID
GL_INTERFACE_CONTROL	GL_LEDGERS	GL_INTERFACE_CONTROL.SET_OF_BOOKS_ID
GL_INTERFACE	GL_LEDGERS	GL_INTERFACE.LEDGER_ID
GL_JE_HEADERS	GL_LEDGERS	GL_JE_HEADERS.LEDGER_ID
GL_JE_LINES	GL_LEDGERS	GL_JE_LINES.LEDGER_ID
GL_JE_LINES_RECON	GL_LEDGERS	GL_JE_LINES_RECON.LEDGER_ID
GL_LEDGERS	GL_LEDGERS	GL_LEDGERS.IMPLICIT_LEDGER_SET_ID
GL_LEDGER_NORM_SEG_VALS	GL_LEDGERS	GL_LEDGER_NORM_SEG_VALS.LEDGER_ID
GL_LEDGER_RELATIONSHIPS	GL_LEDGERS	GL_LEDGER_RELATIONSHIPS.SOURCE_LEDGER_ID
GL_LEDGER_RELATIONSHIPS	GL_LEDGERS	GL_LEDGER_RELATIONSHIPS.TARGET_LEDGER_ID
GL_LEDGER_RELATIONSHIPS	GL_LEDGERS	GL_LEDGER_RELATIONSHIPS.PRIMARY_LEDGER_ID
GL_LEDGER_RELATIONSHIPS	GL_LEDGERS	GL_LEDGER_RELATIONSHIPS.SLA_LEDGER_ID
GL_LEDGER_SEGMENT_VALUES	GL_LEDGERS	GL_LEDGER_SEGMENT_VALUES.LEDGER_ID
GL_LEDGER_SET_ASSIGNMENTS	GL_LEDGERS	GL_LEDGER_SET_ASSIGNMENTS.LEDGER_SET_ID
GL_LEDGER_SET_ASSIGNMENTS	GL_LEDGERS	GL_LEDGER_SET_ASSIGNMENTS.LEDGER_ID
GL_LEDGER_SET_NORM_ASSIGN	GL_LEDGERS	GL_LEDGER_SET_NORM_ASSIGN.LEDGER_SET_ID
GL_LEDGER_SET_NORM_ASSIGN	GL_LEDGERS	GL_LEDGER_SET_NORM_ASSIGN.LEDGER_ID
GL_LEDGER_SET_REQUESTS	GL_LEDGERS	GL_LEDGER_SET_REQUESTS.LEDGER_ID
GL_LEDGER_SET_REQUESTS	GL_LEDGERS	GL_LEDGER_SET_REQUESTS.LEDGER_SET_ID
GL_NET_INCOME_ACCOUNTS	GL_LEDGERS	GL_NET_INCOME_ACCOUNTS.LEDGER_ID
GL_SHARES_ACTIVITY	GL_LEDGERS	GL_SHARES_ACTIVITY.LEDGER_ID
GL_SHARES_OUTSTANDING	GL_LEDGERS	GL_SHARES_OUTSTANDING.LEDGER_ID
GL_SUSPENSE_ACCOUNTS	GL_LEDGERS	GL_SUSPENSE_ACCOUNTS.LEDGER_ID
GL_XFR_LEDGER_MAPPINGS	GL_LEDGERS	GL_XFR_LEDGER_MAPPINGS.FROM_LEDGER_ID
JAI_AP_MATCH_INV_TAXES	GL_LEDGERS	JAI_AP_MATCH_INV_TAXES.SET_OF_BOOKS_ID
JAI_AR_SUP_CHANGES_ALL	GL_LEDGERS	JAI_AR_SUP_CHANGES_ALL.SET_OF_BOOKS_ID
JAI_AR_SUP_HDRS_ALL	GL_LEDGERS	JAI_AR_SUP_HDRS_ALL.SET_OF_BOOKS_ID
JAI_AR_SUP_INV_T	GL_LEDGERS	JAI_AR_SUP_INV_T.SET_OF_BOOKS_ID
JAI_AR_TRXS	GL_LEDGERS	JAI_AR_TRXS.SET_OF_BOOKS_ID
JAI_AR_TRX_INS_LINES_T	GL_LEDGERS	JAI_AR_TRX_INS_LINES_T.SET_OF_BOOKS_ID
JAI_AR_TRX_SUP_INV_T	GL_LEDGERS	JAI_AR_TRX_SUP_INV_T.SET_OF_BOOKS_ID
JAI_CMN_JOURNAL_ENTRIES	GL_LEDGERS	JAI_CMN_JOURNAL_ENTRIES.SET_OF_BOOKS_ID
JAI_OM_OE_GEN_TAXINV_T	GL_LEDGERS	JAI_OM_OE_GEN_TAXINV_T.SET_OF_BOOKS_ID
JAI_RCV_SUBLED_ENTRIES	GL_LEDGERS	JAI_RCV_SUBLED_ENTRIES.SET_OF_BOOKS_ID
JG_ZZ_VAT_REP_ENTITIES	GL_LEDGERS	JG_ZZ_VAT_REP_ENTITIES.LEDGER_ID
JG_ZZ_VAT_TRX_UPG_STG	GL_LEDGERS	JG_ZZ_VAT_TRX_UPG_STG.LEDGER_ID
RG_REPORT_AXIS_CONTENTS	GL_LEDGERS	RG_REPORT_AXIS_CONTENTS.LEDGER_ID
RG_REPORT_REQUESTS	GL_LEDGERS	RG_REPORT_REQUESTS.LEDGER_ID
RG_REPORT_CONTENT_OVERRIDES	GL_LEDGERS	RG_REPORT_CONTENT_OVERRIDES.LEDGER_ID
XLA_ACCOUNTING_ERRORS	GL_LEDGERS	XLA_ACCOUNTING_ERRORS.LEDGER_ID
XLA_CONTROL_BALANCES	GL_LEDGERS	XLA_CONTROL_BALANCES.LEDGER_ID
ZX_ACCT_TX_CLS_DEFS_ALL	GL_LEDGERS	ZX_ACCT_TX_CLS_DEFS_ALL.LEDGER_ID
ZX_LINES_SUMMARY	GL_LEDGERS	ZX_LINES_SUMMARY.LEDGER_ID