DW_EB_X_EBS_PROJECTS_W_PROJ_EXP_LINE_F
This fact table stores the original expenditure records transferred from Purchasing or Accounts Payable, or entered directly in the Porject Expenditure screen. It has almost the same set of dimensions as the Cost star, except for the GL Account and Project/GL dates and Periods.
Details
Module: Projects (EBS_PROJECTS)
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| ROW_WID | NUMBER | 38 | True | Surrogate key to uniquely identify a record. | ||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | 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 | 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 | 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 | This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| BILLABLE_FLG | VARCHAR2 | 1 CHAR | This flag indicates whether the cost amount is billable. | |||
| BILL_JOB_WID | NUMBER | 38 | Key to the Bill Job Dimension | DW_EB_X_EBS_PROJECTS_W_JOB_D | ||
| BURDEN_COST_RATE | NUMBER | The burdened cost rate of the item. Burdened cost rate = (burden cost / quantity ). | ||||
| CAPITALIZABLE_FLG | VARCHAR2 | 1 CHAR | This flag indicates whether the cost amount is capitalizable | |||
| CHANGED_BY_WID | NUMBER | 38 | This is a 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 | ||
| 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 DW_EB_X_EBS_COMMON_W_DAY_D | |||
| COST_DISTRIBUTED_FLG | VARCHAR2 | 1 CHAR | This flag indicates if the cost has been distributed for this expenditure item. | |||
| CREATED_BY_WID | NUMBER | 38 | This is a 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 | 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 DW_EB_X_EBS_COMMON_W_DAY_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. | |||
| 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_BURDENED_COST | NUMBER | 38,10 | Total burdened cost in transaction currency | |||
| DOC_CURR_CODE | VARCHAR2 | 30 CHAR | Transaction Currency Code | |||
| DOC_RAW_COST | NUMBER | 38,10 | Total raw cost in transaction currency | |||
| ENTERED_BY_EMP_WID | NUMBER | 38 | Key to the Entered By Employee Dimension | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | ||
| ETL_PROC_WID | NUMBER | 38 | This column is the unique identifier for the specific ETL process used to create or update this data | |||
| EVENT_WID | NUMBER | 38 | Key to the Event Dimension | DW_EB_X_EBS_PROJECTS_W_EVENT_D | ||
| EXPENDITURE_CLASS_WID | NUMBER | 38 | Key to the Expenditure Class Dimension | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| EXPENDITURE_DT_WID | NUMBER | 38 | Key to the Expenditure Day Dimension | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| EXPENDITURE_ITEM_ID | NUMBER | 15 | The identifier of the expenditure item in the cost distribution line | |||
| EXPENDITURE_OPER_UNIT_WID | NUMBER | 38 | Key to the Expenditure Business Unit Dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| EXPENDITURE_ORGANIZATION_WID | NUMBER | 38 | Key to the Expenditure Organization Dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| FINANCIAL_RESOURCE_WID | NUMBER | 38 | Key to the Financial Resource Dimension | DW_EB_X_EBS_COMMON_W_FINANCIAL_RESOURCE_D | ||
| GLOBAL1_EXCHANGE_RATE | NUMBER | Conversion rate used to convert from transaction currency to DW global currency1 | ||||
| GLOBAL2_EXCHANGE_RATE | NUMBER | Conversion rate used to convert from transaction currency to DW global currency 2 | ||||
| GLOBAL3_EXCHANGE_RATE | NUMBER | Conversion rate used to convert from transaction currency to DW global currency 3 | ||||
| INCURRED_BY_EMP_WID | NUMBER | 38 | Key to the Incurred By Employee Dimension | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | ||
| INCURRED_BY_ORGANIZATION_WID | NUMBER | 38 | Key to the Incurred By Organization Dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| 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. | |||
| INVENTORY_ITEM_WID | NUMBER | 38 | Key to the Inventory Item Dimension | DW_EB_X_EBS_COMMON_W_INVENTORY_PRODUCT_D | ||
| JOB_WID | NUMBER | 38 | Key to the Job Dimension | DW_EB_X_EBS_PROJECTS_W_JOB_D | ||
| LOC_BURDENED_COST | NUMBER | 38,10 | Total burdened cost in functional currency | |||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | Functional Currency code | |||
| LOC_EXCHANGE_RATE | NUMBER | Conversion rate used to convert from transaction currency to functional currency | ||||
| LOC_RAW_COST | NUMBER | 38,10 | Total raw cost in functional currency | |||
| MFG_RESOURCE_BOM_WID | NUMBER | 38 | Key to the BOM Manufacturing Resource Dimension | DW_EB_X_EBS_COMMON_W_MFG_RESOURCE_D | ||
| MFG_RESOURCE_NL_WID | NUMBER | 38 | Key to the Non Labor Manufacturing Resource Dimension | DW_EB_X_EBS_COMMON_W_MFG_RESOURCE_D | ||
| OPERATING_UNIT_ORG_WID | NUMBER | 38 | Key to Operating Unit Organization Dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PROJECT_WID | NUMBER | 38 | Key to Project Dimension | DW_EB_X_EBS_COMMON_W_PROJECT_D | ||
| PROJ_BURDENED_COST | NUMBER | 38,10 | Total burdened cost in project currency | |||
| PROJ_CURR_CODE | VARCHAR2 | 30 CHAR | Project Currency Code | |||
| PROJ_EXCHANGE_RATE | NUMBER | Conversion rate used to convert from transaction currency to project currency | ||||
| PROJ_LOCATION_WID | NUMBER | 38 | Key to the Project Geography Dimension | DW_EB_X_EBS_COMMON_W_GEO_D | ||
| PROJ_MANAGER_WID | NUMBER | 38 | Key to the Project Manager Employee Dimension | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | ||
| PROJ_OPER_UNIT_WID | NUMBER | 38 | Key to the Project Business Unit Dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PROJ_ORGANIZATION_WID | NUMBER | 38 | Key to the Project Organization Dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PROJ_PR_CUSTOMER_ACCOUNT_WID | NUMBER | 38 | Key to Project Primary Customer Account Dimension | DW_EB_X_EBS_COMMON_W_CUSTOMER_ACCOUNT_D | ||
| PROJ_PR_CUSTOMER_WID | NUMBER | 38 | Key to Project Primary Customer Dimension | DW_EB_X_EBS_COMMON_W_PARTY_D | ||
| PROJ_RAW_COST | NUMBER | 38,10 | Total raw cost in project currency | |||
| PROJ_ROLE_WID | NUMBER | 38 | Key to Project Role Dimension | DW_EB_X_EBS_COMMON_W_PROJECT_ROLE_D | ||
| QUANTITY | NUMBER | 28,10 | Total number of units of the work performed | |||
| RAW_COST_RATE | NUMBER | The raw cost rate used to cost the item | ||||
| RESOURCE_CLASS_WID | NUMBER | 38 | Key to the Resource Class Dimension | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| RESOURCE_ORGANIZATION_WID | NUMBER | 38 | Key to the Resource Organization Dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| REVENUE_DISTRIBUTED_FLG | VARCHAR2 | 1 CHAR | This flag indicates if the revenue has been distributed for this expenditure item. | |||
| SERVICE_TYPE_WID | NUMBER | 38 | Key to the Service Type Dimension | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| TASK_ORGANIZATION_WID | NUMBER | 38 | Key to the Task Organization Dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| TASK_WID | NUMBER | 38 | Key to Project Task Dimension | DW_EB_X_EBS_COMMON_W_TASK_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 | |||
| TRANSACTION_SOURCE | VARCHAR2 | 80 CHAR | Name of external system for transactions imported into Projects | |||
| UOM | VARCHAR2 | 30 CHAR | Base unit of measure | DW_EB_X_EBS_DOMAINS_W_DOMAIN_MEMBER_LKP_TL | ||
| VENDOR_WID | NUMBER | 38 | Key to the Supplier Dimension | DW_EB_X_EBS_COMMON_W_PARTY_D | ||
| WORK_TYPE_WID | NUMBER | 38 | Key to the Work Type Dimension | DW_EB_X_EBS_PROJECTS_W_WORK_TYPE_D | ||
| 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 |