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.