DW_EB_X_EBS_PROJECTS_W_PROJ_ASSET_D
No table description is available in the supplied metadata.
Details
Module: Projects (EBS_PROJECTS)
Business Name: Project Asset Dimension
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 | ||||
| ASSET_BU_ID | VARCHAR2 | 80 CHAR | ||||
| ASSET_CATEGORY_ID | VARCHAR2 | 80 CHAR | ||||
| ASSET_CODE | VARCHAR2 | 80 CHAR | ||||
| ASSET_LOCATION_ID | VARCHAR2 | 80 CHAR | ||||
| ASSET_NUMBER | VARCHAR2 | 15 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 | ||||
| BOOK_TYPE_CODE | VARCHAR2 | 15 CHAR | ||||
| CAPITALIZED_DT | TIMESTAMP | 6 | ||||
| CAPITALIZED_FLG | VARCHAR2 | 1 CHAR | ||||
| CHANGED_BY_WID | NUMBER | 38 | ||||
| CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| CREATED_BY_WID | NUMBER | 38 | ||||
| CREATED_ON_DT | TIMESTAMP | 6 | ||||
| DELETE_FLG | VARCHAR2 | 1 CHAR | ||||
| EST_IN_SERVICE_DT | TIMESTAMP | 6 | ||||
| ETL_PROC_WID | NUMBER | 38 | ||||
| FIXED_ASSET_ID | VARCHAR2 | 80 CHAR | ||||
| MANUFACTURER_NAME | VARCHAR2 | 40 CHAR | ||||
| MODEL_NUMBER | VARCHAR2 | 40 CHAR | ||||
| PLACED_IN_SERVICE_DT | TIMESTAMP | 6 | ||||
| PROJECT_ASSET_TYPE | VARCHAR2 | 30 CHAR | ||||
| PROJECT_ID | VARCHAR2 | 80 CHAR | ||||
| REVERSAL_DT | TIMESTAMP | 6 | ||||
| REVERSE_FLG | VARCHAR2 | 1 CHAR | ||||
| ROW_WID | NUMBER | 38 | ||||
| SERIAL_NUMBER | VARCHAR2 | 40 CHAR | ||||
| TAG_NUMBER | VARCHAR2 | 40 CHAR | ||||
| TENANT_ID | VARCHAR2 | 80 CHAR | ||||
| X_CUSTOM | VARCHAR2 | 10 CHAR | ||||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |