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