Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Rate Table - Override feature allows you to group 2 or more Rate Tables together and instruct CDR2Cloud which Rate Table to use for a customer, based on the Rate Tables Override value and the Override value of the CDR record.

Info
titleEXAMPLE

Challenge

You are a VoIP Retailer and your VoIP Wholesaler (Provider) provides you with 3 different services which you resell to your customers. They are SMS, MMS and VOICE services. Your VoIP Provider provides you with CDR files on a timely basis which you in turn use for billing your customers, however each CDR file contains CDR records for all 3 services as follows:

click to enlarge

You charge your customers 3 different rates for SMS, MMS and VOICE, as follows:

 CostDestination Number
VOICE80 cents @ minute (0.80)353838000001
MMS70 cents @ minute (0.70)353838000001
SMS60 cents @ minue (0.60)353838000001

You however can only assign one Rate Table to a Customer record, so you need a solution that will allow you to define 3 separate Rate Tables, one each for SMS, MMS and VOICE and allow the CDR2 Cloud system to use the applicable table depending on the type of service consumed by your customer.

Solution

You define 3 separate Rate Tables each having the same name but different Override expression as follows

PurposeRate Table NameOverride RegexNotes
For billing VOICE servicesCustomer Rates(VOICE)CDR2Cloud will use this Rate Table for billing all Voice services for customers assigned to the "Customer Rates" Rate Table
For billing MMS servicesCustomer Rates(MMS)CDR2Cloud will use this Rate Table for billing all MMS services for customers assigned to the "Customer Rates" Rate Table
For billing SMS servicesCustomer Rates(SMS)CDR2Cloud will use this Rate Table for billing all SMS services for customers assigned to the "Customer Rates" Rate Table

Image Added

Lastly you will assign the Customer Rates Rate Table to you customer(s) as shown below

Image Added

 

 

 

 

 

 

 

Info
iconfalse
titleRATES & RATE TABLE TOPICS

Page Tree
rootRates & Rate Tables
expandCollapseAlltrue
spacesCDR2CLOUD