FLA_LEASES_INT
FLA_LEASES_INT contains the lease header and lease details information
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
FLA_LEASES_INT_PK |
LOAD_REQUEST_ID, INTERFACE_LEASE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTERFACE_LEASE_ID | NUMBER | 18 | Yes | Interface Lease identifier. This column consistutes primary key along with LOAD_REQUEST_ID column of the table. | |
| LOAD_REQUEST_ID | NUMBER | 18 | Yes | Oracle Enterprise Scheduler: request identifier of the interface load job that created the row. | |
| 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. | |
| LEASE_NUMBER | VARCHAR2 | 30 | Lease number which is either automatically generated or entered by the user, based on the system setup option. | ||
| LEASE_NAME | VARCHAR2 | 50 | Lease name to identify the lease. | ||
| LEASE_VERSION_NAME | VARCHAR2 | 50 | Lease version name, It is a short identifier of the version. | ||
| LEASE_VERSION_DESCRIPTION | VARCHAR2 | 1000 | Lease version description on what changes or amendments has been brought into the lease. | ||
| LEASE_ASSET_TYPE_CODE | VARCHAR2 | 30 | Indicates whether the lease asset is of Equipment or Property type. | ||
| LEASE_CLASSIFICATION_CODE | VARCHAR2 | 30 | Indicates the classification of the lease version. Possible values are Finance lease, Operating lease or Exempt Lease. | ||
| EXECUTION_DATE | DATE | Date from which the transaction is booked. It indicates the day on which the lease is being executed. | |||
| LEASE_START_DATE | DATE | 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. | |||
| LEASE_END_DATE | DATE | Date from which the lease is inactive. | |||
| CONTRACT_START_DATE | DATE | Date from which the lease contract is active. | |||
| CONTRACT_END_DATE | DATE | Date from which the lease contract is inactive. | |||
| OPTION_LEVEL_ALLOWED_CODE | VARCHAR2 | 30 | Indicates if option is defined at asset or lease level. | ||
| AMORTIZATION_START_DATE | DATE | Date from which the amortization has to be considered. | |||
| AMORTIZATION_END_DATE | DATE | Date till 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. | ||
| VENDOR_NUMBER | VARCHAR2 | 30 | Unique number to identify a supplier. | ||
| VENDOR_NAME | VARCHAR2 | 240 | Supplier name. Name of the supplier. | ||
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
| BU_NAME | VARCHAR2 | 240 | Business unit to which the lease refers. | ||
| LEGAL_ENTITY_ID | NUMBER | 18 | Legal entity identifier for the lease contract. | ||
| LEGAL_ENTITY_NAME | VARCHAR2 | 240 | Name of the legal entity on the lease. | ||
| PRIM_REGIME_ADDER_RATE | NUMBER | Adder rate which is used for the primary regime. | |||
| PRIM_REGIME_DISC_RATE_INDEX_ID | NUMBER | 18 | Discount rate index that is used for the primary regime. | ||
| PRIM_REGIME_DISC_RATE_IDX_NAME | VARCHAR2 | 300 | Discount rate index name that is used for the primary regime. | ||
| SECD_REGIME_ADDER_RATE | NUMBER | Adder rate which is used for the secondary regime. | |||
| SECD_REGIME_DISC_RATE_INDEX_ID | NUMBER | 18 | Discount rate index that is used for the secondary regime. | ||
| SECD_REGIME_DISC_RATE_IDX_NAME | VARCHAR2 | 300 | Discount rate index name that is used for the secondary regime. | ||
| MIGRATED_LEASE_FLAG | VARCHAR2 | 1 | Indicates if the lease is migrated from any exrernal system. | ||
| TARGET_STATUS_CODE | VARCHAR2 | 30 | Yes | The target status for the lease, whether to bring it in Draft, Completed or Active mode. | |
| MIGRATION_DATE | DATE | Indicates the date when the lease was migrated in. | |||
| ABSTRACTED_BY | VARCHAR2 | 64 | User name who has done the booking and can be different from CREATED_BY | ||
| RESPONSIBLE_USER | VARCHAR2 | 64 | Name of the user responsible for the lease creation. | ||
| 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 | ||
| IMPORT_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the Import Job. Main Job Request ID. | ||
| IMPORT_STATUS_CODE | VARCHAR2 | 30 | Status code for the lease if row is processed or rejected | ||
| INCREASE_APPLICABLE_FLAG | VARCHAR2 | 1 | Indicates if the lease can have payment increase agreements. | ||
| TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Transaction type which identifies which transaction is being executed. Various values could be BOOKING, TERMINATION and REVISION. | ||
| 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. | ||
| INCREASE_ACCOUNTING_CODE | VARCHAR2 | 30 | Indicates the contingent increase amount accounting treatment for the amendment. Possible value would be Contingent Increase and No Contingent Increase. | ||
| LEASE_ID | NUMBER | 18 | Lease identifier. It references the primary key of the FLA_LEASES_ALL table. | ||
| LEASE_DETAIL_ID | NUMBER | 18 | Lease detail identifier. This is referenced from FLA_LEASE_DETAILS table. | ||
| LEASE_AMENDMENT_NOTES | VARCHAR2 | 1000 | Notes captured as part of the amendment. | ||
| 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 amendment. | |||
| OPTION_TYPE_CODE | VARCHAR2 | 30 | Option type code which identifies which option is being chosen for exercise or cancelation. | ||
| 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 for the billing. | ||
| BILL_CUSTOMER_ACCOUNT_NUMBER | VARCHAR2 | 30 | Bill-to customer account number of the transaction. | ||
| 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. | |
| 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. | ||
| HEADLEASE_LEASE_NUMBER | VARCHAR2 | 30 | Lease number 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. | ||
| INTEREST_METHOD_CODE | VARCHAR2 | 30 | Interest method. Possible values are DAILY and PERIODIC COMPOUND. | ||
| ARREARS_PAY_DT_TREATMENT_CODE | VARCHAR2 | 30 | 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. | ||
| ROU_MIGRATION_BASIS_CODE | VARCHAR2 | 30 | 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 | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FLA_LEASES_INT_N1 | Non Unique | FUSION_TS_INTERFACE | IMPORT_REQUEST_ID |
| FLA_LEASES_INT_U1 | Unique | FUSION_TS_INTERFACE | LOAD_REQUEST_ID, INTERFACE_LEASE_ID |