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