DW_EB_X_EBS_AP_W_AP_AGING_INVOICE_ENT_A
This table stores the accounts payable aging information at the invoice 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 |
|---|---|---|---|---|---|---|
| POSTED_ON_DT_WID | NUMBER | 38 | Posting Date key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| REF_DOC_NUM | VARCHAR2 | 80 CHAR | Reference Document Number | |||
| SNAPSHOT_DT_WID | NUMBER | 38 | Surrogate key for the AP fact record | 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 Suppliers dimension | DW_EB_X_EBS_COMMON_W_PARTY_D | ||
| TRANSACTION_DT_WID | NUMBER | 38 | Transaction Date key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| ACCOUNTING_DT_WID | NUMBER | 38 | ||||
| ACCT_DOC_ITEM | NUMBER | 15 | Line item number within the accounting document | |||
| ACCT_DOC_NUM | VARCHAR2 | 80 CHAR | Accounting document number | |||
| ACCT_DOC_SUB_ITEM | NUMBER | 15 | Sub item within a line item of the accounting document | |||
| ACTIVE_HOLD_STATUS_FLAG | VARCHAR2 | 1 CHAR | ||||
| ACTUAL_DT_WID | NUMBER | 38 | ||||
| ALLOCATION_NUM | VARCHAR2 | 80 CHAR | Application Number | |||
| APPR_STATUS_WID | NUMBER | 38 | ||||
| AP_DOC_AMT | NUMBER | 38,10 | Amount in document Currency | |||
| AP_GLOBAL1_AMT | NUMBER | 38,10 | Amount in group currency1 | |||
| AP_GLOBAL2_AMT | NUMBER | 38,10 | Amount in group currency2 | |||
| AP_GLOBAL3_AMT | NUMBER | 38,10 | Amount in group currency3 | |||
| AP_LOC_AMT | NUMBER | 38,10 | Amount in local currency | |||
| BALANCING_SEGMENT_WID | NUMBER | 38 | Key to the Profit Centers dimension | DW_EB_X_EBS_COMMON_W_BALANCING_SEGMENT_D | ||
| BASELINE_DT_WID | NUMBER | 38 | Baseline Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| 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 | ||
| CHANGED_BY_WID | NUMBER | 38 | This is a key to the IA_USERS dimension indicating the user who last updated the record in the source system. | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CHANGED_ON_DT | TIMESTAMP | 6 | This is the date, in Julian format, on which the record was last updated in the source system. This column also functions as a key to IA_DATES. | |||
| 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 | ||
| COST_CENTER_WID | NUMBER | 38 | Key to the Cost Centers dimension | DW_EB_X_EBS_COMMON_W_COST_CENTER_D | ||
| CREATED_BY_WID | NUMBER | 38 | This is a key to the IA_USERS dimension indicating the user who created the record in the source system. | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CREATED_ON_DT | TIMESTAMP | 6 | This is the date, in Julian format, on which the record was created in the source system. This column also functions as a key to IA_DATES. | |||
| CTRL_AREA_ORG_WID | NUMBER | 38 | Key to the Controlling area organization in Business Area Organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_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. | |||
| DB_CR_IND | VARCHAR2 | 30 CHAR | Debit/credit indicator | |||
| DOC_CURR_CODE | VARCHAR2 | 30 CHAR | Document Currency Code | |||
| DOC_HEADER_TEXT | VARCHAR2 | 255 CHAR | Document header text | |||
| DOC_TYPE_WID | NUMBER | 38 | Key to Xact Types dimension for the accounting document | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| ELAPSED_DAYS_DUE | NUMBER | 10 | ||||
| ELAPSED_DAYS_OPEN | NUMBER | 10 | ||||
| ETL_PROC_WID | NUMBER | 38 | This column is the unique identifier for the specific ETL process used to create or update this data. | |||
| EXPENDITURE_ORG_WID | NUMBER | 38 | Expenditure Organization | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| INVENTORY_PROD_WID | NUMBER | 38 | Key to the Manufacturing Products dimension | DW_EB_X_EBS_COMMON_W_INVENTORY_PRODUCT_D | ||
| INVOICED_ON_DT_WID | NUMBER | 38 | Invoice Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| INVOICE_RECEIPT_DT_WID | NUMBER | 38 | Invoice Receipt Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| ISSUE_ORG_WID | NUMBER | 38 | Key to the Issue organization in Business Organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| LEDGER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_LEDGER_D | |||
| LINE_ITEM_TEXT | VARCHAR2 | 255 CHAR | Line Item text | |||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | Local Currency Code | |||
| OPERATING_UNIT_ORG_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| OVERDUE_FLG | VARCHAR2 | 1 CHAR | Flag indicating the transaction is overdue | |||
| PAYABLES_ORG_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| PAYMENT_DUE_DT_WID | NUMBER | 38 | Payment Due Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| PAYMENT_METHOD_WID | NUMBER | 38 | Key to the Payment methods in the Methods Dimension | DW_EB_X_EBS_COMMON_W_PAYMENT_METHOD_D | ||
| PAY_TERMS_WID | NUMBER | 38 | Key to the Payment terms in the Terms Dimension | DW_EB_X_EBS_COMMON_W_AP_TERMS_D | ||
| PLANT_LOC_WID | NUMBER | 38 | Key to the Inventory plant in Business Locations dimension | DW_EB_X_EBS_COMMON_W_BUSN_LOCATION_D | ||
| POSTING_TYPE_WID | NUMBER | 38 | Key to Xact Types dimension for the type of posting of accounting document | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| PRODUCT_WID | NUMBER | 38 | Key to the Products dimension | DW_EB_X_EBS_COMMON_W_PRODUCT_D | ||
| PROFIT_CENTER_WID | NUMBER | 38 | Key to the Profit Centers dimension | |||
| PROJECT_WID | NUMBER | 38 | Project | DW_EB_X_EBS_COMMON_W_PROJECT_D | ||
| PURCH_INVOICE_ITEM | NUMBER | 15 | Purchase Invoice Item | |||
| PURCH_INVOICE_NUM | VARCHAR2 | 80 CHAR | Purchase Invoice number | |||
| PURCH_ORDER_DT_WID | NUMBER | 38 | Purchase Order Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| PURCH_ORDER_ITEM | NUMBER | 15 | Purchase Order Item | |||
| PURCH_ORDER_NUM | VARCHAR2 | 80 CHAR | Purchase Order Number | |||
| PURCH_ORG_WID | NUMBER | 38 | Key to the Purchase organization in Business Organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PURCH_REP_WID | NUMBER | 38 | Key to the Purchase representative in Business Contacts dimension | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | ||
| REF_DOC_ITEM | NUMBER | 15 | Reference Document Text | |||
| REF_DOC_TYPE_WID | NUMBER | 38 | Key to Xact Types dimension for reference document | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| REMAINING_DOC_AMT | NUMBER | 38,10 | Remaining Invoice Amount in Document currency | |||
| REMAINING_GLOBAL1_AMT | NUMBER | 38,10 | Remaining Invoice Amount in Group currency1 | |||
| REMAINING_GLOBAL2_AMT | NUMBER | 38,10 | Remaining Invoice Amount in Group currency2 | |||
| REMAINING_GLOBAL3_AMT | NUMBER | 38,10 | Remaining Invoice Amount in Group currency3 | |||
| REMAINING_LOC_AMT | NUMBER | 38,10 | Remaining Invoice Amount in Local currency | |||
| SOURCE_WID | NUMBER | 38 | ||||
| SPLR_ORDER_DT_WID | NUMBER | 38 | Suppliers Order Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| SUPPLIER_PROD_WID | NUMBER | 38 | Key to the Supplier Products dimension | DW_EB_X_EBS_COMMON_W_SUPPLIER_PRODUCT_D | ||
| 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. | |||
| THIRD_PARTY_WID | NUMBER | 38 | ||||
| VALD_STATUS_WID | NUMBER | 38 | ||||
| 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 |