DBA Data[Home] [Help] [Dependency Information]


TABLE: GL.GL_BALANCES

Object Details
Object Name: GL_BALANCES
Object Type: TABLE
Owner: GL
FND Design Data: TableSQLGL.GL_BALANCES
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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_BALANCES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCODE_COMBINATION_ID
ColumnPERIOD_NAME
GL_BALANCES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERIOD_NAME
GL_BALANCES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERIOD_NUM
ColumnPERIOD_YEAR
GL_BALANCES_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTEMPLATE_ID
Columns
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
Query Text

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;

Dependencies

[top of page]

GL.GL_BALANCES does not reference any database object

GL.GL_BALANCES is referenced by following:

SchemaAPPS
SynonymGL_BALANCES