Lease Balances
These are the lease balances
Data Store Key : FscmTopModelAM.FinExtractAM.FlaBiccExtractAM.LeaseBalancesExtractPVO
Primary Keys : LeaseBalanceLeaseBalanceId
Initial Extract Date : LeaseBalanceCreationDate
Incremental Extract Date : LeaseBalanceLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| LeaseBalanceAccruedLiabilityAmount | This is the interest amount accrued in the period. |
| LeaseBalanceAccruedRouAmount | This is the right-of-use amount accrued in the period. |
| LeaseBalanceAdjustedLiabilityAmount | This is the liability adjustment amount resulting from amendments in the period. |
| LeaseBalanceAdjustedRouAmount | This is the right-of-use amount adjustment amount resulting from amendments in the period. |
| LeaseBalanceBalanceTypeCode | Indicates the type of balance. Possible values are scheduled, accounted and final accounted. |
| LeaseBalanceBalancesVersionNum | This is the version of the transaction balances. |
| LeaseBalanceBookedLiabilityAmount | This is the additional liability amount resulting from bookings or amendments in the period. |
| LeaseBalanceBookedRouAmount | This is the additional right-of-use amount resulting from bookings or amendments in the period. |
| LeaseBalanceClosingLiabilityAmount | This is the closing liability at the end of the period. |
| LeaseBalanceClosingRouAmount | This is the closing right-of-use amount at the end of the period. |
| LeaseBalanceContingentExpenseAmount | The contingent expense amount calculated during the period. |
| LeaseBalanceCreatedBy | Indicates the user who created the row. |
| LeaseBalanceCreationDate | Indicates the date and time of the creation of the row. |
| LeaseBalanceCurrencyCode | The currency code of the lease payment. |
| LeaseBalanceExpiredRouAmount | The expired right-of-use amount during the period. |
| LeaseBalanceJobDefinitionName | Indicates the name of the job that created or last updated the row. |
| LeaseBalanceJobDefinitionPackage | Indicates the package name of the job that created or last updated the row. |
| LeaseBalanceLastUpdateDate | Indicates the date and time of the last update of the row. |
| LeaseBalanceLastUpdateLogin | Indicates the session login associated to the user who last updated the row. |
| LeaseBalanceLastUpdatedBy | Indicates the user who last updated the row. |
| LeaseBalanceLeaseBalanceId | The unique lease balance identifier. |
| LeaseBalanceLeaseDetailId | The lease detail identifier. It's referenced from the FLA_LEASE_DETAILS table. |
| LeaseBalanceLeaseId | The lease identifier. It references the primary key of the FLA_LEASES_ALL table. |
| LeaseBalanceLedgerId | The ledger identifier as defined in General Ledger. |
| LeaseBalanceObjectVersionNumber | 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. |
| LeaseBalanceOpeningLiabilityAmount | The opening liability amount at the start of the period. |
| LeaseBalanceOpeningRouAmount | The opening right-of-use amount at the start of the period. |
| LeaseBalanceOrgId | Indicates the identifier of the business unit associated to the row. |
| LeaseBalancePaidLiabilityAmount | The liability paid to the supplier in the period. |
| LeaseBalancePaymentNumber | The payment number. it's referenced from the FLA_LEASE_PAYMENT_HEADERS table. |
| LeaseBalancePeriodClosedFlag | Indicates if the period is closed or not. |
| LeaseBalancePeriodEndDate | The end date of the accounting period. |
| LeaseBalancePeriodName | The period name of the accounting period. |
| LeaseBalancePeriodStartDate | The start date of the accounting period. |
| LeaseBalanceReducedLiabilityAmount | The liability reduction amount resulting from amendments in the period. |
| LeaseBalanceReducedRouAmount | The right-of-use reduction amount resulting from amendments in the period. |
| LeaseBalanceRegimeCode | The regime code. This drives the accounting model and reporting for the lease. |
| LeaseBalanceRequestId | Indicates the request ID of the job that created or last updated the row in the Enterprise Service Scheduler. |