Lease Accrual Schedules Stage

These are the lease accrual schedules stage.

Data Store Key : FscmTopModelAM.FinExtractAM.FlaBiccExtractAM.LeaseAccrualSchedulesStageExtractPVO

Primary Keys : LeaseAccrSchedStageAccrualScheduleId

Initial Extract Date : LeaseAccrSchedStageCreationDate

Incremental Extract Date : LeaseAccrSchedStageLastUpdateDate

Attributes

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

Name	Description
LeaseAccrSchedStageAccrualReversalFlag	Indicates whether this accrual is reversed when the amendment commencement date precedes the most recent accrual period.
LeaseAccrSchedStageAccrualScheduleId	This is the primary key column.
LeaseAccrSchedStageAccrualStartDate	Indicates the start date of the accrual period.
LeaseAccrSchedStageAccruedFlag	Indicates if schedules are accrued or not.
LeaseAccrSchedStageCatchupFlag	Indicates if schedules are generated for catchup purpose.
LeaseAccrSchedStageClosingFinRouAmount	The financial right-of-use closing balance as of period end date.
LeaseAccrSchedStageClosingOperRouAmount	The operating right-of-use closing balance as of period end date.
LeaseAccrSchedStageCreatedBy	Indicates the user who created the row.
LeaseAccrSchedStageCreationDate	Indicates the date and time of the creation of the row.
LeaseAccrSchedStageGeneratedFromAmendFlag	Indicates if schedule is generated due to an amendment.
LeaseAccrSchedStageInterestAmount	The interest amount for the accrual period.
LeaseAccrSchedStageJobDefinitionName	Indicates the name of the job that created or last updated the row.
LeaseAccrSchedStageJobDefinitionPackage	Indicates the package name of the job that created or last updated the row.
LeaseAccrSchedStageLastUpdateDate	Indicates the date and time of the last update of the row.
LeaseAccrSchedStageLastUpdateLogin	Indicates the session login associated to the user who last updated the row.
LeaseAccrSchedStageLastUpdatedBy	Indicates the user who last updated the row.
LeaseAccrSchedStageLeaseId	The lease's unique identifier which is referenced from FLA_LEASES_ALL table to indicate that the liability schedules are pertaining to specific lease.
LeaseAccrSchedStageNumberOfAccrualDays	The number of days between accrual start and end date.
LeaseAccrSchedStageObjectVersionNumber	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.
LeaseAccrSchedStageOpeningFinRouAmount	The financial right-of-use opening balance as of period start date.
LeaseAccrSchedStageOpeningOperRouAmount	The operating right-of-use opening balance as of period start date.
LeaseAccrSchedStagePaymentNumber	The attribute indicating the payment for which the accruals is being calculated.
LeaseAccrSchedStagePeriodName	The accrual period in which the accrual falls in.
LeaseAccrSchedStagePeriodRemainderAmount	The period remainder amount is used in the lease expense calculation of periodic calculation frequency.
LeaseAccrSchedStageRequestId	Indicates the LeaseAccrSchedStage request ID of the job that created or last updated the row.
LeaseAccrSchedStageSchedule1Amount	The accrual schedule amount for schedule 1.
LeaseAccrSchedStageSchedule1RemainderAmount	The accrual amount remainder for schedule 1 in the current period due to the rounding logic. This should be included in the next period.
LeaseAccrSchedStageSchedule2Amount	The accrual schedule amount for schedule 2.
LeaseAccrSchedStageSchedule2RemainderAmount	The accrual amount remainder for schedule 2 in the current period due to the rounding logic. This should be included in the next period.
LeaseAccrSchedStageSchedule3Amount	The accrual schedule amount for schedule 3.
LeaseAccrSchedStageSchedule3RemainderAmount	The accrual amount remainder for schedule 3 in the current period due to the rounding logic. This should be included in the next period.
LeaseAccrSchedStageSchedule4Amount	The accrual schedule amount for schedule 4.
LeaseAccrSchedStageSchedule4RemainderAmount	The accrual amount remainder for schedule 4 in the current period due to the rounding logic. This should be included in the next period.
LeaseAccrSchedStageSchedule5Amount	The accrual schedule amount for schedule 5.
LeaseAccrSchedStageSchedule5RemainderAmount	The accrual amount remainder for schedule 5 in the current period due to the rounding logic. This should be included in the next period.
LeaseAccrSchedStageScheduleDate	The schedule date indicates end date of the accrual period.
LeaseAccrSchedStageScheduleHeaderId	The schedule header's unique identifier from FLA_SCHEDULE_HEADERS table.
LeaseAccrSchedStageSchedulesBatchId	The batch's unique identifier for the schedules generation batch.
LeaseAccrSchedStageSchedulingVersionNum	The version of the schedule generation.
LeaseAccrSchedStageStageRequestId	The request's unique identifier of the staging request.
LeaseAccrSchedStageVersionNum	The version number of the lease as captured in FLA_LEASE_DETAILS tables.