GL Key Tables : GL_Balances, gl_code_combinations (1)
Jul 20, 2006 ERP Tables
GL_BALANCES stores actual, budget, and encumbrance balances for detail and summary accounts. This table stores functional 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 functional 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.Â
GL_CODE_COMBINATIONS stores valid account combinations for
each Accounting Flexfield structure within your Oracle General Ledger
application. Associated with each account are certain codes and flags,
including whether the account is enabled, whether detail posting or
detail budgeting is allowed, and others.
Segment values are stored in the SEGMENT columns. Note that each
Accounting Flexfield structure may use different SEGMENT columns
within the table to store the flexfield value combination. Moreover, the SEGMENT columns that are used are not guaranteed to be in any order.
The Oracle Application Object Library table FND_ID_FLEX_SEGMENTS stores information about which column in this table is used for each segment of each Accounting Flexfield
structure. Summary accounts have SUMMARY_FLAG = ’Y’ and TEMPLATE_ID not NULL. Detail accounts have SUMMARY_FLAG = ’N’ and TEMPLATE_ID NULL.
September 1st, 2006 at 1:57 pm
[...] Let us consider the below table as an example. Following table is a list of entries from gl_balances table for one particular code_combination_id named ‘1001′ and each entry corresponds to each month. The first column is the code_combination_id which is the reference to the actual Account Code combinations, the second column is the period_name, the remaining columns are described below. [...]
June 22nd, 2007 at 2:22 pm
Hi,
The GL_BALANCES gives balances for the period.But, I need the opening and closing balances for a particular date.
The GL_DAILY_BALANCES has columns for End_of_Day1…End_of_Day35. But, there is no data in any of the columns.
In which case, the End_of_Day columns are NULL?
How can we get the daily balances if these columns are empty?
Thanks!
Yogini