DW_EB_X_EBS_AP_W_AP_XACT_F
This fact table stores various types of Payables transactions. The types of AP transactions stored in this table are: -Payment schedules for various types of invoices-Accounting entries for payments-Lliability accounting entries from various types of invoices-GL Reconciliation records.The first three types of records are extracted from the source applications (ie. Oracle 11i). The fourth type of record, GL Reconciliation records, are records inserted by the source adapters. These records are the results of the 'GL Reconciliation' process.The DOC_TYPE_WID field in this table is the foreign key to DW_EB_X_EBS_COMMON_W_XACT_TYPE_D table. It distinguishes the transaction type of the record.The DOC_STATUS_WID field is the foreign key to DW_EB_X_EBS_COMMON_W_STATUS_D table. It helps identify the status of the record, whether it is 'Open' or 'Cleared', 'Posted' or 'Unposted'.
Details
Module: Payables (EBS_AP)
Business Name: AP Transaction
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| 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. | DW_EB_X_EBS_COMMON_W_REVERSAL_INT_ID_TMP | ||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | This column is the unique identifier of a dimension or fact entity in its source system. In case of composite keys, the value in this column can consist of concatenated parts. | DW_EB_X_EBS_COMMON_W_REVERSAL_INT_ID_TMP | ||
| ACCOUNTING_DT_WID | NUMBER | 38 | ACCOUNTING_DT_WID | |||
| ACCT_DOC_ID | VARCHAR2 | 80 CHAR | ID used to reconciled against GL accounting entries | |||
| ACCT_DOC_ITEM | NUMBER | 15 | Line item number within the accounting document | |||
| ACCT_DOC_NUM | VARCHAR2 | 120 CHAR | Accounting document number | |||
| ACCT_DOC_SUB_ITEM | NUMBER | 15 | Sub item within a line item of the accounting document | |||
| ACCT_REP_WID | NUMBER | 38 | Key to the Account representative in Business Contacts dimension | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | ||
| ACTIVE_HOLD_STATUS_FLAG | VARCHAR2 | 1 CHAR | ||||
| ALLOCATION_NUM | VARCHAR2 | 120 CHAR | Allocation number | |||
| APPR_STATUS_WID | NUMBER | 38 | ||||
| AP_DOC_AMT | NUMBER | 38,10 | Amount in document currency | |||
| AP_GAIN_LOSS_LOC_AMT | NUMBER | 38,10 | ||||
| AP_INV_CURR_AMT | NUMBER | 38,10 | ||||
| AP_LOC_AMT | NUMBER | 38,10 | Amount in local currency | |||
| AP_REMAINING_DOC_AMT | NUMBER | 38,10 | Balancing amount remaining on invoices in invoice currency. | |||
| AP_REMAINING_LOC_AMT | NUMBER | 38,10 | Balancing amount remaining on invoices in local currency. | |||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| BALANCE_ID | VARCHAR2 | 320 CHAR | This is a combination of fields for which the balance is maintained. | |||
| BALANCING_SEGMENT_WID | NUMBER | 38 | Key to the Profit Centers dimension | DW_EB_X_EBS_COMMON_W_BALANCING_SEGMENT_D | ||
| BANK_WID | NUMBER | 38 | Key to the Banks Dimension | DW_EB_X_EBS_COMMON_W_BANK_D | ||
| BASELINE_DT_WID | NUMBER | 38 | Base line Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| BUDGET_ORG_WID | NUMBER | 38 | Key to the Business Organizations dimension for budgeting organization | DW_EB_X_EBS_COMMON_W_INT_ORG_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 foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who last modified the record in the source system. | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CHANGED_ON_DT | TIMESTAMP | 6 | Identifies the date and time when the record was last modified in the source system. | |||
| CLEARED_ON_DT_WID | NUMBER | 38 | Clearing Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| CLEARING_DOC_DT_WID | NUMBER | 38 | Clearing Document Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| CLEARING_DOC_ITEM | NUMBER | 15 | Clearing Document Item | |||
| CLEARING_DOC_NUM | VARCHAR2 | 120 CHAR | Clearing Document Number | |||
| CLRNG_DOC_TYPE_WID | NUMBER | 38 | Key to Transaction Types dimension for the clearing document type | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| CLRNG_POST_TYPE_WID | NUMBER | 38 | Key to Transaction Types dimension for type of posting of the clearing document | DW_EB_X_EBS_COMMON_W_XACT_TYPE_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 | ||
| CONVERSION_DT_WID | NUMBER | 38 | Conversion date key for currency exchange rate | DW_EB_X_EBS_COMMON_W_DAY_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 foreign key to the DW_EB_X_EBS_COMMON_W_USER_D 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 | Identifies the date and time when the record was initially created in the source system. | |||
| CTRL_AREA_ORG_WID | NUMBER | 38 | Key to the Controlling area organization in Business Organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| CUSTOMER_WID | NUMBER | 38 | Key to the Customers dimension | DW_EB_X_EBS_COMMON_W_PARTY_D | ||
| CUST_PUR_ORD_ITEM | NUMBER | 15 | Purchase Order Item of Customer | |||
| CUST_PUR_ORD_NUM | VARCHAR2 | 120 CHAR | Purchase Order Number of Customer | |||
| DB_CR_IND | VARCHAR2 | 30 CHAR | Debit/credit indicator | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | This flag indicates the deletion status of the record in the source system. A value of "Y" indicates that the record is deleted from the source system and logically deleted from the data warehouse; a value of "N" indicates that the record is active. | |||
| DISCOUNT_LOST_AMT | NUMBER | 38,10 | ||||
| DISCOUNT_LOST_LOC_AMT | NUMBER | 38,10 | ||||
| DISCOUNT_TAKEN_AMT | NUMBER | 38,10 | ||||
| DISCOUNT_TAKEN_INV_CURR_AMT | NUMBER | 38,10 | ||||
| DISCOUNT_TAKEN_LOC_AMT | NUMBER | 38,10 | ||||
| DOC_CURR_CODE | VARCHAR2 | 30 CHAR | This code corresponds to the document currency. This typically is the currency in which the transaction occurred. Amounts will be stored in this currency. | |||
| DOC_HEADER_TEXT | VARCHAR2 | 1020 CHAR | Document header text | |||
| DOC_STATUS_WID | NUMBER | 38 | Key to the Status dimension for the document status | DW_EB_X_EBS_COMMON_W_STATUS_D | ||
| DOC_TYPE_WID | NUMBER | 38 | Key to Transaction Types dimension for the accounting document | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| 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. | |||
| EXPENDITURE_ORG_WID | NUMBER | 38 | Key to the Expenditure Organization in Business Organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| FED_BALANCE_ID | VARCHAR2 | 320 CHAR | This is a combination of fields for which the balance is maintained in public sector financials | |||
| FINANCIAL_RESOURCE_WID | NUMBER | 38 | Key to the Financial Resources dimension | DW_EB_X_EBS_COMMON_W_FINANCIAL_RESOURCE_D | ||
| FIN_AREA_ORG_WID | NUMBER | 38 | Key to the Financial area organization in Business Organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| FIRST_DISCOUNT_AMT | NUMBER | 38,10 | ||||
| FIRST_DISCOUNT_DATE | TIMESTAMP | 6 | ||||
| FIRST_DISCOUNT_LOC_AMT | NUMBER | 38,10 | ||||
| GLOBAL1_EXCHANGE_RATE | NUMBER | This is the exchange rate from Document Currency to the first Global Currency. The Global currencies are defined in global currency master table. | ||||
| GLOBAL2_EXCHANGE_RATE | NUMBER | This is the exchange rate from Document Currency to the second Global Currency. The Global currencies are defined in global currency master table. | ||||
| GLOBAL3_EXCHANGE_RATE | NUMBER | This is the exchange rate from Document Currency to the third Global Currency. The Global currencies are defined in global currency master table. | ||||
| GL_ACCOUNT_WID | NUMBER | 38 | Key to the GL Accounts dimension | DW_EB_X_EBS_COMMON_W_GL_ACCOUNT_D | ||
| GL_BALANCE_ID | VARCHAR2 | 320 CHAR | This is a combination of fields for which the GL balance is maintained. | |||
| GL_DATASET_SEC_WID | NUMBER | 38 | ||||
| GL_RECONCILED_ON_DT | TIMESTAMP | 6 | The date this record is reconciled with GL in the warehouse | |||
| GL_RECONCILED_ON_PROC_WID | NUMBER | 38 | System field. This column is the unique identifier for the specific ETL process used to create or update this data. | |||
| GL_STATUS_WID | NUMBER | 38 | ||||
| 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_CURR_CODE | VARCHAR2 | 30 CHAR | ||||
| 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 | ||
| JOURNAL_SOURCE_WID | NUMBER | 38 | ||||
| LEDGER_WID | NUMBER | 38 | Key to the Ledger dimension | DW_EB_X_EBS_COMMON_W_LEDGER_D | ||
| LINE_ITEM_TEXT | VARCHAR2 | 1020 CHAR | Line item text | |||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | This code corresponds to the local currency. The local currency typically is the one in which the transaction will be posted to meet legal requirements for Company's Financial reporting. Alternatively, it may be linked to the currency used by local/regional business units for reporting purposes. | |||
| LOC_EXCHANGE_RATE | NUMBER | This is the exchange rate from Document Currency to the Local Currency. | ||||
| MCAL_CAL_WID | NUMBER | 38 | Key to the Multi-Calendars dimension | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | ||
| NATURAL_ACCOUNT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_NATURAL_ACCOUNT_D | |||
| OPERATING_UNIT_ORG_WID | NUMBER | 38 | Key to the Operating Unit in Business Organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| ORDERED_ON_DT_WID | NUMBER | 38 | Sales Order Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| PAYABLES_ORG_WID | NUMBER | 38 | Key to the Payable Organization in Business Organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PAYABLES_PMT_ORG_WID | NUMBER | 38 | ||||
| PAYMENT_DUE_DT_WID | NUMBER | 38 | Payment Due Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| PAY_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 | ||
| PLANNING_DT_WID | NUMBER | 38 | Planning Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| PLANT_LOC_WID | NUMBER | 38 | Key to the Inventory plant in Business Locations dimension | DW_EB_X_EBS_COMMON_W_BUSN_LOCATION_D | ||
| POSTED_ON_DT_WID | NUMBER | 38 | Posting Date key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| POSTED_ON_TM_WID | NUMBER | 38 | Posting Time key | |||
| POSTING_TYPE_WID | NUMBER | 38 | Key to Transaction 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 | Key to the Projects dimension | DW_EB_X_EBS_COMMON_W_PROJECT_D | ||
| PURCHASE_ORG_WID | NUMBER | 38 | Key to the Purchase organization in Business Organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PURCH_INVOICE_ITEM | NUMBER | 15 | Purchase Invoice Item | |||
| PURCH_INVOICE_NUM | VARCHAR2 | 120 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 | 120 CHAR | Purchase Order Number | |||
| PURCH_REP_WID | NUMBER | 38 | Key to the Purchase representative in Business Contacts dimension | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | ||
| RECEIPT_LINE_NUM | NUMBER | 15 | ||||
| RECEIPT_NUM | VARCHAR2 | 120 CHAR | ||||
| REF_DOC_ITEM | NUMBER | 15 | Reference Document Item | |||
| REF_DOC_NUM | VARCHAR2 | 120 CHAR | Reference Document Number | |||
| REF_DOC_TYPE_WID | NUMBER | 38 | Key to Transaction Types dimension for reference document | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| SALES_INVOICE_ITEM | NUMBER | 15 | Invoice Document Item | |||
| SALES_INVOICE_NUM | VARCHAR2 | 120 CHAR | Invoice Document Number | |||
| SALES_ORDER_ITEM | NUMBER | 15 | Sales Order Item | |||
| SALES_ORDER_NUM | VARCHAR2 | 120 CHAR | Sales Order Number | |||
| SALES_ORG_WID | NUMBER | 38 | Key to the Sales organization in Business Organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| SALES_PROD_WID | NUMBER | 38 | Key to the Sales Products dimension | DW_EB_X_EBS_COMMON_W_SALES_PRODUCT_D | ||
| SALES_REP_WID | NUMBER | 38 | Key to the Sales representative in Business Contacts dimension | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | ||
| SALES_SCH_LINE | NUMBER | 15 | Sales Schedule Line Number | |||
| SECOND_DISCOUNT_AMT | NUMBER | 38,10 | ||||
| SECOND_DISCOUNT_DATE | TIMESTAMP | 6 | ||||
| SECOND_DISCOUNT_LOC_AMT | NUMBER | 38,10 | ||||
| SERVICE_REP_WID | NUMBER | 38 | Key to the Service representative in Business Contacts dimension | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | ||
| SOURCE_WID | NUMBER | 38 | Key to the Transaction Source Dimension | DW_EB_X_EBS_COMMON_W_XACT_SOURCE_D | ||
| SPLR_ACCT_WID | NUMBER | 38 | Key to the Supplier Accounts dimension | DW_EB_X_EBS_COMMON_W_SUPPLIER_ACCOUNT_D | ||
| SPLR_ORDER_DT_WID | NUMBER | 38 | Suppliers Order Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| SPLR_ORDER_ITEM | NUMBER | 15 | Sales Order Item of Supplier | |||
| SPLR_ORDER_NUM | VARCHAR2 | 120 CHAR | Sales Order Number of Supplier | |||
| SUPPLIER_PROD_WID | NUMBER | 38 | Key to the Supplier Products dimension | DW_EB_X_EBS_COMMON_W_SUPPLIER_PRODUCT_D | ||
| SUPPLIER_WID | NUMBER | 38 | Key to the Suppliers dimension | DW_EB_X_EBS_COMMON_W_PARTY_D | ||
| TASK_WID | NUMBER | 38 | Key to the Tasks dimension | DW_EB_X_EBS_COMMON_W_TASK_D | ||
| TAX_TYPE_WID | NUMBER | 38 | Key to the Tax Types Dimension | |||
| 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_DISCOUNT_AMT | NUMBER | 38,10 | ||||
| THIRD_DISCOUNT_DATE | TIMESTAMP | 6 | ||||
| THIRD_DISCOUNT_LOC_AMT | NUMBER | 38,10 | ||||
| THIRD_PARTY_WID | NUMBER | 38 | ||||
| TRANSACTION_DESCR | VARCHAR2 | 2000 CHAR | ||||
| TRANSACTION_DESCR2 | VARCHAR2 | 2000 CHAR | ||||
| TRANSACTION_DT_WID | NUMBER | 38 | Transaction Date key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| TRANSACTION_TM_WID | NUMBER | 38 | Transaction Time key | |||
| UOM_CODE | VARCHAR2 | 50 CHAR | Unit of Measure | |||
| VALD_STATUS_WID | NUMBER | 38 | ||||
| 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 |