DW_EB_X_EBS_AR_W_AR_AGING_CUSTOMER_ENT_A
This table stores the accounts receivable aging information at aggregated dimension levels. Each record in this table indicates the aging information at a particular date in time. The SNAPSHOT_DT_WID domain indicates the date when the aging information is recorded.
Details
Module: Receivables (EBS_AR)
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| ACTUAL_DT_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 | ||
| COMPANY_LOC_WID | NUMBER | 38 | Key to the Company location in Business Locations dimension | DW_EB_X_EBS_COMMON_W_BUSN_LOCATION_D | ||
| COMPANY_ORG_WID | NUMBER | 38 | Key to the Company organization in Business Organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| CUSTOMER_ACCNT_WID | NUMBER | 38 | Customer Account | DW_EB_X_EBS_COMMON_W_CUSTOMER_ACCOUNT_D | ||
| CUSTOMER_WID | NUMBER | 38 | Key to the Supplier dimension | DW_EB_X_EBS_COMMON_W_PARTY_D | ||
| LEDGER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_LEDGER_D | |||
| OPERATING_UNIT_ORG_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| PROJECT_ORG_WID | NUMBER | 38 | Project Organization | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| RECEIVABLES_ORG_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| SALES_GROUP_ORG_WID | NUMBER | 38 | Key to the Sales Group organization in Business Organizations dimension. | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| SALES_OFC_LOC_WID | NUMBER | 38 | Key to the Sales Office location in Business Locations dimension. | DW_EB_X_EBS_COMMON_W_BUSN_LOCATION_D | ||
| SALES_ORG_WID | NUMBER | 38 | Key to the Sales organization in Business Area Organizations dimension. | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| SALES_REP_WID | NUMBER | 38 | Key to the Sales representative in Business Contacts dimension. | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | ||
| SNAPSHOT_DT_WID | NUMBER | 38 | Key to Time dimension. It indicates the date when the Aging Information was recorded | DW_EB_X_EBS_COMMON_W_DAY_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, Siebel recommends that you define separate unique source IDs for each of your different source instances. | |||
| DUE_XACT_CNT | NUMBER | 15 | Due Transaction count | |||
| 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 | |||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | Local Currency code. | |||
| ODUE_XACT_CNT | NUMBER | 15 | Overdue Transaction count | |||
| OUTSTAND_XACT_CNT | NUMBER | 15 | Outstanding transaction count | |||
| 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. | |||
| TOT_DAYS_DUE | NUMBER | 15 | Total days due | |||
| TOT_DAYS_ODUE | NUMBER | 15 | Total days overdue | |||
| TOT_DAYS_OUTSTAND | NUMBER | 15 | Total days outstanding | |||
| TOT_DUE_GLOBAL1_AMT | NUMBER | 38,10 | ||||
| TOT_DUE_GLOBAL2_AMT | NUMBER | 38,10 | ||||
| TOT_DUE_GLOBAL3_AMT | NUMBER | 38,10 | ||||
| TOT_DUE_LOC_AMT | NUMBER | 38,10 | ||||
| TOT_INVOICE_GLOBAL1_AMT | NUMBER | 38,10 | ||||
| TOT_INVOICE_GLOBAL2_AMT | NUMBER | 38,10 | ||||
| TOT_INVOICE_GLOBAL3_AMT | NUMBER | 38,10 | ||||
| TOT_INVOICE_LOC_AMT | NUMBER | 38,10 | ||||
| TOT_ODUE_GLOBAL1_AMT | NUMBER | 38,10 | ||||
| TOT_ODUE_GLOBAL2_AMT | NUMBER | 38,10 | ||||
| TOT_ODUE_GLOBAL3_AMT | NUMBER | 38,10 | ||||
| TOT_ODUE_LOC_AMT | NUMBER | 38,10 | ||||
| TOT_OPEN_GLOBAL1_AMT | NUMBER | 38,10 | ||||
| TOT_OPEN_GLOBAL2_AMT | NUMBER | 38,10 | ||||
| TOT_OPEN_GLOBAL3_AMT | NUMBER | 38,10 | ||||
| TOT_OPEN_LOC_AMT | NUMBER | 38,10 | ||||
| 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 |