Shipment-Based Rate

Internal Table Name: ShipmentBasedRates

Shipment-based rates extend the rating functionality of the Rate table. While the Rate table allows definition of rates that are used to cost a vehicle route at the route level, shipment-based rates allow definition of rate information at the shipment level, providing you with more flexibility and more granular control in costing a route.

Use the Shipment-Based Rate table to define Per Unit Cost and Discount Rate values for each unique Asset-Source-Destination-Class combination. When using shipment-based rates, different costs and rates are allowed for each shipment on a route. This functionality supports LTL aggregation, where shipments with different LTL rates can be combined on a single route. Populate the Class column in the Shipments table to classify shipments for shipment-based rate values.

Asset Name

Technology: TO

Table: ShipmentBasedRates

Internal Name: TransportationAssetName

Type: Text (100)

Select the asset name, filter or group if the shipment-based rate applies to one or more specific asset types.

Source

Technology: TO

Table: ShipmentBasedRates

Internal Name: OriginLocationGroupID

Type: Short Text (100)

Select the source location name, filter or group to which the shipment-based rate applies.

Destination

Technology: TO

Table: ShipmentBasedRates

Internal Name: DestinationLocationGroupID

Type: Short Text (100)

Select the destination location name, filter or group to which the shipment-based rate applies.

Class Name

Technology: TO

Table: ShipmentBasedRates

Internal Name: ClassName

Type: Short Text (100)

Select the class (as defined in the Class Name column in the Shipments table) to which the shipment-based rate applies.

Per Unit Cost

Technology: TO

Table: ShipmentBasedRates

Internal Name: PerUnitCost

Type: Short Text (100)

Enter the cost per unit of the shipment, as determined by the Unit Cost Basis. Enter a number for a constant Per Unit Cost. If the Per Unit Cost varies with the number of units, create a Step Cost Definition such as the following:

And create the associated Step Cost records:

When this step cost is defined, the first 300 units of the shipment are charged at 5 per unit and the units over 300 are charged at 4 per unit.

Unit Cost Basis

Technology: TO

Table: ShipmentBasedRates

Internal Name: PerUnitCostBasis

Type: Short Text (100)

Units of measure from one of Quantity, Weight, Volume.

Specifies the basis on which the Per Unit Cost is applied. This is a unit of measure from one of:

• Quantity
• Weight
• Volume

Default: Quantity unit of measure

Discount Rate

Technology: TO

Table: ShipmentBasedRates

Internal Name: DiscountRate

Type: Number (Double)

Enter a discount percentage that is applied to the total unit cost of the shipment.

Status

Technology: TO

Table: ShipmentBasedRates

Internal Name: Status

Type: Short Text (50)

One of Include, Exclude.

Use this field to determine if Transportation Optimization should consider the Shipment-Based Rate record.

Default: Include