Creating a Charge Table (TH)

A rate structure, as defined using option TH, is the composition of rate calculation types that make up the required set of charges. One or many charges, of any of the predefined calculation methods, can be included in a rating structure. To access this option, choose System Settings|TMS Master Data|Charge Tables or enter TH in the QuickPath.

Enter a code of up to 10 characters.

Enter the date when the Charge Table becomes effective. You can optionally add an end date.

Enter a Charge Table description.

Select this field to summarize charges by charge/revenue code. If multiple rate structure calculation types exist for the same charge/revenue code, then these can be summarized to output a single Shipment Charge line.

The purpose of this set is to determine the level at which to apply the charge criteria. For example, if the rate structure has charges based on Weight and Freight Classes, and shipment transactions include differing freight classes on different item lines, it may be appropriate to choose to calculate charges per Line to select weight from shipment item lines.

Select the level at which to apply the charge criteria when the rate structure is applied to a Group/Load.

Available for future use.

These fields are obsolete.

Possible values for this field are:

• D2D (Deliver to Destination) uses the From City and To City values. If the field is blank, this value is the default.

The Charge details - rate without zones sub-option enables you to create and add charge types to the Charge Table.

Enter a unique sequence number for the charge detail line; for example, 05, 10, 15. The sequence number determines the order in which the calculation program processes the charges.

Select a charge code for this charge.

Select one of the six predefined calculation methods from Preconfigured Calculation Methods. Complete the subsequent fields based on the calculation method you select here.

The default description associated with the charge code in option CH is used. However, you can override the description.

Select the currency in which this charge code is to be calculated.

If a tax is to be calculated on the charge, select the tax group code.

If a zero charge is allowed, select this field.

This field indicates the process number from which this charge method is to apply.

This field indicates the process number to which this charge method is to apply.

If you selected method 02 in the Calculation Method field, enter the rate per unit to be used for the charge calculation.

If you selected method 02 in the Calculation Method field, enter the selling rate per unit to be used for the charge calculation.

If you selected method 00 in the Calculation Method field, enter the Minimum Charge amount to be used for the charge calculation. If the calculated charge amount does not exceed this minimum charge value, the minimum charge is taken. This sets a minimum value for a particular charge code of the charge table. Therefore, if the calculation made by the other lines for that charge code does not reach this prescribed value, the value for that charge code is the minimum value.

If you selected method 00 in the Calculation Method field, enter the Selling Minimum Charge to be used for the charge calculation.

If you selected method 99 in the Calculation Method field, enter the Maximum Charge amount to be used for the charge calculation. If the calculated charge amount does exceed the maximum charge value, the maximum charge is taken. This sets a maximum value for a particular charge code of the charge table. Therefore, if the calculation made by the other lines for that charge code does not exceed this prescribed value, the value for that charge code will be the maximum value.

If you selected method 99 in the Calculation Method field, enter the Selling Maximum Charge to be used for the charge calculation.

If you selected method 01 in the Calculation Method field, enter the Fixed amount to be used for the charge calculation.

If you selected method 01 in the Calculation Method field, enter the selling fixed amount to be used for the charge calculation.

If you selected method 02 or 04 in the Calculation Method field, specify the UOM the charges are based on.

If you selected method 02 in the Calculation Method field, enter the container or pack type code in this field.

If you selected method 03 in the Calculation Method field, enter the percentage rate to be used for the charge calculation.

If you selected method 03 in the Calculation Method field, enter the selling percentage rate to be used for the charge calculation.

If you selected method 03 in the Calculation Method field, select the appropriate value on which the percentage is to be calculated.

If you selected method 03 in the Calculation Method field and the percentage is to be based on a charge code amount, select a charge code. For example, you can specify insurance as a percentage of the freight amount only, rather than as a percentage of shipment value or shipment value + freight. In this case, select Charge Code as the % basis and specify the freight cost code as the % Charge Code.

If you selected method 04 in the Calculation Method field, this field indicates that all rates entered by the user in the X/Y axis are in this unit; for example, an entry of 1000 indicates that the rate is per 1000.

If you selected method 04 in the Calculation Method field and you select this field, PRECISION checks the next tier on the Charge Table. This check can reduce a charge when you are shipping a quantity that is very near to the break. For example, you have a 950 kg shipment, and the rates are as follows:

Using the first tier price, the total cost is 950 x $0.48 = $456. Using the next tier, the total cost is 1001 x $0.43 = $430.43.

If you selected method 04 in the Calculation Method field, use this field to specify the UOM rounding unit. For example, a road carrier deals in quantities that round to full units and a postal carrier rounds to intervals of 0.5 kg. If a round unit is not specified, PRECISION uses the actual weight or volume, rather than the rounded up value. For example, 178.89 kg without rounding uses the value 178.89 as the rate per kg, whereas the same value using a rounding of “1” calculates the figure using 179 as the rate per kg.

If you selected method 04 in the Calculation Method field, use this field to specify the factor for converting the volume to a weight equivalent.

This field determines whether the value entered for the volume/weight conversion is to be used for division or multiplication. If this field is selected, the volume is divided by the conversion rate to give the weight equivalent.

Select this field to test volume against weight on the Charge Table. PRECISION selects the highest/largest weight to calculate the freight rate, based on the conversion that has taken place.

If you selected method 04 in the Calculation Method field, this field contains the user-defined X axis as described in Axis Definitions.

If you selected method 04 in the Calculation Method field, this field contains the user-defined Y axis as described in Axis Definitions.

If you selected method 04 in the Calculation Method field and you want to create a three-dimensional Charge Table, select this field. The third axis is then based on zones.

If you selected method 04 in the Calculation Method field and charge calculations are to be based on the shipment header quantity rather than at item line level, select this field.

If you selected method 04 in the Calculation Method field, use this field to specify the factor for converting the Load Space to a weight equivalent.

This field determines the weight UOM represented by the conversion factor from loadspace to weight.

This field determines whether the value entered for the loadspace/weight conversion is to be used for division or multiplication. If this field is selected, the loadspace is divided by the conversion rate to give the weight equivalent.

Select this field to test loadspace against weight on the Charge Table. PRECISION selects the highest/largest weight to calculate the freight rate, based on the conversion that has taken place.

The Charge Details - Rates Without Zones sub-option also has two sub-options, as displayed in Charge Details - Rates Without Zones Sub-options.

Enter the zone class for which the rates apply.

Enter the minimum charge for this zone classification.

To enable the zone classification, select this field.

This sub-option enables you to control whether other cost types are calculated when another particular cost type is calculated. For example, do not create this type of cost line when the other cost type exists. You can also use this record as a prerequisite. For example, only create this cost line when the other cost type has a value. The editable fields are:

Use this free-text field to describe the purpose of the record created. The prerequisite condition only kicks in when Reason is set to a value of PREREQUISITE.