Lease Accounting measures
Lease
Measure | Source and/or calculation |
---|---|
Base Currency Rate | Lease.Base Currency Rate |
Discount Rate | if(ImplicitInterestRate != '', ImplicitInterestRate, InterestRate) |
Downpayment Transaction Amount | Lease.DownPayment.TransactionAmount |
Incentive Amount | Lease.IncentiveAmount |
Interest Rate | Lease.InterestRate |
Interest Rate times NPV | InterestRate * NetPresentValue.TransactionAmount |
Land Value Transaction Amount | Lease.LandValue.TransactionAmount |
Lease Count | Lease.LeaseKey |
Lease Obligation Base Transaction Amount | Lease.LeaseObligation.BaseAmount.TransactionAmount |
Lease ROU Asset Amount Base Amount Entered Currency Amount | Lease.LeaseROUAssetAmount.BaseAmount.EnteredCurrencyAmount |
Net Present Value Transaction Amount | Lease.NetPresentValue.TransactionAmount |
Remaining Finance Lease Obligation Transaction Amount |
IF [LM Lease.Lease Classification] = 'Finance' THEN IF [Level(Lease Invoice Distribution Summary.Lease Invoice Distribution Summary).Sum of Base Principal Amount] IS NULL THEN [Remaining Finance Lease Obligation Transaction Amount] = [LM Lease.Lease Obligation Base Transaction Amount] - [LM Lease.Downpayment Transaction Amount] ELSE [Remaining Finance Lease Obligation Transaction Amount] = [LM Lease.Lease Obligation Base Transaction Amount] - [LM Lease.Downpayment Transaction Amount] - [Level(Lease Invoice Distribution Summary.Lease Invoice Distribution Summary).Sum of Base Principal Amount] END IF ELSE [Remaining Finance Lease Obligation Transaction Amount] = 0 END IF |
Remaining Life | Lease.RemainingLife |
Remaining Life times NPV | RemainingLife * NetPresentValue.TransactionAmount |
Remaining Operating Lease Obligation Transaction Amount |
IF [LM Lease.Long Term Operating Lease] = 'Yes' AND [LM Lease.Lease Classification] = 'Operating' THEN IF [Level(Lease Invoice Distribution Summary.Lease Invoice Distribution Summary).Sum of Base Distribution Amount] IS NULL THEN [Remaining Operating Lease Obligation Transaction Amount] = [LM Lease.Lease Obligation Base Transaction Amount] - [LM Lease.Downpayment Transaction Amount] ELSE [Remaining Operating Lease Obligation Transaction Amount] = [LM Lease.Lease Obligation Base Transaction Amount] - [LM Lease.Downpayment Transaction Amount] - [Level(Lease Invoice Distribution Summary.Lease Invoice Distribution Summary).Sum of Base Distribution Amount] END IF ELSEIF [LM Lease.Long Term Operating Lease] = 'No' AND [LM Lease.Lease Classification] = 'Operating' THEN [Remaining Operating Lease Obligation Transaction Amount] = Integer([Level(Lease Payment Detail Summary.Lease Payment Detail Summary).Sum of Base Payment Amount]) - Integer(SUM([Level(Lease Payment Balance.Lease Payment Balance).Payment Balance Amount])) ELSE [Remaining Operating Lease Obligation Transaction Amount] = 0 END IF |
Sum of Base Distribution Amount | [Level(Lease Invoice Distribution Summary.Lease Invoice Distribution Summary).Sum of Base Distribution Amount] |
Sum of Base Payment Amount | [Level(Lease Payment Detail Summary.Lease Payment Detail Summary).Sum of Base Payment Amount] |
Sum of Base Principal Amount | [Level(Lease Invoice Distribution Summary.Lease Invoice Distribution Summary).Sum of Base Principal Amount] |
Sum of Lease Invoice Distribution Count | [Level(Lease Invoice Distribution Summary.Lease Invoice Distribution Summary).Sum of Lease Invoice Distribution Count] |
Sum of Payment Balance Amount | SUM([Level(Lease Payment Balance.Lease Payment Balance).Payment Balance Amount]) |
Sum of Remaining Lease Base Payment Amount |
IF [Level(Lease Payment Detail Summary.Lease Payment Detail Summary).Sum of Unreleased Base Payment Amount] IS NULL THEN [Sum of Remaining Lease Base Payment Amount] = 0 ELSE [Sum of Remaining Lease Base Payment Amount] = [Level(Lease Payment Detail Summary.Lease Payment Detail Summary).Sum of Unreleased Base Payment Amount] END IF |
Sum of Remaining Lease Payment Count |
IF [Level(Lease Payment Detail Summary.Lease Payment Detail Summary).Sum of Unreleased Payment Count] IS NULL THEN [Sum of Remaining Lease Payment Count] = 0 ELSE [Sum of Remaining Lease Payment Count] = [Level(Lease Payment Detail Summary.Lease Payment Detail Summary).Sum of Unreleased Payment Count] END IF |
Total Life | Lease.TotalLife |
Lease Currency Payment Period Balance
Measure | Source and/or calculation |
---|---|
Lease Currency Payment Amount | LeaseCurrencyPaymentPeriodBalance.Amount |
Lease Currency Payment Interest Amount | LeaseCurrencyPaymentPeriodBalance.InterestAmount |
Lease Currency Payment Interest Tax Amount | LeaseCurrencyPaymentPeriodBalance.InterestTaxAmount |
Lease Currency Payment Lease Expense | LeaseCurrencyPaymentPeriodBalance.LeaseExpense |
Lease Currency Payment Liability Balance | LeaseCurrencyPaymentPeriodBalance.LiabilityBalance |
Lease Currency Payment Principal Amount | LeaseCurrencyPaymentPeriodBalance.PrincipalAmount |
Lease Currency Payment Principal Tax Amount | LeaseCurrencyPaymentPeriodBalance.PrincipalTaxAmount |
Lease Currency Payment ROU Balance | LeaseCurrencyPaymentPeriodBalance.ROUBalance |
Lease Currency Payment ROU Reduction | LeaseCurrencyPaymentPeriodBalance.ROUReduction |
Lease Date Code
Measure | Source and/or calculation |
---|---|
Lease Date Code Count | LeaseDateCode.LeaseDateCodeCount |
Lease Invoice
Measure | Source and/or calculation |
---|---|
Base Invoice Amount | LeaseInvoice.BaseInvoiceAmount |
Base Tax Amount | LeaseInvoice.BaseTaxAmount |
Lease Invoice Count | LeaseInvoice.UniqueID |
Original Conversion Rate | LeaseInvoice.OriginalConversionRate |
Transaction Invoice Amount | LeaseInvoice.TransactionInvoiceAmount |
Transaction Tax Amount | LeaseInvoice.TransactionTaxAmount |
Transaction Taxable Amount | LeaseInvoice.TransactionTaxableAmount |
Lease Invoice Distribution
Measure | Source and/or calculation |
---|---|
Base Distribution Amount | LeaseInvoiceDistribution.BaseDistributionAmount |
Base Interest Amount | LeaseInvoiceDistribution.BaseInterestAmount |
Base Principal Amount | LeaseInvoiceDistribution.BasePrincipalAmount |
Distribution Amount | LeaseInvoiceDistribution.DistributionAmount |
Invoice Distribution Interest Amount | LeaseInvoiceDistribution.InterestAmount |
Lease Invoice Distribution Count | LeaseInvoiceDistribution.LeaseInvoiceDistributionKey |
To Base Amount | LeaseInvoiceDistribution.ToBaseAmount |
To Base Rate | LeaseInvoiceDistribution.ToBaseRate |
Lease Invoice Distribution Summary
Measure | Source and/or calculation |
---|---|
Sum of Base Distribution Amount | SUM([Level(Lease Invoice Distribution.Lease Invoice Distribution).Base Distribution Amount]) |
Sum of Base Principal Amount |
IF SUM([Level(Lease Invoice Distribution.Lease Invoice Distribution).Base Principal Amount]) IS NULL THEN [Sum of Base Principal Amount] = 0 ELSE [Sum of Base Principal Amount] = SUM([Level(Lease Invoice Distribution.Lease Invoice Distribution).Base Principal Amount]) END IF |
Sum of Lease Invoice Distribution Count | SUM([Level(Lease Invoice Distribution.Lease Invoice Distribution).Lease Invoice Distribution Count]) |
Lease Invoice Interest
Measure | Source and/or calculation |
---|---|
Base Interest Amount | LeaseInvoiceInterest.BaseInterestAmount |
Interest Amount | LeaseInvoiceInterest.InterestAmount |
To Base Amount | LeaseInvoiceInterest.ToBaseAmount |
To Base Interest | LeaseInvoiceInterest.ToBaseInterest |
To Base Interest Rate | LeaseInvoiceInterest.ToBaseInterestRate |
To Base Principal | LeaseInvoiceInterest.ToBasePrincipal |
Lease Payment
Measure | Source and/or calculation |
---|---|
Lease Payment Count | LeasePayment.LeasePaymentKey |
Straight Line Amount | LeasePayment.StraightLineAmount |
Total Non Exec Payment Amount | LeasePayment.TotalNonExecPaymentAmount |
Total Non Exec Payment Count | LeasePayment.TotalNonExecPaymentCount |
Total Payment Amounts | LeasePayment.TotalPaymentAmounts |
Lease Payment Balance Fact
Measure | Source and/or calculation |
---|---|
Balance Amount | LeasePaymentBalance.BalanceAmount |
Begin Oblig | LeasePaymentBalance.BeginOblig |
Beginning Balance Amount | LeasePaymentBalance.BeginningBalanceAmount |
Interest Balance Amount | LeasePaymentBalance.InterestBalanceAmount |
Interest Tax Amount | LeasePaymentBalance.InterestTaxAmount |
Lease Payment Balance Count | LeasePaymentBalance.LeasePaymentBalanceKey |
Payment Balance Amount | LeasePaymentBalance.BalanceAmount |
Principal Balance Amount | LeasePaymentBalance.PrincipalBalanceAmount |
Principal Tax Amount | LeasePaymentBalance.PrincipalTaxAmount |
Remain Oblig | LeasePaymentBalance.RemainOblig |
Lease Payment Detail
Measure | Source and/or calculation |
---|---|
Base Currency Rate | [Level(Cache Lease.LeaseKey).Base Currency Rate] |
Base Payment Amount | LeasePaymentDetail.BasePaymentAmount |
Compute Base Amount | LeasePaymentDetail.ComputeBaseAmount |
Last Payment Number | LeasePaymentDetail.LastPaymentNumber |
Lease Cost |
IF [LM Lease Payment Detail.Executory Cost Code] IS NULL THEN [Lease Cost] = [LM Lease Payment Detail.Lease Cost] ELSE [Lease Cost] = 0 END IF |
Lease Payment Detail Count | LeasePaymentDetail.LeasePaymentDetailCount |
Net Change To Present Value | LeasePaymentDetail.NetChangeToPresentValue |
Payment Amount | LeasePaymentDetail.PaymentAmount |
Payment Detail Base Interest Amount |
IF ([Level(Cache Lease.LeaseKey).Lease Classification] = 'Finance' AND [LM Lease Payment Detail.Executory Cost Code] IS NULL) THEN [Payment Detail Base ROU Reduction] = [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base ROU Reduction] [Payment Detail Base Interest Amount] = [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base Interest Amount] ELSE [Payment Detail Base ROU Reduction] = 0 [Payment Detail Base Interest Amount] =0 END IF |
Payment Detail Base Lease Expense |
IF ([Level(Cache Lease.LeaseKey).Lease Classification] = 'Operating' AND [LM Lease Payment Detail.Executory Cost Code] IS NULL) [Payment Detail Base Lease Expense] = [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base Lease Expense] ELSE [Payment Detail Base Lease Expense] = 0 END IF |
Payment Detail Base ROU Reduction |
IF ([Level(Cache Lease.LeaseKey).Lease Classification] = 'Finance' AND [LM Lease Payment Detail.Executory Cost Code] IS NULL) THEN [Payment Detail Base ROU Reduction] = [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base ROU Reduction] [Payment Detail Base Interest Amount] = [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base Interest Amount] ELSE [Payment Detail Base ROU Reduction] = 0 [Payment Detail Base Interest Amount] =0 END IF |
Payment Detail Finance Lease Cost |
IF [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base ROU Reduction] IS NOT NULL OR [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base Interest Amount] IS NOT NULL THEN IF [Level(Cache Lease.LeaseKey).Lease Classification] = 'Finance' THEN [Payment Detail Finance Lease Cost] = [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base ROU Reduction] + [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base Interest Amount] [Payment Detail Short Term Lease Cost] = 0 [Payment Detail Operating Lease Cost] = 0 END IF END IF IF [Level(Cache Lease.LeaseKey).Lease Classification] = 'Operating' THEN IF [Level(Cache Lease.LeaseKey).Long Term Operating Lease] = 'Yes' OR [Level(Cache Lease.LeaseKey).Adopted Long Term Operating Lease] = 'Yes' THEN [Payment Detail Operating Lease Cost] = [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base Lease Expense] [Payment Detail Finance Lease Cost] = 0 [Payment Detail Short Term Lease Cost] = 0 END IF END IF |
Payment Detail Implicit Interest Rate | LeasePaymentDetail.Lease.ImplicitInterestRate |
Payment Detail Interest Rate | LeasePaymentDetail.Lease.InterestRate |
Payment Detail Operating Lease Cost |
IF [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base ROU Reduction] IS NOT NULL OR [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base Interest Amount] IS NOT NULL THEN IF [Level(Cache Lease.LeaseKey).Lease Classification] = 'Finance' THEN [Payment Detail Finance Lease Cost] = [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base ROU Reduction] + [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base Interest Amount] [Payment Detail Short Term Lease Cost] = 0 [Payment Detail Operating Lease Cost] = 0 END IF END IF IF [Level(Cache Lease.LeaseKey).Lease Classification] = 'Operating' THEN IF [Level(Cache Lease.LeaseKey).Long Term Operating Lease] = 'Yes' OR [Level(Cache Lease.LeaseKey).Adopted Long Term Operating Lease] = 'Yes' THEN [Payment Detail Operating Lease Cost] = [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base Lease Expense] [Payment Detail Finance Lease Cost] = 0 [Payment Detail Short Term Lease Cost] = 0 END IF END IF |
Payment Detail Short Term Lease Cost |
IF [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base ROU Reduction] IS NOT NULL OR [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base Interest Amount] IS NOT NULL THEN IF [Level(Cache Lease.LeaseKey).Lease Classification] = 'Finance' THEN [Payment Detail Finance Lease Cost] = [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base ROU Reduction] + [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base Interest Amount] [Payment Detail Short Term Lease Cost] = 0 [Payment Detail Operating Lease Cost] = 0 END IF END IF IF [Level(Cache Lease.LeaseKey).Lease Classification] = 'Operating' THEN IF [Level(Cache Lease.LeaseKey).Long Term Operating Lease] = 'Yes' OR [Level(Cache Lease.LeaseKey).Adopted Long Term Operating Lease] = 'Yes' THEN [Payment Detail Operating Lease Cost] = [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base Lease Expense] [Payment Detail Finance Lease Cost] = 0 [Payment Detail Short Term Lease Cost] = 0 END IF END IF |
Payment Number | LeasePaymentDetail.LeasePaymentDetail.PaymentNumber |
Payment Plus Tax Amount |
IF ([FSM_LeasePaymentDetail.TransactionLandTax] <> NULL) THEN [Payment Plus Tax Amount] = [FSM_LeasePaymentDetail.PaymentAmount] + [FSM_LeasePaymentDetail.TransactionLandTax] ELSE [Payment Plus Tax Amount] = [FSM_LeasePaymentDetail.PaymentAmount] END IF |
Straight Line Amount | LeasePaymentDetail.StraightLineAmount |
Total Invoice Tax Amount | LeasePaymentDetail.TotalInvoiceTaxAmount |
Total Payment Amount | LeasePaymentDetail.TotalPaymentAmount |
Total Tax Amount | LeasePaymentDetail.TotalTaxAmount |
Transaction Taxable Amount | LeasePaymentDetail.TransactionTaxableAmount |
Unreleased Payment Count |
IF [FSM_LeasePaymentDetail.Released] = 'true' THEN [Unreleased Payment Count]= 0 ELSE [Unreleased Payment Count] = 1 END IF |
Lease Detail Summary
Measure | Source and/or calculation |
---|---|
Sum of Base Payment Amount | SUM([Level(Lease Payment Detail.Lease Payment Detail).Base Payment Amount]) |
Sum of Unreleased Base Payment Amount |
IF SUM([Level(Lease Payment Detail.Lease Payment Detail).Base Payment Amount]) IS NOT NULL AND Sum([Level(Lease Payment Detail.Lease Payment Detail).Unreleased Payment Count]) <> 0 THEN [Sum of Unreleased Base Payment Amount] = SUM([Level(Lease Payment Detail.Lease Payment Detail).Base Payment Amount]) ELSE [Sum of Unreleased Base Payment Amount] = 0 END IF |
Sum of Unreleased Payment Count |
IF SUM([Level(Lease Payment Detail.Lease Payment Detail).Unreleased Payment Count]) IS NULL THEN [Sum of Unreleased Payment Count] = 0 ELSE [Sum of Unreleased Payment Count] = SUM([Level(Lease Payment Detail.Lease Payment Detail).Unreleased Payment Count]) END IF |
Lease Payment Period Balance
Measure | Source and/or calculation |
---|---|
Discount Rate | [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Discount Rate] |
Interest Rate | [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Interest Rate] |
Lease Payment Period Balance | [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Lease Payment Period Balance Date] |
Lease Payment Period Balance Count | [v_Count] |
Lease Term | [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Lease Term] |
Period Balance Base Currency Rate | [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base Currency Rate] |
Period Balance Base Interest Amount | [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base Interest Amount] |
Period Balance Base Lease Expense | [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base Lease Expense] |
Period Balance Base Liability Balance | [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base Liability Balance] |
Period Balance Base Payment Amount | [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base Payment Amount] |
Period Balance Base Principal Amount | [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base Principal Amount] |
Period Balance Base ROU Balance | [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base ROU Balance |
Period Balance Base ROU Reduction | [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base ROU Reduction] |
Period Balance Base Running Payment Amount | [v_PeriodBalanceRunningPaymentAmount] |
Period Balance Count Payment Amount | [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Count Payment Amount] |
Period Balance Finance Lease Cost |
IF [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Lease Classification] = 'Finance' THEN [Period Balance Finance Lease Cost] = IFNULL([Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base ROU Reduction], 0.00) + IFNULL([Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base Interest Amount], 0.00) ELSE [Period Balance Finance Lease Cost] = 0 END IF |
Period Balance Interest Tax Amount | [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Interest Tax Amount] |
Period Balance Operating Lease Cost |
IF [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Lease Classification] = 'Operating' AND ([Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Long Term Operating Lease] = 'Yes' OR [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Adopted Long Term Operating Lease] = 'Yes') THEN [Period Balance Operating Lease Cost] = [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Base Lease Expense] ELSE [Period Balance Operating Lease Cost] = 0 END IF |
Period Balance Payment Number | [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Payment Number] |
Period Balance Principal Tax Amount | [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Principal Tax Amount] |
Period Balance Remaining Base Liability Balance | [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Remaining Base Liability Balance] |
Period Balance Remaining Payment Amount | IFNULL([Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Total Payment Amounts],0.00) - [v_PeriodBalanceRunningPaymentAmount] |
Period Balance Remaining Payment Amounts | [v_PeriodBalanceRemainingPaymentAmount] |
Period Balance Remaining Payment Months | IFNULL([Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Total Non Exec Payment Count],0) - [v_Count] |
Period Balance Running Interest Amount | [v_PeriodBalanceRunningInterestAmount] |
Period Balance Running Lease Expense | [v_PeriodBalanceRunningLeaseExpense] |
Period Balance Running Principal Amount | [v_PeriodBalanceRunningPrincipalAmount] |
Period Balance Running ROU Balance | [v_PeriodBalanceRunningROUBalance] |
Period Balance Running ROU Reduction | [v_PeriodBalanceRunningROUReduction] |
Period Balance Short Term Lease Cost | [v_PeriodBalanceShortTermLeaseCost] |
Period Balance Straight Line Amount | [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Straight Line Amount] |
Period Balance Total Interest Amount | [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Total Interest Amount] |
Period Balance Total Liability Balance | [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Total Liability Balance] |
Period Balance Total Non Exec Payment Amount | [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Total Non Exec Payment Amount] |
Period Balance Total Non Exec Payment Count | [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Total Non Exec Payment Count] |
Period Balance Total Payment Amount | [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Total Payment Amount] |
Period Balance Total Payment Amounts | [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Total Payment Amounts] |
Period Balance Total Principal Amount | [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Total Principal Amount] |
Period Balance Total ROU Balance | [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Total ROU Balance] |
Period Balance Total ROU Reduction | [Level(Lease Payment Period Balance Staging.Lease Payment Period Balance Staging).Period Balance Total ROU Reduction] |
Lease Payment Period Balance Summary
Measure | Source and/or calculation |
---|---|
Period Balance Count Payment Amount | COUNT([LM Lease Payment Period Balance.Amount]) |
Period Balance Total Interest Amount | Sum( [LM Lease Payment Period Balance.Interest Amount]) |
Period Balance Total Liability Balance | Sum([LM Lease Payment Period Balance.Liability Balance]) |
Period Balance Total Payment Amount | Sum([LM Lease Payment Period Balance.Amount]) |
Period Balance Total Principal Amount | Sum([LM Lease Payment Period Balance.Principal Amount]) |
Period Balance Total ROU Balance | Sum([LM Lease Payment Period Balance.ROU Balance]) |
Period Balance Total ROU Reduction | Sum([LM Lease Payment Period Balance.ROU Reduction]) |
Lease Payment Period Balance Summary
Measure | Source and/or calculation |
---|---|
Lease Type Count | LeaseType.LeaseTypeCount |
Sublease
Measure | Source and/or calculation |
---|---|
Sublease Base Currency Rate | Sublease.BaseCurrencyRate |
Sublease Down Payment Base Amount Entered Currency Amount | Sublease.Sublease.DownPayment.BaseAmount.EnteredCurrencyAmount |
Sublease Down Payment Transaction Amount | Sublease.Sublease.DownPayment.TransactionAmount |
Sublease Incentive Amount Base Amount Entered Currency Amount | Sublease.Sublease.IncentiveAmount.BaseAmount.EnteredCurrencyAmount |
Sublease Initial Direct Cost Base Amount Entered Currency Amount | Sublease.Sublease.InitialDirectCost.BaseAmount.EnteredCurrencyAmount |
Sublease Initial Direct Cost Transaction Amount | Sublease.Sublease.InitialDirectCost.TransactionAmount |
Sublease Payments Per Year | Sublease.Sublease.PaymentsPerYear |
Sublease Termination Fee | Sublease.Sublease.Termination Fee |
Sublease Billing Invoice
Measure | Source and/or calculation |
---|---|
Invoice Amount Alternate Amount | SubleaseBillingInvoice.SubleaseBillingInvoice.InvoiceAmount.AlternateAmount.EnteredCurrencyAmount |
Invoice Amount Alternate Amount 2 | SubleaseBillingInvoice.SubleaseBillingInvoice.InvoiceAmount.AlternateAmount2.EnteredCurrencyAmount |
Invoice Amount Alternate Amount 3 | SubleaseBillingInvoice.SubleaseBillingInvoice.InvoiceAmount.AlternateAmount2.EnteredCurrencyAmount |
Invoice Amount Currency Amount | SubleaseBillingInvoice.SubleaseBillingInvoice.InvoiceAmount.CurrencyAmount |
Invoice Amount Functional Amount | SubleaseBillingInvoice.SubleaseBillingInvoice.InvoiceAmount.FunctionalAmount.EnteredCurrencyAmount |
Invoice Amount Project Amount | SubleaseBillingInvoice.SubleaseBillingInvoice.InvoiceAmount.ProjectAmount.EnteredCurrencyAmount |
Invoice Amount Report Amount 1 | SubleaseBillingInvoice.SubleaseBillingInvoice.InvoiceAmount.ReportAmount1.EnteredCurrencyAmount |
Invoice Amount Report Amount 2 | SubleaseBillingInvoice.SubleaseBillingInvoice.InvoiceAmount.ReportAmount2.EnteredCurrencyAmount |
Invoice Amount Report Amount 3 | SubleaseBillingInvoice.SubleaseBillingInvoice.InvoiceAmount.ReportAmount3.EnteredCurrencyAmount |
Invoice Amount Report Amount 4 | SubleaseBillingInvoice.SubleaseBillingInvoice.InvoiceAmount.ReportAmount4.EnteredCurrencyAmount |
Invoice Amount Report Amount 5 | SubleaseBillingInvoice.SubleaseBillingInvoice.InvoiceAmount.ReportAmount5.EnteredCurrencyAmount |
Invoice Amount To Alternate Amount | SubleaseBillingInvoice.SubleaseBillingInvoice.InvoiceAmount.ToAlternateAmount.EnteredCurrencyAmount |
Invoice Amount To Alternate Amount 2 | SubleaseBillingInvoice.SubleaseBillingInvoice.InvoiceAmount.ToAlternateAmount2.EnteredCurrencyAmount |
Invoice Amount To Alternate Amount 3 | SubleaseBillingInvoice.SubleaseBillingInvoice.InvoiceAmount.ToAlternateAmount3.EnteredCurrencyAmount |
Invoice Amount To Functional Amount | SubleaseBillingInvoice.SubleaseBillingInvoice.InvoiceAmount.ToFunctionalAmount.EnteredCurrencyAmount |
Tax Amount Alternate Amount | SubleaseBillingInvoice.SubleaseBillingInvoice.TaxAmount.AlternateAmount.EnteredCurrencyAmount |
Tax Amount Alternate Amount 2 | SubleaseBillingInvoice.SubleaseBillingInvoice.TaxAmount.AlternateAmount2.EnteredCurrencyAmount |
Tax Amount Alternate Amount 3 | SubleaseBillingInvoice.SubleaseBillingInvoice.TaxAmount.AlternateAmount3.EnteredCurrencyAmount |
Tax Amount Currency Amount | SubleaseBillingInvoice.SubleaseBillingInvoice.TaxAmount.CurrencyAmount |
Tax Amount Functional Amount | SubleaseBillingInvoice.SubleaseBillingInvoice.TaxAmount.FunctionalAmount.EnteredCurrencyAmount |
Tax Amount Project Amount | SubleaseBillingInvoice.SubleaseBillingInvoice.TaxAmount.ProjectAmount.EnteredCurrencyAmount |
Tax Amount Report Amount 1 | SubleaseBillingInvoice.SubleaseBillingInvoice.TaxAmount.ReportAmount1.EnteredCurrencyAmount |
Tax Amount Report Amount 2 | SubleaseBillingInvoice.SubleaseBillingInvoice.TaxAmount.ReportAmount2.EnteredCurrencyAmount |
Tax Amount Report Amount 3 | SubleaseBillingInvoice.SubleaseBillingInvoice.TaxAmount.ReportAmount3.EnteredCurrencyAmount |
Tax Amount Report Amount 4 | SubleaseBillingInvoice.SubleaseBillingInvoice.TaxAmount.ReportAmount4.EnteredCurrencyAmount |
Tax Amount Report Amount 5 | SubleaseBillingInvoice.SubleaseBillingInvoice.TaxAmount.ReportAmount5.EnteredCurrencyAmount |
Tax Amount To Alternate Amount | SubleaseBillingInvoice.SubleaseBillingInvoice.TaxAmount.ToAlternateAmount.EnteredCurrencyAmount |
Tax Amount To Alternate Amount 2 | SubleaseBillingInvoice.SubleaseBillingInvoice.TaxAmount.ToAlternateAmount2.EnteredCurrencyAmount |
Tax Amount To Alternate Amount 3 | SubleaseBillingInvoice.SubleaseBillingInvoice.TaxAmount.ToAlternateAmount3.EnteredCurrencyAmount |
Tax Amount To Functional Amount | SubleaseBillingInvoice.SubleaseBillingInvoice.TaxAmount.ToFunctionalAmount.EnteredCurrencyAmount |
Sublease Billing Schedule Detail
Measure | Source and/or calculation |
---|---|
Base Land Tax | SubleaseBillingScheduleDetail.BaseLandTax |
Base Taxable | SubleaseBillingScheduleDetail.BaseTaxable |
Percent Taxable | SubleaseBillingScheduleDetail.PercentTaxable |
Sublease Base Payment Amount | SubleaseBillingScheduleDetail.BasePaymentAmount |
Sublease Maximum Payment | SubleaseBillingScheduleDetail.MaximumPayment |
Sublease Payment Amount | SubleaseBillingScheduleDetail.PaymentAmount |
Sublease Straight Line Amount | SubleaseBillingScheduleDetail.SubleaseBillingSchedule.StraightLineAmount |
Sublease Transaction Taxable Amount | SubleaseBillingScheduleDetail.TransactionTaxableAmount |
Transaction Land Tax | SubleaseBillingScheduleDetail.TransactionLandTax |
Sublease Transaction
Measure | Source and/or calculation |
---|---|
Base Amount | SubleaseTransaction.SubleaseTransaction.TransactionAmount.BaseAmount.EnteredCurrencyAmount |
Transaction Amount | SubleaseTransaction.SubleaseTransaction.TransactionAmount.TransactionAmount |