FND Design Data [Home] [Help]

Table: GL_LEDGERS

Product: GL - General Ledger
Description: Ledger definition
Implementation/DBA Data: TableGL.GL_LEDGERS
Primary Key: GL_LEDGERS_PK
  1. ColumnLEDGER_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
GL_LEDGERS FK Joins to TableGL_LEDGER_CONFIGURATIONS GL_LEDGERS.CONFIGURATION_ID
GL_LEDGERS FK Joins to TableGL_CODE_COMBINATIONS GL_LEDGERS.RES_ENCUMB_CODE_COMBINATION_ID
GL_LEDGERS FK Joins to TableGL_CODE_COMBINATIONS GL_LEDGERS.NET_INCOME_CODE_COMBINATION_ID
GL_LEDGERS FK Joins to TableGL_CODE_COMBINATIONS GL_LEDGERS.ROUNDING_CODE_COMBINATION_ID
GL_LEDGERS FK Joins to TableGL_TRANSACTION_CALENDAR GL_LEDGERS.TRANSACTION_CALENDAR_ID
GL_LEDGERS FK Joins to TableGL_DAILY_CONVERSION_TYPES GL_LEDGERS.DAILY_TRANSLATION_RATE_TYPE
GL_LEDGERS FK Joins to TableFND_FLEX_VALUE_SETS GL_LEDGERS.BAL_SEG_COLUMN_NAME
GL_LEDGERS FK Joins to TableFND_FLEX_VALUE_SETS GL_LEDGERS.MGT_SEG_COLUMN_NAME
GL_LEDGERS FK Joins to TableGL_ACCESS_SETS GL_LEDGERS.IMPLICIT_ACCESS_SET_ID
GL_LEDGERS FK Joins to TableGL_LEDGERS GL_LEDGERS.IMPLICIT_LEDGER_SET_ID
GL_LEDGERS FK Joins to TableGL_DAILY_CONVERSION_TYPES GL_LEDGERS.PERIOD_AVERAGE_RATE_TYPE
GL_LEDGERS FK Joins to TableGL_DAILY_CONVERSION_TYPES GL_LEDGERS.PERIOD_END_RATE_TYPE
GL_LEDGERS FK Joins to TableGL_AUTOREV_CRITERIA_SETS GL_LEDGERS.CRITERIA_SET_ID
GL_LEDGERS FK Joins to TableFND_CURRENCIES GL_LEDGERS.CURRENCY_CODE
GL_LEDGERS FK Joins to TableGL_CODE_COMBINATIONS GL_LEDGERS.RET_EARN_CODE_COMBINATION_ID
GL_LEDGERS FK Joins to TableGL_CODE_COMBINATIONS GL_LEDGERS.CUM_TRANS_CODE_COMBINATION_ID
TableGL_ACCOUNT_HIERARCHIES FK Joins to GL_LEDGERS GL_ACCOUNT_HIERARCHIES.LEDGER_ID
TableGL_INTERCOMPANY_ACCOUNTS FK Joins to GL_LEDGERS GL_INTERCOMPANY_ACCOUNTS.LEDGER_ID
TableGL_INTERCOMPANY_ACC_SETS FK Joins to GL_LEDGERS GL_INTERCOMPANY_ACC_SETS.LEDGER_ID
TableGL_INTERFACE_CONTROL FK Joins to GL_LEDGERS GL_INTERFACE_CONTROL.SET_OF_BOOKS_ID
TableGL_INTERFACE FK Joins to GL_LEDGERS GL_INTERFACE.LEDGER_ID
TableGL_JE_HEADERS FK Joins to GL_LEDGERS GL_JE_HEADERS.LEDGER_ID
TableGL_JE_LINES FK Joins to GL_LEDGERS GL_JE_LINES.LEDGER_ID
TableGL_JE_LINES_RECON FK Joins to GL_LEDGERS GL_JE_LINES_RECON.LEDGER_ID
TableGL_LEDGERS FK Joins to GL_LEDGERS GL_LEDGERS.IMPLICIT_LEDGER_SET_ID
TableGL_LEDGER_NORM_SEG_VALS FK Joins to GL_LEDGERS GL_LEDGER_NORM_SEG_VALS.LEDGER_ID
TableGL_LEDGER_RELATIONSHIPS FK Joins to GL_LEDGERS GL_LEDGER_RELATIONSHIPS.SOURCE_LEDGER_ID
TableGL_LEDGER_RELATIONSHIPS FK Joins to GL_LEDGERS GL_LEDGER_RELATIONSHIPS.TARGET_LEDGER_ID
TableGL_LEDGER_RELATIONSHIPS FK Joins to GL_LEDGERS GL_LEDGER_RELATIONSHIPS.PRIMARY_LEDGER_ID
TableGL_LEDGER_RELATIONSHIPS FK Joins to GL_LEDGERS GL_LEDGER_RELATIONSHIPS.SLA_LEDGER_ID
TableGL_LEDGER_SEGMENT_VALUES FK Joins to GL_LEDGERS GL_LEDGER_SEGMENT_VALUES.LEDGER_ID
TableGL_LEDGER_SET_ASSIGNMENTS FK Joins to GL_LEDGERS GL_LEDGER_SET_ASSIGNMENTS.LEDGER_SET_ID
TableGL_LEDGER_SET_ASSIGNMENTS FK Joins to GL_LEDGERS GL_LEDGER_SET_ASSIGNMENTS.LEDGER_ID
TableGL_LEDGER_SET_NORM_ASSIGN FK Joins to GL_LEDGERS GL_LEDGER_SET_NORM_ASSIGN.LEDGER_SET_ID
TableGL_LEDGER_SET_NORM_ASSIGN FK Joins to GL_LEDGERS GL_LEDGER_SET_NORM_ASSIGN.LEDGER_ID
TableGL_LEDGER_SET_REQUESTS FK Joins to GL_LEDGERS GL_LEDGER_SET_REQUESTS.LEDGER_ID
TableGL_LEDGER_SET_REQUESTS FK Joins to GL_LEDGERS GL_LEDGER_SET_REQUESTS.LEDGER_SET_ID
TableGL_NET_INCOME_ACCOUNTS FK Joins to GL_LEDGERS GL_NET_INCOME_ACCOUNTS.LEDGER_ID
TableGL_SUSPENSE_ACCOUNTS FK Joins to GL_LEDGERS GL_SUSPENSE_ACCOUNTS.LEDGER_ID
TableJAI_AP_MATCH_INV_TAXES FK Joins to GL_LEDGERS JAI_AP_MATCH_INV_TAXES.SET_OF_BOOKS_ID
TableJAI_AR_SUP_CHANGES_ALL FK Joins to GL_LEDGERS JAI_AR_SUP_CHANGES_ALL.SET_OF_BOOKS_ID
TableJAI_AR_SUP_HDRS_ALL FK Joins to GL_LEDGERS JAI_AR_SUP_HDRS_ALL.SET_OF_BOOKS_ID
TableJAI_AR_SUP_INV_T FK Joins to GL_LEDGERS JAI_AR_SUP_INV_T.SET_OF_BOOKS_ID
TableJAI_AR_TRXS FK Joins to GL_LEDGERS JAI_AR_TRXS.SET_OF_BOOKS_ID
TableJAI_AR_TRX_INS_LINES_T FK Joins to GL_LEDGERS JAI_AR_TRX_INS_LINES_T.SET_OF_BOOKS_ID
TableJAI_AR_TRX_SUP_INV_T FK Joins to GL_LEDGERS JAI_AR_TRX_SUP_INV_T.SET_OF_BOOKS_ID
TableJAI_CMN_JOURNAL_ENTRIES FK Joins to GL_LEDGERS JAI_CMN_JOURNAL_ENTRIES.SET_OF_BOOKS_ID
TableJAI_OM_OE_GEN_TAXINV_T FK Joins to GL_LEDGERS JAI_OM_OE_GEN_TAXINV_T.SET_OF_BOOKS_ID
TableJAI_RCV_SUBLED_ENTRIES FK Joins to GL_LEDGERS JAI_RCV_SUBLED_ENTRIES.SET_OF_BOOKS_ID
TableJG_ZZ_VAT_REP_ENTITIES FK Joins to GL_LEDGERS JG_ZZ_VAT_REP_ENTITIES.LEDGER_ID
TableJG_ZZ_VAT_TRX_UPG_STG FK Joins to GL_LEDGERS JG_ZZ_VAT_TRX_UPG_STG.LEDGER_ID
TableRG_REPORT_AXIS_CONTENTS FK Joins to GL_LEDGERS RG_REPORT_AXIS_CONTENTS.LEDGER_ID
TableRG_REPORT_REQUESTS FK Joins to GL_LEDGERS RG_REPORT_REQUESTS.LEDGER_ID
TableRG_REPORT_CONTENT_OVERRIDES FK Joins to GL_LEDGERS RG_REPORT_CONTENT_OVERRIDES.LEDGER_ID