Setting up a rate table > Definitions of row/column selections
Definitions of row/column selections
By default, the Rows and Col's fields in a rate header are set to Not Used. To set up a table of multiple rates for a rate schedule, select the desired value in the Rows and/or Col's fields. Selections are listed here in alphabetical order.
Value
Description
Avg Fuel Price
Allows you to set up a fuel surcharge pay rate that is based on an Average Fuel Price table. An Average Fuel Price table consists of a list of effective dates and the corresponding average fuel prices in effect for those dates. These tables are set up in File Maintenance.
Axle Count
Allows you to base pay on the combined number of axles recorded for the assigned resources (tractor, trailer 1, and trailer 2). For details, see Setting up rates based on axle count.
Bill To
Customer being billed; this selection corresponds to the company ID in the Bill To field on the order.
BillTo OtherTypes1-2
Classifications recorded in the Other Type 1 and Other Type 2 fields in the profile of the Bill To company recorded on the order.
Note: Your company defines the names and options for these fields in the OtherType1 and OtherType2 labels in the System Administration application.
Commodity
Commodity transported on the order.
Note: If there are multiple commodities on the order, the system only looks at the first one.
Commodity Class
Classification code of the commodity transported on the order.
Note: If there are multiple commodities on the order, the system only looks at the first one.
Count
Freight count of an order.
Day Of Week
Define pay rate tables based on the Arrival date for the first stop.
1.  
DayOfWeek(Early Arv)
Define pay rate tables based on the Earliest date for the first billable stop
Dest Co (Order)
This option is designed for split trips. The rate will pull if the order’s last billable stop is on any trip segment that is part of the move associated with the segment being settled.
Note: The rate will be applied even if the resource being paid was assigned to a segment that did not include the order’s last billable stop.
Note regarding the following Destination options: On a pay rate table, these options relate to the final delivery location on the segment. If the trip segment does not have any billable stops, the destination is the stop at the end of the empty move.
Dest. City
City where the last stop took place.
Dest. Company
ID of the company where the last stop took place.
Dest. State
State/province where the last stop took place.
Dest. Zip (3-digit)
First three characters of the ZIP/postal code of the location where the last stop took place.
Dest Zip (Full)
When you select this option, the rating engine will apply the rate only when the ZIP Code used to define the rate is an exact match to the ZIP Code recorded in the profile of the company where the last stop occurred. If the company's ZIP code has:
Five-digits, then any full ZIP Code rate tables for this company must also have five-digits.
Nine-digits, then any full ZIP Code rate tables for this company must also have nine-digits.
Note: When setting up full ZIP Code rate tables for nine-digits ZIP codes, the format used in the rate table must match the format used in the company's profile. For example, if the nine-digit ZIP Code is hyphenated in the company's profile, it must also be hyphenated in the rate table, e.g., 44060-1234 is not the same as 440601234 or 44060 1234.
Dist (Hub)
Allows you to set up rates for mile ranges based on the tractor’s odometer readings.
 
Dist (RoundTrip*Adj)
Allows you to set up rates based on round trip miles.
Dist (Actual) Total
Custom
Distance (Actual)
This option works in conjunction with the Loaded field on the rate’s index to set up rate tables based on just loaded miles or just empty miles.
For example, suppose a trip has 10 empty miles and 100 loaded miles. If you define the table using:
Distance (Actual) and the Loaded field is set to Loaded
The system uses only the loaded miles (100) to select a rate from the table.
Distance (Actual) and the Loaded field is set to Empty
The system uses only the empty miles (10) to select a rate from the table.
Distance (Route)
The system uses all miles (110) to determine where the trip's mileage quantity falls in the mileage ranges recorded in the rate table.
Distance (Billed)
This option allows you to set up a table for mileage ranges based billable miles. The system determines the rate by looking at the quantity of billing miles, and then applies that rate to the number of Settlement miles. It is intended to be used when the mileage quantity used for billing is not the same as the mileage that Settlements uses.
During the rating process, the rating engine does the following:
1. Looks at the total number of billed miles on the order.
2. Determines where that quantity falls in the mileage-based table to find the rate associated with that quantity.
3. Multiples the rate times the Settlement miles to create a pay detail.
Distance (O-D)
Origin to destination miles.
Note: When this option is used, miles between interim stops are not considered.
Distance (Empty) Total
Custom
Distance (Loaded) Total
Custom
Distance (Route)
Total miles (loaded and empty) on a trip for which the driver is being paid.
Distance (Route) Total
Custom
Driver Company
The company with which the driver is associated in his/her profile.
 
Driver Division
The division to which the driver belongs, as identified in his/her profile.
 
Driver Domicile
The home location for the driver, as identified in his/her profile.
 
Driver Fleet
The fleet to which the driver is assigned in his/her profile.
 
Driver ID
Allows you to set up a rate for a specific driver or co-driver.
Driver TeamLeader
The driver’s team leader, as identified in his/her profile.
 
Driver Terminal
Terminal to which the driver is assigned in the driver profile.
 
Driver Type1-4
Driver classifications to which the driver is assigned in the driver profile.
 
