GL_BALANCES
GL_BALANCES contains 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 '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.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LEDGER_ID | NUMBER | 18 | Yes | Ledger identifier of Oracle Fusion General Ledger balance. | |
| CODE_COMBINATION_ID | NUMBER | 18 | Yes | Key flexfield combination identifier. | |
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | Currency code of Oracle Fusion General Ledger balance. | |
| PERIOD_NAME | VARCHAR2 | 15 | Yes | Accounting period name code of Oracle Fusion General Ledger balance. | |
| ACTUAL_FLAG | VARCHAR2 | 1 | Yes | Balance type (Actual, Budget, or Encumbrance). | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| BUDGET_VERSION_ID | NUMBER | 18 | Not currently used. | ||
| ENCUMBRANCE_TYPE_ID | NUMBER | 18 | Encumbrance type defining column. | ||
| TRANSLATED_FLAG | VARCHAR2 | 1 | Translation status of the balance. | ||
| REVALUATION_STATUS | VARCHAR2 | 1 | Not currently used. | ||
| PERIOD_TYPE | VARCHAR2 | 15 | Accounting period type code of Oracle Fusion General Ledger balance. | ||
| PERIOD_YEAR | NUMBER | 18 | Accounting period year code of Oracle Fusion General Ledger balance. | ||
| PERIOD_NUM | NUMBER | 18 | Accounting period number code of Oracle Fusion General Ledger balance. | ||
| PERIOD_NET_DR | NUMBER | Accounting period net debit balance. | |||
| PERIOD_NET_CR | NUMBER | Accounting period net credit balance. | |||
| PERIOD_TO_DATE_ADB | NUMBER | Not currently used. | |||
| QUARTER_TO_DATE_DR | NUMBER | Quarter to date period debit balance. | |||
| QUARTER_TO_DATE_CR | NUMBER | Quarter to date period 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 period debit balance. | |||
| BEGIN_BALANCE_CR | NUMBER | Beginning period credit balance. | |||
| PERIOD_NET_DR_BEQ | NUMBER | Period net debit balance in base currency. | |||
| PERIOD_NET_CR_BEQ | NUMBER | Period net credit balance in base currency. | |||
| QUARTER_TO_DATE_DR_BEQ | NUMBER | Quarter to date debit balance in base currency. | |||
| QUARTER_TO_DATE_CR_BEQ | NUMBER | Quarter to date credit balance in base currency. | |||
| PROJECT_TO_DATE_DR_BEQ | NUMBER | Accumulated project debit balance (life to date balance) in base currency. | |||
| PROJECT_TO_DATE_CR_BEQ | NUMBER | Accumulated project credit balance (life to date balance) in base currency. | |||
| BEGIN_BALANCE_DR_BEQ | NUMBER | Beginning debit balancein base currency. | |||
| BEGIN_BALANCE_CR_BEQ | NUMBER | Beginning credit balance in base currency. | |||
| TEMPLATE_ID | NUMBER | 18 | Summary template identifier. | ||
| ENCUMBRANCE_DOC_ID | NUMBER | 18 | Not currently used. | ||
| ENCUMBRANCE_LINE_NUM | NUMBER | 18 | Not currently used. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| PARTITION_GROUP_CODE | VARCHAR2 | 15 | Partition grouping information which when combined with the period, determines the database partition in which this balance will be stored. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| GL_BALANCES | gl_code_combinations | CODE_COMBINATION_ID |
| GL_BALANCES | gl_period_types | PERIOD_TYPE |
| GL_BALANCES | gl_ledgers | LEDGER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_BALANCES_N1 | Non Unique | Default | CODE_COMBINATION_ID, PERIOD_NAME |
| GL_BALANCES_N2 | Non Unique | Default | PERIOD_NAME |
| GL_BALANCES_N3 | Non Unique | Default | PERIOD_NUM, PERIOD_YEAR |
| GL_BALANCES_U1 | Unique | Default | CODE_COMBINATION_ID, PERIOD_NAME, LEDGER_ID, CURRENCY_CODE, ACTUAL_FLAG, ENCUMBRANCE_TYPE_ID, TRANSLATED_FLAG |