DW_EB_X_EBS_PROJECTS_W_PROJ_CIP_DTL_F
No table description is available in the supplied metadata.
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 | DATASOURCE_NUM_ID | |||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | INTEGRATION_ID | |||
| ANALYSIS_TYPE_WID | NUMBER | 38 | ANALYSIS_TYPE_WID | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| ASSET_BU_WID | NUMBER | 38 | ASSET_BU_WID | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| ASSET_CATEGORY_WID | NUMBER | 38 | ASSET_CATEGORY_WID | DW_EB_X_EBS_FA_W_ASSET_CATEGORY_D | ||
| ASSET_COST | NUMBER | 38,10 | ASSET_COST | |||
| ASSET_LOCATION_WID | NUMBER | 38 | ASSET_LOCATION_WID | DW_EB_X_EBS_FA_W_ASSET_LOCATION_D | ||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | AUX1_CHANGED_ON_DT | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | AUX2_CHANGED_ON_DT | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | AUX3_CHANGED_ON_DT | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | AUX4_CHANGED_ON_DT | |||
| CHANGED_BY_WID | NUMBER | 38 | CHANGED_BY_WID | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CHANGED_ON_DT | TIMESTAMP | 6 | CHANGED_ON_DT | |||
| CIP_GROUP_FLG | VARCHAR2 | 1 CHAR | CIP_GROUP_FLG | |||
| CREATED_BY_WID | NUMBER | 38 | CREATED_BY_WID | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CREATED_ON_DT | TIMESTAMP | 6 | CREATED_ON_DT | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | DELETE_FLG | |||
| ETL_PROC_WID | NUMBER | 38 | ETL_PROC_WID | |||
| EXPENDITURE_BU_WID | NUMBER | 38 | EXPENDITURE_BU_WID | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| EXPENDITURE_CLASS_WID | NUMBER | 38 | EXPENDITURE_CLASS_WID | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| EXPENDITURE_ITEM_ID | VARCHAR2 | 80 CHAR | EXPENDITURE_ITEM_ID | |||
| EXPENDITURE_ORGANIZATION_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| FINANCIAL_RESOURCE_WID | NUMBER | 38 | FINANCIAL_RESOURCE_WID | DW_EB_X_EBS_COMMON_W_FINANCIAL_RESOURCE_D | ||
| FIXED_ASSET_WID | NUMBER | 38 | FA_ASSET_WID | DW_EB_X_EBS_FA_W_FIXED_ASSET_D | ||
| GLOBAL1_EXCHANGE_RATE | NUMBER | GLOBAL1_EXCHANGE_RATE | ||||
| GLOBAL2_EXCHANGE_RATE | NUMBER | GLOBAL2_EXCHANGE_RATE | ||||
| GLOBAL3_EXCHANGE_RATE | NUMBER | GLOBAL3_EXCHANGE_RATE | ||||
| GL_ACCOUNTING_DT_WID | NUMBER | 38 | GL_ACCOUNTING_DT_WID | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | ||
| GL_MCAL_CAL_WID | NUMBER | 38 | GL_MCAL_CAL_WID | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | ||
| INCURRED_BY_EMP_WID | NUMBER | 38 | INCURRED_BY_EMP_WID | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | ||
| JOB_WID | NUMBER | 38 | JOB_WID | DW_EB_X_EBS_PROJECTS_W_JOB_D | ||
| LEDGER_WID | NUMBER | 38 | LEDGER_WID | DW_EB_X_EBS_COMMON_W_LEDGER_D | ||
| LINE_NUM | NUMBER | 15 | LINE_NUM | |||
| LOC_CURR_CODE | VARCHAR2 | 4 CHAR | LOC_CURR_CODE | |||
| PROJECT_ASSET_WID | NUMBER | 38 | PROJECT_ASSET_WID | DW_EB_X_EBS_PROJECTS_W_PROJ_ASSET_D | ||
| PROJECT_WID | NUMBER | 38 | PROJECT_WID | DW_EB_X_EBS_COMMON_W_PROJECT_D | ||
| PROJ_BU_WID | NUMBER | 38 | PROJ_BU_WID | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PROJ_MANAGER_WID | NUMBER | 38 | PROJ_MANAGER_WID | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | ||
| PROJ_ORGANIZATION_WID | NUMBER | 38 | PROJ_ORGANIZATION_WID | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PROJ_PR_CUSTOMER_ACCOUNT_WID | NUMBER | 38 | PROJ_PR_CUSTOMER_ACCOUNT_ WID | DW_EB_X_EBS_COMMON_W_CUSTOMER_ACCOUNT_D | ||
| PROJ_PR_CUSTOMER_WID | NUMBER | 38 | PROJ_PR_CUSTOMER_WID | DW_EB_X_EBS_COMMON_W_PARTY_D | ||
| PROJ_STATUS_WID | NUMBER | 38 | PROJ_STATUS_WID | DW_EB_X_EBS_COMMON_W_STATUS_D | ||
| REVERSED_FLG | VARCHAR2 | 1 CHAR | ||||
| ROW_WID | NUMBER | 38 | ROW_WID | |||
| SUPPLIER_WID | NUMBER | 38 | SUPPLIER_WID | DW_EB_X_EBS_COMMON_W_PARTY_D | ||
| TASK_WID | NUMBER | 38 | TASK_WID | DW_EB_X_EBS_COMMON_W_TASK_D | ||
| TENANT_ID | VARCHAR2 | 80 CHAR | TENANT_ID | |||
| TRANSFER_STATUS_WID | NUMBER | 38 | TRANSFER_STATUS_WID | DW_EB_X_EBS_COMMON_W_STATUS_D | ||
| X_CUSTOM | VARCHAR2 | 10 CHAR | X_CUSTOM | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |