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.

DBA Data [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

Name	Datatype	Length	Mandatory	Comments
LEDGER_ID	NUMBER	(15)	Yes	Ledger defining column
NAME	VARCHAR2	(30)	Yes	Ledger name
SHORT_NAME	VARCHAR2	(20)	Yes	Ledger short name
DESCRIPTION	VARCHAR2	(240)		Description
LEDGER_CATEGORY_CODE	VARCHAR2	(30)	Yes	Ledger category (PRIMARY, SECONDARY, ALC etc)
ALC_LEDGER_TYPE_CODE	VARCHAR2	(30)	Yes	Reporting currency type (NONE, TARGET, SOURCE)
OBJECT_TYPE_CODE	VARCHAR2	(1)	Yes	Ledger type (ledger or ledger set)
LE_LEDGER_TYPE_CODE	VARCHAR2	(1)	Yes	Ledger legal type (Legal, management)
COMPLETION_STATUS_CODE	VARCHAR2	(30)		Ledger setup status (Not Started, Incomplete, Complete)
CONFIGURATION_ID	NUMBER	(15)		Link to an accounting setup definition
CHART_OF_ACCOUNTS_ID	NUMBER	(15)	Yes	Key flexfield structure defining column
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency
PERIOD_SET_NAME	VARCHAR2	(15)	Yes	Accounting calendar name
ACCOUNTED_PERIOD_TYPE	VARCHAR2	(15)	Yes	Accounting period type
FIRST_LEDGER_PERIOD_NAME	VARCHAR2	(15)	Yes	First ledger accounting period name
RET_EARN_CODE_COMBINATION_ID	NUMBER	(15)	Yes	Retained earnings key flexfield defining column
SUSPENSE_ALLOWED_FLAG	VARCHAR2	(1)	Yes	Suspense posting allowed flag
ALLOW_INTERCOMPANY_POST_FLAG	VARCHAR2	(1)	Yes	Allow intercompany posting flag
TRACK_ROUNDING_IMBALANCE_FLAG	VARCHAR2	(1)	Yes	Track rounding imbalances flag
ENABLE_AVERAGE_BALANCES_FLAG	VARCHAR2	(1)	Yes	Enable average balances flag
CUM_TRANS_CODE_COMBINATION_ID	NUMBER	(15)		Cumulative translation adjustment key flexfield defining column
RES_ENCUMB_CODE_COMBINATION_ID	NUMBER	(15)		Reserve for encumbrance key flexfield defining column
NET_INCOME_CODE_COMBINATION_ID	NUMBER	(15)		Net income key flexfield defining column
ROUNDING_CODE_COMBINATION_ID	NUMBER	(15)		Track rounding imbalances key flexfield defining column
ENABLE_BUDGETARY_CONTROL_FLAG	VARCHAR2	(1)	Yes	Enable budgetary control flag
REQUIRE_BUDGET_JOURNALS_FLAG	VARCHAR2	(1)	Yes	Journal required for budget flag
ENABLE_JE_APPROVAL_FLAG	VARCHAR2	(1)	Yes	Enable journal entry approval flag
ENABLE_AUTOMATIC_TAX_FLAG	VARCHAR2	(1)	Yes	Enable automatic tax flag
CONSOLIDATION_LEDGER_FLAG	VARCHAR2	(1)	Yes	ADB Consolidation ledger flag
TRANSLATE_EOD_FLAG	VARCHAR2	(1)	Yes	ADB Translate EOD balances flag
TRANSLATE_QATD_FLAG	VARCHAR2	(1)	Yes	ADB Translate QATD balances flag
TRANSLATE_YATD_FLAG	VARCHAR2	(1)	Yes	ADB Translate YATD balances flag
TRANSACTION_CALENDAR_ID	NUMBER	(15)		ADB Transaction calendar defining column
DAILY_TRANSLATION_RATE_TYPE	VARCHAR2	(30)		ADB: The rate type to be used for translation of average balances
AUTOMATICALLY_CREATED_FLAG	VARCHAR2	(1)	Yes	Automatically created flag used for ledger sets
BAL_SEG_VALUE_OPTION_CODE	VARCHAR2	(1)	Yes	Balancing segment value option
BAL_SEG_COLUMN_NAME	VARCHAR2	(25)	Yes	Balancing segment column name
MGT_SEG_VALUE_OPTION_CODE	VARCHAR2	(1)	Yes	Management segment value option
MGT_SEG_COLUMN_NAME	VARCHAR2	(25)		Management segment column name
BAL_SEG_VALUE_SET_ID	NUMBER	(10)	Yes	Balancing segment value set ID
MGT_SEG_VALUE_SET_ID	NUMBER	(10)		Management segment value set ID
IMPLICIT_ACCESS_SET_ID	NUMBER	(15)		Implicit access set ID
CRITERIA_SET_ID	NUMBER	(15)		Journal reversal criteria set defining column
FUTURE_ENTERABLE_PERIODS_LIMIT	NUMBER	(15)	Yes	Number of future enterable periods
LEDGER_ATTRIBUTES	VARCHAR2	(2000)	Yes	The compiled values of any segment qualifier assigned to the segment value
IMPLICIT_LEDGER_SET_ID	NUMBER	(15)		Implicit ledger set ID
LATEST_OPENED_PERIOD_NAME	VARCHAR2	(15)		Latest opened accounting period name
LATEST_ENCUMBRANCE_YEAR	NUMBER	(15)		Latest open year for encumbrances
PERIOD_AVERAGE_RATE_TYPE	VARCHAR2	(30)		Default balances level period average rate type used for actual translation
PERIOD_END_RATE_TYPE	VARCHAR2	(30)		Default balances level period end rate type used for actual translation
BUDGET_PERIOD_AVG_RATE_TYPE	VARCHAR2	(30)		Default balances level period average rate type used for budget translation
BUDGET_PERIOD_END_RATE_TYPE	VARCHAR2	(30)		Default balances level period end rate type used for budget translation
SLA_ACCOUNTING_METHOD_CODE	VARCHAR2	(30)		Subledger accounting method code
SLA_ACCOUNTING_METHOD_TYPE	VARCHAR2	(1)		Subledger accounting method type
SLA_DESCRIPTION_LANGUAGE	VARCHAR2	(15)		Subledger accounting description language
SLA_ENTERED_CUR_BAL_SUS_CCID	NUMBER	(15)		Suspense account used for balancing subledger journal entries by entered currency
SLA_SEQUENCING_FLAG	VARCHAR2	(1)		Required for SLA (Yes/No)
SLA_BAL_BY_LEDGER_CURR_FLAG	VARCHAR2	(1)		Subledger balance by ledger currency flag
SLA_LEDGER_CUR_BAL_SUS_CCID	NUMBER	(15)		Suspense account used for balancing subledger journal entries by ledger currency
ENABLE_SECONDARY_TRACK_FLAG	VARCHAR2	(1)		Enable secondary tracking for closing and translation flag
ENABLE_REVAL_SS_TRACK_FLAG	VARCHAR2	(1)		Enable secondary tracking for revaluation flag
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
CONTEXT	VARCHAR2	(150)		Descriptive flexfield context column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ENABLE_RECONCILIATION_FLAG	VARCHAR2	(1)	Yes	Enable journal reconciliation flag
CREATE_JE_FLAG	VARCHAR2	(1)	Yes	Create journal flag
SLA_LEDGER_CASH_BASIS_FLAG	VARCHAR2	(1)		Subledger cash basis accounting flag
COMPLETE_FLAG	VARCHAR2	(1)		Ledger complete flag
COMMITMENT_BUDGET_FLAG	VARCHAR2	(1)		Commitment Budget Flag

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
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_LEDGERS; PJI_TIME_PA_RPT_STR_MV