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
Set up a fuel surcharge 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
Bill based on the combined number of axles recorded for the assigned resources (tractor, trailer 1, and trailer 2)
 
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
 
Commodity
Commodity transported on the order
Note: If there are multiple commodities on the order, the system looks at only the first commodity.
Commodity Class
Classification code of the commodity transported on the order
Note: If there are multiple commodities on the order, the system looks at only the first commodity.
Company
Company classification specified on the order
 
Count
Freight count of the order
Day Of Week
You can define billing rate tables based on the Arrival date for the first billable stop.
1.  
DayOfWeek(Early Arv)
You can define billing rate tables based on the Earliest date for the first billable stop.
1.  
Dest. City
City where the last stop took place
Dest. Company
Company site 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)
The rating engine applies 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, any full ZIP Code rate tables for the company must also have five digits.
If the company's ZIP Code has nine digits, any full ZIP Code rate tables for the company must also have nine digits.
Note: When setting up rate tables for nine-digit ZIP Codes, the format used in the rate table must match the format used in the company 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, not 440601234 or 44060 1234.
Destination County
County where the last delivery stop took place
Note: To use this option, you must record the complete county name in the City File Maintenance profile for each city that you specify in your rate table as a destination.
Destination Region
Geographic region where the last stop took place
Notes:
1. Regions that are used as rating restrictions are defined in the Rate Schedule application's Trips and Regions Edit window.
2. For information about creating region-based rates that will be applied to orders, see Setting up rates based on regions.
Dist (closestpoint)
Custom
Dist. (Hub)
Set up rates for mile ranges based on the tractor’s odometer readings
Dist (Round Trip *Adj)
Round trip mileage for the order is determined by adding route miles and origin/destination miles, then multiplying the sum by the adjustment factor specified in the [Invoice]AdjustedMileBillingFactor setting in your TTS50.
Note: Route miles are the total point-to-point miles for all stops on an order; origin/destination (O/D) miles are the miles from just the origin point to the destination point.
For example, you have a trip with three stops. The mileage from point A to point B is 40 miles, the mileage from point B to point C is 80 miles, and the mileage from point C to point A (the O/D miles) is 60 miles.
Your TTS50 file specifies that AdjustedMileBillingFactor=.5
The system would calculate the round trip mileage as:
[(40 + 80) + 60] X .5 = 90 round trip miles
Note: When this option is used, the system ignores miles between interim stops.
Distance (Empty)
Total empty miles on an order
This option applies only to:
Mileage between billable stops on an order.
Charge types for which you select Distance (Empty) in the Unit Basis field.
 
Distance (Loaded)
Total loaded miles on an order
This option applies only to:
Mileage between billable stops on an order.
Charge types for which you select Distance (Loaded) in the Unit Basis field.
Distance (O-D)
Origin-to-destination miles on the order
Note: When this option is used, miles between interim stops are not considered.
Distance (Route)
Total miles on the order
 
Divis. of/Parent
Parent company for the Bill To on the order
Drop Stops
Defines secondary billing rate tables that will charge based on the number of drop stops recorded on an order. You can specify whether to charge 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 billing rates for pickup stops and for drop stops. You can use the existing incremental rating feature to specify a different number of free stops for each rate.
DrvType1-4
Driver classifications to which the lead driver on the order is assigned
Factor
Currently not operational
Height
Freight height (in inches) on the order
Length
Freight length (in inches) on the order
LghType1-2
Set up a rate table that is based on the LghType1-2 classifications assigned to the trip segment to which the order is associated
Notes:
1. For consolidated orders, the system retains only the LghType1 or LghType2 value for the order with the lowest ID.
2. Use of the LghType1-2 options for billing rates is not supported for split trips or cross docked orders.
3. LghType1-2 classifications are assigned in the Assign Driver/Equipment window in Order Entry, Asset Assignment window in Dispatch, or in the Trip Folder's Stops grid.
 
LHRate
Custom
Master Order#
Number of the master order from which the order was copied
Origin City
City where the first stop took place
Origin Company
Company site where the first stop took place
Origin County
County where the first stop took place
Note: To use this option, you must record the full county name in the City File Maintenance profile for each city that you specify in your rate table as an origin.
Origin Region
Geographic region where the first stop took place
Notes:
1. Regions that are used as rating restrictions are defined in the Rate Schedule application's Trips and Regions Edit window.
2. For information about creating region-based rates that will be applied to orders, see Setting up rate schedules based on regions.
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)
Complete ZIP/postal code of the location where the first stop took place
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, any full ZIP Code rate tables for the company must also have five digits.
If the company's ZIP Code has nine digits, any full ZIP Code rate tables for the company must also have nine digits.
Note: When setting up rate tables for nine-digit 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, not 440601234 or 44060 234.
OtherType1-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
 
Out of Route
Mileage that is determined by subtracting the origin-to-destination miles from the total miles traveled
Pallet Count
Custom
Pallet Type
Custom
Pickup Stops
Defines the secondary billing rate tables that will calculate charges based on the number of pickup stops recorded on a trip. You can specify whether to charge 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 billing rates for pickup stops and for drop stops. You can use the existing incremental rating feature to specify a different number of free stops for each rate.
Premium Day PUP/DRP
Set up accessorial rates for pickups or drops that fall on premium days (e.g., weekends and holidays)
 
RevType1-4
Revenue classifications specified on the order header
 
Route ORDRTE
Custom
Route ROUTE
Custom
Stop City
City where a pickup or delivery stop occurs after the initial pickup
This option works only with the Hi Rate All Combos rating option, which selects the highest rate on a multiple-stop trip, regardless of the order of the stops.
For instance, suppose you charge $100 for trips between city A and city B, and you charge $150 for trips between city A and city C. By default, the system applies the rate that matches the origin and destination cities, so the system would charge $100 for a trip that goes from A to C to B. Using the Hi Rate All Combos rating option, the system would apply a charge of $150 to that same trip.
Note: If you select Stop City in the Rows field, you must select Origin City in the Cols field. Conversely, if you select Stop City in the Cols field, you must select Origin City in the Rows field.
Stop Company
Company where a pickup or delivery stop occurs after the initial pickup
This option works only with the Hi Rate All Combos rating option, which selects the highest rate on a multiple-stop trip, regardless of the order of the stops.
For instance, suppose you charge $100 for trips between company A and company B, and you charge $150 for trips between company A and company C. By default, the system applies the rate that matches the origin and destination companies, so the system would charge $100 for a trip that goes from A to C to B. Using the Hi Rate All Combos rating option, the system would apply a charge of $150 to that trip.
Note: If you select Stop Company in the Rows field, you must select Origin Company in the Cols field. Conversely, if you select Stop Company in the Cols field, you must select Origin Company in the Rows field.
Stops
Number of loaded stops on an order for which the customer is being billed; generally used for a stop charge rate
 
Terms
Billing terms recorded for the order
TrcType1-4
Tractor classifications to which the tractor on the order is assigned
 
TrlType1-4
Trailer classifications specified in the trailer profile of the trailer assigned to the order
 
Volume
Freight volume of the order
Weight
Freight weight of the order
 
Width WID
Custom