[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GL_BALANCES_DELTA |
|---|---|
| Object Type: | TABLE |
| Owner: | GL |
| FND Design Data: |  SQLGL.GL_BALANCES_DELTA
|
| Subobject Name: | |
| Status: | VALID |
GL_BALANCES_DELTA is used to keep track of incremental balances. The DR and CR columns in this table contain the incremental amounts, which are added to the balances in GL_BALANCES. The Posting program and the Translation program, each insert one row for each account to be updated. There may be multiple rows for an account in this table. Programs like the Analyzer - Extract Full Balances summarize and extract the incremental balances for upload to applications like Oracle Financial Analyzer.
The delta_run_id column is different for each group of records inserted into this table. Each posting request has a different delta_run_id. Each translation request inserts records with a different delta_run_id for each period that it processes. The primary key on this table consists of the following columns: delta_run_id, ledger_id, code_combination_id, currency_code, period_name, actual_flag, budget_version_id, encumbrance_type_id and translated_flag
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| GL_BALANCES_DELTA_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
 DELTA_RUN_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| DELTA_RUN_ID | NUMBER | (15) | Yes | Posting run defining column |
| 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 |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_LOGIN | 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 | |
| TEMPLATE_ID | NUMBER | (15) | Summary template defining column | |
| 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 | ||
| QUARTER_TO_DATE_DR | NUMBER | Quarter to date debit balance | ||
| QUARTER_TO_DATE_CR | NUMBER | Quarter to date credit balance | ||
| PROJECT_TO_DATE_DR | NUMBER | Accumulated project debit balance(life to date balance) | ||
| PROJECT_TO_DATE_CR | NUMBER | Accumulated project credit balance | ||
| BEGIN_BALANCE_DR | NUMBER | Beginning debit balance | ||
| BEGIN_BALANCE_CR | NUMBER | Beginning credit balance | ||
| PERIOD_NET_DR_BEQ | NUMBER | Period to date debit balance, base currency | ||
| PERIOD_NET_CR_BEQ | NUMBER | Period to date credit balance, base currency | ||
| BEGIN_BALANCE_DR_BEQ | NUMBER | Year to date debit balance, base currency | ||
| BEGIN_BALANCE_CR_BEQ | NUMBER | Year to date credit balance, base currency |
Cut, paste (and edit) the following text to query this object:
SELECT DELTA_RUN_ID
, LEDGER_ID
, CODE_COMBINATION_ID
, CURRENCY_CODE
, PERIOD_NAME
, ACTUAL_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, BUDGET_VERSION_ID
, ENCUMBRANCE_TYPE_ID
, TRANSLATED_FLAG
, TEMPLATE_ID
, PERIOD_YEAR
, PERIOD_NUM
, PERIOD_NET_DR
, PERIOD_NET_CR
, QUARTER_TO_DATE_DR
, QUARTER_TO_DATE_CR
, PROJECT_TO_DATE_DR
, PROJECT_TO_DATE_CR
, BEGIN_BALANCE_DR
, BEGIN_BALANCE_CR
, PERIOD_NET_DR_BEQ
, PERIOD_NET_CR_BEQ
, BEGIN_BALANCE_DR_BEQ
, BEGIN_BALANCE_CR_BEQ
FROM GL.GL_BALANCES_DELTA;
GL.GL_BALANCES_DELTA does not reference any database object
GL.GL_BALANCES_DELTA is referenced by following:
APPS
GL_BALANCES_DELTA
|
|
|
|