Lease Payment Detail
Analyze by Date: Payment Detail Due Date
| Measure | Source and/or calculation |
|---|---|
| Base Currency Rate | Lease.BaseCurrencyRate |
| Base Payment Amount | BasePaymentAmount |
| Compute Base Amount | ComputeBaseAmount |
| Last Payment Number | LastPaymentNumber |
| Lease Cost |
IF ExecutoryCostCode <> NULL THEN 0 ELSE IF Lease_ExerciseExtension = true THEN BasePaymentAmount ELSE IF StraightLine = true THEN StraightLineAmount ELSE BasePaymentAmount |
| Lease Payment Detail Count | LeasePaymentDetail record count |
| Net Change To Present Value | NetChangeToPresentValue |
| Payment Amount | PaymentAmount |
| Payment Detail Base Interest Amount |
IF Lease.LeaseClassification <> Finance AND ExecutoryCostCode <> NULL THEN 0 ELSE LeasePaymentPeriodBalance.InterestAmount |
| Payment Detail Base Lease Expense |
IF Lease.LeaseClassification <> Operating AND ExecutoryCostCode <> NULL THEN 0 ELSE LeasePaymentPeriodBalance.LeaseExpense |
| Payment Detail Base ROU Reduction |
IF Lease.LeaseClassification Classification <> Finance AND ExecutoryCostCode <> NULL THEN 0 ELSE LeasePaymentPeriodBalance.ROUReduction |
| Payment Detail Finance Lease Cost |
IF LeasePaymentPeriodBalance.ROUReduction <> NULL OR LeasePaymentPeriodBalance.InterestAmount <> NULL THEN IF Lease.LeaseClassification = Finance THEN LeasePaymentPeriodBalance.ROUReduction + LeasePaymentPeriodBalance.InterestAmount IFLease.LeaseClassification = Operating THEN 0 |
| Payment Detail Implicit Interest Rate | ImplicitInterestRate |
| Payment Detail Interest Rate | InterestRate |
| Payment Detail Operating Lease Cost |
IF Lease.LeaseClassification = Operating THEN IF Lease.LongTermOperatingLease = true OR AdoptedLongTermOperatingLease = true THEN LeasePaymentPeriodBalance.LeaseExpense |
| Payment Detail Short Term Lease Cost |
IF Lease.LeaseClassification = Operating AND Lease.LongTermOperatingLease = false AND ExecutoryCostCode = NULL THEN IF StraightLine = Yes THEN Lease Cost * Lease.BaseCurrencyRate ELSE Lease Cost |
| Payment Number | LeasePaymentDetailPaymentNumber |
| Payment Plus Tax Amount |
IF TransactionLandTax <> NULL THEN PaymentAmount + TransactionLandTax ELSE PaymentAmount |
| Straight Line Amount | StraightLineAmount |
| Total Invoice Tax Amount | TotalInvoiceTaxAmount |
| Total Payment Amount | TotalPaymentAmount |
| Total Tax Amount | TotalTaxAmount |
| Transaction Taxable Amount | TransactionTaxableAmount |
| Unreleased Payment Count | Count IF Released <> 'true' |