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.
INTEREST_METHOD_CODE VARCHAR2 30 Yes Interest method. Possible values are DAILY and PERIODIC COMPOUND.
ARREARS_PAY_DT_TREATMENT_CODE VARCHAR2 30 Yes Indicates whether the payment due date is included in day count calculation for the present value derivation when the payment is in arrears. Possible values are Beginning of the day and End of the day.
APPROVAL_TRANSACTION_ID NUMBER 18 Indicates the transaction identifier generated for lease approvals.
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