This table requires activation of Lease Accounting functional area. This table stores Lease Contract Details.
Module:
LEASE_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| LEASE_ID | NUMBER | 38 | 0 | True | Lease identifier. It is the primary key of the table. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. System generated Unique Identifier. | ||||
| LEASE_DETAIL_ID | NUMBER | 38 | 0 | This is Lease detail identifier. | |||
| LEASE_NAME | VARCHAR2 | 64 | Lease name to identify the lease. | ||||
| LEASE_NUMBER | VARCHAR2 | 32 | Lease number of the lease. | ||||
| LEASE_STATUS_CODE | VARCHAR2 | 32 | Lease status. Possible values are Active, Terminated, and Hold. | ||||
| LEASE_TYPE_CODE | VARCHAR2 | 32 | Attribute indicating the lease type. | ||||
| LEASE_ASSET_TYPE_CODE | VARCHAR2 | 32 | Indicates whether the lease asset is of Equipment or Property type. | ||||
| ORG_ID | NUMBER | 38 | 0 | Indicates the identifier of the business unit associated to the row | |||
| LEGAL_ENTITY_ID | NUMBER | 38 | 0 | Legal entity identifier for the lease contract. | |||
| LEDGER_ID | NUMBER | 38 | 0 | Ledger identifier as defined in general ledger. | |||
| SUPPLIER_ID | NUMBER | 38 | 0 | Vendor identifier which represents the lessor associated with the lease. | |||
| FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | Accounting period type. Examples are Weekly, Monthly, Quarterly. | ||||
| FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | Name of the accounting calendar. | ||||
| LEASE_CLASSIFICATION_CODE | VARCHAR2 | 32 | Indicates the classification of the lease version. | ||||
| LEASE_SECONDARY_CLASSIF_CODE | VARCHAR2 | 32 | Indicates the secondary classification of the lease. | ||||
| OPTION_LEVEL_ALLOWED_CODE | VARCHAR2 | 32 | Indicates if option is defined at asset or lease level. | ||||
| AMORTIZATION_PRORATION_CODE | VARCHAR2 | 32 | Proration method to identify the number of days to consider per month to prorate the amount | ||||
| PRIMARY_REGIME_CODE | VARCHAR2 | 32 | Primary regime code. | ||||
| SECONDARY_REGIME_CODE | VARCHAR2 | 32 | Secondary regime code. | ||||
| TRANSACTION_TYPE_CODE | VARCHAR2 | 32 | Transaction type which identifies which transaction is being executed. | ||||
| TRANSACTION_SUBTYPE_CODE | VARCHAR2 | 32 | Transaction sub type. | ||||
| PRIM_REGIME_DISC_RATE_INDEX_NAME | VARCHAR2 | 512 | Discount rate index name associated with discount rate index identifier. | ||||
| PRIM_REGIME_INTEREST_RATE | NUMBER | Discount rate index value that is used for the primary regime. | |||||
| PRIM_REGIME_ADDER_RATE | NUMBER | Adder rate which is used for the primary regime. | |||||
| VERSION_NUM | NUMBER | 38 | 0 | Version number of the lease. | |||
| APPROVAL_STATUS_CODE | VARCHAR2 | 32 | Lease approval status. | ||||
| LEASE_VERSION_DESCRIPTION | VARCHAR2 | 999 | Lease version description on what changes or amendments has been brought into the lease. | ||||
| LEASE_VERSION_NAME | VARCHAR2 | 64 | Lease version name, It is a short identifier of the version. | ||||
| LEASE_START_DATE | DATE | Date from which the lease is active. | |||||
| TERMINATION_DATE | DATE | Date from which the lease is inactive. | |||||
| AMORTIZATION_START_DATE | DATE | Date from which the amortization has to be considered. | |||||
| AMORTIZATION_END_DATE | DATE | Date till which the amortization has to be considered. | |||||
| CONTRACT_START_DATE | DATE | Date from which the lease contract is active. | |||||
| CONTRACT_END_DATE | DATE | Date from which the lease contract is inactive. | |||||
| EXECUTION_DATE | DATE | Date from which the transaction is booked. | |||||
| MIGRATION_DATE | DATE | Indicates the date when the lease was migrated in. | |||||
| COMMENCEMENT_DATE | DATE | Date from which the lease commenced or amendment commenced. | |||||
| APPROVED_DATE | DATE | Date from which the lease or amendment was approved. | |||||
| ABSTRACTED_BY | VARCHAR2 | 128 | User ID who has done the booking. | ||||
| RESPONSIBLE_USER | VARCHAR2 | 128 | Name of the user responsible for the lease creation. | ||||
| MIGRATED_LEASE_FLAG | VARCHAR2 | 16 | Indicates if the lease is migrated or imported from an external system. | ||||
| PAYMENT_INCREASE_APPLICABLE_IND | VARCHAR2 | 16 | Indicates if the lease can have payment increase agreements. | ||||
| LEASE_AMENDMENT_NOTES | VARCHAR2 | 999 | Notes captured as part of amendment. | ||||
| LEASE_CREATION_DATE | DATE | Who column: indicates the date of the creation of the row. | |||||
| 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. |
Copyright © 2019, 2026, Oracle and/or its affiliates.