About tier tables

Important: You cannot redefine a tier table at charge plan or refill plan levels.

A tier table allows you to create new properties that can be used in the price plan, the charging plan, or the refill logic.

A tier table is an n-dimensional table that consists of:

A Group Name column
A Range column
A set of one to five string or number output columns
A set of rows

When creating a tier table, you use:

The Group Name column to create groups of numerical intervals
The Range column to represent the numerical intervals of each group
The output columns to assign number or string values to each interval

Note: Remember that:

You can create as many groups as you want
You can create in each group ranging from -∞ to +∞ as many numerical intervals as you want
You can use negative or decimal numbers
You cannot create discontinuous or empty numerical intervals
You cannot delete or rename the default group
You must arrange the numerical intervals in increasing order
The numerical intervals cannot overlap
Each group of intervals is independent of the other ones

After you have created a tier table, you can add it to the price plan, the charging plan, or the refill logic. You can use the same tier table more than once in any price plan, charging plan, or refill logic.

Example

A company sells postal services which are delivered by subcontractors. The parcel postal tariffs are priced according to the subcontractor, the region of the world, and the weight of the parcel (weight in gram: ]-∞, 200[, [200, 500[, [500, +∞[). All prices are calculated in USD.

In this example, if the subcontractor is unknown, the default group is used to determine the price of the postal service.

Tier table versions

When you modify and save a tier table, you can access all previous versions of it by clicking the Change Version icon on the toolbar.

You can replace a version of a tier table with a new version, specifying an effective date of the new version earlier than that of the version you want to replace. This action deletes all versions previously saved in the database with a date later than the effective date you have specified.