DW_EB_X_EBS_GL_W_GL_BALANCE_F
This table stores the current balance for general ledger accounts. Only Posted records are considered for calculating the balances and Balance amts can be use for Financial reporting.
Details
Module: General Ledger (EBS_GL)
Business Name: General Ledger Account Balance
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| 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, Siebel recommends that you define separate unique source IDs for each of your different source instances. | |||
| INTEGRATION_ID | VARCHAR2 | 320 CHAR | This column is the unique identifier of a dimension or fact entity in its source system. In case of composite keys, the value in this column can consist of concatenated parts. | |||
| ACCT_CURR_CODE | VARCHAR2 | 30 CHAR | Account Currency Code | |||
| 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 | |||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | Last update date in OLTP system for the 'set of books' record. | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | Last update date in OLTP system for the 'accounting period' record. | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | Currently not used. | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | Currently not used. | |||
| BALANCE_ACCT_AMT | NUMBER | 38,10 | Balance amount in account currency | |||
| BALANCE_DT_KEY | NUMBER | 38 | ||||
| BALANCE_DT_WID | NUMBER | 38 | Balance Date Key | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | ||
| 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_ID | VARCHAR2 | 240 CHAR | Balance identifier | |||
| BALANCE_LOC_AMT | NUMBER | 38,10 | Balance amount in local currency | |||
| BALANCE_TM_WID | NUMBER | 38 | Balance Time Key | W_TIME_OF_DAY_D | ||
| BALANCE_TYPE_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. | |||
| BALANCE_TYPE_WID | NUMBER | 38 | Key to the balance type domain | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| 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_ACCOUNT_WID | NUMBER | 38 | ||||
| BUDGET_LEDGER_WID | NUMBER | 38 | ||||
| BUDGET_MCAL_CAL_WID | NUMBER | 38 | ||||
| BUDGET_PERIOD_WID | NUMBER | 38 | Identifies budget periods. | DW_EB_X_EBS_COMMON_W_MCAL_PERIOD_D | ||
| BUDGET_SEGMENT10_WID | NUMBER | 38 | ||||
| BUDGET_SEGMENT1_WID | NUMBER | 38 | ||||
| BUDGET_SEGMENT2_WID | NUMBER | 38 | ||||
| BUDGET_SEGMENT3_WID | NUMBER | 38 | ||||
| BUDGET_SEGMENT4_WID | NUMBER | 38 | ||||
| BUDGET_SEGMENT5_WID | NUMBER | 38 | ||||
| BUDGET_SEGMENT6_WID | NUMBER | 38 | ||||
| BUDGET_SEGMENT7_WID | NUMBER | 38 | ||||
| BUDGET_SEGMENT8_WID | NUMBER | 38 | ||||
| BUDGET_SEGMENT9_WID | NUMBER | 38 | ||||
| BUDGET_WID | NUMBER | 38 | ||||
| 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 | ||
| CARRY_FORWARD_ACCT_AMT | NUMBER | Carry forward amount in account currency | ||||
| CARRY_FORWARD_GLOBAL1_AMT | NUMBER | Carry forward amount in group currency1 | ||||
| CARRY_FORWARD_GLOBAL2_AMT | NUMBER | |||||
| CARRY_FORWARD_GLOBAL3_AMT | NUMBER | |||||
| CARRY_FORWARD_LOC_AMT | NUMBER | Balance amount in local currency | ||||
| CHANGED_ON_DT | TIMESTAMP | 6 | Last update date in OLTP system for the balance record. | |||
| 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 | DW_EB_X_EBS_COMMON_W_COST_CENTER_D | |||
| CREATED_ON_DT | TIMESTAMP | 6 | Creation date in OLTP system for the balance record. | |||
| DB_CR_IND | VARCHAR2 | 30 CHAR | Debit/Credit Indicator | |||
| ETL_PROC_WID | NUMBER | 38 | Siebel System Field. This column is the unique identifier for the specific ETL process used to create or update this data | |||
| FINANCIAL_GL_FLG | VARCHAR2 | 1 CHAR | This flag indicates the record is for GL. | |||
| GL_ACCOUNT_WID | NUMBER | 38 | Key to the GL Accounts dimension | DW_EB_X_EBS_COMMON_W_GL_ACCOUNT_D | ||
| GL_DATASET_SEC_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_DATASET_SEC_D | |||
| GL_SEGMENT10_WID | NUMBER | 38 | Key to the GL Segment 10 in GL Segment dimension | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | ||
| GL_SEGMENT1_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | |||
| GL_SEGMENT2_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | |||
| GL_SEGMENT3_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | |||
| GL_SEGMENT4_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | |||
| GL_SEGMENT5_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | |||
| GL_SEGMENT6_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | |||
| GL_SEGMENT7_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | |||
| GL_SEGMENT8_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | |||
| GL_SEGMENT9_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | |||
| LEDGER_WID | NUMBER | 38 | Key to the Ledger dimension | DW_EB_X_EBS_COMMON_W_LEDGER_D | ||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | Local Currency Code | |||
| MCAL_CAL_WID | NUMBER | 38 | Key to the Multi-Calendars dimension | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | ||
| NATURAL_ACCOUNT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_NATURAL_ACCOUNT_D | |||
| PROFIT_CENTER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PROFIT_CENTER_D | |||
| SEG_PROGRAM_WID | NUMBER | 38 | ||||
| SEG_PROJECT_WID | NUMBER | 38 | ||||
| SUMMARY_ACCOUNT_FLAG | VARCHAR2 | 1 CHAR | This column indicates whether the account is the one against which the transaction has been entered, or a 'pseudo-account' that has been created by the OLTP system exclusively for reporting purposes. This is the pseudo account or summary account contains rollup amounts from all accounts that satisfy a certain criteria as defined in a template in the OLTP application. | |||
| TENANT_ID | VARCHAR2 | 80 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 indicates whether the balance amount is in the 'entered' currency or that which is translated into the 'foreign' currency by the OLTP application. | |||
| TREASURY_SYMBOL_WID | NUMBER | 38 | Key to the Treasury Symbol dimension | DW_EB_X_EBS_COMMON_W_TREASURY_SYMBOL_D | ||
| X_CUSTOM | VARCHAR2 | 10 CHAR | This column is used as a generic field for customer extensions. | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |