Franchise Management measures

Measure name Table name Source field
Adjustments FRSALES ADJUSTMENTS
Base Amount FRCHARGE BASE_AMOUNT
Charge To Date FRCHARGE CHARGE_TO_DATE
Closing Sales FRSALES REGISTER_CLOSE
Current Balance FRCHARGE CURRENT_BAL
Franchise Contract Charge FRCHARGE SEQ
Franchise Contract Charge Count FRCHARGE COUNT(FranchiseContractChargeKey)
Franchise Payment Count FRPREPAY COUNT(FranchisePrepaymentKey)
Franchise Sales Count FRSALES COUNT(FranchiseSalesKey)
Interest Rate FRCHARGE INTEREST_RATE
Maximum Amount FRCHARGE MAX_AMOUNT
Minimum Amount FRCHARGE MIN_AMOUNT
Net Sales FRSALES NET_SALES
Note Amount FRCHARGE NOTE_AMOUNT
Number Of Payments FRCHARGE NBR_OF_PMTS
Payment Amount FRCHARGE PAYMNT_AMT
Percent Of Sales FRCHARGE PERC_OF_SALES
Prepayment Amount FRPREPAY TRAN_AMT
Remaining Payments FRCHARGE REMAINING_PMTS
Sales Tax FRSALES SALES_TAX
Step Limit 1 FRCHARGE STEP_LIMIT_01
Step Limit 10 FRCHARGE STEP_LIMIT_10
Step Limit 2 FRCHARGE STEP_LIMIT_02
Step Limit 3 FRCHARGE STEP_LIMIT_03
Step Limit 4 FRCHARGE STEP_LIMIT_04
Step Limit 5 FRCHARGE STEP_LIMIT_05
Step Limit 6 FRCHARGE STEP_LIMIT_06
Step Limit 7 FRCHARGE STEP_LIMIT_07
Step Limit 8 FRCHARGE STEP_LIMIT_08
Step Limit 9 FRCHARGE STEP_LIMIT_09
Step Percent 1 FRCHARGE STEP_PCT_01
Step Percent 10 FRCHARGE STEP_PCT_10
Step Percent 2 FRCHARGE STEP_PCT_02
Step Percent 3 FRCHARGE STEP_PCT_03
Step Percent 4 FRCHARGE STEP_PCT_04
Step Percent 5 FRCHARGE STEP_PCT_05
Step Percent 6 FRCHARGE STEP_PCT_06
Step Percent 7 FRCHARGE STEP_PCT_07
Step Percent 8 FRCHARGE STEP_PCT_08
Step Percent 9 FRCHARGE STEP_PCT_09
Total Adjustment FRSALES TTL_ADJUSTMENT
Total Charges FRSALES TTL_CHARGES
Total Closing Sales FRSALES TTL_REG_CLOSE
Total Due FRSALES TTL_DUE
Total Estimates FRCONTMAST TTL_ESTIMATES
Total Net Sales FRSALES TTL_NET_SALES
Total Remaining Amount FRCHARGE PAYMNT_AMT*NBR_OF_PMTS
Total Sales Tax FRSALES TTL_SALES_TAX
Total Variance FRSALES TTL_VARIANCE
Variance Limit FRCONTMAST VARIANCE_LIMIT