DW_EB_X_EBS_AP_W_AP_AGING_SUPPLIER_A
This table stores the accounts payable aging information at the supplier and association dimension levels. Each record in this table indicates the aging information at a particular date in time. The SNAPSHOT_DT_WID column indicates the date when the aging information is recorded.
Details
Module: Payables (EBS_AP)
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 | ||
| EXPENDITURE_ORG_WID | NUMBER | 38 | Expenditure Organization | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| LEDGER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_LEDGER_D | |||
| MCAL_CAL_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | |||
| OPERATING_UNIT_ORG_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| PAYABLES_ORG_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_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 | ||
| SPLR_ACCT_WID | NUMBER | 38 | Key to the Supplier Accounts dimension | DW_EB_X_EBS_COMMON_W_SUPPLIER_ACCOUNT_D | ||
| SUPPLIER_WID | NUMBER | 38 | Key to the Supplier dimension | DW_EB_X_EBS_COMMON_W_PARTY_D | ||
| THIRD_PARTY_WID | NUMBER | 38 | ||||
| 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 | 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 |