Drop Stops
Used to define secondary pay rate tables that will calculate pay based on the number of drop stops recorded on a trip. You can specify whether pay is created for all stops, or only for stops that are more than a user-defined number.
Note: This option (along with the Pickup Stops option) allows you to create separate pay rates for pickup stops and for drop stops. In addition, you can use the existing incremental rating feature to specify a different number of free stops for each rate. For details, see Setting up separate stop pay rates for pickups and drops.
Event
Allows you to create a rate schedule that is based on events assigned to stops that occurred during a trip. It is applicable when:
The rate schedule is for a particular event type; and
Rates differ based on the number of times the specified event is recorded on a trip.
Event Type
Allows you to set up a rate schedule that is based on events assigned to stops that occurred during a trip. It is applicable when:
The rate schedule is for multiple event types; and
Each event type has a specific rate.
Factor
Supported only for billing rates.
Height
Supported only for billing rates.
Length
Supported only for billing rates.
LHRate
Custom.
Orig Co (Order)
This option is designed for split trips. The rate will pull if the order’s first billable stop is on any trip segment that is part of the move associated with the segment being settled. For details, see Restricting pay based on origin/destination.
Note: The rate will be applied even if the resource being paid was assigned to a segment that did not include the order’s first billable stop.
Note regarding the following Origin options: On a pay rate table, these options relate to the initial pickup location on a trip segment. If the trip segment does not have any billable stops, the origin is the stop at the start of the empty move.
Origin City
City where the first stop took place.
Origin Company
ID of the company where the first stop took place.
Origin State
State/province where the first stop took place.
Origin Zip (3-digit)
First three characters of the ZIP/postal code of the location where the first stop took place.
Origin Zip (Full)
When you select this option, the rating engine will apply the rate only when the ZIP Code used to define the rate is an exact match to the ZIP Code recorded in the profile of the company where the first stop occurred. If the company's ZIP code has:
Five-digits, then any full ZIP Code rate tables for this company must also have five-digits.
Nine-digits, then any full ZIP Code rate tables for this company must also have nine-digits.
Note: When setting up full ZIP Code rate tables for nine-digits ZIP codes, the format used in the rate table must match the format used in the company's profile. For example, if the nine-digit ZIP Code is hyphenated in the company's profile, it must also be hyphenated in the rate table, e.g., 44060-1234 is not the same as 440601234 or 44060 234.
Other Type 1 - 2
Classifications recorded in the Other Type 1 and Other Type 2 fields in the profile of the Order By company recorded on the order.
Note: The names and options for these fields are defined in the OtherType1 and OtherType2 labels in the System Administration application.
Out of Route
Supported only for billing rates.
PassThruState/Prov
Allows you to set up secondary pay rates that will calculate add-on pay based on the number of miles traveled through specified states or provinces. When the rate is applied to a trip, the system creates a separate pay detail for the miles traveled in each state on the trip.
 
Pickup Stops
Used to define secondary pay rate tables that will calculate pay based on the number of pickup stops recorded on a trip. You can specify whether pay is created for all stops, or only for stops that are more than a user-defined number.
Note: This option (along with the Drop Stops option) allows you to create separate pay rates for pickup stops and for drop stops. In addition, you can use the existing incremental rating feature to specify a different number of free stops for each rate. For details, see Setting up separate stop pay rates for pickups and drops.
RevType1– RevType4
Revenue classification on the order header for the order for which the driver is being paid. If multiple orders exist on the trip, the system looks only at the first one.
 
Seniority (months)
Number of months a driver has been employed. To determine the driver’s seniority level, the system checks the entry in the Seniority Date field in the driver's profile in File Maintenance. If a Seniority Date is not specified, the system uses the entry in the Hire Date field. For details, see Setting up a line haul rate that is based on driver seniority.
State Passed Through
Custom
Stop Othertypes 1-2
These options are used in conjunction with the options selected in the existing Event field to set up secondary rates that will be applied only when the specified event occurs at the specified stop.
Notes:
1. The Stop Other Type 1-2 options:
Are supported only for secondary pay rates.
Are supported only on rates that also have an event defined.
Are associated with the Other Type 1 and Other Type 2 fields in the company profile of the stop company.
Stops
Applicable for secondary stop pay rates. Pay is based on the number of loaded stops on an order.
Time of Day
Allows you to create flat pay based on when a trip starts. You can use it to set up a matrix of flat pay amounts to accommodate different rates for shift pay. For details, see Creating flat pay rates based on when a trip starts.
Tractor Company
The company that owns the tractor, as identified in the tractor's profile. This field is most commonly used for multi-company organizations.
 
Tractor Division
The division to which the tractor belongs, as identified in the tractor's profile.
 
Tractor Fleet
The fleet to which the tractor belongs, as identified in the tractor's profile.
 
Tractor Terminal
Terminal to which the tractor is assigned in the tractor profile.
 
Tractor Type1– 4
Tractor classifications to which the tractor is assigned.
 
Trailer Company
The company to which the trailer is associated, as identified in the trailer's profile. Most commonly used for multi-company organizations.
 
Trailer Division
The division with which the trailer is associated, as identified in the trailer's profile.
 
Trailer Fleet
The fleet to which the trailer belongs, as identified in the trailer's profile.
 
Trailer Terminal
Terminal to which the trailer is assigned in the trailer profile.
 
Trailer Type1– 4
Trailer classifications to which the primary trailer is assigned.
 
Trip Type
Allows you to set up a rate table that is based on the LghType1 classification assigned to the trip segment.
Notes:
1. This option can be used with consolidated orders and split trips.
2. When orders on separate trip segments are consolidated onto one trip segment, the system resets the LghType1-4 values to the values associated with the order that is listed first in the stop sequence.
3. Use of this option is not supported for cross docked orders.
4. LghType1 classifications are assigned in the Assign Driver/ Equipment window in Order Entry, or the Asset Assignment window in Dispatch.
5.  
Volume
Freight volume of an order for which the resource is being paid.
Weight
Freight weight of an order for which the resource is being paid.
Width
Supported only for billing rates.