This is the Enity table for lease interest expense and lease expense values for a leased asset for each period at the distribution level.
Module: Assets
LEASE_EXPENSE_DETAIL_ID, LEDGER_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
LEDGER_ID | NUMBER | 38 | 0 | True | Identifier of the accounting ledger. | ||
LEASE_EXPENSE_DETAIL_ID | NUMBER | 38 | 0 | True | Lease expense amount identification number per period for each distribution. | ||
SOURCE_RECORD_ID | VARCHAR2 | 64 | Source record identifier. Value is derived from a combination of Asset Transaction header identifiers. | ||||
SUBLEDGER_LINKAGE_DST_ENTITY_ID | VARCHAR2 | 64 | Subledger Linkage Distribution Entity Identifier | ||||
LEASE_EXPENSE_SUMMARY_ID | NUMBER | 38 | 0 | Lease expense summary identification number. | |||
BOOK_TYPE_CODE | VARCHAR2 | 32 | Name of the asset book in which the lease is recorded. | ||||
ASSET_ID | NUMBER | 38 | 0 | Identifier of the asset number. | |||
PERIOD_COUNTER | NUMBER | 38 | 0 | Depreciation period identifier. | |||
DISTRIBUTION_ID | NUMBER | 38 | 0 | Identifier of the Asset distribution . | |||
LEASE_SOURCE_CODE | VARCHAR2 | 32 | Source from where the lease record was created. Possible values are B(BOOKS) and L(LEASE). | ||||
LEASE_INTEREST_AMOUNT | NUMBER | Interest amount included in the periodic lease payment. | |||||
YTD_LEASE_INTEREST_AMOUNT | NUMBER | Year-to-date lease interest expense of the asset. | |||||
LEASE_INTEREST_ADJ_AMOUNT | NUMBER | Lease interest expense adjustment amount for the period. | |||||
LEASE_PAYMENT_AMOUNT | NUMBER | Periodic lease payment amount that the lessee pays to the lessor. | |||||
LEASE_LIABILITY_BALANCE | NUMBER | Running lease liability balance of the asset. | |||||
LEASE_EXPENSE_AMOUNT | NUMBER | Lease expense amount for the asset for the period. | |||||
YTD_LEASE_EXPENSE_AMOUNT | NUMBER | Year-to-date lease expense of the asset. | |||||
LEASE_EXPENSE_ADJ_AMOUNT | NUMBER | Lease expense adjustment amount for the period. | |||||
PERIODIC_DEPRN_RESERVE | NUMBER | Accumulated depreciation for the asset for the period. | |||||
DEPRN_RESERVE | NUMBER | Accumulated depreciation balance of the asset. | |||||
EVENT_ID | NUMBER | 38 | 0 | Transaction event identifier that is associated with this row for accounting purposes. | |||
LEASE_RUN_ID | NUMBER | 38 | 0 | Lease program submission identifier. | |||
CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
CREATED_BY | VARCHAR2 | 128 | Who column: indicates the user who created the row. | ||||
LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||||
LAST_UPDATE_LOGIN | VARCHAR2 | 64 | Who column: indicates the session login associated to the user who last updated the row. | ||||
LAST_UPDATED_BY | VARCHAR2 | 128 | Who column: indicates the user who last updated the row. | ||||
OBJECT_VERSION_NUMBER | NUMBER | 38 | 0 | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |||
LEASE_PAYMENT_ADJ_AMOUNT | NUMBER | Lease payment adjustment amount for the period. | |||||
DEPRN_RESERVE_ADJ_AMOUNT | NUMBER | Depreciation reserve adjustment amount for the period. | |||||
LTD_LEASE_EXPENSE_AMOUNT | NUMBER | Accumulated lease expense of the asset. | |||||
LEASE_RATE_GAIN_LOSS_AMOUNT | NUMBER | Gain or loss amount on lease liability for the currency exchange rate changes. | |||||
PERIODIC_LEASE_LIABILITY_AMT | NUMBER | PERIODIC_LEASE_LIABILITY_AMT | |||||
PERIODIC_LEASE_CLEARING_AMOUNT | NUMBER | Periodic payment invoice amount transferred to Oracle Fusion Payables. | |||||
MC_FLAG | VARCHAR2 | 16 | Flag to indicate the source of data is MC or Regular dataset | ||||
H_ASSET_NUMBER | VARCHAR2 | 32 | User-defined asset identification number. | ||||
H_ASSET_KEY_CCID | NUMBER | 38 | 0 | Identifier of the asset key flexfield combination. | |||
H_ASSET_CATEGORY_ID | NUMBER | 38 | 0 | Identifier of the asset category. | |||
H_DESCRIPTION | VARCHAR2 | 128 | Asset description | ||||
H_ASSET_TYPE | VARCHAR2 | 16 | Type of the asset allowed in the Oracle Fusion Assets. The asset types allowed are Capitalized, Construction-in-Process, Expensed, and Group. | ||||
H_TAG_NUMBER | VARCHAR2 | 16 | Unique user-defined tracking number for an asset. | ||||
H_SERIAL_NUMBER | VARCHAR2 | 64 | Serial number assigned to the asset. | ||||
H_IN_USE_FLAG | VARCHAR2 | 16 | Indicator used to determine whether the asset is in use. | ||||
H_OWNED_LEASED | VARCHAR2 | 16 | Indicates whether asset is owned or leased. | ||||
H_COMMITMENT | VARCHAR2 | 32 | Financial liability or commitment assigned to the asset. | ||||
H_PARENT_ASSET_ID | NUMBER | 38 | 0 | Identifier of the parent asset for the child or component asset. | |||
H_INVENTORIAL | VARCHAR2 | 16 | Indicates whether the asset should be included in physical inventory. | ||||
H_PROPERTY_1245_1250_CODE | VARCHAR2 | 16 | Indicates whether the asset belongs to the 1245 property class or 1250 property class. | ||||
H_PROPERTY_TYPE_CODE | VARCHAR2 | 32 | Option indicating whether the asset is considered personal, real, or residential property. | ||||
H_INTANGIBLE_ASSET_FLAG | VARCHAR2 | 16 | Indicates whether the asset is an intangible asset. | ||||
H_MANUFACTURER_NAME | VARCHAR2 | 512 | Name of the manufacturer of the asset. | ||||
H_MODEL_NUMBER | VARCHAR2 | 64 | Model number assigned to the asset. | ||||
H_NEW_USED | VARCHAR2 | 16 | Option indicating whether asset is new or used. | ||||
H_INVESTMENT_LAW | VARCHAR2 | 32 | Benefit incentives applied to the asset. | ||||
H_CURRENT_UNITS | NUMBER | Current number of units for an asset. |