Lease Accrual Schedules
These are lease accrual schedules.
Data Store Key : FscmTopModelAM.FinExtractAM.FlaBiccExtractAM.LeaseAccrualSchedulesExtractPVO
Primary Keys : LeaseAccrualScheduleAccrualScheduleId
Initial Extract Date : LeaseAccrualScheduleCreationDate
Incremental Extract Date : LeaseAccrualScheduleLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| LeaseAccrualScheduleAccrualReversalFlag | Specifies whether this accrual is reversed if the amendment commencement date precedes the most recent accrual period. |
| LeaseAccrualScheduleAccrualScheduleId | This is the primary key column ACCRUAL_SCHEDULE_ID. |
| LeaseAccrualScheduleAccrualStartDate | The start date of accrual period. |
| LeaseAccrualScheduleAccruedFlag | Indicates if schedules are accrued or not. |
| LeaseAccrualScheduleCatchupFlag | Indicates if schedules are generated for catchup purpose. |
| LeaseAccrualScheduleClosingFinRouAmount | The financial ROU closing balance as of period end date. |
| LeaseAccrualScheduleClosingOperRouAmount | The operating ROU closing balance as of period end date. |
| LeaseAccrualScheduleCreatedBy | Indicates the user who created the row. |
| LeaseAccrualScheduleCreationDate | Indicates the date and time of the creation of the row. |
| LeaseAccrualScheduleExpiredRouFlag | Indicates if the right of use has expired because of an impairment. |
| LeaseAccrualScheduleGeneratedFromAmendFlag | Indicates if schedule is generated due to an amendment. |
| LeaseAccrualScheduleInterestAmount | The interest amount for the accrual period. |
| LeaseAccrualScheduleJobDefinitionName | Indicates the name of the job that created or last updated the row. |
| LeaseAccrualScheduleJobDefinitionPackage | Indicates the package name of the job that created or last updated the row. |
| LeaseAccrualScheduleLastUpdateDate | Indicates the date and time when the row was last updated.. |
| LeaseAccrualScheduleLastUpdateLogin | Indicates the session login associated to the user who last updated the row. |
| LeaseAccrualScheduleLastUpdatedBy | Indicates the user who last updated the row. |
| LeaseAccrualScheduleLeaseId | The lease's unique identifier. It's referenced from FLA_LEASES_ALL table to indicate that the liability schedules are pertaining to specific lease. |
| LeaseAccrualScheduleNumberOfAccrualDays | The number of days between accrual start and end date. |
| LeaseAccrualScheduleObjectVersionNumber | 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. |
| LeaseAccrualScheduleOpeningFinRouAmount | The financial ROU opening balance as of period start date. |
| LeaseAccrualScheduleOpeningOperRouAmount | The operating ROU opening balance as of period start date. |
| LeaseAccrualSchedulePaymentNumber | The attribute indicating the payment for which the accruals is being calculated. |
| LeaseAccrualSchedulePeriodName | The accrual period in which accrual falls. |
| LeaseAccrualSchedulePeriodRemainderAmount | The period remainder amount. It's used in lease expense calculation of periodic calculation frequency. |
| LeaseAccrualScheduleReadInDraftFlag | Indicates whether the record was considered for generation of accrual schedules in the draft lease. |
| LeaseAccrualScheduleRequestId | Indicates the LeaseAccountingHeader request ID of the job that created or last updated the row. |
| LeaseAccrualScheduleSchedule1Amount | The accrual Schedule amount for schedule 1. |
| LeaseAccrualScheduleSchedule1RemainderAmount | The accrual amount remainder leftover for current period due to the rounding logic. This should be included in the next period. |
| LeaseAccrualScheduleSchedule2Amount | The accrual schedule amount for schedule 2. |
| LeaseAccrualScheduleSchedule2RemainderAmount | The accrual amount remainder leftover for current period due to the rounding logic. This should be included in the next period. |
| LeaseAccrualScheduleSchedule3Amount | The accrual schedule amount for schedule 3. |
| LeaseAccrualScheduleSchedule3RemainderAmount | The accrual amount remainder leftover for current period due to the rounding logic. This should be included in the next period. |
| LeaseAccrualScheduleSchedule4Amount | The accrual schedule amount for schedule 4. |
| LeaseAccrualScheduleSchedule4RemainderAmount | The accrual amount remainder leftover for current period due to the rounding logic. This should be included in the next period. |
| LeaseAccrualScheduleSchedule5Amount | The accrual schedule amount for schedule 5. |
| LeaseAccrualScheduleSchedule5RemainderAmount | The accrual amount remainder leftover for current period due to the rounding logic. This should be included in the next period. |
| LeaseAccrualScheduleScheduleDate | Indicates the schedule date which is the end date of the accrual period. |
| LeaseAccrualScheduleScheduleHeaderId | The schedule header's unique identifier from FLA_SCHEDULE_HEADER table. |
| LeaseAccrualScheduleSchedulesBatchId | The batch identifier for the schedules generation batch. |
| LeaseAccrualScheduleSchedulingVersionNum | The version of the schedule generation. |
| LeaseAccrualScheduleVersionNum | The version number of the lease as captured in FLA_LEASE_DETAILS table. |