DW_EB_X_EBS_SLA_W_SLA_XACT_F
DW_EB_X_EBS_SLA_W_SLA_XACT_F fact table stores information about subledger accounting entries. The grain of this table is at distribution link level. It holds the details about the document and local amount The dimensionalities captured in the fact includes Customer, Supplier, and Business Unit (Operating Units)
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 |
|---|---|---|---|---|---|---|
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | AUX1_CHANGED_ON_DT | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | AUX2_CHANGED_ON_DT | |||
| INTEGRATION_ID | VARCHAR2 | 300 CHAR | INTEGRATION_ID | |||
| ACCOUNTING_CLASS_CODE | VARCHAR2 | 30 CHAR | ACCOUNTING_CLASS_CODE | |||
| ACCOUNTING_DT_WID | NUMBER | 38 | ACCOUNTING_DT_WID | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| 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 | ||
| APPLIED_TO_TXN_NUMBER | VARCHAR2 | 280 CHAR | APPLIED_TO_TXN_NUMBER | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | AUX3_CHANGED_ON_DT | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | AUX4_CHANGED_ON_DT | |||
| BALANCE_TYPE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | |||
| BALANCING_SEGMENT_WID | NUMBER | 38 | BALANCING_SEGMENT_WID | DW_EB_X_EBS_COMMON_W_BALANCING_SEGMENT_D | ||
| BUDGET_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_BUDGET_D | |||
| CHANGED_BY_WID | NUMBER | 38 | CHANGED_BY_WID | DW_EB_X_EBS_COMMON_W_USER_D | ||
| 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 | |||
| CUSTOMER_ACCT_WID | NUMBER | 38 | CUSTOMER_ACCT_WID | DW_EB_X_EBS_COMMON_W_CUSTOMER_ACCOUNT_D | ||
| CUSTOMER_WID | NUMBER | 38 | CUSTOMER_WID | DW_EB_X_EBS_COMMON_W_PARTY_D | ||
| DATASOURCE_NUM_ID | NUMBER | 10 | DATASOURCE_NUM_ID | |||
| DB_CR_IND | VARCHAR2 | 30 CHAR | DB_CR_IND | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | DELETE_FLG | |||
| DOC_CURR_CODE | VARCHAR2 | 30 CHAR | DOC_CURR_CODE | |||
| ETL_PROC_WID | NUMBER | 38 | ETL_PROC_WID | |||
| EVENT_CLASS_CODE | VARCHAR2 | 30 CHAR | EVENT_CLASS_CODE | |||
| EVENT_TYPE_CODE | VARCHAR2 | 30 CHAR | EVENT_TYPE_CODE | |||
| 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 | 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 | ||
| GL_STATUS_WID | NUMBER | 38 | GL_STATUS_WID | DW_EB_X_EBS_COMMON_W_STATUS_D | ||
| GL_TRANSFER_DT_WID | NUMBER | 38 | GL_TRANSFER_DT_WID | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| JOURNAL_CATEGORY | VARCHAR2 | 30 CHAR | JOURNAL_CATEGORY | |||
| JOURNAL_HEADER_DESCR | VARCHAR2 | 2000 CHAR | ||||
| JOURNAL_LINE_DESCR | VARCHAR2 | 2000 CHAR | ||||
| JOURNAL_LINE_NUM | NUMBER | 38 | JOURNAL_LINE_NUM | |||
| 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 | |||
| LOC_EXCHANGE_RATE | NUMBER | LOC_EXCHANGE_RATE | ||||
| 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 | ||
| OVERRIDDEN_AE_LINE_NUM | NUMBER | |||||
| OVERRIDDEN_BALANCING_SEG_WID | NUMBER | 38 | ||||
| OVERRIDDEN_COST_CENTER_WID | NUMBER | 38 | ||||
| OVERRIDDEN_GL_ACCOUNT_WID | NUMBER | 38 | ||||
| OVERRIDDEN_NATURAL_ACCNT_WID | NUMBER | 38 | ||||
| OVERRIDE_REASON | VARCHAR2 | 240 CHAR | ||||
| PAYABLES_ORG_WID | NUMBER | 38 | PAYABLES_ORG_WID | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| RECEIVABLES_ORG_WID | NUMBER | 38 | RECEIVABLES_ORG_WID | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| SLA_DOC_AMT | NUMBER | 38,10 | SLA_DOC_AMT | |||
| SLA_LOC_AMT | NUMBER | 38,10 | SLA_LOC_AMT | |||
| SOURCE_DISTRIBUTION_ID | VARCHAR2 | 80 CHAR | SOURCE_DISTRIBUTION_ID | |||
| SOURCE_TRANSACTION_NUM | VARCHAR2 | 280 CHAR | SOURCE_TRANSACTION_NUM | |||
| SUPPLIER_ACCT_WID | NUMBER | 38 | SUPPLIER_ACCT_WID | DW_EB_X_EBS_COMMON_W_SUPPLIER_ACCOUNT_D | ||
| SUPPLIER_WID | NUMBER | 38 | SUPPLIER_WID | DW_EB_X_EBS_COMMON_W_PARTY_D | ||
| SUPPORT_REF10_WID | NUMBER | 38 | GL_DATASET_SEC_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 | DW_EB_X_EBS_SLA_W_SLA_SUPPORT_REF_D | ||
| 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 | DW_EB_X_EBS_SLA_W_SLA_SUPPORT_REF_D | ||
| 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 | 10 CHAR | X_CUSTOM | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |