For a sample Stop File, see About Route Files.
| FIELD NAME | DESCRIPTION | REQUIRED IN DIRECTROUTE |
| Name | Technically called 'Name', anything could be used as Alias for Name | no |
| Contact | Stop / Customer contact name | no |
| Phone | Stop / Customer contact phone # | no |
| ID1 | Primary ID - Store # would be an Alias for ID1 | yes |
| ID2 | Secondary ID - Invoice # or Delivery # could be an Alias for ID2, needs to be unique by Branch and best if unique for entire DRTrack database, if using | no |
| ID3 | Tertiary ID - Most often thought as SKU # | no |
| Address | Legal address of stop, used for geocoding | no |
| Address2 | Suite, Building info… | no |
| City | Used for geocoding | no |
| State | Used for geocoding | no |
| Zip | Required for use with internal PCMiler, Google Geocoding requires first digit of zip | no |
| FixedTime | Stop duration time | no |
| Rt | DirectRoute reserved field | no |
| Seq | DirectRoute reserved field | no |
| SzRestriction | related to the Volume1 (primary volume) and the Max Capacity as setup in the Truck File and defined in Preferences | no |
| EqCode | tons of uses, training will cover this in detail (Ex. - Liftgate or a Territory) | no |
| Cube | Volume - need at least one, can be named anything (i.e. Pallets, Pounds, Gallons, VolAlias1, etc.) | yes |
| Weight | Volume - need at least one, can be named anything (i.e. Pallets, Pounds, Gallons, VolAlias1, etc.) | no |
| UnldCube | used for variable unload rate per hour, adds time to any already defined FixedTime | no |
| UnldWeight | used for variable unload rate per hour, adds time to any already defined FixedTime | no |
| CloseTW | if TRUE, stop must be completely unloaded or serviced by the Close time | no |
| Open1 | Military Time format of when stop is available for service / delivery | yes |
| Close1 | Military Time format of when stop is closed for service / delivery | yes |
| Pattern1 | Days that delivery can occur - SMTWRFA for each day of the week | yes |
| Open2 | Optional time for service / delivery - up to 10 Open/Close Patterns can be developed | no |
| Close2 | Optional time for service / delivery - up to 10 Open/Close Patterns can be developed | no |
| Pattern2 | Optional time for service / delivery - up to 10 Open/Close Patterns can be developed | no |
| Longitude | if not provided, DirectRoute will populate during the Geocoding process | yes |
| Latitude | if not provided, DirectRoute will populate during the Geocoding process | yes |
| Symbol | recommended but not required | no |
| Size | in pixels, size of stop icon | no |
| Color | recommended but not required, use for enhanced map interaction | no |
| Selected | used to permanently mark a stop with a bounding square on the Map | no |
| EarliestDate | further stipulates a day or range of days for the delivery to occur, uses MM/DD/YYYY formating, Pattern1 still applies | no |
| LatestDate | further stipulates a day or range of days for the delivery to occur, uses MM/DD/YYYY formating, Pattern1 still applies | no |
| EarlyBuffer | Additional time before Open1 that a stop could be serviced - in Hours (Ex. .25, .5, 1, 2 or 3). Used to activate the Soft TimeWindows function within the software, allowing stops to be delivered outside of the hard time window. A penalty cost should also be used in conjunction as it guards against the use of the buffers when they are not needed. Note: EarlyBuffers and LateBuffers are used to expand time windows. | no |
| LateBuffer | Additional time after Close1 that a stop could be serviced - in Hours (Ex. .25, .5, 1, 2 or 3). Used to activate the Soft TimeWindows function within the software, allowing stops to be delivered outside of the hard time window. A penalty cost should also be used in conjunction as it guards against the uses of the buffers when they are not needed. Note: EarlyBuffers and LateBuffers are used to expand time windows. | no |
| PenaltyCost | The penalty cost applies only when the delivery is within the early or late buffer period. The penalty is prorated, and a value of 60 is suggested, equal to $1 per minute of buffer time used. Without a PenaltyCost the algorithm interprets the Buffer Time as “free” and will use it to a larger degree. | no |
| AddressErr | Reserved for DirectRoute | no |
| GeoResult | Populated by DirectRoute - accuracy of Lat / Long | no |
| MaxSplits | Specifies maximum number of times a stop can be split by the Splitting logic setup in Preferences | no |
| CurrentRoute | Stop user field (setup in Preferences > Configuration) | no |
| RouteSequence | Stop user field (setup in Preferences > Configuration) | no |
| ServiceDate | Stop user field (setup in Preferences > Configuration) | no |
| LocationTimeZone | Populated by DirectRoute during the Geocoding process if set to true in Preferences > Geocode Options | no |
| Zone | Speed Adjustment | no |
| AMStart | Speed Rush Hr Adjustment | no |
| AMEnd | Speed Rush Hr Adjustment | no |
| AMAdj | Speed Rush Hr Adjustment | no |
| PMStart | Speed Rush Hr Adjustment | no |
| PMEnd | Speed Rush Hr Adjustment | no |
| PMAdj | Speed Rush Hr Adjustment | no |
| Territory | TerrPro will assign, or user can prepoplulate to Initialize current Stop to Territory assignments (req'd for TerritoryPro) | no |
| Day | TerrPro can assign, not standard use | no |
| Frequency | Required for SchPro (Regular and Vollume Allocation versions) - value represents # of service occurances per week (Ex. 1=1x per wk, .5=2x per mo, .25=1x per mo) | no |
| ServTm | TerritoryPro reserved field | no |
| EstTime | TerritoryPro reserved field | no |
| StemTm | TerritoryPro reserved field | no |
| DrvBtwnStop | TerritoryPro reserved field | no |
| Lock | TerritoryPro reserved field | no |
| OrgTerritory | TerritoryPro reserved field | no |
| OrgDay | TerritoryPro reserved field | no |
| Change | TerritoryPro reserved field | no |
| Patterns | Vollume Allocation SchPro field, populated by SchPro via the Pattern Library (can be user populated for special circumstances) | no |
| Delivery Day | SchPro reserved field | no |
| AssignedDays | SchPro reserved field | no |
| Priority | Not standard functionality, used with DRTrack database integration and the Priority Routing module | no |
| OnFinalize | DRTrack reserved field | no |
| Country | Blank assumes USA, need to input 3 digit Country Code if using outside of USA (Ex. CAN or MEX) | no |