DW_EB_X_EBS_EE_W_EXPENSE_F
This table is used to capture all expense related data that is submitted through an expense report.
Details
Module: Employee Expense (EBS_EE)
Business Name: Expense
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. | |||
| 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. | |||
| ACTUAL_EXPENSE_DT | TIMESTAMP | 6 | Stores the date of the actual expense. | |||
| ACTUAL_EXPENSE_DT_WID | NUMBER | 38 | Stores the date of the actual expense. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| ADJUSTMENT_REASON_WID | NUMBER | 38 | Identifies the adjustment reasons, If adjustments are made to the expense report. | DW_EB_X_EBS_COMMON_W_REASON_D | ||
| APPROVED_AMT | NUMBER | 38,10 | Stores the approved amount based on corporate policy in document currency, and is the same as requested the document amount if no adjustments are required. E.G., request is $40, but the requestor only has receipts for $30, so the approved amount is $30. | |||
| APPROVER_DEPT_ORG_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| APPROVER_ORG_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| APPROVER_WID | NUMBER | 38 | Identifies the employee who last approved the expense in the approval cycle. | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | ||
| 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. | |||
| BALANCING_SEGMENT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_BALANCING_SEGMENT_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. | |||
| COMPANY_ORG_WID | NUMBER | 38 | Identifies the company which honors the expense request. This is the organization where the chart of accounts is maintained. | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| COST_CENTER_WID | NUMBER | 38 | Identifies the cost center that is liable for the expense incurred by the requestor. | 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. | |||
| CUSTOMER_BILL_TO_LOC_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_CUSTOMER_LOC_D | |||
| CUSTOMER_LOC_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_CUSTOMER_LOC_D | |||
| CUSTOMER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PARTY_D | |||
| CUST_BILLABLE_FLG | VARCHAR2 | 1 CHAR | Identifies if the expense incurred can be billed to the customer. (Set to Y if it is billable, otherwise it is set to N.) | |||
| 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. | |||
| 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. | |||
| EMP_POSTN_DH_WID | NUMBER | 38 | Foreign key to DW_EB_X_EBS_COMMON_W_POSITION_DH indicating the employee position dimension hierarchy id. | DW_EB_X_EBS_COMMON_W_POSITION_DH | ||
| 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_TYPE_WID | NUMBER | 38 | Identifies the Expenditure type for Oracle Projects expense report line. | DW_EB_X_EBS_COMMON_W_FINANCIAL_RESOURCE_D | ||
| EXPENSE_APPROVAL_DT | TIMESTAMP | 6 | Stores the date when the last action was performed during the approval process of the expense report. | |||
| EXPENSE_APPROVAL_DT_WID | NUMBER | 38 | Stores the date when the last action was performed during the approval process of the expense report. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| EXPENSE_DIST_ITEM_NUM | NUMBER | 10 | Identifies the distribution item number which further helps uniquely identify the cost center/GL account level distribution of the expense item. This can be automatically generated by the ERP systems when distribution or split expenses are enabled. | |||
| EXPENSE_FROM_DT_WID | NUMBER | 38 | Stores the start date of the expense period of the expense report. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| EXPENSE_INVOICE_DT | TIMESTAMP | 6 | Stores the date the expense was invoiced. Can be used to link with Accounts Payable when the posted-on date is not available. | |||
| EXPENSE_INVOICE_DT_WID | NUMBER | 38 | Stores the date the expense was invoiced. Can be used to link with Accounts Payable when the posted-on date is not available. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| EXPENSE_INVOICE_ITEM | NUMBER | 10 | Reference to the Invoice item in Accounts Payable for this expense. | |||
| EXPENSE_INVOICE_NUM | VARCHAR2 | 50 CHAR | Reference to the Invoice number in Accounts Payable for this expense report. | |||
| EXPENSE_INVOICE_POSTED_DT_WID | NUMBER | 38 | Stores the date the expense invoice was posted into the Accounts Payables system in finance. This is the date on which finance will create liability in the books for paying off this expense. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| EXPENSE_INV_POSTED_DT | TIMESTAMP | 6 | Stores the date the expense invoice was posted into the Accounts Payables system in finance. This is the date on which finance will create liability in the books for paying off this expense. | |||
| EXPENSE_ITEM_QTY | NUMBER | 28,10 | Stores the total quantity/number of occurrences of item usage E.G., number of days in hotel/ number of flights /number of days car rented. | |||
| EXPENSE_PAY_TYPE_WID | NUMBER | 38 | Determines type of expense being captured: P=expense was pre-paid by the company, C=Cash advance, E=Actual expense incurred by requestor. E.G.,: P = pre-paid Air travel, C = cash advance from the company for extended trips, E = employee paid for meals. | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| EXPENSE_PROJECT_WID | NUMBER | 38 | Foreign key to DW_EB_X_EBS_COMMON_W_PROJECT_D indicating the project identifier for oracle projects. | DW_EB_X_EBS_COMMON_W_PROJECT_D | ||
| EXPENSE_REASON_WID | NUMBER | 38 | Identifies the business reason for the expense incurred. E.G., this would categorize the reason as a sales call, marketing event, celebration event, etc. | DW_EB_X_EBS_COMMON_W_REASON_D | ||
| EXPENSE_REPORT_ITEM | NUMBER | 10 | Uniquely identifies the expense item details in the expense report. Generally, expenses will have multiple line items. E.G., travel expenses will have line items for Air Fare, Hotel, Lunch etc. | |||
| EXPENSE_REPORT_NUM | VARCHAR2 | 50 CHAR | Identifies the document number which uniquely identifies the expense report in the source system. | |||
| EXPENSE_SOURCE_WID | NUMBER | 38 | Identifies the source system from where the expense report is created E.G iexpenses,payables. | DW_EB_X_EBS_COMMON_W_XACT_SOURCE_D | ||
| EXPENSE_STATUS_REASON_WID | NUMBER | 38 | Identifies the reason for the status of the expense report. This is mostly applicable for statuses which need explanation, such as Denial, Withdrawal, etc. Examples of reasons could be: "insufficient information" etc. | DW_EB_X_EBS_COMMON_W_REASON_D | ||
| EXPENSE_STATUS_WID | NUMBER | 38 | Identifies the status of the expense report after submission for approval/reimbursement, and is tracked at the report level. Status examples include Submitted, Approved, Request More Info, etc.) | DW_EB_X_EBS_COMMON_W_STATUS_D | ||
| EXPENSE_TASK_WID | NUMBER | 38 | Foreign key to W_TASK _D indicating the task identifier for oracle projects. | DW_EB_X_EBS_COMMON_W_TASK_D | ||
| EXPENSE_TO_DT_WID | NUMBER | 38 | Stores the end date of the expense period of the expense report. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| EXPENSE_TYPE_WID | NUMBER | 38 | Identifies the type of expense submitted. Expense types are generally defined by the organization and determines where money was spent. Expense type is typically tracked at the expense line item level (as opposed to expense report level). | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| EXPENSE_VIOLATION_WID | NUMBER | 38 | Identifies violations of company expense policy, defined within the organization and categorized by expense types into different kinds of violations with different severity levels. (E.G., a $20 breakfast when the allowance is set at $10 is a violation). | DW_EB_X_EBS_COMMON_W_REASON_D | ||
| 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 | Identifies the general ledger account where the expense will be posted. | DW_EB_X_EBS_COMMON_W_GL_ACCOUNT_D | ||
| HEADER_TO_DIST_PERC | NUMBER | 28,10 | ||||
| LINE_TEXT | VARCHAR2 | 255 CHAR | Captures item descriptions and expense reasons entered by the requestor. This will be free form text that the requestor enters as item description/comments. | |||
| LINE_TO_DIST_PERC | NUMBER | 28,10 | Stores the distribution factor in percentage. Used to distribute an expense item amount across different cost centers/GL accounts | |||
| LOCATION_WID | NUMBER | 38 | Identifies the Location for the expense incurred | DW_EB_X_EBS_COMMON_W_GEO_D | ||
| 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 | 28,10 | This is the exchange rate from Document Currency to the Local Currency. | |||
| MERCHANT_CODE | VARCHAR2 | 50 CHAR | The merchant code from whom the product/service was purchased. If this is not part of the vendor/supplier master then it can be captured at the transaction level. In many ERP systems, this is a free form data element supplied by the requestor. | |||
| MERCHANT_NAME | VARCHAR2 | 80 CHAR | The merchant name from whom the product/service was purchased by the requestor. | |||
| OPERATING_UNIT_ORG_WID | NUMBER | 38 | Identifies the operating unit organization. | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PREF_MERCHANT_FLG | VARCHAR2 | 1 CHAR | Indicates if the merchant is a preferred merchant for the company. If this is a preferred merchant the flag is set to Y and usually will be in the supplier/vendor master. If the merchant is not a preferred merchant, the flag is set to N. | |||
| PREPAYMENT_AMT | NUMBER | 38,10 | Prepayment Amount | |||
| PRODUCT_DESC | VARCHAR2 | 255 CHAR | Identifies the description of the product or service expensed by the requestor. This can be captured only when the product/services expensed are not captured as a part of the product master. | |||
| PRODUCT_NUM | VARCHAR2 | 30 CHAR | Identifies the number of the product or service expensed by the requestor. If it is not part of the product master, then it can be captured at the transaction level. In many ERP systems, this is a free form data element supplied by the requestor. | |||
| PRODUCT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PRODUCT_D | |||
| PROFIT_CENTER_WID | NUMBER | 38 | Identifies the profit center to which the expense is attributed. Typically the profit center would have both revenue and expense items under them. | DW_EB_X_EBS_COMMON_W_PROFIT_CENTER_D | ||
| PROJECT_ORGANIZATION_WID | NUMBER | 38 | Identifies the project organization for the expense incurred | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PURCH_PAY_METHOD_WID | NUMBER | 38 | The mode by which the expensed item was paid by the requestor at the time expense was incurred, such as Credit Card, Corporate Card, Cash, Check etc. | DW_EB_X_EBS_COMMON_W_PAYMENT_METHOD_D | ||
| PURPOSE | VARCHAR2 | 240 CHAR | Indicates the purpose of the expense report | |||
| RECEIPT_FLG | VARCHAR2 | 1 CHAR | Receipt Indicator | |||
| REIMBURSEMENT_CURRENCY_CODE | VARCHAR2 | 30 CHAR | Indicates the Reimbursement Currency Code | |||
| REQUESTOR_DEPT_ORG_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| REQUESTOR_ORG_WID | NUMBER | 38 | Identifies the requestor's organization (business unit). | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| REQUESTOR_VENDOR_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PARTY_ORG_D | |||
| REQUESTOR_WID | NUMBER | 38 | Identifies the employee who placed the reimbursement request for the expense incurred as the requestor. | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | ||
| RQSTN_AMT | NUMBER | 38,10 | Stores the requested expense item amount in document currency. In cases where expenses are split across cost centers/GL accounts, this represents the distribution percentage factor for the total item expense amount. | |||
| SUBMITTED_ON_DT | TIMESTAMP | 6 | Stores the date when the expense report was submitted for processing. | |||
| SUBMITTED_ON_DT_WID | NUMBER | 38 | Stores the date when the expense report was submitted for processing. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| SUPPLIER_ACCOUNT_WID | NUMBER | 38 | Identifies financial information for the supplier. This will be resolved only if vendors are captured in the vendor master and/or the accounting view of the vendor is maintained. On-off expenses (lunches, etc.) most likely will not resolve this key. | DW_EB_X_EBS_COMMON_W_SUPPLIER_ACCOUNT_D | ||
| SUPPLIER_PROD_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_SUPPLIER_PRODUCT_D | |||
| SUPPLIER_WID | NUMBER | 38 | Identifies the vendor supplying the product/service. Typically, this will be resolved only if vendors are captured in the vendor master. On-off expenses (Lunch/dinner etc) would most likely not resolve this key. | DW_EB_X_EBS_COMMON_W_PARTY_ORG_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 code E.G., Days, Each, etc. | |||
| VIOLATION_COUNT | NUMBER | 10 | Counts the number of company policy violations within an expense item. E.G., exceeding a rental car allowance and accepting a disallowed rental car type counts as 2 violations. | |||
| 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 |