DW_EB_X_EBS_PROJECTS_W_PROJ_BUDGET_F
Imported from database
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 |
|---|---|---|---|---|---|---|
| DATASOURCE_NUM_ID | NUMBER | 10 | ||||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | ||||
| ANALYSIS_TYPE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | |||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| AWARD_WID | NUMBER | 38 | DW_EB_X_EBS_PROJECTS_W_AWARD_D | |||
| BUDGET_WID | NUMBER | 38 | DW_EB_X_EBS_PROJECTS_W_PROJ_BUDGET_D | |||
| BURDEN_COST_RATE | NUMBER | |||||
| BURDEN_COST_RATE_OVERRIDE | NUMBER | 28,10 | ||||
| CHANGED_BY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_USER_D | |||
| CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| CREATED_BY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_USER_D | |||
| CREATED_ON_DT | TIMESTAMP | 6 | ||||
| DELETE_FLG | VARCHAR2 | 1 CHAR | ||||
| DOC_BURDENED_COST | NUMBER | 38,10 | ||||
| DOC_CURR_CODE | VARCHAR2 | 30 CHAR | ||||
| DOC_RAW_COST | NUMBER | 38,10 | ||||
| DOC_REVENUE | NUMBER | 28,10 | ||||
| EMPLOYEE_WID | NUMBER | 38 | ||||
| END_DT | TIMESTAMP | 6 | END_DT | |||
| END_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_DAY_D | |||
| ETL_PROC_WID | NUMBER | 38 | ||||
| EXPENDITURE_CATEGORY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | |||
| EXPENDITURE_ORGANIZATION_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| FINANCIAL_RESOURCE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_FINANCIAL_RESOURCE_D | |||
| GLOBAL1_COST_EXCHANGE_RATE | NUMBER | |||||
| GLOBAL1_REV_EXCHANGE_RATE | NUMBER | |||||
| GLOBAL2_COST_EXCHANGE_RATE | NUMBER | |||||
| GLOBAL2_REV_EXCHANGE_RATE | NUMBER | |||||
| GLOBAL3_COST_EXCHANGE_RATE | NUMBER | |||||
| GLOBAL3_REV_EXCHANGE_RATE | NUMBER | |||||
| GL_ACCOUNT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_ACCOUNT_D | |||
| GL_ACCT_END_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | |||
| GL_ACCT_START_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | |||
| GL_MCAL_CAL_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | |||
| GL_PERIOD_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_PERIOD_D | |||
| INCURRED_BY_EMP_WID | NUMBER | 38 | DW_EB_X_EBS_PROJECTS_W_EMPLOYMENT_D | |||
| INVENTORY_ITEM_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PRODUCT_D | |||
| ITEM_CATEGORY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PRODUCT_D | |||
| JOB_WID | NUMBER | 38 | DW_EB_X_EBS_PROJECTS_W_JOB_D | |||
| LOC_BURDENED_COST | NUMBER | 38,10 | ||||
| LOC_COST_EXCHANGE_RATE | NUMBER | |||||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | ||||
| LOC_RAW_COST | NUMBER | 38,10 | ||||
| LOC_REVENUE | NUMBER | 28,10 | ||||
| LOC_REV_EXCHANGE_RATE | NUMBER | |||||
| MFG_RESOURCE_BOM_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MFG_RESOURCE_D | |||
| MFG_RESOURCE_NL_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MFG_RESOURCE_D | |||
| OPERATING_UNIT_ORG_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| PA_MCAL_CAL_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | |||
| PROJECT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PROJECT_D | |||
| PROJ_ACCT_END_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | |||
| PROJ_ACCT_START_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | |||
| PROJ_BURDENED_COST | NUMBER | 38,10 | ||||
| PROJ_COST_EXCHANGE_RATE | NUMBER | |||||
| PROJ_CURR_CODE | VARCHAR2 | 30 CHAR | ||||
| PROJ_LOCATION_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GEO_D | |||
| PROJ_MANAGER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | |||
| PROJ_OPER_UNIT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| PROJ_ORGANIZATION_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| PROJ_PERIOD_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_PERIOD_D | |||
| PROJ_PR_CUSTOMER_ACCOUNT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_CUSTOMER_ACCOUNT_D | |||
| PROJ_PR_CUSTOMER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PARTY_D | |||
| PROJ_RAW_COST | NUMBER | 38,10 | ||||
| PROJ_REVENUE | NUMBER | 28,10 | ||||
| PROJ_REV_EXCHANGE_RATE | NUMBER | |||||
| PROJ_ROLE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PROJECT_ROLE_D | |||
| PROJ_STATUS_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_STATUS_D | |||
| PROJ_UNIT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| QUANTITY | NUMBER | 28,10 | ||||
| RESOURCE_CLASS_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | |||
| ROW_WID | NUMBER | 38 | ||||
| START_DT | TIMESTAMP | 6 | START_DT | |||
| START_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_DAY_D | |||
| TASK_ORGANIZATION_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| TASK_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_TASK_D | |||
| TENANT_ID | VARCHAR2 | 80 CHAR | ||||
| TXN_BILL_RATE_OVERRIDE | NUMBER | 28,10 | ||||
| TXN_COST_RATE_OVERRIDE | NUMBER | 28,10 | ||||
| TXN_DISCOUNT_PERCENTAGE | NUMBER | 28,10 | ||||
| TXN_MARKUP_PERCENT | NUMBER | 28,10 | ||||
| TXN_MARKUP_PERCENT_OVERRIDE | NUMBER | 28,10 | ||||
| TXN_STANDARD_BILL_RATE | NUMBER | |||||
| TXN_STANDARD_COST_RATE | NUMBER | |||||
| UOM | VARCHAR2 | 50 CHAR | DW_EB_X_EBS_DOMAINS_W_DOMAIN_MEMBER_LKP_TL | |||
| VENDOR_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PARTY_D | |||
| WORK_TYPE_WID | NUMBER | 38 | DW_EB_X_EBS_PROJECTS_W_WORK_TYPE_D | |||
| X_CUSTOM | VARCHAR2 | 10 CHAR | ||||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |