DW_EB_X_EBS_SLA_W_SLA_BALANCE_F
DW_EB_X_EBS_SLA_W_SLA_BALANCE_F fact table stores information about subledger accounting balances. The grain of this table is at supporting reference balance level. It holdst the debit and crediti amount The dimensionalities captured in the fact includes Ledger, GL Account, and Journal Source.
Details
Module: Subledger Accounting (EBS_SLA)
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| INTEGRATION_ID | VARCHAR2 | 300 CHAR | True | INTEGRATION_ID | ||
| ACCOUNTING_SOURCE | VARCHAR2 | 50 CHAR | ACCOUNTING_SOURCE | |||
| ACCT_PERIOD_END_DT_KEY | NUMBER | 10 | ||||
| ACCT_PERIOD_END_DT_WID | NUMBER | 38 | ACCT_PERIOD_END_DT_WID | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | ||
| ACTIVITY_CR_DOC_AMT | NUMBER | 38,10 | ||||
| ACTIVITY_CR_LOC_AMT | NUMBER | 38,10 | ACTIVITY_CR_LOC_AMT | |||
| ACTIVITY_DR_DOC_AMT | NUMBER | 38,10 | ||||
| ACTIVITY_DR_LOC_AMT | NUMBER | 38,10 | ACTIVITY_DR_LOC_AMT | |||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | AUX1_CHANGED_ON_DT | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | AUX2_CHANGED_ON_DT | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | AUX3_CHANGED_ON_DT | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | AUX4_CHANGED_ON_DT | |||
| BALANCE_CR_DOC_AMT | NUMBER | 38,10 | ||||
| BALANCE_CR_LOC_AMT | NUMBER | 38,10 | BALANCE_CR_LOC_AMT | |||
| BALANCE_DR_DOC_AMT | NUMBER | 38,10 | ||||
| BALANCE_DR_LOC_AMT | NUMBER | 38,10 | BALANCE_DR_LOC_AMT | |||
| BALANCING_SEGMENT_WID | NUMBER | 38 | BALANCING_SEGMENT_WID | DW_EB_X_EBS_COMMON_W_BALANCING_SEGMENT_D | ||
| CHANGED_BY_WID | NUMBER | 38 | CHANGED_BY_WID | |||
| CHANGED_ON_DT | TIMESTAMP | 6 | CHANGED_ON_DT | |||
| COMPANY_ORG_WID | NUMBER | 38 | COMPANY_ORG_WID | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| COST_CENTER_WID | NUMBER | 38 | COST_CENTER_WID | DW_EB_X_EBS_COMMON_W_COST_CENTER_D | ||
| CREATED_BY_WID | NUMBER | 38 | CREATED_BY_WID | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CREATED_ON_DT | TIMESTAMP | 6 | CREATED_ON_DT | |||
| DATASOURCE_NUM_ID | NUMBER | 10 | DATASOURCE_NUM_ID | |||
| DELETE_FLG | VARCHAR2 | 4 CHAR | DELETE_FLG | |||
| DOC_CURR_CODE | VARCHAR2 | 15 CHAR | ||||
| ETL_PROC_WID | NUMBER | 38 | ETL_PROC_WID | |||
| GLOBAL1_EXCHANGE_RATE | NUMBER | GLOBAL1_EXCHANGE_RATE | ||||
| GLOBAL2_EXCHANGE_RATE | NUMBER | GLOBAL2_EXCHANGE_RATE | ||||
| GLOBAL3_EXCHANGE_RATE | NUMBER | GLOBAL3_EXCHANGE_RATE | ||||
| GL_ACCOUNT_WID | NUMBER | 38 | GL_ACCOUNT_WID | DW_EB_X_EBS_COMMON_W_GL_ACCOUNT_D | ||
| GL_DATASET_SEC_WID | NUMBER | 38 | GL_DATASET_SEC_WID | DW_EB_X_EBS_COMMON_W_GL_DATASET_SEC_D | ||
| GL_SEGMENT10_WID | NUMBER | 38 | GL_SEGMENT10_WID | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | ||
| GL_SEGMENT1_WID | NUMBER | 38 | GL_SEGMENT1_WID | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | ||
| GL_SEGMENT2_WID | NUMBER | 38 | GL_SEGMENT2_WID | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | ||
| GL_SEGMENT3_WID | NUMBER | 38 | GL_SEGMENT3_WID | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | ||
| GL_SEGMENT4_WID | NUMBER | 38 | GL_SEGMENT4_WID | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | ||
| GL_SEGMENT5_WID | NUMBER | 38 | GL_SEGMENT5_WID | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | ||
| GL_SEGMENT6_WID | NUMBER | 38 | GL_SEGMENT6_WID | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | ||
| GL_SEGMENT7_WID | NUMBER | 38 | GL_SEGMENT7_WID | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | ||
| GL_SEGMENT8_WID | NUMBER | 38 | GL_SEGMENT8_WID | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | ||
| GL_SEGMENT9_WID | NUMBER | 38 | GL_SEGMENT9_WID | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | ||
| JOURNAL_SOURCE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_XACT_SOURCE_D | |||
| LEDGER_WID | NUMBER | 38 | LEDGER_WID | DW_EB_X_EBS_COMMON_W_LEDGER_D | ||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | LOC_CURR_CODE | |||
| MCAL_CAL_WID | NUMBER | 38 | MCAL_CAL_WID | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | ||
| NATURAL_ACCOUNT_WID | NUMBER | 38 | NATURAL_ACCOUNT_WID | DW_EB_X_EBS_COMMON_W_NATURAL_ACCOUNT_D | ||
| SUPPORT_REF10_WID | NUMBER | 38 | SUPPORT_REF10_WID | DW_EB_X_EBS_SLA_W_SLA_SUPPORT_REF_D | ||
| SUPPORT_REF1_WID | NUMBER | 38 | SUPPORT_REF1_WID | DW_EB_X_EBS_SLA_W_SLA_SUPPORT_REF_D | ||
| SUPPORT_REF2_WID | NUMBER | 38 | SUPPORT_REF2_WID | DW_EB_X_EBS_SLA_W_SLA_SUPPORT_REF_D | ||
| SUPPORT_REF3_WID | NUMBER | 38 | SUPPORT_REF3_WID | DW_EB_X_EBS_SLA_W_SLA_SUPPORT_REF_D | ||
| SUPPORT_REF4_WID | NUMBER | 38 | SUPPORT_REF4_WID | |||
| SUPPORT_REF5_WID | NUMBER | 38 | SUPPORT_REF5_WID | DW_EB_X_EBS_SLA_W_SLA_SUPPORT_REF_D | ||
| SUPPORT_REF6_WID | NUMBER | 38 | SUPPORT_REF6_WID | DW_EB_X_EBS_SLA_W_SLA_SUPPORT_REF_D | ||
| SUPPORT_REF7_WID | NUMBER | 38 | SUPPORT_REF7_WID | DW_EB_X_EBS_SLA_W_SLA_SUPPORT_REF_D | ||
| SUPPORT_REF8_WID | NUMBER | 38 | SUPPORT_REF8_WID | |||
| SUPPORT_REF9_WID | NUMBER | 38 | SUPPORT_REF9_WID | DW_EB_X_EBS_SLA_W_SLA_SUPPORT_REF_D | ||
| TENANT_ID | VARCHAR2 | 80 CHAR | TENANT_ID | |||
| X_CUSTOM | VARCHAR2 | 40 CHAR | X_CUSTOM | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |