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

Name	Datatype	Length	Precision	Not Null	Comments
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.