# DW_LEASE_ASSET_D (Preview)

This table requires activation of Lease Accounting functional area. This table stores Lease Asset Details.

## Details

Module:

## Key Columns

LEASE_ASSET_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
LEASE_ASSET_ID | NUMBER | 38 | 0 | True | Asset identifier to uniquely identify an asset in this table. |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Source record identifier. |  |
LEASE_ID | NUMBER | 38 | 0 |  | Lease identifier. |  |
LEASE_DETAIL_ID | NUMBER | 38 | 0 |  | Lease details identifier which is referenced |  |
ASSET_NUMBER | VARCHAR2 | 32 |  |  | Asset number. |  |
START_DATE | DATE |  |  |  | Date from which the asset is active. |  |
END_DATE | DATE |  |  |  | Date from which the asset is inactive. |  |
ASSET_LOCATION_ID | NUMBER | 38 | 0 |  | Site information at which the asset is being installed |  |
INVENTORY_ORG_ID | NUMBER | 38 | 0 |  | Inventory item operating unit identifier. |  |
INVENTORY_ITEM_ID | NUMBER | 38 | 0 |  | Inventory item identifier. |  |
EMPLOYEE_ID | NUMBER | 38 | 0 |  | Employee with whom the asset is tagged with. |  |
PROPERTY_ID | NUMBER | 38 | 0 |  | Attribute indicating the property identifier of the property. |  |
ASSET_MODEL_CODE | VARCHAR2 | 32 |  |  | Model of the asset that describes the asset. |  |
ASSET_STATUS_CODE | VARCHAR2 | 32 |  |  | Asset status code. |  |
UNITS_CONSUMED | NUMBER | 38 | 0 |  | Number of units of the asset being taken on lease |  |
UNIT_OF_MEASURE | VARCHAR2 | 32 |  |  | Attribute indicating Unit of measure used for the asset. |  |
AMORTIZATION_END_DATE | DATE |  |  |  | Date when the amortization schedule ends. |  |
ASSET_IMPAIRED_FLAG | VARCHAR2 | 16 |  |  | Indicates if the asset has been impaired. |  |
CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the last update of the row. |  |
CREATED_BY | VARCHAR2 | 128 |  |  | Who column: indicates the user who created the row. |  |
LAST_UPDATED_BY | VARCHAR2 | 128 |  |  | Who column: indicates the user who last updated the row. |  |

Copyright Â© 2019, 2026, Oracle and/or its affiliates.