1. Tables and Views for Financials
  2. FA_LEASES

FA_LEASES

FA_LEASES contains information about lease assets including whether they are operating or capital lease assets, their terms and lessor data.

Details

  • Schema: FUSION

  • Object owner: FA

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

FA_LEASES_PK

LEASE_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping Status
LEASE_ID NUMBER 18 Yes Identifier of the capital or operating lease.
LEASE_NUMBER VARCHAR2 30 Yes User-defined lease number of the lease. Active
LESSOR_ID NUMBER 18 Yes Identifier of the lessor. Lessors have to be set as valid suppliers. Active
DESCRIPTION VARCHAR2 240 Yes Description of the asset lease. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Leases (FA_LEASES) Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Leases (FA_LEASES) Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Leases (FA_LEASES) Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Leases (FA_LEASES) Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Leases (FA_LEASES) Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Leases (FA_LEASES) Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Leases (FA_LEASES) Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Leases (FA_LEASES) Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Leases (FA_LEASES) Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Leases (FA_LEASES) Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Leases (FA_LEASES) Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Leases (FA_LEASES) Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Leases (FA_LEASES) Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Leases (FA_LEASES) Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Leases (FA_LEASES) Active
ATTRIBUTE_CATEGORY_CODE VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Leases (FA_LEASES) Active
FASB_LEASE_TYPE VARCHAR2 15 Type of lease. Leases can be classified as capital or operating leases. Active
COST_CAPITALIZED NUMBER Capitalized cost for a capital lease asset. Active
TRANSFER_OWNERSHIP VARCHAR2 1 Ownership transfer at the end of lease contract. Active
BARGAIN_PURCHASE_OPTION VARCHAR2 1 Bargain purchase option to acquire the asset after lease expiration. Active
PAYMENT_SCHEDULE_ID NUMBER 18 Payment schedule identifier for lease assets. Active
ASSET_LIFE NUMBER Expected useful life of the asset. Active
CURRENCY_CODE VARCHAR2 5 The currency that is used on the page. Active
LESSOR_SITE_ID NUMBER 18 Identifier of the location to which the payment will be sent. Active
DIST_CODE_COMBINATION_ID NUMBER 18 Identifier of the account code combination for the depreciation expense account. Active
TERMS_ID NUMBER 18 Terms unique identifier for lease assets. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
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. Active
LEASE_START_DATE DATE Yes Date on which the lease payment starts as per lease contract. Active
TERM_FREQUENCY_CODE VARCHAR2 30 The intervals in which the lease amount is payable. Obsolete
CATEGORY_ID NUMBER 18 Yes Category flexfield identification number. Active
CONTRACT_NUMBER VARCHAR2 255 Unique identifier of the lease contract. Active
INSTALLMENT_TYPE_CODE VARCHAR2 30 Indicates whether the lease payment is paid in advance or arrears. Obsolete
NUMBER_OF_ASSETS NUMBER 4 Number assets added to the asset book from the asset lease. Obsolete
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE21 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE22 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE23 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE24 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE25 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE26 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE27 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE28 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE29 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE30 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 30 Global Descriptive Flexfield: structure definition of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_NUMBER1 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_NUMBER6 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_NUMBER7 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_NUMBER8 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_NUMBER9 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_NUMBER10 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_DATE1 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_DATE2 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_DATE3 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_DATE4 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_DATE5 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_DATE6 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_DATE7 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_DATE8 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_DATE9 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_DATE10 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GENERATE_PAYMENT_INVOICE_CODE VARCHAR2 30 Yes Indicates whether the lease payment invoice to be generated for the asset book. Active
UPD_ASSET_LEASE_SCHEDULE_FLAG VARCHAR2 1 Indicates whether the asset level payment schedule is updated by the user. Obsolete
LEASE_END_DATE DATE Date when the last lease payment to be made as per the lease contract. Active
LEDGER_ID NUMBER 18 Unique ledger identifier. Active
BU_ID NUMBER 18 Business unit identifier. Active
FAIR_VALUE NUMBER Fair market value of the lease asset. Active
PRESENT_VALUE NUMBER Present value of lease payments. Active
LEASE_TERM NUMBER Stipulated length of the lease contract. Active
LEASE_TYPE VARCHAR2 1 Type of lease. Leases can be classified as capital or operating leases. Active
PAYMENT_FREQUENCY_CODE VARCHAR2 30 Yes The intervals in which the lease amount is payable.
PAYMENT_OPTION_TYPE_CODE VARCHAR2 30 Yes Indicates whether the lease payment is paid in advance or arrears.

Foreign Keys

Table Foreign Table Foreign Key Column
FA_LEASES poz_suppliers LESSOR_ID
FA_LEASES gl_code_combinations DIST_CODE_COMBINATION_ID
FA_LEASES ap_terms_b TERMS_ID
fa_additions_b fa_leases LEASE_ID
fa_mc_lease_schedules fa_leases LEASE_ID
fa_lease_books fa_leases LEASE_ID
fa_lease_schedules fa_leases LEASE_ID
fa_mc_lease_books fa_leases LEASE_ID

Indexes

Index Uniqueness Tablespace Columns Status
FA_LEASES_U1 Unique FUSION_TS_TX_IDX LEASE_ID Active
FA_LEASES_U2 Unique FUSION_TS_TX_IDX LESSOR_ID, LEASE_NUMBER Active