[Home] [Help]
[Dependency Information]
Object Name: | GL_BALANCES |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
GL_BALANCES stores actual, budget, and encumbrance balances for detail and summary accounts. This table stores ledger currency, foreign currency, and statistical balances for each accounting period that has ever been opened. ACTUAL_FLAG is either 'A', 'B', or 'E' for actual, budget, or encumbrance balances, respectively. If ACTUAL_FLAG is 'B', then BUDGET_VERSION_ID is required. If ACTUAL_FLAG is 'E', then ENCUMBRANCE_TYPE_ID is required. GL_BALANCES stores period activity for an account in the PERIOD_NET_DR and PERIOD_NET_CR columns. The table stores the period beginning balances in BEGIN_BALANCE_DR and BEGIN_BALANCE_CR. An account's year-to-date balance is calculated as BEGIN_BALANCE_DR - BEGIN_BALANCE_CR + PERIOD_NET_DR - PERIOD_NET_CR. Detail and summary foreign currency balances that are the result of posted foreign currency journal entries have TRANSLATED_FLAG set to 'R', to indicate that the row is a candidate for revaluation.
For foreign currency rows, the begin balance and period net columns contain the foreign currency balance, while the begin balance and period net BEQ columns contain the converted ledger currency balance. Detail foreign currency balances that are the result of foreign currency translation have TRANSLATED_FLAG set to 'Y' or 'N'. 'N' indicates that the translation is out of date (i.e., the account needs to be re-translated). 'Y' indicates that the translation is current. Summary foreign currency balances that are the result of foreign currency translation have TRANSLATED_FLAG set to NULL. All summary account balances have TEMPLATE_ID not NULL. The columns that end in ADB are not used. Also, the REVALUATION_STATUS column is not used.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_BALANCES_N1 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() |
GL_BALANCES_N2 | NORMAL | NONUNIQUE |
![]() |
![]() |
GL_BALANCES_N3 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() |
GL_BALANCES_N4 | NORMAL | NONUNIQUE |
![]() |
![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEDGER_ID | NUMBER | (15) | Yes | Ledger defining column |
CODE_COMBINATION_ID | NUMBER | (15) | Yes | Key flexfield combination defining column |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency |
PERIOD_NAME | VARCHAR2 | (15) | Yes | Accounting period |
ACTUAL_FLAG | VARCHAR2 | (1) | Yes | Balance type (Actual, Budget, or Encumbrance) |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
BUDGET_VERSION_ID | NUMBER | (15) | Budget version defining column | |
ENCUMBRANCE_TYPE_ID | NUMBER | (15) | Encumbrance type defining column | |
TRANSLATED_FLAG | VARCHAR2 | (1) | Translated balance flag | |
REVALUATION_STATUS | VARCHAR2 | (1) | Not currently used | |
PERIOD_TYPE | VARCHAR2 | (15) | Accounting period type | |
PERIOD_YEAR | NUMBER | (15) | Accounting period year | |
PERIOD_NUM | NUMBER | (15) | Accounting period number | |
PERIOD_NET_DR | NUMBER | Period net debit balance | ||
PERIOD_NET_CR | NUMBER | Period net credit balance | ||
PERIOD_TO_DATE_ADB | NUMBER | Not currently used | ||
QUARTER_TO_DATE_DR | NUMBER | Quarter to date debit balance | ||
QUARTER_TO_DATE_CR | NUMBER | Quarter to date credit balance | ||
QUARTER_TO_DATE_ADB | NUMBER | Not currently used | ||
YEAR_TO_DATE_ADB | NUMBER | Not currently used | ||
PROJECT_TO_DATE_DR | NUMBER | Accumulated project debit balance (life to date balance) | ||
PROJECT_TO_DATE_CR | NUMBER | Accumulated project credit balance | ||
PROJECT_TO_DATE_ADB | NUMBER | Not currently used | ||
BEGIN_BALANCE_DR | NUMBER | Beginning debit balance | ||
BEGIN_BALANCE_CR | NUMBER | Beginning credit balance | ||
PERIOD_NET_DR_BEQ | NUMBER | Period net debit balance, base currency | ||
PERIOD_NET_CR_BEQ | NUMBER | Period net credit balance, base currency | ||
BEGIN_BALANCE_DR_BEQ | NUMBER | Beginning debit balance, base currency | ||
BEGIN_BALANCE_CR_BEQ | NUMBER | Beginning credit balance, base currency | ||
TEMPLATE_ID | NUMBER | (15) | Summary template defining column | |
ENCUMBRANCE_DOC_ID | NUMBER | (15) | Purchasing encumbrance column | |
ENCUMBRANCE_LINE_NUM | NUMBER | (15) | Purchasing encumbrance column | |
QUARTER_TO_DATE_DR_BEQ | NUMBER | Quarter to date debit balance, base currency | ||
QUARTER_TO_DATE_CR_BEQ | NUMBER | Quarter to date credit balance, base currency | ||
PROJECT_TO_DATE_DR_BEQ | NUMBER | Accumulated project debit balance (life to date balance), base currency | ||
PROJECT_TO_DATE_CR_BEQ | NUMBER | Accumulated project credit balance (life to date balance), base currency |
Cut, paste (and edit) the following text to query this object:
SELECT LEDGER_ID
, CODE_COMBINATION_ID
, CURRENCY_CODE
, PERIOD_NAME
, ACTUAL_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, BUDGET_VERSION_ID
, ENCUMBRANCE_TYPE_ID
, TRANSLATED_FLAG
, REVALUATION_STATUS
, PERIOD_TYPE
, PERIOD_YEAR
, PERIOD_NUM
, PERIOD_NET_DR
, PERIOD_NET_CR
, PERIOD_TO_DATE_ADB
, QUARTER_TO_DATE_DR
, QUARTER_TO_DATE_CR
, QUARTER_TO_DATE_ADB
, YEAR_TO_DATE_ADB
, PROJECT_TO_DATE_DR
, PROJECT_TO_DATE_CR
, PROJECT_TO_DATE_ADB
, BEGIN_BALANCE_DR
, BEGIN_BALANCE_CR
, PERIOD_NET_DR_BEQ
, PERIOD_NET_CR_BEQ
, BEGIN_BALANCE_DR_BEQ
, BEGIN_BALANCE_CR_BEQ
, TEMPLATE_ID
, ENCUMBRANCE_DOC_ID
, ENCUMBRANCE_LINE_NUM
, QUARTER_TO_DATE_DR_BEQ
, QUARTER_TO_DATE_CR_BEQ
, PROJECT_TO_DATE_DR_BEQ
, PROJECT_TO_DATE_CR_BEQ
FROM GL.GL_BALANCES;
GL.GL_BALANCES does not reference any database object
GL.GL_BALANCES is referenced by following:
|
|
|