DW_EB_X_EBS_FA_W_ASSET_LEASE_D
Fixed Asset Lease dimension table stores information about Leased Assets
Details
Module: Fixed Assets (EBS_FA)
Business Name: Fixed Asset Lease
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 | ||||
| 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 | ||||
| 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 | ||||
| EFFECTIVE_FROM_DT | TIMESTAMP | 6 | ||||
| EFFECTIVE_TO_DT | TIMESTAMP | 6 | ||||
| ETL_PROC_WID | NUMBER | 38 | ||||
| LEASE_END_DATE | TIMESTAMP | 6 | ||||
| LEASE_NUMBER | VARCHAR2 | 80 CHAR | ||||
| LEASE_START_DATE | TIMESTAMP | 6 | ||||
| LEASE_TERM | VARCHAR2 | 10 CHAR | ||||
| LEASE_TYPE | VARCHAR2 | 80 CHAR | ||||
| LESSOR_SITE_WID | NUMBER | 38 | ||||
| LESSOR_WID | NUMBER | 38 | ||||
| ROW_WID | NUMBER | 38 | ||||
| SRC_EFF_FROM_DT | TIMESTAMP | 6 | ||||
| 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 |