DW_EB_X_EBS_PROJECTS_W_PROJ_BUDGET_D
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 |
|---|---|---|---|---|---|---|
| ROW_WID | NUMBER | 38 | True | |||
| APPROVED_COST_PLAN_TYPE_FLG | VARCHAR2 | 1 CHAR | ||||
| APPROVED_REV_PLAN_TYPE_FLG | VARCHAR2 | 1 CHAR | ||||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| BASELINE_DT | TIMESTAMP | 6 | ||||
| BUDGET_STATUS_CODE | VARCHAR2 | 80 CHAR | ||||
| BUDGET_TYPE_CODE | VARCHAR2 | 50 CHAR | ||||
| BUDGET_VERSION | VARCHAR2 | 80 CHAR | ||||
| CHANGED_BY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_USER_D | |||
| CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| CHANGE_REASON_CODE | VARCHAR2 | 50 CHAR | ||||
| CREATED_BY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_USER_D | |||
| CREATED_ON_DT | TIMESTAMP | 6 | ||||
| CURRENT_ORIGINAL_VERSION_FLG | VARCHAR2 | 1 CHAR | ||||
| CURRENT_VERSION_FLG | VARCHAR2 | 1 CHAR | ||||
| DATASOURCE_NUM_ID | NUMBER | 10 | ||||
| DELETE_FLG | VARCHAR2 | 1 CHAR | ||||
| END_DATE_ACTIVE | TIMESTAMP | 6 | ||||
| ETC_START_DT | TIMESTAMP | 6 | ||||
| ETL_PROC_WID | NUMBER | 38 | ||||
| FIN_PLAN_LEVEL_CODE | VARCHAR2 | 50 CHAR | ||||
| FIRST_BUDGET_PERIOD | VARCHAR2 | 30 CHAR | ||||
| FORECAST_PLAN_DT | TIMESTAMP | 6 | ||||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | ||||
| LAST_AMT_GEN_DT | TIMESTAMP | 6 | ||||
| PLAN_CLASS_CODE | VARCHAR2 | 50 CHAR | ||||
| PRIMARY_COST_FORECAST_FLG | VARCHAR2 | 1 CHAR | ||||
| PRIMARY_REV_FORECAST_FLG | VARCHAR2 | 1 CHAR | ||||
| PROJECT_ID | VARCHAR2 | 80 CHAR | ||||
| PROJECT_NUMBER | VARCHAR2 | 25 CHAR | ||||
| START_DATE_ACTIVE | TIMESTAMP | 6 | ||||
| TENANT_ID | VARCHAR2 | 80 CHAR | ||||
| TIME_PHASED_CODE | VARCHAR2 | 50 CHAR | ||||
| VERSION_TYPE_CODE | VARCHAR2 | 50 CHAR | ||||
| W_PLAN_STATUS_CODE | VARCHAR2 | 80 CHAR | ||||
| W_TIME_PHASED_CODE | VARCHAR2 | 50 CHAR | ||||
| X_CUSTOM | VARCHAR2 | 10 CHAR | ||||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |