DW_FA_LEASE_EXPENSE_DETAIL_EN

This is the Enity table for lease interest expense and lease expense values for a leased asset for each period at the distribution level.

Details

Module: Assets

Key Columns

LEASE_EXPENSE_DETAIL_ID, LEDGER_ID

Columns

Columns
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.