TrkID

Truck ID entry may be a number, truck name, driver name, or what is of most importance to the router.

Required

Territory

(TerritoryPro) The Territory ID will represent the name of each Territory. It can be any number in length, an alpha name, or alphanumeric. When Territories are built, this ID will be passed to the Stop File column named Territory, to identify the Territory that each Stop has been assigned. The number of unique Territory IDs used in the Truck File will determine how many Territories will actually be built. 

Ex: TrkID’s 101, 102, and 103 are all assigned to Territory 10000. TrkID’s 201, 202, 203 are all assigned to Territory 20000.

Required

Available

This must be set to TRUE in order to make the vehicle available for use in the route build.

Required

One-way

Set to TRUE for vehicle which will routed out, but not returned to the depot. Set to FALSE if the vehicle will return to the depot upon completion of the route.

Required

SpEq

Special Equipment Codes, used to identify special designations for the vehicle (Lift Gate, Refrig compartment, etc.); must have coordinating EqCode in the Stop File. 

Note: If using refuel points, insert ‘REFUELPOINT’ in this field (no corresponding EqCode necessary in Stop File) to designate the refuel location. 

Optional

Volume1

The maximum quantity of Volume1 (Stop File) that the vehicle can carry (vehicle capacity). Use the same Volume1 type used in the Stop File.

Required

UnldPerf%

Unload Performance regulates changes to the UnldRate. When a value is entered into this field, the unload rate will either increase or decrease. 100% is the default value. An increase to 110 will increase the Unload Rate by 10% (shorter time to unload). A decrease to 90 will decrease in the Unload Rate by 10% (increase the time to unload).

Required

Redispatch

Set to TRUE if vehicle will be sent back out on another route, if time remains in the workday; FALSE if Redispatching is not used.

Optional

MinTm

Minimum Time; used with Redispatching. Reflects amount of time (hours) that must remain in a workday upon return to depot, in order to redispatch the vehicle.

Optional

TurnTm

Turn Time is used with Redispatching; the amount of time (minutes) it takes to reload or any required time at the depot, between routes, before Redispatching.

Optional

MiCost

Mileage Cost is cost per mile to operate this vehicle.

Required

HrCost

Hourly Cost is the hourly cost of the driver for this vehicle.

Required

OTCost1

Overtime Costs is the cost per hour added if the time to complete the route exceeds the time set for WorkDay. 

Ex: If the cost for the first two hours of overtime is $5, then OTCost1 = 5.

Optional

OTHrs1

The level at which overtime hours are calculated; used with OTCost1. 

Ex: If OT costs are paid in 2 hr. increments, then OTHrs1 = 2. 

Optional

FixedCost

Costs that don’t change (tractor rental, maintenance, etc.)

Optional

UnldHrCost

Cost to unload per hour.

Optional

DropCost

Drop Cost is the drop cost for each stop. User input, File > Preferences > Routing > General (Drop Count). A number in this section will add a drop cost to each stop on the route.

Optional

WaitHrCost

The cost per hour if a vehicle must wait at the stop before making its delivery.

Optional

UnitCost

The cost of each unit delivered (volume).

Optional

LayoverCost

The cost applied when a vehicle must layover before completing its route and returning to the terminal.

Optional

EarStart

The earliest time a vehicle may leave the terminal to begin a route; enter in military time format (2400).

Optional

EDate

The earliest day, from the dispatch date, a vehicle may depart. The Date of Dispatch is DAY 1. A one (1) would be entered in this field if the trucks could leave on the first day of dispatch. One day vehicles may have an Edate of 1-7, depending on which day of the Dispatch cycle they are released to proceed.

Required

LatStart

The latest time a vehicle can leave out of the terminal; enter in military time format (2400).

Optional

LatFinish

The latest time a vehicle must return to the depot; enter in military time format (2400).

Optional

LDate

The latest date a vehicle must return to the terminal. This day is calculated from the dispatch date. A one-day route may have an Edate of 1, but also a Ldate of 1, while a weekly route may have an Edate of 1 and an Ldate of 7.

Required

WorkDay

The number of hours in a normal workday, OTCosts are incurred if the Workday hours are exceeded to complete the route (required if OTCost1 is used)

Optional

NormalStart

The normal daily start time of the vehicle

Required

Brk1Start

How far into the shift/route a mandatory break should start; if the driver should take a break four hours into the route, then Brk1Start = 4. 

Note: Up to five break fields can be used.

Optional

Brk1Duration

The duration of the break; entered in decimal or whole number format (30 min = .5, 15 minutes = .25, etc.). Each numbered Break Start field must have a corresponding numbered Break Duration field.

Optional

MaxWorkTm

The max time a vehicle can be out before returning to the depot (per day)

Required

TargetWrkTm

The target work time for each vehicle.

Optional

MaxDriveTm

The max drive time per shift on a route before a layover is implemented; entered in hours.

Optional

MinLayover

The minimum number of hours a vehicle can layover.

Optional

MaxLayover

The maximum number of hours a vehicle can layover.

Optional

MaxDrvTmB4Layover

Used by the software to determine how long a vehicle must drive before a layover can be implemented.

Optional

MaxLayovers

The maximum number of layovers allowed per route.

Optional

Max Miles

