# DW_LEASE_CONTRACT_D (Preview)

This table requires activation of Lease Accounting functional area. This table stores Lease Contract Details.

## Details

Module:

## Key Columns

LEASE_ID

## Columns

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