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