DW_EB_X_EBS_FA_W_ASSET_CATEGORY_D
Imported from database
Details
Module: Fixed Assets (EBS_FA)
Business Name: Fixed Asset Category
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 | ||||
| SRC_EFF_FROM_DT | TIMESTAMP | 6 | ||||
| ACTIVE_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 | ||||
| CAPITALIZE_FLAG | VARCHAR2 | 3 CHAR | ||||
| CATEGORY_CODE | VARCHAR2 | 50 CHAR | ||||
| CATEGORY_TYPE | VARCHAR2 | 30 CHAR | ||||
| CHANGED_BY_WID | NUMBER | 38 | ||||
| CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| CONCATENATED_SEGMENT_VALUE | VARCHAR2 | 2000 CHAR | ||||
| CREATED_BY_WID | NUMBER | 38 | ||||
| CREATED_ON_DT | TIMESTAMP | 6 | ||||
| CURRENT_FLG | VARCHAR2 | 1 CHAR | ||||
| DELETE_FLG | VARCHAR2 | 1 CHAR | ||||
| EFFECTIVE_FROM_DT | TIMESTAMP | 6 | ||||
| EFFECTIVE_TO_DT | TIMESTAMP | 6 | ||||
| ETL_PROC_WID | NUMBER | 38 | ||||
| MAJOR_CATEGORY | VARCHAR2 | 80 CHAR | MAJOR_CATEGORY | |||
| MINOR_CATEGORY | VARCHAR2 | 80 CHAR | MINOR_CATEGORY | |||
| OWNED_LEASED | VARCHAR2 | 30 CHAR | ||||
| PROPERTY_CLASS | VARCHAR2 | 10 CHAR | ||||
| PROPERTY_TYPE | VARCHAR2 | 30 CHAR | ||||
| ROW_WID | NUMBER | 38 | ||||
| SEGMENT1 | VARCHAR2 | 80 CHAR | ||||
| SEGMENT2 | VARCHAR2 | 80 CHAR | ||||
| SEGMENT3 | VARCHAR2 | 80 CHAR | ||||
| SEGMENT4 | VARCHAR2 | 80 CHAR | ||||
| SEGMENT5 | VARCHAR2 | 80 CHAR | ||||
| SEGMENT6 | VARCHAR2 | 80 CHAR | ||||
| SEGMENT7 | VARCHAR2 | 80 CHAR | ||||
| SRC_EFF_TO_DT | TIMESTAMP | 6 | ||||
| TENANT_ID | VARCHAR2 | 80 CHAR | ||||
| X_CUSTOM | VARCHAR2 | 10 CHAR | ||||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |