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