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. | ||
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_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 |