1. Tables and Views for Financials
  2. FLA_LEASE_DETAILS

FLA_LEASE_DETAILS

FLA_LEASE_DETAILS table contains the lease version details like Lease End Date, Lease Classification, Lease Execution Date etc.

Details

  • Schema: FUSION

  • Object owner: FUN

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

FLA_LEASE_DETAILS_PK

LEASE_DETAIL_ID

Columns

Name Datatype Length Precision Not-null Comments Status
LEASE_DETAIL_ID NUMBER 18 Yes Lease detail identifier. This is the primary key of the table. 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_ID NUMBER 18 Yes Lease identifier. It references the primary key of the FLA_LEASES_ALL table Active
VERSION_TYPE_CODE VARCHAR2 30 Yes Version type code. Any lease would have a minimum of one and a maximum of two versions. Possible values are "D" for Draft version and "F" for Final version.
VERSION_NUM NUMBER 9 Yes Version number of the lease. This indicates the number of versions the lease has undergone.
LEASE_VERSION_NAME VARCHAR2 50 Yes Lease version name, It is a short identifier of the version. Active
LEASE_VERSION_DESCRIPTION VARCHAR2 1000 Lease version description on what changes or amendments has been brought into the lease. Active
LEASE_CLASSIFICATION_CODE VARCHAR2 30 Yes Indicates the classification of the lease version. Possible values are Finance lease, Operating lease or Exempt Lease.
COMMENCEMENT_DATE DATE Yes Date from which the lease commenced or amendment commenced. Active
TERMINATION_DATE DATE Yes Date from which the lease is inactive. Active
AMORTIZATION_END_DATE DATE Yes Date till which the amortization has to be considered. Active
DATA_SOURCE_CODE VARCHAR2 30 Feeder system from which lease data was created.
EXECUTION_DATE DATE Date from which the transaction is booked. It indicates the day on which the lease is being executed. Active
APPROVED_BY VARCHAR2 64 Name of the user who has approved the lease draft to mark it as final. Active
APPROVED_DATE DATE Date from which the lease or amendment was approved. Active
APPROVAL_STATUS_CODE VARCHAR2 30 Lease approval status. A Draft lease or an amendment goes through different statuses before being finalized.
APPROVAL_COMMENTS VARCHAR2 255 Comments or details provided by the user who has approved the lease version. Active
RESPONSIBLE_USER VARCHAR2 64 Name of the user responsible for the lease creation. Active
PRIM_REGIME_ADDER_RATE NUMBER Adder rate which is used for the primary regime. Active
PRIM_REGIME_DISC_RATE_INDEX_ID NUMBER 18 Discount rate index that is used for the primary regime. Active
PRIM_REGIME_INTEREST_RATE NUMBER Discount rate index value that is used for the primary regime. Active
SECD_REGIME_ADDER_RATE NUMBER Adder rate which is used for the secondary regime. Active
SECD_REGIME_DISC_RATE_INDEX_ID NUMBER 18 Discount rate index that is used for the secondary regime. Active
SECD_REGIME_INTEREST_RATE NUMBER Discount rate index value that is used for the secondary regime. Active
SYSTEM_ORIGIN_REFERENCE_1 VARCHAR2 30 System reference column to maintain the key of source system from which lease is being imported
SYSTEM_ORIGIN_REFERENCE_2 VARCHAR2 30 System reference column to maintain the key of source system from which lease is being imported
GENERATED_BY VARCHAR2 64 Name of the user who has generated the schedules and payments.
GENERATED_DATE DATE Date when the schedules and payments were generated.
VALIDATED_BY VARCHAR2 64 Name of the user who has validated the lease.
VALIDATED_DATE DATE Date when the lease was validated.
SUBMITTED_BY VARCHAR2 64 Name of the user who has submitted the lease for approval.
SUBMITTED_DATE DATE Date when the lease was submitted for approval.
TRANSACTION_TYPE_CODE VARCHAR2 30 Transaction type which identifies which transaction is being executed. Various values could be BOOKING, TERMINATION, AMEND, RESCIND.
TRANSACTION_SUBTYPE_CODE VARCHAR2 30 Transaction sub type. Possible values are SCOPE_INCREASE, SCOPE_DECREASE, SCOPE_NO_CHANGE, EDIT and so forth for a REVISION transaction type.
PERCENTAGE_OF_REDUCTION NUMBER Reduction in ROU or Liability. This would be based on reduction in time, usage or liability.
VERSION_PREPARED_BY VARCHAR2 64 Name of the user who has prepared the version.
VERSION_SIGNED_DATE DATE Date the version is signed on during an amend.
VERSION_INITIATED_BY VARCHAR2 64 Name of the user who has initiated the version.
VERSION_INITIATED_DATE DATE Date when the version was initiated.
SCHEDULES_REFRESH_NEEDED_FLAG VARCHAR2 1 Flag to indicate if the schedules need to be refreshed or not.
LEASE_AMENDMENT_NOTES VARCHAR2 1000 Notes captured as part of amendment.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
REPORT_JOB_ID NUMBER 18 Report request identifier of the job that created or last updated the row.
REPORT_JOB_NAME VARCHAR2 200 Indicates the name of the job that created or last updated the row.
REPORT_JOB_RUN_DATE DATE Date the report job was launched.
QUARTZ_RUN_DATE DATE Date the quartz process started the scheduling.
QUARTZ_JOB_NAME VARCHAR2 256 Functional name of the quartz job.
QUARTZ_JOB_GROUP VARCHAR2 100 Group associated with quartz job.
PROCESS_REQUEST_ID NUMBER 18 Oracle Enterprise Scheduler: request identifier of the job that created or last updated the row.
PROCESS_JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
PROCESS_JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
OPTION_TRANSACTION_CODE VARCHAR2 30 Option type selected during an amendment in case the amendment is for exercise or cancel of an option.
TERMINATION_TRANSACTION_CODE VARCHAR2 30 Termination type selected during termination. Value could be ASSET or LEASE.
APPROVAL_SUB_STATUS_CODE VARCHAR2 30 Approval sub status indicates the lease version sub status when the version is in working status.
LEASE_TERMINATION_FLAG VARCHAR2 1 Indicates if the lease is getting terminated or not.
AUTO_FINALIZE_VERSION_FLAG VARCHAR2 1 Indicates if the lease should be auto finalized along with validation and generation of schedules.
INCREASE_ACCOUNTING_CODE VARCHAR2 30 Indicates the contingent increase amount accounting treatment for the amendment. Possible value would be Contingent Increase and Non Contingent Increase.
INCREASE_IMPACT_FLAG VARCHAR2 1 Indicates if the lease is impacted by payment increase agreement.
INCREASE_GENERATED_BY VARCHAR2 100 Name of the user who has submitted the generate payment increase action.
INCREASE_GENERATED_DATE DATE Date when the lease was submitted for generate payment increase action.
BALANCE_SYNC_REQUEST_ID NUMBER 18 Oracle Enterprise Scheduler: request identifier of the job that created or last updated the row. This is used for request created for the purpose of lease balances.
BALANCE_SYNC_STATUS_CODE VARCHAR2 30 Indicates if the balances were synced for this lease.
LEASE_TRX_APPROVAL_FLAG VARCHAR2 1 Indicates if the lease approval is enabled for the lease version.
PROCESS_REQUEST_CODE VARCHAR2 30 Captures the request details executed on the lease.
AMEND_FOR_INDEX_FLAG VARCHAR2 1 Indicates if the amendment is for finalization of assessments which are for index based agreements.
PRIM_REGIME_SCOPE_CHANGE_CODE VARCHAR2 30 Scope change method for leases in primary accounting standard. Values can be Unit based percentage and Liability based percentage.
SECD_REGIME_SCOPE_CHANGE_CODE VARCHAR2 30 Scope change method for leases in secondary accounting standard. Values can be Unit based percentage and Liability based percentage.
LEASE_SECONDARY_CLASSIF_CODE VARCHAR2 30 Indicates the secondary classification of the lease. Possible values are Finance, Operating and Exempt.
REQUIRE_PROPERTY_DEFN_FLAG VARCHAR2 1 Yes Flag to Indicate if a property is required for the assets on the expense lease.
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
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_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE_CHAR1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
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.

Foreign Keys

Table Foreign Table Foreign Key Column
FLA_LEASE_DETAILS fla_leases_all LEASE_ID
fla_lease_payment_headers fla_lease_details LEASE_DETAIL_ID
fla_lease_assets fla_lease_details LEASE_DETAIL_ID

Indexes

Index Uniqueness Tablespace Columns Status
FLA_LEASE_DETAILS_N1 Non Unique Default PRIM_REGIME_DISC_RATE_INDEX_ID
FLA_LEASE_DETAILS_N2 Non Unique Default BALANCE_SYNC_REQUEST_ID, BALANCE_SYNC_STATUS_CODE
FLA_LEASE_DETAILS_U1 Unique FUSION_TS_TX_IDX LEASE_DETAIL_ID Active
FLA_LEASE_DETAILS_U2 Unique FUSION_TS_TX_IDX LEASE_ID, VERSION_TYPE_CODE Active