Add a new row to the table to define a new output column in the schema of the range table class.Create a range table class before setting it up. A range table class window must be open.
The range table class allows you to create the structure of your range tables (and subscriber range tables) which can consists of one input column and one to fifteen output columns.
|
Note: Once you have saved a range table class, you can no longer modify its table schema as soon as the class is referenced by a range table or a subscriber range table. You can always modify the description and the additional information. |
To set up a range table class, you must fill in or modify the Table Schema tab and the Additional Information tab.
Name: Type the unique identifier of the range table class.
Description: Describe the range table class. This description is mandatory.
You set up the characteristics of all the numerical intervals of all the business data tables (range tables, subscriber range tables) based on this class:
Range Upper Bound: Set up if the upper bounds of the ranges are inclusive (default) or exclusive.
Last Range Upper Bound: Set up if the upper bound of a last range of a table is bounded (default) or not.
Use the following icons to fill in the table Output Columns with at least one row:
Add a new row to the table to define a new output column in the schema of the range table class.
Delete a row from the table.
Move a row up.
Move a row down.
|
Note: You can set up 15 output columns maximum. |
Output Columns
Name: Type the output column name that you want to define for this class of business data tables. This name must be unique within the set of output columns.
Description: Describe the output column. This description is mandatory.
Type: Select the type of the output column and the associated computation mode (see the examples of range tables):
String: The input property value determines a row of the range table. The output column values of this row are assigned to the generated properties.
Single Number: The input property value determines a row of the range table. The output column values of this row are assigned to the generated properties.
Cumulative Number: This type is useful when you want to design tiered pricing based on the cumulativeness of prices defined by ranges. The input property value determines a row of the range table. The output column values of this row are assigned to the generated properties. For each output column, the output column value of this row and the values of the output column of the previous rows are added together. The resulting values of these sums are then assigned to another generated properties.
Range Size Cumulative Number: This type is useful when you want to design cumulative tiered pricing based on quantity (time) multiplied by a unit price. The property value determines a row of the range table. The output column values of this row are assigned to the generated properties. For each output column, the output column value of this row and the values in the output column of the previous rows are processed according to the formula "a*(b-c) or a*size" (where "a" is the output column value, "b" is the property value, and "c" is the lower boundary of the range including the property value, and "size" is the size of the range (distance between the lowed boundary and the upper boundary) and added together. Each value is multiplied by the size of the range. The resulting values are then assigned to another generated properties.
Use the table and its icons to create additional information.
: Click to add a row to the table.
: Click to delete a row from the table.
Fill in each row that you add to the table:
Name: Type the name of the additional information.
Type: Provides the list of the additional information types. Select one of the following types: Number, String, or Date.
Value: Type the additional information according to the selected type.
Description: Type the description of the additional information. This description is visible from the CRM application or the external provisioning system that is connected to SAP Convergent Charging.