FA_MC_LEASE_EXPENSE_DETAIL_H
This table contains the history of lease expense and lease interest information for audit and inquiry purposes for records that were accounted for. Only accounted records in FINAL mode in Subledger Accounting
Details
-
Schema: FUSION
-
Object owner: FA
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FA_MC_LEASE_EXPENSE_DETAI_PK |
LEDGER_ID, LEASE_EXPENSE_DETAIL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LEDGER_ID | NUMBER | 18 | Yes | Identifier of the accounting ledger. | |
| LEASE_EXPENSE_DETAIL_ID | NUMBER | 18 | Yes | Lease expense amount identification number per period for each distribution. | |
| LEASE_EXPENSE_SUMMARY_ID | NUMBER | 18 | Yes | Lease expense summary identification number. | |
| BOOK_TYPE_CODE | VARCHAR2 | 30 | Yes | Name of the asset book in which the lease is recorded. | |
| ASSET_ID | NUMBER | 18 | Yes | Identifier of the asset number. | |
| PERIOD_COUNTER | NUMBER | 18 | Yes | Depreciation period identifier. | |
| DISTRIBUTION_ID | NUMBER | 18 | Yes | Identifier of the Asset distribution . | |
| LEASE_SOURCE_CODE | VARCHAR2 | 30 | Yes | 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 depreciationged for the asset for the period. | |||
| DEPRN_RESERVE | NUMBER | Accumulated depreciation balance of the asset. | |||
| EVENT_ID | NUMBER | 18 | Transaction event identifier that is associated with this row for accounting purposes. | ||
| LEASE_RUN_ID | NUMBER | 18 | Lease program submission identifier. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE30 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | 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 | Reduction in lease liability due to the lease payments made to the lessor. | |||
| PERIODIC_LEASE_CLEARING_AMOUNT | NUMBER | Periodic payment invoice amount transferred to Oracle Fusion Payables. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FA_MC_LEASE_EXPENSE_DET_H_N1 | Non Unique | Default | LEDGER_ID, LEASE_EXPENSE_SUMMARY_ID |
| FA_MC_LEASE_EXPENSE_DET_H_U1 | Unique | FUSION_TS_TX_DATA | LEDGER_ID, LEASE_EXPENSE_DETAIL_ID |
| FA_MC_LEASE_EXPENSE_DET_H_U2 | Unique | FUSION_TS_TX_DATA | LEDGER_ID, DISTRIBUTION_ID, BOOK_TYPE_CODE, PERIOD_COUNTER, LEASE_RUN_ID |