Enter the number of miles by which to limit the vehicle. When used, DirectRoute will not attempt to build routes that exceed the number of miles set in the field. Field is considered during the optimization process; moves or swaps will not be made if the total route miles will exceed this setting. If a route is manually edited to go over the Max Miles set in this field, DR will return a MaxMiles route level violation.

Optional

PreTrip

In accordance with DOT rules, time added (in minutes) at the start of each route. 

Optional

PostTrip

In accordance with DOT rules, time added (in minutes) at the end of each route.

Optional

Origin

Name of the Depot

Optional

Address

Address where the vehicle (Depot) is located.

Required

City

City where address is located; used to geocode and used in the Distance File.

Required

State

2 letter state abbreviation for the address; used to geocode.

Required

Zip

Zip Code of the address; used to geocode.

Required

Country

This column will be used during the geocoding process for passing country code to the mileage system. If no value is present in this column, the country code set in the Preferences will be used. The value in this column should be ISO2 or ISO3 country code format (i.e. valid country code for the US is USA/US and for Canada CAN/CA). If no address information is given in the file, DR will try to geocode the stops using City, State, and Zip.

USA/US

Longitude

The Depot's longitude coordinate, discovered during the geocode process.

Required

Latitude

The Depot's latitude coordinate, discovered during the geocode process.

Required

Zone

A percentage adjustment to the drive time. Default is 100 = normal rate of speed. An increase to the drive time will lower speed; a decrease to drive time will increase speed. Zone is hard coded to eight miles. 

Ex: If rush hour distance is set to 30 miles, it will apply to the truck for a 30mile radius from the depot. If it is set on the customer in the Stop File, it will be a 30mile radius from the customer.

Ex: (Truck File) A value of 110 would increase the drive time by 10%, hence lowering the speed by 10%. A value of 90 would decrease drive time by 10%, increasing speed by 10%. The speed adjustment is only applied to the first 8 miles of each route segment (from Depot). 

Ex: (Stop File) If all customers in downtown Chicago have a value of 110 in this field, the software will increase drive time for the stops in downtown Chicago (within the 8 mile radius), while lowering the speed of travel.

Optional

AMStart

Set AM start time to adjust speed to account for heavier/lighter traffic.

Optional

AMEnd

Set AM end time to adjust speed to account for heavier/lighter traffic.

Optional

AMAdj

Set drive time adjustment for AMStart and AMEnd. AM/PM Adjust works the same as Zone; increase the number (110) to increase the drive time by 10 percent. In turn the speed is decreased by 10 percent. The radius is based on the rush hour distance setting (Preferences > Routing > General). Zone is hard coded to eight miles, while AM/PM Adjust is based on the rush hour distance. 

Ex: If rush hour distance is set to 30 miles, it will apply to the truck for a 30mile radius from the depot. If it is set on the customer in the Stop File, it will be a 30mile radius from the customer.

Optional

PMStart

Set PMStart to adjust speed to account for heavier or lighter traffic.

Optional

PMEnd

Set PMEnd to adjust speed to account for heavier or lighter traffic.

Optional

PMAdj

Set drive time adjustment for PMStart and PMEnd. See AMAdj for additional info.

Optional

Symbol

The symbol (size and color) that is displayed on the map, to represent the Stop. Symbols are chosen from the Stop File; Double+Click on the customer record to open the dialog box; select the symbol, size and color, then select on OK.

Optional

Size

Specifies the size of the symbol to be displayed on the map. Default size is 8.

Optional

Color

Specifies the color of the chosen symbol. Select colors in the same fashion/at the same time as selecting symbols.

Optional

AMStart

Set AM start time; adjust speed for heavier/lighter traffic.

Optional

AMEnd

Set AM end time; adjust speed for heavier/lighter traffic.

Optional

AMAdj

Set drive time adjustment for AMStart and AMEnd. AM/PM Adjust works the same as Zone; increase the number (110) to increase the drive time by 10 percent. In turn the speed is decreased by 10 percent. The radius is based on the rush hour distance setting in the Preferences. Zone is hard coded to eight miles, while AM/PM Adjust is based on the depot radius distance (Preferences > Routing > Algorithm > Depot Radius). 

Ex: If rush hour distance is set to 30 miles, it will apply to the truck for a 30mile radius from the depot. If it is set on the customer in the Stop File, it will be a 30mile radius from the customer.

Optional

PMStart

Set PMStart to adjust speed to account for heavier or lighter traffic.

Optional

PMEnd

Set PMEnd to adjust speed to account for heavier or lighter traffic.

Optional

PMAdj

Set drive time adjustment for PMStart and PMEnd. See AMAdj for additional info. 

Note: AM/PM Adjust works the same as zone; increase the number (110) to increase the drive time by 10 percent. In turn the speed is decreased by 10 percent. The radius is based on the rush hour distance setting in the Preferences. Zone is hard coded to eight miles, while AM/PM Adjust is based on the depot radius (Preferences > Routing > Algorithm > Depot Radius). 

Ex: If rush hour distance is set to 30 miles, it will apply to the truck for a 30mile radius from the depot. If it is set on the customer in the Stop File, it will be a 30mile radius from the customer.

Optional

Georesult

Georesult will display the results received when records are geocoded.

Automatic