Difference between revisions of "ATI - Deutsche Telekom example"
| Line 33: | Line 33: | ||
For Primary data we will use Worksheet 1 (DTGC Hubbing Rates) | For Primary data we will use Worksheet 1 (DTGC Hubbing Rates) | ||
<br><br> | |||
[[File:CT_DT1.png]] | |||
<br><br> | |||
Destination/Zone Column A, Prefix/Code Column B, Effective Date Column D | |||
<br><br> | |||
[[File:CT_DT2.png]] | |||
<br><br> | |||
Rate Column C , Minimal Time second value from 0/1/1 and Increment third value from 0/1/1 in the Column E | |||
<br><br> | |||
[[File:CT_DT3.png]] | |||
<br><br> | |||
Revision as of 05:17, 24 October 2025
Step-by-step example for Deutsche Telekom Tariff
1. Review Deutsche Telekom XLSX tariff structure
We can see that the XLSX document consists of three Worksheets: Worksheet 1 (DTGC Hubbing Rates), Worksheet 2 (Origin Rates) and Worksheet 3 (Origin Dialcodes).
2. Go to BILLING > Tariff Import > Import Rules > Templates to create a new Template
3. Configure Template for Deutsche Telekom XLSX structure
As you can see, there are two tabs on this page: Primary Data and Secondary Data. Do not confuse them with Worksheets, they are not related.
For Primary data we will use Worksheet 1 (DTGC Hubbing Rates)
Destination/Zone Column A, Prefix/Code Column B, Effective Date Column D
Rate Column C , Minimal Time second value from 0/1/1 and Increment third value from 0/1/1 in the Column E
