[Home] [Help] [Dependency Information]

TABLE: GL.GL_LEDGERS

Object Details

Object Name:	GL_LEDGERS
Object Type:	TABLE
Owner:	GL
FND Design Data:	SQLGL.GL_LEDGERS
Subobject Name:
Status:	VALID

GL_LEDGERS stores information about the ledgers defined in the Accounting Setup Manager and the ledger sets defined in the Ledger Set form. Each row includes the ledger or ledger set name, short name, description, ledger currency, calendar, period type, chart of accounts, and other information. Some columns in this table are not applicable for ledger sets. In this case, default values would be inserted into these columns for ledger sets.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_LEDGERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	NAME
GL_LEDGERS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	LEDGER_ID
GL_LEDGERS_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	SHORT_NAME
GL_LEDGERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHART_OF_ACCOUNTS_ID PERIOD_SET_NAME ACCOUNTED_PERIOD_TYPE
GL_LEDGERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BAL_SEG_VALUE_SET_ID
GL_LEDGERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MGT_SEG_VALUE_SET_ID

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT LEDGER_ID
,      NAME
,      SHORT_NAME
,      DESCRIPTION
,      LEDGER_CATEGORY_CODE
,      ALC_LEDGER_TYPE_CODE
,      OBJECT_TYPE_CODE
,      LE_LEDGER_TYPE_CODE
,      COMPLETION_STATUS_CODE
,      CONFIGURATION_ID
,      CHART_OF_ACCOUNTS_ID
,      CURRENCY_CODE
,      PERIOD_SET_NAME
,      ACCOUNTED_PERIOD_TYPE
,      FIRST_LEDGER_PERIOD_NAME
,      RET_EARN_CODE_COMBINATION_ID
,      SUSPENSE_ALLOWED_FLAG
,      ALLOW_INTERCOMPANY_POST_FLAG
,      TRACK_ROUNDING_IMBALANCE_FLAG
,      ENABLE_AVERAGE_BALANCES_FLAG
,      CUM_TRANS_CODE_COMBINATION_ID
,      RES_ENCUMB_CODE_COMBINATION_ID
,      NET_INCOME_CODE_COMBINATION_ID
,      ROUNDING_CODE_COMBINATION_ID
,      ENABLE_BUDGETARY_CONTROL_FLAG
,      REQUIRE_BUDGET_JOURNALS_FLAG
,      ENABLE_JE_APPROVAL_FLAG
,      ENABLE_AUTOMATIC_TAX_FLAG
,      CONSOLIDATION_LEDGER_FLAG
,      TRANSLATE_EOD_FLAG
,      TRANSLATE_QATD_FLAG
,      TRANSLATE_YATD_FLAG
,      TRANSACTION_CALENDAR_ID
,      DAILY_TRANSLATION_RATE_TYPE
,      AUTOMATICALLY_CREATED_FLAG
,      BAL_SEG_VALUE_OPTION_CODE
,      BAL_SEG_COLUMN_NAME
,      MGT_SEG_VALUE_OPTION_CODE
,      MGT_SEG_COLUMN_NAME
,      BAL_SEG_VALUE_SET_ID
,      MGT_SEG_VALUE_SET_ID
,      IMPLICIT_ACCESS_SET_ID
,      CRITERIA_SET_ID
,      FUTURE_ENTERABLE_PERIODS_LIMIT
,      LEDGER_ATTRIBUTES
,      IMPLICIT_LEDGER_SET_ID
,      LATEST_OPENED_PERIOD_NAME
,      LATEST_ENCUMBRANCE_YEAR
,      PERIOD_AVERAGE_RATE_TYPE
,      PERIOD_END_RATE_TYPE
,      BUDGET_PERIOD_AVG_RATE_TYPE
,      BUDGET_PERIOD_END_RATE_TYPE
,      SLA_ACCOUNTING_METHOD_CODE
,      SLA_ACCOUNTING_METHOD_TYPE
,      SLA_DESCRIPTION_LANGUAGE
,      SLA_ENTERED_CUR_BAL_SUS_CCID
,      SLA_SEQUENCING_FLAG
,      SLA_BAL_BY_LEDGER_CURR_FLAG
,      SLA_LEDGER_CUR_BAL_SUS_CCID
,      ENABLE_SECONDARY_TRACK_FLAG
,      ENABLE_REVAL_SS_TRACK_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ENABLE_RECONCILIATION_FLAG
,      CREATE_JE_FLAG
,      SLA_LEDGER_CASH_BASIS_FLAG
,      COMPLETE_FLAG
,      COMMITMENT_BUDGET_FLAG
,      NET_CLOSING_BAL_FLAG
,      AUTOMATE_SEC_JRNL_REV_FLAG
FROM GL.GL_LEDGERS;

Dependencies

[top of page]

GL.GL_LEDGERS does not reference any database object

GL.GL_LEDGERS is referenced by following:

APPS

GL_ACCESS_SET_LEDGERS

GL

GL_LEDGERS#