Lease Schedule Headers

These are the lease schedule headers.

Data Store Key : FscmTopModelAM.FinExtractAM.FlaBiccExtractAM.LeaseScheduleHeadersExtractPVO

Primary Keys : LeaseScheduleHeaderScheduleHeaderId

Initial Extract Date : LeaseScheduleHeaderCreationDate

Incremental Extract Date : LeaseScheduleHeaderLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
LeaseScheduleHeaderAccountedFlag	The flag to indicate that the accounting is processed.
LeaseScheduleHeaderActiveFlag	This is the active flag. Tells if the schedule header is active or not.
LeaseScheduleHeaderAdderRate	Indicates the adder rate defined at lease level. This will be the adder rate set for the regime at lease level.
LeaseScheduleHeaderAdjustedFinRouAmount	The adjusted financial right-of-use as on amendment commencement date.
LeaseScheduleHeaderAdjustedLiabilityAmount	The adjusted liability as on amendment commencement date.
LeaseScheduleHeaderAdjustedOperRouAmount	The adjusted operating right-of-use as on amendment commencement date.
LeaseScheduleHeaderAdjustedReserveAmount	The adjusted reserve amount for the payment term.
LeaseScheduleHeaderAdjustmentStartDate	Indicates start date of the amendment entries.
LeaseScheduleHeaderAmortizationEndDate	This marks the date when the amortization schedule ends.
LeaseScheduleHeaderAmortizationProrationCode	This is the proration method to identify the number of days to consider per month to prorate the amount.
LeaseScheduleHeaderAmortizationRate	This contains one day amortization rate in case of daily and one month rate in case of periodic.
LeaseScheduleHeaderAmortizationStartDate	This marks the date from which the amortization schedule starts.
LeaseScheduleHeaderBillToCustomerId	The bill-to customer identifier for the billing.
LeaseScheduleHeaderBillToSiteUseId	The bill-to customer site use identifier.
LeaseScheduleHeaderClosingExpenseAmount	Indicates the closing lease expense amount till amendment commencement date.
LeaseScheduleHeaderClosingFinRouAmount	Indicates the closing financial right-of-use till amendment commencement date.
LeaseScheduleHeaderClosingInterestAmount	Indicates the closing interest till amendment commencement date.
LeaseScheduleHeaderClosingLiabilityAmount	Indicates the closing liability till amendment commencement date.
LeaseScheduleHeaderClosingOperRouAmount	Indicates the closing operating right-of-use till amendment commencement date.
LeaseScheduleHeaderClosingPaymentAmount	Indicates the closing payment till amendment commencement date.
LeaseScheduleHeaderContingentAmount	This is the contingent amount captured for the payment.
LeaseScheduleHeaderContingentOnlyImpactFlag	Indicates if contingent amount is impacted.
LeaseScheduleHeaderCreatedBy	Indicates the user who created the row.
LeaseScheduleHeaderCreationDate	Indicates the date and time of the creation of the row.
LeaseScheduleHeaderCurrencyCode	This is the attribute indicating payment currency code.
LeaseScheduleHeaderDailyCompoundingRate	Determines the daily compounding interest rate for the lease.
LeaseScheduleHeaderEndOfDayPaymentFlag	Indicates the present value to be calculated at the end of the day for the payment.
LeaseScheduleHeaderEndOfTermTransferFlag	The end-of-term transfer flag indicates if the transfer of balance is at the end of the payment or option term.
LeaseScheduleHeaderExpirationTransactionFlag	The expiration transaction flag indicates if the termination transaction is during an expiration of lease or asset.
LeaseScheduleHeaderFinRouGrossBalanceAmount	The finance right-of-use gross balance amount for migrated leases.
LeaseScheduleHeaderFinalFinAccruedRouAmount	This is the final financial right-of-use accrued amount as of closing.
LeaseScheduleHeaderFinalOperAccruedRouAmount	This is the final operating right-of-use accrued amount as of closing.
LeaseScheduleHeaderFinanceAccumAmortAmount	The finance right-of-use accumulated amortization amount for migrated leases.
LeaseScheduleHeaderForecastedFinRouAmount	The forecasted financial right-of-use amount for the payment term.
LeaseScheduleHeaderForecastedInterestAmount	The forecasted Interest amount for the payment term.
LeaseScheduleHeaderForecastedLiabilityAmount	The forecasted liability amount for the payment.
LeaseScheduleHeaderForecastedOperRouAmount	The forecasted operating right-of-use amount for the payment term.
LeaseScheduleHeaderForecastedPaymentAmount	The forecasted payment amount for the payment term.
LeaseScheduleHeaderForecastedReserveAmount	The forecasted reserve amount for the payment term.
LeaseScheduleHeaderGainLossAmount	Determines the calculated gain or loss as on amendment commencement date.
LeaseScheduleHeaderHeaderBalanceSyncDate	This marks the date when the schedule balances were synced up.
LeaseScheduleHeaderInterestCompoundingCode	Indicates the interest compounding method. Possible values are daily and monthly.
LeaseScheduleHeaderInterestCompoundingDays	This is the number of interest compounding days.
LeaseScheduleHeaderInterestRate	Indicates the interest rate . it's derived from discount rate index selected at lease level. This will be the interest rate for the regime.
LeaseScheduleHeaderJobDefinitionName	Indicates the name of the job that created or last updated the row.
LeaseScheduleHeaderJobDefinitionPackage	Indicates the package name of the job that created or last updated the row.
LeaseScheduleHeaderLastAccrualSyncDate	This marks the date when the last accrual was synced up.
LeaseScheduleHeaderLastAccruedDate	This marks the date till which the last accrual was run.
LeaseScheduleHeaderLastPaymentDate	This marks the last date of the payment. This is derived based on the payment lines.
LeaseScheduleHeaderLastPaymentSyncDate	This marks the date when the last payment was synced up.
LeaseScheduleHeaderLastReclassAccruedDate	This is the attribute indicating date till which the last liability reclassification was run.
LeaseScheduleHeaderLastUpdateDate	Indicates the date and time of the last update of the row.
LeaseScheduleHeaderLastUpdateLogin	Indicates the session login associated to the user who last updated the row.
LeaseScheduleHeaderLastUpdatedBy	Indicates the user who last updated the row.
LeaseScheduleHeaderLeaseClassificationCode	Indicates the lease classification. Possible values are Finance Lease, Operating Lease.
LeaseScheduleHeaderLeaseDetailId	The lease detail's unique identifier. it's referenced from FLA_LEASE_DETAILS table.
LeaseScheduleHeaderLeaseExpenseRate	This is the one day expense rate in case of daily and one month rate in case of periodic.
LeaseScheduleHeaderLeaseId	The lease's identifier. It's referenced from FLA_LEASES_ALL table to indicate that the schedules header is pertaining to specific lease.
LeaseScheduleHeaderNumberOfAmortizationDays	This marks the number of days between Amortization start and end dates.
LeaseScheduleHeaderObjectVersionNumber	This is 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.
LeaseScheduleHeaderOperRouGrossBalanceAmount	This is the operating right-of-use gross balance amount for migrated leases.
LeaseScheduleHeaderOperatingAccumAmortAmount	This is the operating right-of-use accumulated amortization amount for migrated leases.
LeaseScheduleHeaderParentRecordId	This is the parent booking or amendment schedule header primary key.
LeaseScheduleHeaderParentTransferRecordId	This is the parent payment or option record from which transfer of balance was processed.
LeaseScheduleHeaderPaymentNumber	This is the payment number. Schedules are generated for this payment header.
LeaseScheduleHeaderPercentageOfReduction	Indicates the reduction in right-of-use or liability. This would be based on reduction in time, usage or liability.
LeaseScheduleHeaderPriorExpenseAmount	Indicates the lease expense amount for the payment term before the amendment.
LeaseScheduleHeaderPriorFinRouAmount	Indicates the financial right-of-use amount for the payment term before the amendment.
LeaseScheduleHeaderPriorInterestAmount	Indicates the interest amount for the payment term before the amendment..
LeaseScheduleHeaderPriorLiabilityAmount	Indicates the liability amount for the payment term before the amendment.
LeaseScheduleHeaderPriorOperRouAmount	Indicates the operating right-of-use amount for the payment term before the amendment..
LeaseScheduleHeaderPriorPaymentAmount	Indicates the payment amount for the payment term before the amendment.
LeaseScheduleHeaderReducedExpenseAmount	Indicates the reduction in lease expense amount due to scope reduction.
LeaseScheduleHeaderReducedFinRouAmount	Indicates the reduction in financial right-of-use amount due to scope reduction.
LeaseScheduleHeaderReducedInterestAmount	Indicates the reduction in interest amount due to scope reduction.
LeaseScheduleHeaderReducedLiabilityAmount	Indicates the reduction in liability amount due to scope reduction.
LeaseScheduleHeaderReducedOperRouAmount	Indicates the reduction in operating right-of-use amount due to scope reduction.
LeaseScheduleHeaderReducedPaymentAmount	Indicates the reduction in payment amount due to scope reduction.
LeaseScheduleHeaderRegenerateSchedulesFlag	This is the regenerate schedules flag. If the flag is set then the schedules need to be regenerated.
LeaseScheduleHeaderRegimeCode	This is the regime code. This drives the accounting model and reporting for the lease.
LeaseScheduleHeaderRequestId	Indicates the LeaseScheduleHeader request ID of the job that created or last updated the row.
LeaseScheduleHeaderRevenueMethodCode	Indicates the method for spread of generated revenue, valid values are lease revenue and nonlease revenue.
LeaseScheduleHeaderReversalFlag	Indicates if the transaction is reversed or pending for reversal.
LeaseScheduleHeaderScheduleHeaderId	This is primary key for the table.
LeaseScheduleHeaderScheduleTypeCode	Indicates the type of schedule. Values are payment and billing.
LeaseScheduleHeaderSchedulingVersionNum	Indicates the version of the schedule generation.
LeaseScheduleHeaderScopeChangeBasisCode	Indicates the scope change method for the lease. Values can be unit based percentage and liability based percentage.
LeaseScheduleHeaderShipToSiteUseId	The ship-to customer site use identifier.
LeaseScheduleHeaderSimpleInterestRate	Indicates the simple interest rate derived based on discount rate provided.
LeaseScheduleHeaderTotForecastLiabilityAmount	Indicates the total forecasted liability amount. This is the unrounded amount.
LeaseScheduleHeaderTransactionDate	Indicates the transaction date. This will be used to derive the catchup amounts.
LeaseScheduleHeaderTransactionSubtypeCode	Indicates the transaction subtype. Possible values are scope increase, scope decrease, scope no change, edit and so forth for a revision transaction type.
LeaseScheduleHeaderTransactionTypeCode	The transaction type. Possible values are booking, revision or termination.
LeaseScheduleHeaderTransferBalanceFlag	This is the transfer balance flag which indicates if the payment balance or option balance has been transferred to the linked payment.
LeaseScheduleHeaderUnitOfMeasureCode	This is the attribute indicating unit of measure used for the asset.
LeaseScheduleHeaderUnitsConsumed	This is the number of units of the asset being considered on lease.
LeaseScheduleHeaderVendorSiteId	This is the attribute indicating the supplier site identifier.
LeaseScheduleHeaderVersionNum	The version number of the lease as captured in FLA_LEASE_DETAILS table.