1. Tables and Views for Financials
  2. FLA_LEASES_ALL

FLA_LEASES_ALL

FLA_LEASES_ALL contains lease information such as type of the lease, name of the lease, number, and lease start date, and so on.

Details

  • Schema: FUSION

  • Object owner: FUN

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

FLA_LEASES_PK

LEASE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
LEASE_ID NUMBER 18 Yes Lease identifier. It 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_NUMBER VARCHAR2 30 Yes Lease number which is either automatically generated or entered by the user, based on the system setup option. Active
LEASE_NAME VARCHAR2 50 Yes Lease name to identify the lease. Active
LEASE_START_DATE DATE Yes Date from which the lease is active. It is same as the lease commencement date for the first draft. It is not modifiable, once the lease is finalized. Active
LEASE_ASSET_TYPE_CODE VARCHAR2 30 Yes Indicates whether the lease asset is of Equipment or Property type.
LEASE_STATUS_CODE VARCHAR2 30 Yes Lease status. Possible values are Active, Terminated, and Hold.
CONTRACT_START_DATE DATE Date from which the lease contract is active. Active
CONTRACT_END_DATE DATE Date from which the lease contract is inactive. Active
MIGRATED_LEASE_FLAG VARCHAR2 1 Indicates if the lease is migrated or imported from an external system.
MIGRATION_DATE DATE Indicates the date when the lease was migrated in.
OPTION_LEVEL_ALLOWED_CODE VARCHAR2 30 Indicates if option is defined at asset or lease level.
IMPORT_TARGET_STATUS_CODE VARCHAR2 30 Target status of the lease that is imported. Values could be Active, Draft & Complete.
ABSTRACTED_BY VARCHAR2 64 User ID who has done the booking and can be different from CREATED_BY Active
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row. Active
LEGAL_ENTITY_ID NUMBER 18 Yes Legal entity identifier for the lease contract.
AMORTIZATION_START_DATE DATE Yes Date from which the amortization has to be considered.
AMORTIZATION_PRORATION_CODE VARCHAR2 30 Proration method to identify the number of days to consider per month to prorate the amount
VENDOR_ID NUMBER 18 Vendor identifier which represents the lessor associated with the lease. Active
DATA_SOURCE_CODE VARCHAR2 30 Feeder system from which lease data was created.
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
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.
INCREASE_APPLICABLE_FLAG VARCHAR2 1 Indicates if the lease can have payment increase agreements.
LEASE_TYPE_CODE VARCHAR2 30 Yes Attribute indicating the lease type. Valid values are EXPENSE, REVENUE and SUBLEASE.
BILL_TO_CUSTOMER_ID NUMBER 18 Bill to customer identifier. This is the party or lessee for the lease.
SUBLEASE_FLAG VARCHAR2 1 Indicates whether lease is a sublease. This is applicable for a revenue lease.
HEADLEASE_LEASE_ID NUMBER 18 Lease identifier of the headlease. This is applicable if this lease is a sublease.
ENABLE_SUBLEASES_FLAG VARCHAR2 1 Indicates if subleases are allowed on this lease. This is applicable for an expense lease.
ROU_MIGRATION_BASIS_CODE VARCHAR2 30 Yes Right of use migration basis. Indicates if the right of use balance should be entered as a gross or net amount for migrated leases.
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.
ATTRIBUTE_CHAR1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
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

Indexes

Index Uniqueness Tablespace Columns Status
FLA_LEASES_N1 Non Unique Default LEASE_START_DATE, ORG_ID
FLA_LEASES_N2 Non Unique Default VENDOR_ID, ORG_ID
FLA_LEASES_U1 Unique FUSION_TS_TX_IDX LEASE_ID Active
FLA_LEASES_U2 Unique FUSION_TS_TX_IDX LEASE_NUMBER, ORG_ID Active