Edit Customer Billing Plan

Base Settings

Plan Amount
Term Length

Taxes and Fees

State Tax
Enable USF fee
Card Reject Fee
Paper Invoice Charge
CID Charge
SMS Message Cost
MMS Message Cost
SMS Outbound Message Cost

Minute Tanks

Inbound Minutes
Outbound Minutes
Shared Minutes

DIDs

Initial DID Setup Fee
DID Monthly Fee
Initial Toll Free DID Setup Fee
Toll Free Monthly Fee
e911 Monthly
Rogue 911 per call
e411 Setup Fee
e411 Per Call
Toll Free Per-call rate
Phonebook Listing
Phonebook entry quantity

Call Cost Settings

Domestic Inbound Connect cost
Domestic Inbound Increment cost
Domestic Outbound Connect cost
Domestic Outbound Increment cost
$/Min Inbound
$/Min Outbound
Domestic Outbound Rate Deck
International Inbound Connect cost
International Inbound Increment cost
International Outbound Connect cost
International Outbound Increment cost
International Rate Deck

Trunks

Inbound Trunks
Outbound Trunks
$/Trunk

Child Account Costs

monthly per child charge (50 or less)
monthly per child charge (100 or less)
monthly per child charge (250 or less)
monthly per child charge (500 or less)
monthly per child charge (1000 or less)
Back to Summary

08-25-2026 21:50:36 SQL Statement: SELECT billPlan.bpID, billPlan.s_date, billPlan.nextBillDate, billPlan.setupFee_E411, billPlan.perCall_E411, billPlan.perCall_E411, billPlan.perCall_E911, billPlan.perCall_Rogue911, billPlan.stateTax, billPlan.USinInitialCharge, billPlan.USoutInitialCharge, billPlan.USin2ndCharge, billPlan.USout2ndCharge, billPlan.InternationalinInitialCharge, billPlan.InternationaloutInitialCharge, billPlan.InternationalinAfterCall, billPlan.InternationaloutAfterCall, billPlan.inRate, billPlan.outRate, billPlan.perCall_tollFree, billPlan.TollFreeInitialCharge, billPlan.TollFreeAfterCharge, billPlan.usf_enable, billPlan.baseAmount, billPlan.trunkRate, billPlan.trunksIn, billPlan.trunksIn, billPlan.trunksOut, billPlan.STD_In_numbersPorted, billPlan.STD_In_numberPortingFee, billPlan.STD_Out_numbersPorted, billPlan.STD_Out_numberPortingFee, billPlan.tollFree_In_numbersPorted, billPlan.tollFree_In_numberPortingFee, billPlan.tollFree_Out_numbersPorted, billPlan.tollFree_Out_numberPortingFee, billPlan.setupFee_InitialDID, billPlan.DIDMonthlyFee, billPlan.setupFee_tollFree, billPlan.DIDMonthlyFee_tollFree, billPlan.phoneBookListing, billPlan.numPhoneBookListings, billPlan.paperInvoiceFee, billPlan.planID, billPlan.inPack, billPlan.outPack, billPlan.combinedSecs, billPlan.cidFee, billPlan.sms_rate, billPlan.mms_rate, billPlan.smsout_rate, billPlan.cardRejectFee, billPlan.PerChild50, billPlan.PerChild100, billPlan.PerChild250, billPlan.PerChild500, billPlan.PerChild1000, customer_billplan.customer_id FROM billPlan, customer_billplan WHERE billPlan.bpID = customer_billplan.plan_id AND customer_billplan.customer_id = '32'

08-25-2026 21:50:36 SQL Statement: SELECT id, account_number, company_name, first_name, last_name, status, auto_inactive_enable, inactivation, billing_type, parent, wholesale, child, credit_card_failure, account_manager FROM customer WHERE id = '32'

08-25-2026 21:50:36 SQL Statement: SELECT billPlan.bpID, billPlan.planName, billPlan.term, billPlan.s_date, billPlan.nextBillDate, billPlan.billingDays, billPlan.gracePeriod, billPlan.external_tax_processing, billPlan.external_tax_filing, billPlan.threshold, billPlan.threshold_type, billPlan.chargeAmount, billPlan.recharge_type, billPlan.cutoff_value, billPlan.international_enable, billPlan.international_enable_style, billPlan.international_warning_minutes, billPlan.international_cutoff_minutes, customer_billplan.customer_id FROM billPlan, customer_billplan WHERE billPlan.bpID = customer_billplan.plan_id AND customer_billplan.customer_id = '32'

08-25-2026 21:50:36 SQL Statement: SELECT COUNT(*) AS quantity FROM customer_domestic_rate_deck WHERE customer_id = '32'

08-25-2026 21:50:36 SQL Statement: SELECT id, customer_id, deckId FROM customer_international_rate_deck WHERE customer_id = '32'

08-25-2026 21:50:36 SQL Statement: SELECT planID, name, isPublic, term, baseAmount, cost_per_min, costPerMinOut, in_secs, out_secs, combinedSecs, conCalls, conCallsout FROM voip_plans ORDER BY name

08-25-2026 21:50:36 SQL Statement: SELECT t.deckId, t.deck_name, t.markup, t.wholesaler_id, t.account_number, t.first_name, t.last_name, t.company_name FROM (SELECT ratedeck.deckId AS deckId, ratedeck.deck_name AS deck_name, ratedeck.markup AS markup, ratedeck.wholesaler_id AS wholesaler_id, wholesaler.account_number AS account_number, wholesaler.first_name AS first_name, wholesaler.last_name AS last_name, wholesaler.company_name AS company_name FROM domestic_rate_deck ratedeck LEFT JOIN customer wholesaler ON ratedeck.wholesaler_id = wholesaler.id) AS t ORDER BY t.deck_name

08-25-2026 21:50:36 SQL Statement: SELECT t.deckId, t.deck_name, t.markup, t.wholesaler_id, t.account_number, t.first_name, t.last_name, t.company_name FROM (SELECT ratedeck.deckId AS deckId, ratedeck.deck_name AS deck_name, ratedeck.markup AS markup, ratedeck.wholesaler_id AS wholesaler_id, wholesaler.account_number AS account_number, wholesaler.first_name AS first_name, wholesaler.last_name AS last_name, wholesaler.company_name AS company_name FROM international_rate_deck ratedeck LEFT JOIN customer wholesaler ON ratedeck.wholesaler_id = wholesaler.id) AS t ORDER BY t.deck_name