DW_EB_X_EBS_FA_W_FIXED_ASSET_D
No table description is available in the supplied metadata.
Details
Module: Fixed Assets (EBS_FA)
Business Name: Fixed Asset
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 | ||||
| ACQUISITION_DATE | TIMESTAMP | 6 | ||||
| ACTIVE_FLG | VARCHAR2 | 1 CHAR | ||||
| ASSET_CODE | VARCHAR2 | 80 CHAR | ||||
| ASSET_NUMBER | VARCHAR2 | 50 CHAR | ||||
| ASSET_TYPE | VARCHAR2 | 50 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 | 50 CHAR | ||||
| CAPITALIZATION_DATE | TIMESTAMP | 6 | ||||
| CHANGED_BY_WID | NUMBER | 38 | ||||
| CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| CREATED_BY_WID | NUMBER | 38 | ||||
| CREATED_ON_DT | TIMESTAMP | 6 | ||||
| CURRENT_FLG | VARCHAR2 | 1 CHAR | ||||
| DATE_PLACED_IN_SERVICE | TIMESTAMP | 6 | DATE_PLACED_IN_SERVICE | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | ||||
| DEPRECIATION_START_DATE | TIMESTAMP | 6 | ||||
| EFFECTIVE_FROM_DT | TIMESTAMP | 6 | ||||
| EFFECTIVE_TO_DT | TIMESTAMP | 6 | ||||
| ETL_PROC_WID | NUMBER | 38 | ||||
| FULLY_RETIRED_DATE | TIMESTAMP | 6 | ||||
| IN_USE_FLAG | VARCHAR2 | 3 CHAR | ||||
| LEASE_CODE | VARCHAR2 | 50 CHAR | ||||
| LEASE_TERM | NUMBER | 10 | ||||
| LEASE_TYPE | VARCHAR2 | 80 CHAR | ||||
| LESSOR_SITE_WID | NUMBER | 38 | ||||
| LESSOR_WID | NUMBER | 38 | ||||
| MANUFACTURER | VARCHAR2 | 360 CHAR | ||||
| MCAL_CAL_WID | NUMBER | 38 | ||||
| MODEL | VARCHAR2 | 50 CHAR | ||||
| ORIGINAL_COST | NUMBER | 38,10 | ||||
| OWNED_LEASED | VARCHAR2 | 30 CHAR | ||||
| RECOVERABLE_COST | NUMBER | 38,10 | ||||
| ROW_WID | NUMBER | 38 | ||||
| SALVAGE_VALUE | NUMBER | 28,10 | ||||
| SERIAL_NUMBER | VARCHAR2 | 50 CHAR | ||||
| SRC_EFF_FROM_DT | TIMESTAMP | 6 | ||||
| SRC_EFF_TO_DT | TIMESTAMP | 6 | ||||
| SRC_TRAN_HEADER_DT_IN | TIMESTAMP | 6 | ||||
| SRC_TRAN_HEADER_DT_OUT | TIMESTAMP | 6 | ||||
| SRC_TRAN_HEADER_ID_IN | NUMBER | 10 | ||||
| SRC_TRAN_HEADER_ID_OUT | NUMBER | 10 | ||||
| TAG_NUMBER | VARCHAR2 | 50 CHAR | ||||
| TENANT_ID | VARCHAR2 | 80 CHAR | ||||
| TOTAL_LIFE_IN_MONTHS | NUMBER | 10 | ||||
| TOTAL_LIFE_IN_YEARS | NUMBER | 10 | ||||
| WARRANTY_CODE | VARCHAR2 | 50 CHAR | ||||
| WARRANTY_COST | NUMBER | 38,10 | ||||
| WARRANTY_END_DATE | TIMESTAMP | 6 | ||||
| WARRANTY_START_DATE | TIMESTAMP | 6 | ||||
| X_CUSTOM | VARCHAR2 | 10 CHAR | ||||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |