A translation table is an n-dimensional table that consists of:
A set of input columns (I1, I2, I3,..., In) with n less than or equal to 5
A set of output columns (O1, O2, O3,..., On) with n less than or equal to 15
A set of one or more rows
Each row of the table consists of a set of values of input columns (I1, I2, I3,..., In) to which corresponds a set of values of output columns (O1, O2, O3,..., On).
Translation tables are objects that you can reuse in price plans, costs, or pricing macros.
The rate per minute for the U.S. during weekdays (out of holidays) depends on the destination. To calculate the consumption price in US dollars, you create a table with the following inputs and outputs: Destination number (input), Price per minute (output), and Connection fee (output) as follows:
|
Destination number |
Price per minute |
Connection fee |
|
1650 |
0.02 |
0.25 |
|
1703 |
0.01 |
0.15 |
|
1620 |
0.03 |
0.21 |
Because a translation table cannot be inserted in a price plan, you need to insert a table operator component in a price plan, a cost, or a pricing macro to reuse an existing translation table.
The table operator allows you:
To select a translation table
Select the properties to compare with the input columns of the translation table
Select the type of comparison