1. Transportation Management Implementation Guide
  2. Understanding Rate Table Setup

Understanding Rate Table Setup

After you define the rate and the lookup type variables, you must set up the actual values in the rate table. Based on the values that you defined in the lookup table, you set up the actual rate amount. The system uses the rate table to determine the correct rate for each of the values.

To determine what rate to apply for payable charges, the system uses a hierarchy within the rate table. The rate table also selects a route, based on the origin of the shipment. This list identifies the hierarchy for payable charges:

  1. The system uses the rate detail that matches the carrier, the carrier currency code, and the specific origin.

  2. If no information is found, the system then uses the rate detail that matches the carrier, the domestic currency code, and the specific origin.

  3. If no information is found, the system then uses the rate detail that matches any carrier, the domestic currency code, and the specific origin.

  4. If no information is found, the system then uses the rate detail that matches the carrier, carrier currency code, and any origin.

  5. If no information is found, the system then uses the rate detail that matches the carrier, the domestic currency code, and any origin.

  6. If no information is found, the system then uses the rate detail that matches any carrier, the currency code, and any origin.

To determine what rate to apply for billable charges, the system uses a hierarchy within the rate table. The rate table also selects a route, based on the origin of the shipment. This list identifies the hierarchy for billable charges:

  1. The system uses the rate detail that matches the ship to address, the customer currency code, and the specific origin.

  2. If no information is found, the system then uses the rate detail that matches the ship to address, the domestic currency code, and the specific origin.

  3. If no information is found, the system then uses the rate detail that matches any ship to address, the domestic currency code, and the specific origin.

  4. If no information is found, the system then uses the rate detail that matches the ship to address, the customer currency code, and any origin.

  5. If no information is found, the system then uses the rate detail that matches the ship to address, the domestic currency code, and any origin.

  6. If no information is found, the system then uses the rate detail that matches any ship to address, the currency code, and any origin.