Lease Liability Schedules Stage

These are the lease liability schedules stage.

Data Store Key : FscmTopModelAM.FinExtractAM.FlaBiccExtractAM.LeaseLiabilitySchedulesStageExtractPVO

Primary Keys : LeaseLiabilitySchedStageLiabilityScheduleId

Initial Extract Date : LeaseLiabilitySchedStageCreationDate

Incremental Extract Date : LeaseLiabilitySchedStageLastUpdateDate

Attributes

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

Name Description
LeaseLiabilitySchedStageCatchupFlag Indicates if schedules are generated for catchup purpose.
LeaseLiabilitySchedStageClosingLiabilityAmount Indicates the liability balance as on period end date.
LeaseLiabilitySchedStageClosingLongTermLiabAmount Determines the closing long term liability amount.
LeaseLiabilitySchedStageClosingShortTermLiabAmount Determines the closing short term liability amount.
LeaseLiabilitySchedStageContingentAmount This is the contingent increase amount calculated for the period.
LeaseLiabilitySchedStageCreatedBy Indicates the user who created the row.
LeaseLiabilitySchedStageCreationDate This marks the date and time of the creation of the row.
LeaseLiabilitySchedStageCumulativeContingentAmount Indicates the cumulative contingent increase amount calculated for the period.
LeaseLiabilitySchedStageCumulativeIncreaseAmount Indicates the cumulative increase amount calculated for the period.
LeaseLiabilitySchedStageCumulativeNumberOfDays Indicates the cumulative number of days based on number of days.
LeaseLiabilitySchedStageIncreaseAmount Specifies the increase amount calculated for the period.
LeaseLiabilitySchedStageInterestAmount Specifies the interest amount calculated from last calculated date to current due date.
LeaseLiabilitySchedStageInterestRemainderAmount Indicates the interest remainder amount left in current period due to the rounding logic. This should be included in the next period.
LeaseLiabilitySchedStageJobDefinitionName Indicates the name of the job that created or last updated the row.
LeaseLiabilitySchedStageJobDefinitionPackage Indicates the package name of the job that created or last updated the row.
LeaseLiabilitySchedStageLastUpdateDate This marks the date and time of the last update of the row.
LeaseLiabilitySchedStageLastUpdateLogin Indicates the session login associated to the user who last updated the row.
LeaseLiabilitySchedStageLastUpdatedBy Indicates the user who last updated the row.
LeaseLiabilitySchedStageLeaseId The lease's unique identifier. It's referenced from FLA_LEASES_ALL table to indicate the liability schedules that pertain to a specific lease.
LeaseLiabilitySchedStageLiabilityEndDate Marks the end date for liability calculation.
LeaseLiabilitySchedStageLiabilityScheduleId This is the Primary key column.
LeaseLiabilitySchedStageLiabilityStartDate This marks the start date for liability calculation.
LeaseLiabilitySchedStageNumberOfLiabilityDays Indicates the number of days between liability start and end dates.
LeaseLiabilitySchedStageObjectVersionNumber 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.
LeaseLiabilitySchedStageOpeningLiabilityAmount Indicates the liability balance as on period start date.
LeaseLiabilitySchedStageOpeningLongTermLiabAmount Indicates the opening long term liability amount.
LeaseLiabilitySchedStageOpeningShortTermLiabAmount Indicates the opening short term liability amount.
LeaseLiabilitySchedStagePaymentItemAmount Indicates the payment item amount in the payment currency.
LeaseLiabilitySchedStagePaymentItemDate The payment item due date based on the payment definition.
LeaseLiabilitySchedStagePaymentNumber This is the attribute indicating the payment for which the liability is being calculated.
LeaseLiabilitySchedStagePeriodName This marks the accrual period in which the accrual falls.
LeaseLiabilitySchedStagePresentValueAmount This is the value of actual amount after cumulative number of days.
LeaseLiabilitySchedStageReclassLongTermLiabAmount This is the long term liability reclassification amount.
LeaseLiabilitySchedStageReclassShortTermLiabAmount This is the short term liability reclassification amount.
LeaseLiabilitySchedStageRequestId The LeaseLiabilitySchedStage request ID of the job that created or last updated the row.
LeaseLiabilitySchedStageScheduleDate This marks the period end date or amortization end date.
LeaseLiabilitySchedStageScheduleHeaderId The schedule header's unique identifier from FLA_SCHEDULE_HEADERS table.
LeaseLiabilitySchedStageSchedulesBatchId Indicates the batch identifier for the schedules generation batch.
LeaseLiabilitySchedStageSchedulingVersionNum This is the version of the schedule generation.
LeaseLiabilitySchedStageStageRequestId Identifier of the staging request.
LeaseLiabilitySchedStageUpfrontTaxAmount This is the upfront tax amount included in liability. This includes recoverable and unrecoverable amounts as applicable.
LeaseLiabilitySchedStageVersionNum Indicates the version number of the lease as captured in FLA_LEASE_DETAILS table.