DW_EB_X_EBS_GL_W_GL_BALANCE_A
Stores GL account balances aggregated by GL account segment codes and segment attributes
Details
Module: General Ledger (EBS_GL)
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| ACCT_CURR_CODE | VARCHAR2 | 120 CHAR | Account Currency Code | |||
| BALANCE_DT_WID | NUMBER | 38 | Balance Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| BALANCE_TM_WID | NUMBER | 38 | Balance Time Key | W_TIME_OF_DAY_D | ||
| BALANCE_TYPE_WID | NUMBER | 38 | Key to the Balance Type domain - Actual, Budget, and Encumbrance Types | |||
| BALANCING_SEGMENT_WID | NUMBER | 38 | Key to the balancing segment dimension | DW_EB_X_EBS_COMMON_W_BALANCING_SEGMENT_D | ||
| BUDGETARY_CONTROL_FLG | VARCHAR2 | 1 CHAR | This flag indicates the record is for Public Sector. | |||
| BUDGET_LEDGER_WID | NUMBER | 38 | ||||
| BUDGET_MCAL_CAL_WID | NUMBER | 38 | ||||
| BUDGET_PERIOD_WID | NUMBER | 38 | Key to the Budget Period (Multi- Calendar Period) dimension | DW_EB_X_EBS_COMMON_W_MCAL_PERIOD_D | ||
| BUDGET_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_BUDGET_D | |||
| BUSN_AREA_ORG_WID | NUMBER | 38 | Key to the Business Area Organization in Business Organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| COMPANY_ORG_WID | NUMBER | 38 | Key to the Company organization in Business Organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| COST_CENTER_WID | NUMBER | 38 | Key to the Cost Center dimension | DW_EB_X_EBS_COMMON_W_COST_CENTER_D | ||
| DATASOURCE_NUM_ID | NUMBER | 10 | This column is the unique identifier of the source system from which data was extracted. In order to be able to trace the data back to its source, Oracle recommends that you define separate unique source IDs for each of your different source instances. | |||
| DB_CR_IND | VARCHAR2 | 120 CHAR | Debit/Credit Indicator | |||
| FINANCIAL_GL_FLG | VARCHAR2 | 1 CHAR | This flag indicates the record is for GL. | |||
| GL_DATASET_SEC_WID | NUMBER | 38 | Key to the GL Data Set Security dimension | DW_EB_X_EBS_COMMON_W_GL_DATASET_SEC_D | ||
| GROUP_ACCT_WID | NUMBER | 38 | Key to the Group Account dimension. | DW_EB_X_EBS_COMMON_W_GL_GROUP_ACCOUNT_D | ||
| LEDGER_WID | NUMBER | 38 | Key to the Ledger dimension | DW_EB_X_EBS_COMMON_W_LEDGER_D | ||
| LOC_CURR_CODE | VARCHAR2 | 120 CHAR | Local Currency Code | |||
| MCAL_CAL_WID | NUMBER | 38 | Key to the Multi-Calendar dimension. | |||
| NATURAL_ACCOUNT_WID | NUMBER | 38 | Key to the Natural Account dimension | DW_EB_X_EBS_COMMON_W_NATURAL_ACCOUNT_D | ||
| SEG_PROGRAM_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | |||
| SEG_PROJECT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | |||
| TENANT_ID | VARCHAR2 | 320 CHAR | This column is the unique identifier for a Tenant in a multi-tenant environment. This would typically be used in an Application Service Provider (ASP) / Software As a Service (SOAS) model | |||
| TRANSLATED_FLAG | VARCHAR2 | 1 CHAR | This column is used to identify the balance type for the balance record: 'A' for actuals, 'B' for budgets, and 'E' for encumbrances. | |||
| TREASURY_SYMBOL_WID | NUMBER | 38 | Key to the Treasury Symbol dimension | |||
| ACTIVITY_ACCT_AMT | NUMBER | 38,10 | Activity amount in account currency | |||
| ACTIVITY_GLOBAL1_AMT | NUMBER | 38,10 | Activity amount in group currency1 | |||
| ACTIVITY_GLOBAL2_AMT | NUMBER | 38,10 | Activity amount in group currency2 | |||
| ACTIVITY_GLOBAL3_AMT | NUMBER | 38,10 | Activity amount in group currency3 | |||
| ACTIVITY_LOC_AMT | NUMBER | 38,10 | Activity amount in local currency | |||
| BALANCE_ACCT_AMT | NUMBER | 38,10 | Balance amount in account currency | |||
| BALANCE_GLOBAL1_AMT | NUMBER | 38,10 | Balance amount in group currency1 | |||
| BALANCE_GLOBAL2_AMT | NUMBER | 38,10 | Balance amount in group currency2 | |||
| BALANCE_GLOBAL3_AMT | NUMBER | 38,10 | Balance amount in group currency3 | |||
| BALANCE_LOC_AMT | NUMBER | 38,10 | Balance amount in local currency | |||
| CARRY_FORWARD_ACCT_AMT | NUMBER | 38,10 | Carry forward amount in accounted currencies | |||
| CARRY_FORWARD_GLOBAL1_AMT | NUMBER | 38,10 | Carry forward amount in group currency1 | |||
| CARRY_FORWARD_GLOBAL2_AMT | NUMBER | 38,10 | Carry forward amount in group currency2 | |||
| CARRY_FORWARD_GLOBAL3_AMT | NUMBER | 38,10 | Carry forward amount in group currency3 | |||
| CARRY_FORWARD_LOC_AMT | NUMBER | 38,10 | Carry forward amount in local currency | |||
| PROFIT_CENTER_WID | NUMBER | 38 | Key to the Profit Center dimension | DW_EB_X_EBS_COMMON_W_PROFIT_CENTER_D | ||
| ROW_WID | NUMBER | 38 | ||||
| SEGMENT1_WID | NUMBER | 38 | Key to the GL segment dimension | |||
| SEGMENT2_WID | NUMBER | 38 | Key to the GL segment dimension | |||
| SEGMENT3_WID | NUMBER | 38 | Key to the GL segment dimension | |||
| SEGMENT4_WID | NUMBER | 38 | Key to the GL segment dimension | |||
| SEGMENT5_WID | NUMBER | 38 | Key to the GL segment dimension | |||
| SEGMENT6_WID | NUMBER | 38 | Key to the GL segment dimension | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |