Franchise Management measures
Franchise Contract
| Measure | Source and/or calculation |
|---|---|
| Active Count |
IF [FR Franchise Contract.Active] = 'Yes' THEN [Active Count] = 1 [Inactive Count] = 0 ELSE [Active Count] = 0 [Inactive Count] = 1 END IF |
| Aggregate Count |
IF [FR Franchise Contract.Sales Flag Code] = 'Y' THEN [Aggregate Count] = 1 [Non Aggregate Count] = 0 ELSE [Aggregate Count] = 0 [Non Aggregate Count] = 1 END IF |
| Franchise Contract Count |
IF [FR Franchise Contract.Sales Flag Code] = 'Y' THEN [Aggregate Count] = 1 [Non Aggregate Count] = 0 ELSE [Aggregate Count] = 0 [Non Aggregate Count] = 1 END IF |
| Inactive Count |
IF [FR Franchise Contract.Active] = 'Yes' THEN [Active Count] = 1 [Inactive Count] = 0 ELSE [Active Count] = 0 [Inactive Count] = 1 END IF |
| Non Aggregate Count |
IF [FR Franchise Contract.Sales Flag Code] = 'Y' THEN [Aggregate Count] = 1 [Non Aggregate Count] = 0 ELSE [Aggregate Count] = 0 [Non Aggregate Count] = 1 END IF |
| Non Taxable Count |
IF [FR Franchise Contract.Taxable Flag Code] = 'E' THEN [Taxable Count] = 0 [Non Taxable Count] = 1 ELSE [Taxable Count] = 1 [Non Taxable Count] = 0 END IF |
| Taxable Count |
IF [FR Franchise Contract.Taxable Flag Code] = 'E' THEN [Taxable Count] = 0 [Non Taxable Count] = 1 ELSE [Taxable Count] = 1 [Non Taxable Count] = 0 END IF |
| Variance Limit | FranchiseContract.VarianceLimit |
Franchise Contract Charge
| Measure | Source and/or calculation |
|---|---|
| Base Amount | FranchiseContractCharge.BaseAmount |
| Current Balance | FranchiseContractCharge.CurrentBalance |
| Franchise Standard Charge Percent | FranchiseContractCharge.FranchiseStandardCharge_Percent |
| Interest Rate | FranchiseContractCharge.InterestRate |
| Maximum Amount | FranchiseContractCharge.MaximumAmount |
| Minimum Amount | FranchiseContractCharge.MinimumAmount |
| Note Amount | FranchiseContractCharge.NoteAmount |
| Number Of Payments | FranchiseContractCharge.NumberOfPayments |
| Payment Amount | IFNULL([FSM_FranchiseContractCharge.PaymentAmount],0.0) |
| Percent Of Sales | FranchiseContractCharge.PercentOfSales |
| Remaining Payments | IFNULL([FSM_FranchiseContractCharge.RemainingPayments],0) |
| Step Limit 01 | FranchiseContractCharge.StepLimit1 |
| Step Limit 02 | FranchiseContractCharge.StepLimit2 |
| Step Limit 03 | FranchiseContractCharge.StepLimit3 |
| Step Limit 04 | FranchiseContractCharge.StepLimit4 |
| Step Limit 05 | FranchiseContractCharge.StepLimit5 |
| Step Limit 06 | FranchiseContractCharge.StepLimit6 |
| Step Limit 07 | FranchiseContractCharge.StepLimit7 |
| Step Limit 08 | FranchiseContractCharge.StepLimit8 |
| Step Limit 09 | FranchiseContractCharge.StepLimit9 |
| Step Limit 10 | FranchiseContractCharge.StepLimit10 |
| Step Percent 01 | FranchiseContractCharge.StepPercent1 |
| Step Percent 02 | FranchiseContractCharge.StepPercent2 |
| Step Percent 03 | FranchiseContractCharge.StepPercent3 |
| Step Percent 04 | FranchiseContractCharge.StepPercent4 |
| Step Percent 05 | FranchiseContractCharge.StepPercent5 |
| Step Percent 06 | FranchiseContractCharge.StepPercent6 |
| Step Percent 07 | FranchiseContractCharge.StepPercent7 |
| Step Percent 08 | FranchiseContractCharge.StepPercent8 |
| Step Percent 09 | FranchiseContractCharge.StepPercent9 |
| Step Percent 10 | FranchiseContractCharge.StepPercent10 |
| Total Remaining Amount | FranchiseContractCharge.TotalRemainingAmount |
Franchise Contract Charge
| Measure | Source and/or calculation |
|---|---|
| Prepayment Amount | FranchisePrepayment.TransactionAmount |
Franchise Sales
| Measure | Source and/or calculation |
|---|---|
| Adjustments | FranchiseSales.Adjustments |
| Closing Sales | FranchiseSales.ClosingSales |
| Net Sales | FranchiseSales.NetSales |
| Sales Tax | FranchiseSales.SalesTax |
| Total Adjustment | FranchiseSales.TotalAdjustment |
| Total Charges | FranchiseSales.TotalCharges |
| Total Closing Sales | FranchiseSales.TotalClosingSales |
| Total Due | FranchiseSales.TotalDue |
| Total Net Sales | FranchiseSales.TotalNetSales |
| Total Sales Tax | FranchiseSales.TotalSalesTax |
| Total Variance | FranchiseSales.TotalVariance |