1. Tables and Views for Financials
  2. FLA_SCHEDULE_HEADERS

FLA_SCHEDULE_HEADERS

FLA_SCHEDULE_HEADERS contains schedule information at payment line and regime level for each transaction. Transactions can be BOOKING, REVISION, TERMINATION and EXPIRY.

Details

  • Schema: FUSION

  • Object owner: FUN

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

FLA_SCHEDULE_HEADERS_PK

SCHEDULE_HEADER_ID

Columns

Name Datatype Length Precision Not-null Comments
SCHEDULE_HEADER_ID NUMBER 18 Yes SCHEDULE_HEADER_ID. This is primary key for the table.
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_DETAIL_ID NUMBER 18 Yes Lease detail identifier. It is referenced from FLA_LEASE_DETAILS table.
VERSION_NUM NUMBER 9 Yes Version number of the lease as captured in FLA_LEASE_DETAILS.
LEASE_ID NUMBER 18 Yes Lease identifier. It is referenced from FLA_LEASES_ALL table to indicate that the schedules header is pertaining to specific lease.
PAYMENT_NUMBER VARCHAR2 30 Yes Payment number. Schedules are generated for this Payment Header.
REGIME_CODE VARCHAR2 30 Yes Regime code. This drives the accounting model and reporting for the lease.
AMORTIZATION_START_DATE DATE Yes Date from which the amortization schedule starts.
AMORTIZATION_END_DATE DATE Yes Date when the amortization schedule ends.
NUMBER_OF_AMORTIZATION_DAYS NUMBER 9 Yes Number of days between Amortization start and end dates
INTEREST_RATE NUMBER Interest rate . It is derived from Discount rate index selected at lease level. This will be the interest rate for the regime.
ADDER_RATE NUMBER Adder rate defined at lease level. This will be the adder rate set for the regime at Lease level.
DAILY_COMPOUNDING_RATE NUMBER Daily compounding interest rate for the Lease.
LEASE_EXPENSE_RATE NUMBER It contains one day expense rate in case of daily and one month rate in case of periodic.
AMORTIZATION_RATE NUMBER It contains one day amortization rate in case of daily and one month rate in case of periodic.
FORECASTED_LIABILITY_AMOUNT NUMBER Forecasted Liability Amount for the Payment.
FORECASTED_FIN_ROU_AMOUNT NUMBER Forecasted Financial ROU Amount for the Payment Term.
FORECASTED_OPER_ROU_AMOUNT NUMBER Forecasted Operating ROU Amount for the Payment Term.
FORECASTED_RESERVE_AMOUNT NUMBER Forecasted Reserve Amount for the Payment Term.
FORECASTED_PAYMENT_AMOUNT NUMBER Forecasted Payment Amount for the Payment Term.
FORECASTED_INTEREST_AMOUNT NUMBER Forecasted Interest amount for the Payment Term.
CLOSING_LIABILITY_AMOUNT NUMBER Closing liability till amendement commencement date.
CLOSING_FIN_ROU_AMOUNT NUMBER Closing Financial ROU till amendement commencement date.
CLOSING_OPER_ROU_AMOUNT NUMBER Closing Operating ROU till amendement commencement date.
CLOSING_PAYMENT_AMOUNT NUMBER Closing payment till amendement commencement date.
CLOSING_INTEREST_AMOUNT NUMBER Closing interest till amendement commencement date.
ADJUSTED_LIABILITY_AMOUNT NUMBER Adjusted liability as on amendement commencement date.
ADJUSTED_FIN_ROU_AMOUNT NUMBER Adjusted Financial ROU as on amendement commencement date.
ADJUSTED_OPER_ROU_AMOUNT NUMBER Adjusted Operating ROU as on amendement commencement date.
ADJUSTED_RESERVE_AMOUNT NUMBER Adjusted reserve amount for the payment term.
GAIN_LOSS_AMOUNT NUMBER Calculated Gain or Loss as on amendment commencement date.
CLOSING_EXPENSE_AMOUNT NUMBER Closing lease expense amount till amendment commencement date.
PRIOR_LIABILITY_AMOUNT NUMBER Pre-amendment liability amount for the payment term.
PRIOR_FIN_ROU_AMOUNT NUMBER Pre-amendment financial ROU amount for the payment term.
PRIOR_OPER_ROU_AMOUNT NUMBER Pre-amendment operating ROU amount for the payment term.
PRIOR_PAYMENT_AMOUNT NUMBER Pre-amedment payment amount for the payment term.
PRIOR_INTEREST_AMOUNT NUMBER Pre-amendment interest amount for the payment term.
PRIOR_EXPENSE_AMOUNT NUMBER Pre-amendment lease expense amount for the payment term.
REDUCED_LIABILITY_AMOUNT NUMBER Reduction in liability amount due to scope reduction.
REDUCED_FIN_ROU_AMOUNT NUMBER Reduction in financial ROU amount due to scope reduction.
REDUCED_OPER_ROU_AMOUNT NUMBER Reduction in operating ROU amount due to scope reduction.
REDUCED_PAYMENT_AMOUNT NUMBER Reduction in payment amount due to scope reduction.
REDUCED_INTEREST_AMOUNT NUMBER Reduction in interest amount due to scope reduction.
REDUCED_EXPENSE_AMOUNT NUMBER Reduction in lease expense amount due to scope reduction.
PERCENTAGE_OF_REDUCTION NUMBER Reduction in ROU or Liability. This would be based on reduction in time, usage or liability.
TRANSACTION_TYPE_CODE VARCHAR2 30 Transaction type. Possible values are BOOKING,REVISION or TERMINATION.
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.
REVERSAL_FLAG VARCHAR2 1 Reversal flag which indicates if the transaction is reversed or pending for reversal.
LEASE_CLASSIFICATION_CODE VARCHAR2 30 Indicates the lease classification. Possible values are Finance Lease, Operating Lease.
ADJUSTMENT_START_DATE DATE Indicates start date of the amendment entries.
TRANSACTION_DATE DATE Indicates the Transaction date. This will be used to derive the Catchup amounts.
ACCOUNTED_FLAG VARCHAR2 1 Flag to indicate that the accounting is processed.
ACTIVE_FLAG VARCHAR2 1 Active flag. Tells if the schedule header is active or not.
PARENT_RECORD_ID NUMBER 18 It contains parent booking or amendement schedule header primary key.
REGENERATE_SCHEDULES_FLAG VARCHAR2 1 Regenerate schedules flag. If the flag is set then the schedules need to be regenerated.
AMORTIZATION_PRORATION_CODE VARCHAR2 30 Proration method to identify the number of days to consider per month to prorate the amount
LAST_ACCRUED_DATE DATE Date till which the last accrual was run.
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.
FINAL_FIN_ACCRUED_ROU_AMOUNT NUMBER Final financial Right of use accrued amount as of closing.
FINAL_OPER_ACCRUED_ROU_AMOUNT NUMBER Final operating Right of use accrued amount as of closing.
TRANSFER_BALANCE_FLAG VARCHAR2 1 Transfer balance flag indicates if the payment balance or option balance has been transferred to the linked payment.
END_OF_TERM_TRANSFER_FLAG VARCHAR2 1 End of term transfer flag indicates if the transfer of balance is at the end of the payment or option term.
PARENT_TRANSFER_RECORD_ID NUMBER 18 This stores the parent payment or option record from which transfer of balance was processed.
EXPIRATION_TRANSACTION_FLAG VARCHAR2 1 Expiration transaction flag indicates if the termination transaction is during an expiration of lease or asset.
HEADER_BALANCE_SYNC_DATE DATE Date when the schedule balances were synced up.
LAST_PAYMENT_SYNC_DATE DATE Date when the last payment was synced up.
LAST_ACCRUAL_SYNC_DATE DATE Date when the last accrual was synced up.
CONTINGENT_AMOUNT NUMBER Contingent amount captured for the payment.
CONTINGENT_ONLY_IMPACT_FLAG VARCHAR2 1 Indicates contingent amount is impacted.
SCHEDULING_VERSION_NUM NUMBER 8 Version of the schedule generation.
TOT_FORECAST_LIABILITY_AMOUNT NUMBER Total forecasted liability amount. This is the unrounded amount.
LAST_RECLASS_ACCRUED_DATE DATE Attribute indicating date till which the last liability reclassification was run.
VENDOR_SITE_ID NUMBER 18 Attribute indicating the Supplier site identifier.
CURRENCY_CODE VARCHAR2 15 Attribute indicating payment currency code.
REVENUE_METHOD_CODE VARCHAR2 30 Indicates the method for spread of generated revenue, valid values are lease revenue and non lease revenue.
SCHEDULE_TYPE_CODE VARCHAR2 30 Yes Indicates the type of schedule, valid values are PAYMENT and BILLING.
BILL_TO_CUSTOMER_ID NUMBER 18 Bill to customer identifier for the billing.
BILL_TO_SITE_USE_ID NUMBER 18 Bill to customer site use identifier.
SHIP_TO_SITE_USE_ID NUMBER 18 Ship to customer site use identifier.
SCOPE_CHANGE_BASIS_CODE VARCHAR2 30 Scope change method for the lease. Values can be Unit based percentage and Liability based percentage.
UNITS_CONSUMED NUMBER 9 Number of units of the asset being considered on lease.
UNIT_OF_MEASURE_CODE VARCHAR2 30 Attribute indicating unit of measure used for the asset.
LAST_PAYMENT_DATE DATE Last date of the payment. This is derived based on the payment lines.
END_OF_DAY_PAYMENT_FLAG VARCHAR2 1 Yes Indicates the present value to be calculated at the end of the day for the payment.
INTEREST_COMPOUNDING_DAYS NUMBER 3 Yes Number of interest compounding days.
SIMPLE_INTEREST_RATE NUMBER Simple interest rate derived based on discount rate provided.
INTEREST_COMPOUNDING_CODE VARCHAR2 30 Yes Interest compounding method. Possible values are DAILY and MONTHLY.
FIN_ROU_GROSS_BALANCE_AMOUNT NUMBER Finance right of use gross balance amount for migrated leases.
OPER_ROU_GROSS_BALANCE_AMOUNT NUMBER Operating right of use gross balance amount for migrated leases.
FINANCE_ACCUM_AMORT_AMOUNT NUMBER Finance right of use accumulated amortization amount for migrated leases.
OPERATING_ACCUM_AMORT_AMOUNT NUMBER Operating right of use accumulated amortization amount for migrated leases.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index Uniqueness Tablespace Columns
FLA_SCHEDULE_HEADERS_N1 Non Unique FUSION_TS_TX_IDX LEASE_DETAIL_ID, PAYMENT_NUMBER, REGIME_CODE
FLA_SCHEDULE_HEADERS_N2 Non Unique FUSION_TS_TX_IDX PARENT_RECORD_ID
FLA_SCHEDULE_HEADERS_U1 Unique FUSION_TS_TX_IDX SCHEDULE_HEADER_ID
FLA_SCHEDULE_HEADERS_U2 Unique FUSION_TS_TX_IDX LEASE_ID, VERSION_NUM, PAYMENT_NUMBER, REGIME_CODE