CONFIGURATION

Config settings applied to the Stop and Truck Files

ID1

Acct#

A unique field to identify a stop (customer#, account#, invoice#, etc).

ID2

Order#

Optional secondary field identifying a stop (order#, SKU#, etc.)

ID3

ID3

Optional tertiary field (item#, etc.)

Name

Name

Customer name, Account#, etc.

Address 2

Addr2

Optional secondary address info (bldg#, dock#, door#, etc.)

Contact

Tom Jones

Contact info for delivery

Phone

516-222-1234

Contact info for delivery

Volumes

(Collection)

(weight, cases, pallets, units, etc.)

Volume type used in the Stop File 

Stop User Fields

(Collection)

Ex: Comments, Style, Descript, Order Status, etc.

Optional additional fields to list in the Stop File; use to collect info for reports, display in Route File, etc. 

Truck User Fields

(Collection)

Ex: Driver, Shift, Maint. Cat, etc.

Optional additional fields to display in the Truck File; use to collect info for reports, display in Route File, etc.

Number of Time Windows

2

Number of delivery time windows (1 thru 10)

DEFAULTS

Applied to all stops

Time Window

(Collection)

Default delivery time window applied to ALL stops

Fixed Time

15

Standard fixed time (minutes) applied to ALL vehicles at each delivery

EQ Code

LG-BH-002

Ex: 1 to 3 characters per code; multiple codes separated by a dash (–)

Special identifier for vehicles and/or requirements (lift gate, backhauls, priority codes, OD Pairs, etc.)

Unload Rates

( Collection)

(weight, #cases, #pallets, etc.)

Standard number of Volume quantity unloaded per hour 

Zone

100

Note: Increase or decrease applied as percentage to drive time to affect speed of vehicle

Ex: 110 = increase drive time by 10%, decreases speed; 90 = reduce drive time by 10%, increases speed

Default = 100; used to increase or decrease drive time (speed) within a pickup or delivery area; applied within 8 mile radius of depot, or applied to stops located within 8 miles of another stop

Earliest Date

1 Jan 2016

Earliest date of delivery

Latest Date

3 Jan 2016

Latest date of delivery

Early Buffer

.25 

Ex: 1.00 = 1 hour, 0.25 = 15 min, 0.5 = 30 min, 0.75 = 45 min

Time before actual delivery window allowed for early delivery without penalty

Late Buffer

.25

Ex: 1.00 = 1 hour, 0.25 = 15 min, 0.5 = 30 min, 0.75 = 45 min

Time after actual delivery window allowed for late delivery without penalty

Penalty Cost

50

(50 = $50)

Fee ($) assessed when delivery Time Window is violated

Max Splits

2

Note: When Apply Defaults is set to TRUE, then Max Splits value is applied to each stop

Maximum # of times any stop (volume) can be split

DRTRACK

Use with DRTrack license

DRTrack URL

http://companyname.routetracking.com/Login.aspx

URL to DRTrack site; used for uploading data/files

Company Name

Johnson Tile

Used for importing and exporting

DRTrack Username

Username for DRTrack. We recommend setting a Username and Password to help ensure only authorized users pass data to and from DRTrack.

DRTrack Password

Enter DRTrack password

Password for DRTrack. We recommend setting a Username and Password to help ensure only authorized users pass data to and from DRTrack.

DRTrack Proxy Server

(If used to filter internet traffic)

Name of the proxy server

DRTrack Proxy Port

Port for proxy server

DRTrack Proxy Username

Proxy Username

DRTrack Proxy Password

Proxy password

DRTrack Timeout

10

System time-out value, in minutes

Branch

(Collection)

Branch names, if used

Default Branch

Default branch name

Profiles

(Collection)

Truck profiles, if used for different routing days

Route Upload Version

5

Upload version# 

Master Profiles

Master Profile names. More than one can be recorded and used

Shift

(Collection)

(Shift name, From time, To time, Truck Profile)

Enter Time Shifts when routing occurs (if used)

Account Master Upload Version

1

Upload version#, if more than one is used

Use LoadID From Stop File

TRUE (FALSE)

Default is FALSE

Compression Method

None (Zip)

File compression method 

Manage Master Profile Routes

Set the start and end dates for each Master Profile

ETSPROVIDER

Interface settings for additional TMW software modules

TMW ETS

Truckmate

Select product family for interface

TMW INNOVATIVE LOGIN

Username 

Login credentials (requires additional license)

Password

Enter Password

SCAC code

Enter SCAC code

Service Version

Version 1

EXTRACT

Use with OMS to extract data for Route Files

Account Master File

Master.xls

Master File name

Append New Accounts to Account Master 

TRUE (FALSE)

Set to TRUE, will append (add to) the Master File with new account data found in the Extract File. 

Extract Option

CreateStopFile

Creates a Stop File from the Master File with all account information, or Update Account Master File

Get Address from Account Master 

TRUE (FALSE)

Gets address information from the Master File

Overwrite Address in Account Master 

TRUE (FALSE)

Overwrites address in the Master File with address from Extract File

Primary Identifier

ID1

ID1 from Configuration setting

Secondary Identifier

None

ID2, if used

Tertiary Identifier

None

ID3, if used

Update Blank Account Master Fields

TRUE (FALSE)

If TRUE, will update blank fields (existing customers only) in the Master File with data from the Extract File.

Use Defaults for New Accounts

TRUE (FALSE)

If TRUE, will populate the default field settings (Time Windows, Unload Rates, etc.) to any new accounts in the Master File.

Zero Coordinates if Address doesn’t match

TRUE (FALSE)

If TRUE, will clear the Lat/Long from the Stop File if the address in both the Master File and Extract File does not match

Populate LoadID in Truck File

TRUE (FALSE)

Note: Applies when an Extract is performed with a new Route Build, and LoadID columns are populated

If TRUE, copies LoadID from Extract File to Truck File when routes are initialized 

LoadID Column Name

Column that contains LoadID in Extract File

Interface

Interface

FILE NAMES AND PATHS

Identifies location of files used in the routing process

User Data Directory

C:\Program Files\Appian\DirectRoute\Data

Note: Should be in the DirectRoute folder that was created during the installation process. 

Note: DirectRoute will display a message on the screen when the user doesn't have access (authorized API key) to the selected Directory, and the info box will be restored to the original User Data Directory path. 

Location of the User or project DirectRoute Data Folder 

9-Digit Zip Directory

C:\Program Files\Appian\DirectRoute\

ZIP9 Data

Note: Should be in the DirectRoute folder that was created during the installation process

Name and location of the ZIP9 Data File 

Account Master File

C:\Program Files\Appian\DirectRoute\Data\Acct Master File.xls

Location and name of the Account Master File

Base Map Directory

C:\Program Files\Appian\DirectRoute\

Base Maps

Note: Should be in the DirectRoute Data Folder that was created during the installation process

Location of the Map File

Cross Dock File Path

C:\Program Files\Appian\Direct Route\Data\Cross Dock.xls

Location and name of Cross Dock File

Custom Geocode File Path

C:\Program Files\Appian\Direct Route\Data\Geo File.xls

The path to the Custom Geocode File

Drawing File Name

C:\Program Files\Appian\Direct Route\Data\ Drawing File.drw

The path of the Drawing File

Geoset

C:\Program Files\Appian\Direct Route\BASEMAPS\USA\USA.GST

The location of the .gst File

OBC Folder Path

OBC upload output folder path

Product Family File Path (*.xls)

C:\Program Files\Appian\DirectRoute\PFFP File.xls

Note: File should contain populated ProductFamilyName column {mapped with TankSpEq column in Truck File} and populated ProductName column

Select Product Family File for Tanker Algorithm

Relay File Path

C:\Program Files\Appian\DirectRoute\Data\Relay File

Enter the path name to the Relay Truck File

Upload File Name

Upload File

Enter the name of the Upload File

Upload File Path

C:\Program Files\Appian\DirectRoute\Data\ Upload File

Enter the path to the Upload File

Upload Format File (*urp)

URP File name and location; input here will remove prompt during every upload session

Z1 Path

C:\Program Files\Appian\ DirectRoute\Address Cleanup\Z1.DAT

Note: Should be in DirectRoute\Address Cleanup folder

Name and location of the Z1 File 

Z8 Path

C:\Program Files\Appian\ DirectRoute\Address Cleanup\Z8.DAT

Note: Should be in DirectRoute\Address Cleanup folder

Name and location of the Z8 File

GEOCODE OPTIONS

Used to find and validate location coordinates

Secondary Geocoder

None, Google

Note: Limited to 2,500 requests per 24hr period, and 10 requests per second. 

Use Google to validate geocode results, or to obtain Canada or Australia geocode results.

Fallback to secondary geocoding after

Always, Never, Level 1, Level 2

Level 1: Recheck if result = other than Level 1

Level 2: Recheck if result = other than Level 1 or 2

Never: Never recheck addresses

Always: Always recheck addresses

Default is Always 

GOOGLE SETTINGS

Required when Google is Secondary Geocoder

Google API Key

800900700601 

(12-digit # issued when User initiates a Google Maps account)

Google API address

Google Geocode Accuracy Level

Rooftop

Rooftop–(High Accuracy) Precise down to street address precision

RangeInterpolated–(Same Street) Reflects an approximation (usually on a road) interpolated between two precise points (such as intersections);

Geometric Center–(Same Region) Result is the geometric center of a result such as a polyline (ex. a street) or polygon (region);

Approximate–(Approximate) Indicates the result is approximate

Default is Rooftop

IMPORT

Use with Integrated TMW Systems to Import files

Enable Order Selection

TRUE (FALSE)

Set to TRUE if downloading orders for next dispatch date + additional days

Overwrite Quantity Fields

TRUE (FALSE)

Set to TRUE if not passing required fields

Overwrite User Fields

TRUE (FALSE)

Set to TRUE if not passing User Fields

Ignore Trucks passed in XML

TRUE (FALSE)

If FALSE, will prompt the user to pick a Truck File

Enable Preprocess

TRUE (FALSE)

If set to TRUE, enables Preprocess to run when importing from an XML File

MODE SELECTION

For use with Transportation Modeler, identifies mode types available, files, costs, and limitations

MaxRoutesPerShipment

3

Max# of routes per shipment; default is 3

Rate File

C:\Program Files\Appian\DirectRoute\Data\Rate Table

Path to Rate File

Distance File

C:\Program Files\Appian\DirectRoute\Data\ Data.dist

Distance File name/path; usually the DirectRoute Data Folder

Default TLRate

1.5

Default truckload rate

Weight (Primary Qty Field)

Weight

Primary Qty field used

Volume (Secondary Qty Field)

Cube

Volume field used

Count (Trichiary Qty Field) 

Skids

Quantity count (WT, Cube, Skids, etc.)

SECURITY CREDENTIALS

 USER CREDENTIALS

Use with Rateware, UPS

FEDEXCONFIGURATION

SERVICE TYPE

Use with FEDEX service

Wait cost in LTL shipments

150.5

Wait cost in LTL shipments

Border crossing delay

90

Border crossing delay (minutes)

Max Allowed Work Hours in DOT Cycle

0

Max allowed work time on multi-day route (ex. 60 hrs)

Team Rate Premium

890

Team Rate Premium

Aggregate LTLCost on Consolidate

TRUE (FALSE)

Default is FALSE

LTL Consolidation Type

Costs or Miles

Consolidation type for LTL Shipments

LTL COST ADJUSTMENT

Cost adjustments (LTL Rate)

Quantity Name

Weight

Volume type

Quantity Over

0

Threshold after which LTL Cost Adjustment is added

Additional Cost

0

Additional cost when threshold is reached

OTHER

Mileage System and Map Files 

Mileage System

Trimble Maps

(PC*MILER Direct, PC*MILER, MapInfo, MapInfoCV, or None)

Name of the Mileage System to be used with the software

Date Format

MM/dd/yyyy, dd/MM/yyyy, MMMM dd yyyy, or yyyy-MM-dd

Time Format

Time format used when passed to primary business system using an Upload File

Custom Geocode File Path

C:\Program Files\Appian\DirectRoute\Data\ Geo File.xls

Location of custom Geocode File, if used

Geocode File Col Identifier

CTY

Name of the column in custom Geocode File, to be examined when applying custom geocoding

Distance Options

Miles

Miles or Kilometers, used in map bar display

Coordinate Option

Decimal Degrees

Decimal degrees, (Degree:Minute:Seconds) used in the map status bar

Convert STP/xls File

TRUE (FALSE)

If TRUE, converts .STP and older .xls Files to newer format

FIND STREET LAYER

Designation of street level GST layer used in Find Street utility

Major Road

Main Street

Name of the road

Street 1

Usa_dap

Street 2

Country

En-AU (English) Australia

For use with Google Maps API Geocoding, select applicable country code, if needed

Company Name

Parks

Name

Auto-save solution after generating directions

TRUE (FALSE)

If TRUE, saves solution after direction generation

Auto-save Route Book layout files

TRUE (FALSE)

If TRUE, saves Route Book layout (F8 key) when the Route Book is closed

Clone Stop and Truck File while saving Route File with Save As option

TRUE (FALSE)

If TRUE, saves and copies Stop, Truck, and Route File, when using Save As option to close files; copied files are assigned a new (same) name as the Route File, while original Route Files are left intact and unchanged

Store distance entries in:

File

Note: If entries are stored in Database {Db}, use the following app settings in the exe.config File: 

Use Database for DistanceEntries =TRUE ConnectionStringName = Name of the string configured {Connection Strings section} CompanyID =1 {default})

Select File or Database (PC*MILER route type)

ORDER CRITERIA

Enables Order Selection Filter for DRTrack download, and Selective Routing

Query by User Field

Status

Enter each Stop User Field (Configuration > Stop User Fields) to enable use as a filter for stop selection 

Query by Values

Ready / Not Ready

Ex: Stop User Field chosen is Status.

Values found in the Stop File (in this field) are Ready and Not Ready 

Enter all Values separately, as found in the selected Stop User Field

Stop Selection Color

Choose color for stop selection

Blue

Auto open Stop Grid on Routing

TRUE (FALSE)

When set to TRUE, automatically opens the Stop Grip in a routing solution

Replenishment Point Name

Default

TruckID

Choose refuel point name to be displayed

PC*MILER

Use with a PC*MILER license

PC*MILER routing options

Route across borders

TRUE (FALSE)

If TRUE, will allow routes to cross international borders; default is FALSE

Route Type

Practical

Practical, Shortest or Air (straight line)

Route Type option

Default

Default, National, Avoid Toll, or Fifty Three

Hazardous option

None

None, General, Explosive, Inhalant, Radioactive, Corrosive, or Flammable

Thread

Single

For use when generating Distance File, for multi-core CPU, set threading to Multiple; otherwise set to Single

PC*MILER DIRECT

Use without a PC*MILER license

PC*MILER routing options

Route across borders

TRUE (FALSE)

If TRUE, will allow routes to cross international borders; default is FALSE

Route Type

Practical

Practical, Shortest or Air (straight line)

Avoid Toll

TRUE (FALSE)

If TRUE, will avoid toll roads when possible during the routing process; default is FALSE

Hazardous option

None

None, General, Explosive, Inhalant, Radioactive, Corrosive, or Flammable

Thread Count

0

Preset; not editable

Distance Generation Mode

Pair

Option to change how PC*MILER generates distance entries. Default is Pair

Vehicle Profiles

(Collection)

Profile allows edit of vehicle height, length, width, weight limit, and # of axles (no less than 2).

Ex: Light Assets, Full Sized Van, Double Trailers, Straight Truck, 48’ Semi Trailer, 53’ Semi Trailer, or Custom (PC*MILER Direct/Vehicle Profiles). Add additional if necessary, under ‘Custom’.

Add/Enter all vehicle profiles used in the Truck File. Only those profiles entered will be available for selection in as a Default Vehicle Profile. 

Default Vehicle Profile

Only vehicles entered in Vehicle Profiles will be available for selection.

Select the default vehicle profile to use during the route building process.

Map Region

Default Map Region

N/A (not used at this time)

Use Historical Traffic Data

Requires additional Appian licensing.

When not used, system will default to DirectRoute Drive Time (or other installed Mileage System). 

If TRUE, generates drive times and distances based on historic traffic time estimates and collected real-time traffic data, instead of DirectRoute’s calculated drive time/distances.

POSTPROCESS

Use to accelerate additional processes after routing

Upload

TRUE (FALSE)

If TRUE, will pass orders/routes in an upload file (UPL) after routing

Upload DRTrack

TRUE (FALSE)

Set to TRUE, will pass orders/routes to DRTrack after routing

Print Route Book

TRUE (FALSE)

If TRUE, will automatically print the Route Book upon completion of the routing process

PREPROCESS

Use to accelerate the routing process

GENERATE DISTANCE FILE

Generate Distance File

TRUE (FALSE)

If TRUE, generates Distance File during Preprocess

Minimum Distance Between Stops

0

Minimum distance the software will compute distance between stops

Maximum Distance Between Stops

800

Maximum distance the software will compute distance between stops

Speed Adjustment

100

Adjust drive time by this factor (100 is baseline, 120 increases drive time by 20%, etc.)

Maximum Speed

60

Maximum allowable speed by vehicle on a route

Generate 2-way entries for stops less than (x miles)

5

Add a return distance, between two stops within X miles of each other 

Generate 2-way distance entries

TRUE (FALSE)

If TRUE, will calculate distances To and From stops

Stem Distances Only

TRUE (FALSE)

If TRUE, will calculate distance between the Terminal and City where the stop is located (not the stop itself) 

In Cone

TRUE (FALSE)

(Angle and radius created from the terminal, defaulting to 57º)

If TRUE, only stops within the Angle or Radius may be added to the selected route 

Overwriting Existing Entries

TRUE (FALSE)

If TRUE, will overwrite any Distance File in the DirectRoute Data Folder

Within Territories

TRUE (FALSE)

Set to TRUE, will generate a Distance File with distances listed between EqCodes of the same type

Route Across National Border

TRUE (FALSE)

If TRUE, will allow route to cross Canada and/or Mexico borders; if FALSE, will prevent routes from crossing borders (may result in more miles)

Commercial Restrictions

TRUE (FALSE)

Option for Prophesy to use only roads permitted for commercial vehicles

Avoid Toll Roads

TRUE (FALSE)

If TRUE, keeps trucks from using toll roads

Use DirectRoute Drive Time

TRUE (FALSE)

If TRUE, will generate distances and drive times using DirectRoute calculations (instead of any optionally installed Mileage System or Historic Traffic Data.

Threading

Single Thread

For use when generating Distance File, multi-core CPU = set threading to Multiple, otherwise set to Single

Distance File

Location to save Distance File, generated during pre-process

Use Mileage System Drv Time if it is > DirectRoute Drv Time

TRUE (FALSE)

If TRUE and an optional Mileage System is installed, will use the optional Mileage System’s drive times when generating the Distance File if those drive times are greater than DirectRoute’s calculated drive times.

GEOCODING

Geocode Stops

TRUE (FALSE)

If TRUE, will Geocode Stop File before routing

Clean Address

TRUE (FALSE)

If TRUE, calls the Address Clean up module to clean the records prior to Geocoding

Skip Geocoded Records

TRUE (FALSE)

If TRUE, will skip any records that have been previously Geocoded

Color Code Stops

TRUE (FALSE)

If TRUE, color codes stops 

Update Address, City, and Zip

TRUE (FALSE)

If TRUE, updates corrected Address, City and Zip

APPLY BOUNDARY

Apply EqCodes to stops

TRUE (FALSE)

If TRUE, applies EqCodes to stops

Drawing File Name

Name of the Drawing File (if used)

Overwrite Existing EqCodes

TRUE (FALSE)

If TRUE, overwrites existing EqCodes

APPLY DEFAULTS

Apply Defaults

TRUE (FALSE)

If TRUE, enables the Stop Filter selection during the routing process (actives the Stop Filter Pop-up menu).

Overwrite Existing Entries

TRUE (FALSE)

If TRUE, overwrites existing entries in Stop File

FIXED ROUTE

Run Fixed Routes

TRUE (FALSE)

If TRUE, stops are matched to trucks based on the fields selected to get route assignments

Truck File Matching Field

Trk ID

Select a field from the Truck File

Stop File Primary Matching Field

Trk ID

Select field in the Stop File that corresponds to the field in the Truck File

Stop File Secondary Matching Field

Driver

Select the field in the Stop File that corresponds to the field in the Truck File

Copy Sequence

TRUE (FALSE)

If TRUE, sequence number will be copied from the selected field to the SEQ field

Stop File Sequence Field

Select the field that has the sequence number

Get DOW Sequence Code Based Upon Pattern 1

TRUE (FALSE)

For fuel-specific functions

Overwrite Route and Sequence

TRUE (FALSE)

If TRUE, will overwrite existing Route and Sequence, if any, already in the Stop File

Generate Route Directions

TRUE (FALSE)

If TRUE, will generate route directions after routes are built

Enable Stop Filter

TRUE (FALSE)

(Applies to selected records only, versus all records in the Stop File)

If TRUE, will enable the Stop Filter during the route building process

ROUTING

Options for Automatic Load Building and Optimization

ALGORITHM SETTINGS

Add Turn Time

TRUE (FALSE)

If TRUE, and redispatch is selected in the Truck File, DirectRoute will add the specified turn time to the route work time

Algorithm 

REGULAR–Normal two-way routes

DOW–Day of Week, for fuel specific functions

INBOUND TO–Route from stops back to depot, similar to a one-way inverted route

FARTHESTIN–Two-way routes from the farthest stop back to the depot

OUTBOUND–Farthest stop is the last stop, with return to the depot

Select the desired Algorithm type to use

Box Expand

5 

Note: When optimizing, the software constructs the smallest box that will contain all the stops on a route; parameter affects the optimization process.

Number of miles (size of box around stops); default is 1

Check In Cone

TRUE (FALSE)

(Not recommended for One-way routing)

If TRUE, forces the software to select and group stops in a geographical direction 

Cone Angle

55

Angle of cone, with depot at center; default is 55

Depot Radius

10

Radius around depot (miles) to which stops can be loaded on same route out of cone; default is 10

Lambda

2

(Determines how much weight to give cone expansion vs. distance from depot)

Used by Algorithm when deciding which stop to load on a route next; less than 2, will build tighter routes

Lambda Increments

0.2

Ex: If Lambda is = .6, increments = .2, and iterations = 4, the software will construct routes four times (iterations) in increments of .2, starting at .6 (ex .8, 1, 1.2)

Incremental value added to LAMBDA for each iteration, when constructing routes

Lambda Iterations

1

(To find which value yields the lowest cost solution, run several routes using 1 thru 4)

The number of times the software will build routes using the Lambda Values 

Max Redispatch Iterations

4

(How the software determines the feasibility of redispatching a route)

If set to 4, the software creates up to 4 load passes to determine the best scenario

Max Wait Time

1000

Maximum amount of time a vehicle will be allowed to stay at a stop

Max Dist Between Stops

8000

Prevents stops that are more than X miles apart from loading on the same route

Max Work Time LO

0

Maximum work time before a layover is required

Optimize Stops After Loading

TRUE (FALSE)

If TRUE, moves stops between and within routes to minimize cost

Optimize Trucks After Loading

TRUE (FALSE)

If TRUE, moves loads from bigger to smaller trucks to minimize cost; if using various vehicle sizes in the Truck File, set to TRUE

TW Gap For Buffers

1.75

If early and late buffer overlaps the gap between time windows, then they are adjusted to have the specified amount as gap between time windows

Load Backhaul Stop on Empty Truck

TRUE (FALSE)

If TRUE, loads backhaul stop on empty trucks

Max Out of Route Miles For Backhaul

1000

Set max miles to consider for backhaul route; if stop is farther than this, it will not be considered for backhaul

Max Percent Out of Route Miles for Backhaul

50

Set max percentage of route miles, instead of distance, to consider for backhaul

Max Closest Stops

200

Maximum closest stop

Refuel Algorithm

Original, Distance Based

Original - Default option, works using the existing algorithm; will insert refuel points based on location, in reference to stop locations.

Distance Based - Will keep track of route capacity and adds refuel points only when capacity is available and still 30% of work time left in a route. This option will also remove refuel points when not needed.

Select which algorithm to apply during routing. 

Add Pre-Post time on redispatch

TRUE

When TRUE, adds Pre/Post time on all legs. When FALSE, adds only for the starting and ending terminal on the whole route.

Use Terminal as Refuel Point

TRUE

When TRUE, considers the terminal as a refuel point. If false, DR does not consider the terminal as a refuel point.

Max Routes Per ID1

-1

Max number of routes to allocate per ID1. Less than 1 will disable this feature.

GENERAL

Enable Start Time Column

TRUE (FALSE)

Using this function removes the necessity to edit individual routes each time a change is needed to the actual route start time. 

When TRUE and Start Time column is added to the Stop File, DirectRoute will use the Start Time listed in the Stop File as a route dispatch time when initializing routes.

Allowing Logging

TRUE (FALSE)

If TRUE, sets tracking mechanism for algorithm xml

Display Build Route File tab option

TRUE (FALSE)

(For DRTrack users)

Show/Hide Build Route File tab on New Route dialogue box

Distance Cache

1000000

Max size of cache used for Distance File records

Drop Count

0

Subtracts a drop cost from equal number of stops

Field used in Distance File

Lat/Lon

Field other than city (account, zip, etc) to use in Distance File

Lock on Init and Load

If TRUE, locks trucks already routed from being considered when routing new stops.

Make Empty Trucks Unavailable after loading

TRUE (FALSE)

If FALSE, allows empty trucks to be loaded during the Modify Load process

Maximum Stops Per Route

50

Set max number of stops per route

Mileage Adjustment

100

Percentage to adjust calculated mileages; default is baseline 100. Ignored if distance entries are used.

Minimum Time Between stops (minutes)

0

Minimum time between stops; overrides drive time calculations if calculated time is less than this number

Apply Min Time Between Stops after directions

TRUE (FALSE)

If TRUE, will automatically apply the Min Time Between Stops (Min) 

Route Colors

(Collection)

Define colors for each route

Route Line Width

Use the dropdown menu to select the width of the line displayed on the map (planned routes on the map)

Color Empty Miles

Use the dropdown menu to select a color to apply on the map to portions of a route performed by an empty vehicle

Scale Factor

0

Used to increase miles on a route using percentages. Ex: 1.1 = 110%

Secondary Route Identifier

TrkID

Secondary Identifier for a Route

Speed 

50

(50 =50 mph)

Sets an average speed on a route, in miles per hour 

Speed Adjustment

(Drive Time)

95

Increase drive time = decreases vehicle speed 

Decrease drive time = increases vehicle speed 

Ex: 95 = Decreases drive time 5% by increasing vehicle speed by 5%

% to increase or decrease Drive Time; default is 100. 10% increase = 110

10% decrease = 90

Use DirectRoute Drive Time

TRUE (FALSE)

If TRUE, used DirectRoute drive times instead of other installed Mileage System

Rush Hour Distance

0

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

Distance in which adjusted speed is implemented to account for traffic delays; used in conjunction with Speed Adjustment and AM/PM Adj fields in the Stop File and/or Truck File.

Dispatch Date Offset

1

Number of days out from the date routes are run, to begin dispatch/delivery

CONSOLIDATE SETTINGS

Note: Consolidation settings are validated each time the settings are updated

If TRUE, consolidates stops with same settings 

(Time Windows, EqCodes, Lat/Long, Size Restrictions, etc.)

Consolidate by ID1

TRUE (FALSE)

If TRUE, consolidates stops by value in ID1

Consolidate by ID2

TRUE (FALSE)

Note: An error message will be generated if Consolidate by ID2 is set to TRUE and both Consolidate by ID1 & Consolidate by Address is set to FALSE; this setting must be corrected to save/close the dialog box, or select Cancel to exit without saving the erroneous setting changes)

If TRUE, consolidates stops by value in ID2; set to FALSE if Consolidate by ID1 and Consolidate by Address are both set to FALSE

Consolidate by Address

TRUE (FALSE)

If TRUE, consolidate stops by address

Consolidate (Sum) Fixed Times

TRUE (FALSE)

If TRUE, will consolidate all stops to the Fixed Time of first stop in the group

Consolidate on Initialize

TRUE (FALSE)

If TRUE, consolidates routes upon initialization

STATIC SPLITTING

Restrictions for Split Loads

Split Size

0

Set minimum size of load to split. Generally, set with split stops 'TRUE' and split orders 'FALSE'

Split Stops

TRUE (FALSE)

If TRUE, allows splitting a stop between routes

Split Orders

TRUE (FALSE)

If TRUE, allows splitting an order (by line item) between stops

Split Line Items

TRUE (FALSE)

If TRUE, allows splitting of line items between stops

Quantity Field To Split

None

Qty field used to calculate splits (i.e. weight, cube, Pallets, etc.)

DYNAMIC SPLITTING

Restrictions for Routes with low stop counts

Split Stops While Loading

TRUE (FALSE)

If TRUE, will split the load to ensure delivery of the product; if FALSE, the remaining parameters for Dynamic Splitting are inconsequential

Split Orders

TRUE (FALSE)

If TRUE, software will consider splitting an order by line item, between routes; if FALSE, will only split stops by full orders

Split Line Items

TRUE (FALSE)

If TRUE, software will consider splitting stops at the line item level; only valid for stops that have just one order with one Line Item 

Evaluate All Splitting Options

TRUE (FALSE)

Evaluates splitting options during optimization process

Max Splits Per Stop

0

(generally, just 1 or 2 times)

Max number of splits per stop 

Min Split Size

0

Minimum size (Quantity 1 field) for a split order

Splits-Truck Full

0

Used in conjunction with Min Split Size; determines vehicle capacity percentage used for split loads

GRAPH

Fields from the Truck File, to appear on the Graph Chart in the Route Book

Route Identifier 1

None

Route identifier, from the Stop File

Route Identifier 2

None

Route identifier, from the Stop File

Route Identifier 3

None

Route identifier, from the Stop File

Route Identifier 4

None

Route identifier, from the Stop File

Route Identifier 5

None

Route identifier, from the Stop File

Route Identifier 6

None

Route identifier, from the Stop File

STOP CAPACITY ADJUSTMENT

Allows lowered vehicle capacity based on the number of stops

Capacity Field

None

Qty field to use for stop capacity adjustment

Stop Adjustment

0

Amount of Qty to reduce capacity

CROSS DOCK/RELAY ROUTES

Use with Relay and Cross Dock Files

Cross Dock Col Identifier

Column heading in Cross Dock File to identify cross dock location 

Cross Dock File Path

Location of the Cross Dock File

Relay File Col Identifier

Column heading in the Truck File that identifies a Relay Route

Relay File Path (.xls, *.xlsx)

Location of the Relay Truck File

PASSWORD PROTECTION

Pswd protection for Routing Category

Enable

TRUE (FALSE)

Default is FALSE

Password

TRUE (FALSE)

Add/Edit password

TANKER

Used for load building compartmentalized vehicles

Weight

Choose from Volume fields

Volume

Choose from Volume fields

Count

Choose from Volume fields

Tote File Name

C:\Program Files\Appian\ DirectRoute\Data\ Tote.xls

Name and path of the Tote File, typically found in the DirectRoute Data Folder

Product Ratio File Name

C:\Program Files\Appian\DirectRoute\Data\ Ratio.xls

Name and path of the Ratio File, typically found in the DirectRoute Data Folder

Use Tanker Algorithm for Product Assignment

TRUE (FALSE)

If TRUE, uses tanker algorithm to ensure products loaded on trucks are placed in designated compartments

Max Number of Totes Per Order

10

Max number of totes allowed on each order

Split Orders to Totes

TRUE (FALSE)

If TRUE, allow splitting of orders into totes; if FALSE, attempts to split the order will only be done on tanks

Split unloaded stops and try loading

FALSE

Split unloaded stops and try loading

Trimble Maps

Thread Count

30000

Sets the number of threads to use during the distance generation process. Max threads = 8. Enter 0 to use all threads possible. This can slow down your computer during processing.

Elevation

30000

Sets the elevation limit. The unit of measure is based on Other- > Distance Options. If Distance Option is set to Miles, set elevation to miles. If set to KM, set elevation to Meters.

Route Across National Border

TRUE (FALSE)

If TRUE, will allow route to cross Canada and/or Mexico borders; if FALSE, will prevent routes from crossing borders (may result in more miles)

Route Type

Practical, Shortest

Sets the routing type when getting directions

Avoid Toll

FALSE (TRUE)

Hazardous Option

None

Indicates the directions hazard options

Vehicle Profiles

(Collection)

Vehicle profiles (sizes)

Distance Generation Mode

Pair (Matrix)

Option to change how Trimble MAPS generates distance entries

Default Vehicle Profile

Select one from Vehicle Profiles (above)

Default vehicle profile to use

Use Historical Traffic Data

FALSE (TRUE)

Use historical traffic data

Highway Only

FALSE (TRUE)

Indicated if the route should travel on highways and/or primary roads only.

Data Version

 PCM_NA = North America

 PCM_EU = Europe

 PCM_OC = Oceanic

 PCM_SA = South America

 PCM_ME = Middle East

 PCM_AS = Australia

 PCM_AF = Africa

 PCM_WW = Worldwide

 PCM_GT = GeoTrack/Energy (oil site roads, mostly dirt roads)

Note: GeoTrack/Energy maps aren't usually available on normal versions of mapping data. 

Target map data from different regions or access the World Wide data. May require additional licensing.

UPDATE STOP FILE

Primary Identifier

ID1

Primary Stop File field

Secondary Identifier

ID2

Secondary Stop File field

Third Identifier

ID3

Tertiary Stop File field

Convert TW

TRUE (FALSE)

Convert old style time windows to new

UPLOAD

Options for uploading Route Files to OBCs, terminal systems, etc.

Upload Consolidated

TRUE (FALSE)

If TRUE, consolidated orders will be uploaded in consolidated format 

Upload Displayed Only

TRUE (FALSE)

If TRUE, will write (to the Upload File) only those routes that are locked and displayed on the map; if FALSE, will write ALL routes 

Upload Header Record

TRUE (FALSE)

If TRUE, adds Header row at top of the Upload File 

Upload Starting Terminal

TRUE (FALSE)

If TRUE, adds the beginning terminal/distribution center to the Upload File

Upload Ending Terminal

TRUE (FALSE)

If TRUE, adds the ending terminal/distribution center to the Upload File

Upload Date Format

MM/DD/YYYY

Choose date format

Upload Format File (*urp)

Enter path and file name of URP File; If used, system will not prompt for the info during upload process

Upload File Name

RTUPLOAD

Default name for the file it can be changed later in the Data Folder)

Upload File Path

(Blank)

Location of the Upload File, if different than current Data Folder 

Upload File Type

*.UPL

Enter type (Upload File) used

Upload XML Version

5

XML version number used

Upload Sequence

TRUE (FALSE)

Set to TRUE, will list the route and sequence number

OBC Upload

None

Allows choice of onboard computer system (XATA, PeopleNet, etc.) to Upload File format for OBC File

OBC Folder Path

Path to OBC File

OBC Upload File Name

RTUPLOAD

OBC Upload File name

Upload Time Format

Hmm, HHmm, H:mm, HH:mm

Choose time format

V8 Compatible

TRUE (FALSE)

Backwards compatibility with DR Version 8

Display Arrival and Departure Time on Consolidated Order

TRUE (FALSE)

If TRUE, will display the same arrival and depart time for consolidated orders on the same stop 

Display Miles on Consolidated Order

TRUE (FALSE)

If TRUE, will display the same miles for consolidated orders on the same stop 

Display Unload Time on Consolidated Order

TRUE (FALSE)

If TRUE, will display the same unload time for consolidated orders on same stop

Ignore Terminal in XML Upload

TRUE (FALSE)

If TRUE, ignores the terminal stop in the Upload File when appropriate

Display Drive and Work Time on Consolidate

FALSE (TRUE)

Displays drive and work time on consolidated orders

Abbreviate Rt Violation

FALSE (TRUE)

Abbreviate Route Violation

Display Total Distance on Consolidated Orders

FALSE (TRUE)

Display route total distance on consolidated orders

Routing Preferences and Options Table