Setting up a translation table

Create, open, or modify a translation table before setting it up. A translation table window must be open.

Translation Table window

To set up a translation table, you must fill in or modify the Table Schema tab and the Table Instance tab.

Table Schema tab

This tab allows you to create the structure of your translation table which can consists of one to five input columns and one to fifteen output columns. Use the icons to fill in the tab.

Name: Type the unique identifier of the table.

Description: Describe the translation table if necessary.

Start and end dates can be specified for each row: If selected, this option adds the columns Start Date and End Date to the table in the Table Instance tab. This option is used in combination with the field Reference Date of a table operator component. You use this option as an additional criterion to sort the items of the table. You can, for example, fix the price of phone calls depending on prefixes and call dates.

Disallow duplicate input values for the same time: If selected, this option prevent you from adding two rows containing the same input values. An error message is displayed when two rows containing the same values are added to the table. If the option Start and end dates can be specified for each row is selected, two rows are considered as duplicated if they contain the same input values and if the periods delimited by Start date and End date overlap.

Example of duplicate input values

(*): Null represents an unspecified date in the past or the future.

(*): Null represents an empty cell.

(*): An overlap of 1 second is enough.

Input Columns

• Name: type the input column name.

• Description: Describe the input column if necessary.

Output Columns

• Name: Type the output column name.

• Description: Describe the output column if necessary.

• Type: Provides the list of types. Select Number or String.

• Default value: Assign a value to the output column. When the translation table is used in a price plan or a pricing macro, if no comparison is successful, a default value for each generated property is returned by the translation table.

Table Instance tab

Once you have created the structure of your translation table in the Table Schema tab, you can add one or more rows to the table, and then fill in the cells of each row with appropriate values. When adding a new row to the table, each cell of the input columns is assigned the default value "Any" that represents any value. You can replace "Any" by any value of your choice.

If you have selected the Start and end dates can be specified for each row option, two additional columns Start Date and End Date appear in the table. After you add a row, click the cell of each column to open a calendar, and then select a date if necessary. Depending on your choice, the item of the table is defined as follows:

• If only the cell of the Start Date column is empty: The corresponding item of the table is defined by a time period ranging from an unspecified date to the selected date

• If only the cell of the End Date column is empty: The corresponding item of the table is defined by a time period ranging from the selected date to an unspecified date

• If the cell of both columns is left blank: The corresponding item of the table is defined by a time period ranging from an unspecified date to an unspecified date

Use the icons to fill in the data.