Difference between revisions of "Make Retail Tariff from Wholesale Tariff explained"
From Kolmisoft Wiki
Jump to navigationJump to search
| Line 30: | Line 30: | ||
{| border="1" cellpadding="5" cellspacing="0" | {| border="1" cellpadding="5" cellspacing="0" | ||
| '''Based on which variable''' || '''FROM''' || '''DURATION''' || '''TYPE''' || '''ROUND BY'' || '''RATE''' || '''Comments''' | | '''Based on which variable''' || '''FROM''' || '''DURATION''' || '''TYPE''' || '''ROUND BY''' || '''RATE''' || '''Comments''' | ||
|- | |- | ||
| connection_fee || 1 || || event || || connection_fee || This record only created when connection_fee > 0 | | connection_fee || 1 || || event || || connection_fee || This record only created when connection_fee > 0 | ||
|- | |- | ||
| min_time || 1 || minute || min_time || rate || This record only created when min_time | | min_time || 1 || min_time || minute || min_time || rate || This record only created when min_time > 0 | ||
|- | |- | ||
| increment_s || min_time + 1 || -1 (means 'infinity') || minute || increment_s || rate || This record is always created | | increment_s || min_time + 1 || -1 (means 'infinity') || minute || increment_s || rate || This record is always created | ||
|- | |- | ||
|} | |} | ||
Revision as of 12:14, 20 November 2009
Retail Tariff from Wholesale Tariff is done by following algorithm:
1. Highest Rate in Wholesale Tariff for Destinations in Destination Group (DG) is selected 2. This rate is modified by adding some value or percent to it
Example
Imagine we have Wholesale Tariff with such rates for USA:
- Prefix 1, rate 0.01
- Prefix 12, rate 0.02
- Prefix 123, rate 0.03
And we have Destination Group USA with such Destinations in this Destination Group (1;12;123)
Now if we want to create Retail Tariff adding 0.005 to Wholesale tariff, we will have price for USA Destination Group = 0.035
E.g. highest rate from Destinations is selected and modified.
Inner mechanics
Wholesale tariff line will have such values:
- connection_fee
- min_time
- increment_s
When transforming to Retail such Advanced Rates are created:
| Based on which variable | FROM | DURATION | TYPE | ROUND BY | RATE | Comments |
| connection_fee | 1 | event | connection_fee | This record only created when connection_fee > 0 | ||
| min_time | 1 | min_time | minute | min_time | rate | This record only created when min_time > 0 |
| increment_s | min_time + 1 | -1 (means 'infinity') | minute | increment_s | rate | This record is always created |
