The following fields from the CDR are used to calculate the cost of Origination (Inbound) Calls.
ORIG RATE = This is the rate from the rate deck that is associated to the Origination Customer Trunk Group that received the call.
ORIG BILLED DURATION = This is the number of billed seconds and is based on the initial increment and subsequent increment time intervals associated with the ORIG RATE in the Rate Deck associated to the Origination Customer Trunk Group that received the call. Common values for initial increment and subsequent increment intervals are 6, 6; 1,1; and 60,60. For the example calculations on this page we will use 6, 6.
Example Rate Deck
Prefix | initial increment | subsequent increment | interrate | intrarate | ijrate | effective_date |
1204741 | 6 | 6 | 0.00225 | 0.00225 | 0.00225 | 4/17/2023 |
1204742 | 6 | 6 | 0.00225 | 0.00225 | 0.00225 | 4/17/2023 |
1204743 | 6 | 6 | 0.00225 | 0.00225 | 0.00225 | 4/17/2023 |
1204744 | 6 | 6 | 0.002125 | 0.002125 | 0.002125 | 4/17/2023 |
1204745 | 6 | 6 | 0.0025 | 0.0025 | 0.0025 | 4/17/2023 |
1204746 | 6 | 6 | 0.0025 | 0.0025 | 0.0025 | 4/17/2023 |
1204747 | 6 | 6 | 0.002 | 0.002 | 0.002 | 4/17/2023 |
… |
Rounding Digits = This is the number of Rounding Digits selected on the Rate Deck page for the Origination Rate Deck associated to the Origination Customer Trunk Group that received the call. The example below show 4 Rounding Digits.
Orig Cost = CEILING((orig_rate * (orig_billed_duration / 60))* POWER(10, Rounding Digits),1) / POWER(10, Rounding Digits)
Examples
Orig Cost = CEILING((0.00095 * (12 / 60))* POWER(10,4) / POWER(10,4) = 0.0002
Orig Cost = CEILING((0.00130 * (12 / 60))* POWER(10,4) / POWER(10,4) = 0.0003