DW_EB_X_EBS_AR_W_AR_AGING_INVOICE_A
This table stores accounts receivable invoice level aggregate aging information
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 |
|---|---|---|---|---|---|---|
| CUSTOMER_ACCNT_WID | NUMBER | 38 | Customer Account | DW_EB_X_EBS_COMMON_W_CUSTOMER_ACCOUNT_D | ||
| 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 | Key to the Time dimension. It indicates the dates when the Aging Information is recorded | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| TRANSACTION_DT_WID | NUMBER | 38 | Transaction Date key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| ACCOUNTING_DT_WID | NUMBER | 38 | ||||
| ACCT_DOC_NUM | VARCHAR2 | 80 CHAR | Accounting document number | |||
| ACTUAL_DT_WID | NUMBER | 38 | ||||
| AGREEMENT_WID | NUMBER | 38 | Agreement | DW_EB_X_EBS_AR_W_CONTRACT_HDR_D | ||
| 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 | Base line 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 | ||
| CUSTOMER_BILL_TO_LOC_WID | NUMBER | 38 | Key to the Bill to location in Customer Locations dimension | DW_EB_X_EBS_COMMON_W_CUSTOMER_LOC_D | ||
| CUSTOMER_CONTACT_WID | NUMBER | 38 | Key to the Customer Contacts dimension | DW_EB_X_EBS_COMMON_W_PARTY_PER_D | ||
| CUSTOMER_PAYER_LOC_WID | NUMBER | 38 | Key to the Payer location in Customer Locations dimension | DW_EB_X_EBS_COMMON_W_CUSTOMER_LOC_D | ||
| CUSTOMER_SHIP_TO_LOC_WID | NUMBER | 38 | Key to the Ship to location in Customer Locations dimension | DW_EB_X_EBS_COMMON_W_CUSTOMER_LOC_D | ||
| CUSTOMER_SOLD_TO_LOC_WID | NUMBER | 38 | Key to the Sold to location in Customer Locations dimension | DW_EB_X_EBS_COMMON_W_CUSTOMER_LOC_D | ||
| CUSTOMER_WID | NUMBER | 38 | Key to the Customers dimension | DW_EB_X_EBS_COMMON_W_PARTY_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. | |||
| DOC_CURR_CODE | VARCHAR2 | 30 CHAR | Local Currency Code | |||
| ELAPSED_DAYS_DUE | NUMBER | 28,10 | ||||
| ELAPSED_DAYS_OPEN | NUMBER | 28,10 | ||||
| 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 | |||
| 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 | ||
| LEDGER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_LEDGER_D | |||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | Local Currency Code | |||
| MCAL_CAL_WID | NUMBER | 38 | Fiscal Calendar | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | ||
| OPERATING_UNIT_ORG_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| ORIGINAL_DOC_AMT | NUMBER | 38,10 | Original Invoice Amount in Document currency | |||
| ORIGINAL_GLOBAL1_AMT | NUMBER | 38,10 | Original Invoice Amount in Group currency1 | |||
| ORIGINAL_GLOBAL2_AMT | NUMBER | 38,10 | Original Invoice Amount in Group currency2 | |||
| ORIGINAL_GLOBAL3_AMT | NUMBER | 38,10 | Original Invoice Amount in Group currency3 | |||
| ORIGINAL_LOC_AMT | NUMBER | 38,10 | Original Invoice Amount in Local currency | |||
| OVERDUE_FLG | VARCHAR2 | 1 CHAR | Clearing Document Number | |||
| 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_PAYMENT_TERMS_D | ||
| PRODUCT_WID | NUMBER | 38 | Key to the Products dimension | DW_EB_X_EBS_COMMON_W_PRODUCT_D | ||
| PROFIT_CENTER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PROFIT_CENTER_D | |||
| PROJECT_ORG_WID | NUMBER | 38 | Project Organization | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PROJECT_WID | NUMBER | 38 | Project | DW_EB_X_EBS_COMMON_W_PROJECT_D | ||
| RECEIVABLES_ORG_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_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 | |||
| 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_INVOICE_NUM | VARCHAR2 | 80 CHAR | Clearing Document Number | |||
| 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_PRODUCT_WID | NUMBER | 38 | Key to the Sales Products dimension | DW_EB_X_EBS_COMMON_W_SUPPLIER_PRODUCT_D | ||
| SALES_REP_WID | NUMBER | 38 | Key to the Sales representative in Business Contacts dimension | DW_EB_X_EBS_COMMON_W_EMPLOYEE_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. | |||
| UOM_CODE | VARCHAR2 | 50 CHAR | Unit of Measure | |||
| XACT_QTY | NUMBER | 28,10 | Transaction Quantity | |||
| 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 |