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