Lease Liability Schedules

These are lease liability schedules.

Data Store Key : FscmTopModelAM.FinExtractAM.FlaBiccExtractAM.LeaseLiabilitySchedulesExtractPVO

Primary Keys : LeaseLiabilityScheduleLiabilityScheduleId

Initial Extract Date : LeaseLiabilityScheduleCreationDate

Incremental Extract Date : LeaseLiabilityScheduleLastUpdateDate

Attributes

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

Name	Description
LeaseLiabilityScheduleCatchupFlag	Indicates if schedules are generated for catchup purpose.
LeaseLiabilityScheduleClosingLiabilityAmount	Indicates the liability balance as on period end date.
LeaseLiabilityScheduleClosingLongTermLiabAmount	Indicates the closing long term liability amount.
LeaseLiabilityScheduleClosingShortTermLiabAmount	Indicates the closing short term liability amount.
LeaseLiabilityScheduleContingentAmount	This is the contingent increase amount calculated for the period.
LeaseLiabilityScheduleCreatedBy	Indicates the user who created the row.
LeaseLiabilityScheduleCreationDate	Indicates the date and time of the creation of the row.
LeaseLiabilityScheduleCumulativeContingentAmount	Indicates the cumulative contingent increase amount calculated for the period.
LeaseLiabilityScheduleCumulativeIncreaseAmount	Indicates the cumulative increase amount calculated for the period.
LeaseLiabilityScheduleCumulativeNumberOfDays	Indicates the cumulative number of days based on number of days.
LeaseLiabilityScheduleIncreaseAmount	Specifies the increase amount calculated for the period.
LeaseLiabilityScheduleInterestAmount	Specifies the interest amount calculated from last calculated date to current due date.
LeaseLiabilityScheduleInterestRemainderAmount	Indicates the interest remainder amount left in current period due to the rounding logic. This should be included in the next period.
LeaseLiabilityScheduleJobDefinitionName	Indicates the name of the job that created or last updated the row.
LeaseLiabilityScheduleJobDefinitionPackage	Indicates the package name of the job that created or last updated the row.
LeaseLiabilityScheduleLastUpdateDate	Indicates the date and time of the last update of the row.
LeaseLiabilityScheduleLastUpdateLogin	Indicates the session login associated to the user who last updated the row.
LeaseLiabilityScheduleLastUpdatedBy	Indicates the user who last updated the row.
LeaseLiabilityScheduleLeaseId	The lease's unique identifier. It's referenced from FLA_LEASES_ALL table to indicate the liability schedules that pertain to a specific lease.
LeaseLiabilityScheduleLiabilityEndDate	This marks the end date for liability calculation.
LeaseLiabilityScheduleLiabilityReversalFlag	Indicates if this transaction is reversed.
LeaseLiabilityScheduleLiabilityScheduleId	This is the primary key column.
LeaseLiabilityScheduleLiabilityStartDate	This marks the start date for liability calculation.
LeaseLiabilityScheduleNumberOfLiabilityDays	Indicates the number of days between liability start and end dates.
LeaseLiabilityScheduleObjectVersionNumber	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.
LeaseLiabilityScheduleOpeningLiabilityAmount	Specifies the liability balance as on period start date.
LeaseLiabilityScheduleOpeningLongTermLiabAmount	Indicates the opening long term liability amount.
LeaseLiabilityScheduleOpeningShortTermLiabAmount	Indicates the opening short term liability amount.
LeaseLiabilitySchedulePaymentItemAmount	Specifies the payment item amount in the payment currency.
LeaseLiabilitySchedulePaymentItemDate	Specifies the payment item due date based on the payment definition.
LeaseLiabilitySchedulePaymentNumber	This is the attribute indicating the payment for which the liability is being calculated.
LeaseLiabilitySchedulePeriodName	This is the accrual period in which accrual falls.
LeaseLiabilitySchedulePresentValueAmount	This is the value of actual amount after cumulative number of days.
LeaseLiabilityScheduleReadInDraftFlag	Indicates whether the payment item was considered for generation in the draft lease.
LeaseLiabilityScheduleReclassLongTermLiabAmount	Indicates the long term liability reclassification amount.
LeaseLiabilityScheduleReclassShortTermLiabAmount	Indicates the short term liability reclassification amount.
LeaseLiabilityScheduleRequestId	Indicates the LeaseAccrSchedStage request ID of the job that created or last updated the row.
LeaseLiabilityScheduleScheduleDate	This marks the period end date or amortization end date.
LeaseLiabilityScheduleScheduleHeaderId	The schedule header's unique identifier from FLA_SCHEDULE_HEADERS table.
LeaseLiabilityScheduleSchedulesBatchId	Indicates the batch identifier for the schedules generation batch.
LeaseLiabilityScheduleSchedulingVersionNum	Indicates the version of the schedule generation.
LeaseLiabilityScheduleUpfrontTaxAmount	This is the upfront tax amount included in liability. This includes recoverable and unrecoverable amounts as applicable.
LeaseLiabilityScheduleVersionNum	The version number of the lease as captured in FLA_LEASE_DETAILS table.