File Import
Contents
The File Import from DirectRoute allows data exchange using TXT or XLS files. Benefits of this import type include:
- Little to no IT involvement needed.
- Simple TXT or XLS file format.
- Typically used for routing only deployments with a third-party dispatch/execution system.
The Order File generated can contain as much, or as little, information as the ERP/WMS/OMS is capable of sending. At a minimum, the file should include Account Number, Ship To Address, Order Number, Order Volume/Weight, Delivery Address, and any special instructions. Any missing information will be completed from an Account Master File, which can reside locally in a stored file or database. Orders for new accounts will automatically create a new record in the Account Master File. Behind the scenes, the system is automatically generating an XML File for import into DRTrack.
The Order File generated can contain as much or as little information as the ERP/WMS/OMS is capable of sending. Any missing information will be completed from the Account Master File, stored in a local file or database.
Account Master Data
| Field Name | Description | Required |
|---|---|---|
Name
| The name of the Customer/Stop to be delivered. | Required |
Contact
| The name of a contact at the Customer/Stop. | Optional |
Phone
| Telephone number at the stop location. If the Area Code is included, The Legacy application (DirectRoute) can use it for geocoding. | Optional |
ID1
| Primary unique identifier for Customer/Stop (user defined field in Preferences/Config settings) used in the extract process. Example: Account or Customer number. | Required |
ID2
| Secondary unique identifier for the Customer/Stop (user defined field in Preferences/Config settings). Example: Store or Stop number. | Optional |
ID3
| Tertiary unique identifier for the Customer/Stop (user defined field in Preferences/Config settings). Example: Line Item or SKU. | Optional |
Address
| Street Address for the Customer. Address, along with City, State, and Zip Code are used to geocode by Address. | Required |
Address2
| Additional Address Information. Example: Suite, building, Door, or Dock number. | Optional |
City
| Name of the City (Address). Can be used in conjunction with the Distance File to determine distances and Drive Time. (Required to geocode). | Required |
State
| 2 letter State (Address) abbreviation. Example: WA, CA, OR. (Required to geocode). | Required |
Zip
| Zip Code (Address). Can be used for geocoding in conjunction with the Address field, or geocoding by 5- or 9-Digit Zip. | Required |
Longitude
| The Longitude and Latitude fields are coordinates that define where a Customer is located. Geocoding is the process used to identify these coordinates. | Required |
Latitude
| See Longitude. | Required |
FixedTime
| Used to identify a required/mandatory time that all vehicles must spend at a stop (in addition to Unload Rate/Time). Can be used to account for completing required paperwork. Input Fixed Time time in minutes; may be different for each customer. Example: An entry of 15 would require the truck to be at the stop for 15 minutes, in addition to the time calculated by the UnldRate. Total time at the stop will be calculated by The Legacy application, by adding these two fields together. | Optional |
SzRestriction
| Size Restriction will inform The Legacy application that this is the maximum size or volume for a vehicle that may deliver to this stop. Using a size restriction will limit which truck size the customer load can be put on. Example: A quantity of 20,000 = load could only be put on trucks with a capacity of 20,000 or less in (Volume1 field) the Truck File. | Optional |
EqCode
| An alphanumeric code (unlimited number of characters) used to designate special equipment or requirements for a stop (lift gate, refrigerated compartment, etc.). Corresponding Truck File field: SpE. When EqCodes are used, The Legacy application will only load the stops on a vehicle with a matching SpEq code listed in the Truck File. Example: If a stop requires a lift gate in order to complete delivery, place a code in the EqCode field that designates lift gate, and use the same code in the SpEq field on a truck in the Truck File. Can combine multiple codes (i.e. AJ-BH-HH-XX). Note: There are also special EqCodes that can be utilized for Back Hauls, prioritizing and sequencing of stops, territory codes and exclusion codes. | Optional |
UnldRate
| Identifies the amount of time it takes to unload the volume1 value, in hours. Note: If Volume = cases, the field appears in the Stop File as ‘UnldCases’. Example: It takes one hour to unload 1000 cases. A truck that carries 2000 cases would have an unload rate of 2 (2000 ÷ 1000/per hr.). | Optional |
Open1
| Earliest time of day s customer will accept delivery. Military Time format (0000-2400). Multiple Time Windows can be used (up to ten), defined as Open1, Close1, Pattern1; Open2, Close2, Pattern2. Example: Customer can receive deliveries between 800 and 1130 on Sunday, Wednesday, and Saturday. Enter Open1=0800, Close1=1130, and Pattern1=SWA. | Required |
Close1
| Latest time of day that customer will accept delivery. See Open1 for additional info. | Required |
Pattern1
| Days of the week when the customer will accept deliveries. Each letter corresponds to the days of the week, beginning with Sunday (SMTWRFA). Example: Pattern1 = SWA; the customer can receive deliveries on Sunday, Wednesday, and Saturday. | Required |
EarlyBuffer
| EarlyBuffer is used to activate the Soft TimeWindows function within The Legacy application, allowing stops to be loaded before the actual Open1 time window. A penalty cost is added if the buffer is engaged. (MM/DD/YY) Used in conjunction with EarliestDate; determines the latest date the stop may be serviced. May be the same date as EarliestDate if there is only one day in which the stop may be serviced. | Optional |
LateBuffer
| LateBuffer is used to activate the Soft Time Windows function within The Legacy application, allowing stops to be loaded after the actual Close1 time window. A penalty cost is added if the buffer is engaged.EarlyBuffer is used to activate the Soft TimeWindows function within The Legacy application, allowing stops to be loaded before the actual Open1 time window. A penalty cost is added if the buffer is engaged. | Optional |
MaxSplits
| Max Number of Splits Allowed for a Stop | Optional |
PenaltyCost
| The PenaltyCost (dollar amount per hour) is used in conjunction with the EarlyBuffer and LateBuffer to calculate and apply a penalty cost to stops that use the buffers, when engaged. During the Optimization process, The Legacy application will try to move a stop with a penalty cost to another route in an attempt to eliminate the penalty (calculated per hour). | Optional |
Rt
| The Route # on which the customer is normally serviced. When pre-populated, The Legacy application will place the stop on this Route. If left blank, The Legacy application will determine which Route will service the stop.Max Number of Splits Allowed for a Stop | Optional |
Seq
| The delivery position of the stop on the Route. If pre-populated, The Legacy application will place the stop in this position. If left blank, The Legacy application will determine the position during the routing process. Example: A value of 3 indicates the customer is the third stop on the route.Max Number of Splits Allowed for a Stop | Optional |
Order File Data
Because the account master exists in the database, data elements that are required for routing aren’t necessarily required in the order file. Any information missing from the data will automatically populate from account master information. The order file can contain simply order summary data or be as detailed as line level data.
| Field Name | Description | Required? |
|---|---|---|
Name
| The name of the customer/business (stop) to be delivered. | Optional |
Contact
| The name of a contact at the customer stop. | Optional |
Phone
| Telephone number at the stop location. If the Area code is included, the software can use it for geocoding. | Optional |
ID1
| Primary unique identifier for the customer/stop (Acct#, Customer#). User defined (Preferences→Configuration) used in extract process. | Required |
ID2
| Secondary unique identifier for the customer/stop. Example: Store#, Stop#. User defined field in Preferences→Configuration. | Required |
ID3
| Tertiary unique identifier for the customer/stop. Example: Line Item, SKU. User defined field in Preferences→Configuration. | Optional |
Address
| Street Address for the customer. Address, along with City, State, and Zip are used to geocode by address. Also used by Address Cleanup. | Optional |
Address2
| Additional Address information. Example: Suite#, building#, Door#, Dock#. | Optional |
City
| Name of the city (Address). This field can be used in conjunction with the Distance File to determine distances and drive time. Required to geocode. | Optional |
State
| 2 letter state (Address) abbreviation. Example: WA, CA, OR. Required to geocode. | Optional |
Zip
| The zip code (Address). Can be used for geocoding in conjunction with the Address field, or geocoding by 5-Digit or 9-Digit Zip. | Optional |
FixedTime
| Used to identify a required/mandatory time that all vehicles must spend at the stop (in addition to unload rate/time). Can be used to account for completing required paperwork. Input Fixed Time in minutes; may be different for each customer. Example: An entry of 15 would require the truck to be at the stop for 15 minutes, in addition to the time calculated by the UnldRate. Total time at the stop will be calculated by the software by adding these two fields together. Note: DR will route without this field, but in practice a Fixed Time is needed as the truck will have to stop for certain amount of time to unload (and perform other activities). Typical range is 15-45 (15 to 45 minutes). Enter number in minutes. | Optional |
SzRestriction
| Size Restriction will inform the software that this is the maximum size or volume for a vehicle that may deliver to this stop. Using a size restriction will limit which truck size the customer load can be put on. Example: A quantity of 20,000 would mean that the customer load could only be put on trucks with a capacity of 20,000 or less in (Volume 1 field) the Truck File. | Optional |
EqCode
| An alphanumeric code (unlimited number of characters) used to designate special equipment or requirements for a stop (lift gate, refrigerated compartment, etc.). Corresponding Truck File field: SpE. When EqCodes are used, the software will only load the stops on a vehicle with a matching SpEq code listed in the Truck File. Example: If a stop requires a lift gate in order to complete delivery, place a code in the EqCode field that designates lift gate, and use the same code in the SpEq field on a truck in the Truck File. It is possible to combine the use of several EqCodes, but each code should be separated by a dash (i.e. AJ-BH-HH-XX). If there are no special requirements for a stop, this field should be blank. Note: There are also special EqCodes that can be utilized for Back Hauls, prioritizing and sequencing of stops, territory codes and exclusion codes. | Optional |
Qty Fields
| The volume to be delivered; user defined field (Preferences→Configuration) can be any quantity type (weight, cube, pallets, cases, etc.). If no volume type is entered, the software will load all stops on one route, or until it reaches the maximum stops per route, as defined by the user. The capacity fields in the Truck File correspond to the volume fields in the Stop File. Example: Volume used is Cases; the column heading appears in the Stop File as Cases. Capacity 1 column heading in the Truck File will also appear as Cases. Note: Must be at least one (1) volume field in use, even if left blank. | Required |
UnldRate (UnldQty)
| Identifies the amount of time it takes to unload Volume1 value, in hrs. Example: Volume1 = Cases. The field appears in the Stop File as UnldCases. it takes one hour to unload 1000 cases. A truck that carries 2000 cases would have an unload rate of 2 (2000 ÷ 1000/per hr.). The UnldRate time is added to the Fixed Time. The UnldRate heading will mirror the volume name defined in the Preferences→ Configuration→Volumes (Weight = UnldWeight, Cases = UnldCases). | Optional |
CloseTW
| TRUE or FALSE. When this option is set to TRUE, a vehicle must reach the stop, deliver and complete unloading before the Time Window closes (including Fixed Time plus UnldRate). | Optional |
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 hardcoded to eight miles. Example: If rush hour distance is set to 30 miles, it will apply to the truck for a 30 mile radius from the depot. If it is set on the customer in the Stop File, it will be a 30 mile radius from the customer. Example (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). Example (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 hardcoded to eight miles, while AM/PM Adjust is based on the rush hour distance. Example: If rush hour distance is set to 30 miles, it will apply to the truck for a 30 mile radius from the depot. If it is set on the customer in the Stop File, it will be a 30 mile 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 |
Open1
| Earliest time of day delivery can be made. Using Military Time format (0000-2400), delivery time windows are entered in the Open1 and Close1 fields. Multiple Time Windows can be established (up to ten), and are defined as Open1, Close1, Pattern1; Open2, Close2, Pattern2; Open3, Close3, Pattern3 and so forth. Example: Customer can receive deliveries between 800 and 1130 on Sunday, Wednesday, and Saturday. This corresponds to Open1=0800, Close1=1130, and Pattern1=SWA. | Optional |
Close1
| Latest time a delivery can be made. See Open1 for additional info. | Optional |
Pattern1
| Days of the week when the customer will accept deliveries. Time Windows are entered as patterns of opening and closing times and days of the week (SMTWRFA) that define when the customer will accept deliveries. Example: Customer can receive deliveries between 800 and 1130 on Sunday, Wednesday, and Saturday. This corresponds to Open1=0800, Close1=1130, and Pattern1=SWA. S=Sunday, M=Monday, T=Tuesday, W=Wednesday, R=Thursday, F=Friday, A=Saturday | Optional |
EarliestDate
| (MM/DD/YY). May be used to ensure that a stop is not serviced before a specific date, or when used in combination with LatestDate, used to ensure the stop is delivered within a specific time window, and can allow multi-day/week deliveries based on date versus time window only. If this column is blank, it will be ignored. | Optional |
LatestDate
| (MM/DD/YY) Used in conjunction with EarliestDate; determines the latest the date that the stop may be serviced. May be the same date as EarliestDate if there is only one day in which the stop may be serviced. If this column is blank it will be ignored. | Optional |
EarlyBuffer
| Used to activate the Soft TimeWindows function within the software, allowing stops to be loaded before the hard time window. A penalty cost is counted against the uses of the buffers. Note: EarlyBuffers and LateBuffers are used to expand time windows. | Optional |
LateBuffer
| Used to activate the Soft Time Windows function within the software. allowing stops to be loaded after the hard time windows. A penalty cost is counted against the use of the buffers. Note: EarlyBuffers and LateBuffers are used to expand time windows. | Optional |
PenaltyCost
| Used in conjunction with the EarlyBuffer and LateBuffer, is used to calculate and apply a penalty cost to stops that use the buffers. During the Optimization process, the software will try to move a stop with a penalty cost to another route in an attempt to eliminate the penalty (calculated per hour). Enter dollar amount per hour. | Optional |
Upload Fields and Descriptions
| ROUTE FIELDS | DESCRIPTION |
|---|---|
| RFARV_DATE | Arrival date at delivery location |
| RFARV_DAY | Arrival day at delivery location |
| RFARV_TIME | Arrival time at delivery location |
| RFBREAKTM | Break time for driver |
| RFCUM_DRV_TM | Cumulative drive time |
| RFCUM_WRK_TM | Cumulative work time on route |
| RFCUMQTY001 | Cumulative Quantity1 of Order |
| RFCUMQTY002 | Cumulative Quantity2 of Order |
| RFCUMQTY003 | Cumulative Quantity3 of Order |
| RFCUMQTY004 | Cumulative Quantity4 of Order |
| RFCUMQTY005 | Cumulative Quantity5 of Order |
| RFCUMQTY006 | Cumulative Quantity6 of Order |
| RFCUMQTY007 | Cumulative Quantity7 of Order |
| RFCUMQTY008 | Cumulative Quantity8 of Order |
| RFCUMQTY009 | Cumulative Quantity9 of Order |
| RFCUMQTY010 | Cumulative Quantity10 of Order |
| RFDEPDAY | Day of departure/dispatch day |
| RFDEPT_DATE | Route departure date |
| RFDEPT_TIME | Time of route departure |
| RFDIST_TO_PREV_STOP | Distance from previous stop |
| RFINCR_COST | Incremental cost of a stop; calculates difference in miles, drvtm; if a stop is added, applies mileage and hr cost |
| RFLAYOVER_TM | Overnight layover time within a route |
| RFREMAINCAP001 | Remaining Capacity1 |
| RFREMAINCAP002 | Remaining Capacity2 |
| RFREMAINCAP003 | Remaining Capacity3 |
| RFREMAINCAP004 | Remaining Capacity4 |
| RFREMAINCAP005 | Remaining Capacity5 |
| RFREMAINCAP006 | Remaining Capacity6 |
| RFREMAINCAP007 | Remaining Capacity7 |
| RFREMAINCAP008 | Remaining Capacity8 |
| RFREMAINCAP009 | Remaining Capacity9 |
| RFREMAINCAP010 | Remaining Capacity10 |
| RFSEQ_NO | Sequence number of stop within a route |
| RFTIME_TO_PREV_STOP | Time to Previous Stop |
| RFUNLOAD_TIME | Unload Time |
| RFWAIT_TM_AT_STOP | Wait time at stop |
| RFWINDOW_VIOLATION | Window Violation |
| RT_NUM | Route Number |
| RT%_ABSCAP001_USED | Absolute value of Qty1 for each stop on route divided by Trk capacity * 2 (pickup, delivery) |
| RT%_ABSCAP002_USED | Absolute value of Qty2 for each stop on route divided by Trk capacity * 2 |
| RT%_ABSCAP003_USED | Absolute value of Qty3 for each stop on route divided by Trk capacity * 2 |
| RT%_ABSCAP004_USED | Absolute value of Qty4 for each stop on route divided by Trk capacity * 2 |
| RT%_ABSCAP005_USED | Absolute value of Qty5 for each stop on route divided by Trk capacity * 2 |
| RT%_ABSCAP006_USED | Absolute value of Qty6 for each stop on route divided by Trk capacity * 2 |
| RT%_ABSCAP007_USED | Absolute value of Qty7 for each stop on route divided by Trk capacity * 2 |
| RT%_ABSCAP008_USED | Absolute value of Qty8 for each stop on route divided by Trk capacity * 2 |
| RT%_ABSCAP009_USED | Absolute value of Qty9 for each stop on route divided by Trk capacity * 2 |
| RT%_ABSCAP010_USED | Absolute value of Qty10 for each stop on route divided by Trk capacity * 2 |
| RT%_CAP001_USED | Percent of cap1 used on route (10 cap fields avail) |
| RT%_CAP002_USED | Percent of cap2 used on route |
| RT%_CAP003_USED | Percent of cap3 used on route |
| RT%_CAP004_USED | Percent of cap4 used on route |
| RT%_CAP005_USED | Percent of cap5 used on route |
| RT%_CAP006_USED | Percent of cap6 used on route |
| RT%_CAP007_USED | Percent of cap7 used on route |
| RT%_CAP008_USED | Percent of cap8 used on route |
| RT%_CAP009_USED | Percent of cap9 used on route ( |
| RT%_CAP010_USED | Percent of cap10 used on route |
| RTCAP001_USED | Route capacity1 used (10 cap fields avail) |
| RTCAP002_USED | Route capacity2 used |
| RTCAP003_USED | Route capacity3 used |
| RTCAP004_USED | Route capacity4 used |
| RTCAP005_USED | Route capacity5 used |
| RTCAP006_USED | Route capacity6 used |
| RTCAP007_USED | Route capacity7 used |
| RTCAP008_USED | Route capacity8 used |
| RTCAP009_USED | Route capacity9 used |
| RTCAP010_USED | Route capacity10 used |
| RTBACKHAUL001 | Backhaul1 |
| RTBACKHAUL002 | Backhaul2 |
| RTBACKHAUL003 | Backhaul3 |
| RTBACKHAUL004 | Backhaul4 |
| RTBACKHAUL005 | Backhaul5 |
| RTBACKHAUL006 | Backhaul6 |
| RTBACKHAUL007 | Backhaul7 |
| RTBACKHAUL008 | Backhaul8 |
| RTBACKHAUL009 | Backhaul9 |
| RTBACKHAUL010 | Backhaul10 |
| RTCOSTPERSTOP | Cost per Stop |
| RTDEL001 | Total value of Qty1 delivered (Non negative quantities and excludes backhauls) |
| RTDEL002 | Total value of Qty2 delivered |
| RTDEL003 | Total value of Qty3 delivered |
| RTDEL004 | Total value of Qty4 delivered |
| RTDEL005 | Total value of Qty5 delivered |
| RTDEL006 | Total value of Qty6 delivered |
| RTDEL007 | Total value of Qty7 delivered |
| RTDEL008 | Total value of Qty8 delivered |
| RTDEL009 | Total value of Qty9 delivered |
| RTDEL010 | Total value of Qty10 delivered |
| RTCOSTPERQTY001 | Cost per Quantity1 |
| RTCOSTPERQTY002 | Cost per Quantity2 |
| RTCOSTPERQTY003 | Cost per Quantity3 |
| RTCOSTPERQTY004 | Cost per Quantity4 |
| RTCOSTPERQTY005 | Cost per Quantity5 |
| RTCOSTPERQTY006 | Cost per Quantity6 |
| RTCOSTPERQTY007 | Cost per Quantity7 |
| RTCOSTPERQTY008 | Cost per Quantity8 |
| RTCOSTPERQTY009 | Cost per Quantity9 |
| RTCOSTPERQTY010 | Cost per Quantity10 |
| RTEARLIESTLATEDATE | Shows the critical latest delivery date when Earliest/Latest Date is used. |
| RTENDDATE | End date of route |
| RTENDDAY | End day of route |
| RTENDTIME | Time route ends |
| RTSTARTDATE | Date route starts |
| RTSTART_DAY | Day route starts |
| RTSTARTTIME | Time route starts |
| RTFARTHESTSTOP | Distance to the farthest stop on the route |
| RTJULIANPLUSRT | Used to generate rt # for peoplenet day of year +Rt# (ex. 050012 is rt 12 on the 50th day of the year) |
| RTNONSTEMDIST | None Stem distance |
| RTPENALTYCOST | Penalty Cost |
| RTPICKUP001 | Total value of Qty1 delivered (shown as negative quantities) |
| RTPICKUP002 | Total value of Qty2 delivered |
| RTPICKUP003 | Total value of Qty3 delivered |
| RTPICKUP004 | Total value of Qty4 delivered |
| RTPICKUP005 | Total value of Qty5 delivered |
| RTPICKUP006 | Total value of Qty6 delivered |
| RTPICKUP007 | Total value of Qty7 delivered |
| RTPICKUP008 | Total value of Qty8 delivered |
| RTPICKUP009 | Total value of Qty9 delivered |
| RTPICKUP010 | Total value of Qty10 delivered |
| RTQTYPERHR001 | Quantity1 per hour |
| RTQTYPERHR002 | Quantity2 per hour |
| RTQTYPERHR003 | Quantity3 per hour |
| RTQTYPERHR004 | Quantity4 per hour |
| RTQTYPERHR005 | Quantity5 per hour |
| RTQTYPERHR006 | Quantity6 per hour |
| RTQTYPERHR007 | Quantity7 per hour |
| RTQTYPERHR008 | Quantity8 per hour |
| RTQTYPERHR009 | Quantity9 per hour |
| RTQTYPERHR010 | Quantity10 per hour |
| RTQTYPERMI001 | Quantity1 per mile |
| RTQTYPERMI002 | Quantity2 per mile |
| RTQTYPERMI003 | Quantity3 per mile |
| RTQTYPERMI004 | Quantity4 per mile |
| RTQTYPERMI005 | Quantity5 per mile |
| RTQTYPERMI006 | Quantity6 per mile |
| RTQTYPERMI007 | Quantity7 per mile |
| RTQTYPERMI008 | Quantity8 per mile |
| RTQTYPERMI009 | Quantity9 per mile |
| RTQTYPERMI010 | Quantity10 per mile |
| RTSTEMDIST | Route stem distance |
| RTSTOPSPERHR | Stops per hour on route |
| RTSTOPSPERMI | Stops per mile on route |
| RTTOAT_UNLD_TM | Route total unload time |
| RTTOT_DAYS | Total number of days on a route |
| RTTOT_DIST | Total distance of a route |
| RTTOT_DROPCOST | Total drop cost of a route |
| RTTOT_ELAPSED_TIME | Total elapsed time of a route |
| RTTOT_FIXEDCOST | Total fixed cost of a route |
| RTTOT_HRCOST | Total hourly pay cost of route |
| RTTOT_LAYOVERCOST | Total cost of layovers on a route |
| RTTOT_MICOST | Total mileage cost of a route |
| RTTOT_OTCOST | Total overtime cost of a route |
| RTTOT_PREPOST | Total pre and post time for a route |
| RTTOT_UNITCOST | Total unit cost on a route |
| RTTOT_UNLDHRCOST | Total unload hour cost on a route |
| RTTOT_WAITHRCOST | Total wait hour cost of a route |
| RTTOTAL_COST | Total cost of a route |
| RTTOTAL_DRV_TM | Total drive time |
| RTTOTAL_STOPS | Total stops serviced |
| RTTOTAL_WAIT_TM | Total wait time on a route |
| RTTOTAL_WRK_TM | Total work time on a route |
| RTVIOLATIONSYN | Violations yes or no |
| RTVIOLATIONSFULL | Violations (equip/capacity) on a route-Full |
| RTVIOLATIONSBRIEF | Violations (equip/capacity) on a route-Brief |
| RFEMPTYMILES | Empty Miles |
| RTTOTAL_HOURS_PERROUTEDAY | Total hours per route day |
| RTTOT_LAYOVERTIME | Total layover time of a route |
| RTTOTAL_MILES_PERROUTEDAY | Total miles per route day |
| RTTOT_LAYOVERS | Total no of layovers on a route |
| RTTOLLCOST | Toll cost per route |
| RTQTY001 | Total Qty1 per route |
| RTQTY002 | Total Qty2 per route |
| RTMILESPERQTY001 | Route miles per QTY1 |
| RTMILESPERQTY002 | Route miles per QTY2 |
| Stop Fields | Description of Field Info |
| SFADDRESS | Address of stop |
| SFADDRESS2 | Extra address information |
| SFAMADJ | AM Rush Hour Speed Adjustment |
| RFBUFFERUSED | Total untilized buffer time |
| SFCITY | City the stop is located in |
| SFCOLOR | Color of stop displayed on the map |
| SFCONTACT | Contact name for stop |
| SFOPEN1 | Earliest time for 1st delivery Time Window |
| SFCLOSE1 | Latest time for 1st delivery Time Window |
| SFPATTERN1 | Avail Del Days for first set of Time Windows |
| SFOPEN2 | Earliest time for 2nd delivery Time Window |
| SFCLOSE2 | Latest time for 2nd delivery Time Window |
| SFPATTERN2 | Avail Del Days for 2nd set of Time Windows |
| SFDELQTY001 | Quantity1 delivered to stop |
| SFDELQTY002 | Quantity2 delivered to stop |
| SFDELQTY003 | Quantity3 delivered to stop |
| SFDELQTY004 | Quantity4 delivered to stop |
| SFDELQTY005 | Quantity5 delivered to stop |
| SFDELQTY006 | Quantity6 delivered to stop |
| SFDELQTY007 | Quantity7 delivered to stop |
| SFDELQTY008 | Quantity8 delivered to stop |
| SFDELQTY009 | Quantity9 delivered to stop |
| SFDELQTY010 | Quantity10 delivered to stop |
| SFEQCODE | Equipment code |
| SFFIXEDTIME | Fixed time for stop |
| SFEARLIESTDATE | EarliestDate for stop |
| SFID1 | First Identifier for Customer/Acct (Account#) |
| SFID2 | Second Identifier for Customer/Acct (Order#) |
| SFID3 | Third Identifier for Customer/Acct (LineItem) |
| SFLATITUDE | Latitude coordinates of stop |
| SFLONGITUDE | Longitude coordinates of stop |
| SFLATESTDATE | LatestDate |
| SFNAME | Customer name |
| SFOUTPFROUTECOST | Out of Route cost for Stop |
| SFPHONE | Customer phone number |
| RFPENALTYCOST | Cost incurred for utilizing Early/Late Buffer |
| SFPICKUPQTY001 | Pickup quantity1 (negative number) |
| SFPICKUPQTY002 | Pickup quantity2 (negative number) |
| SFPICKUPQTY003 | Pickup quantity3 (negative number) |
| SFPICKUPQTY004 | Pickup quantity4 (negative number) |
| SFPICKUPQTY005 | Pickup quantity5 (negative number) |
| SFPICKUPQTY006 | Pickup quantity6 (negative number) |
| SFPICKUPQTY007 | Pickup quantity7 (negative number) |
| SFPICKUPQTY008 | Pickup quantity8 (negative number) |
| SFPICKUPQTY009 | Pickup quantity9 (negative number) |
| SFPICKUPQTY010 | Pickup quantity10 (negative number) |
| SFQTY001 | Quantity1 of order |
| SFQTY002 | Quantity2 of order |
| SFQTY003 | Quantity3 of order |
| SFQTY004 | Quantity4 of order |
| SFQTY005 | Quantity5 of order |
| SFQTY006 | Quantity6 of order |
| SFQTY007 | Quantity7 of order |
| SFQTY008 | Quantity8 of order |
| SFQTY009 | Quantity9 of order |
| SFQTY010 | Quantity10 of order |
| SFROW | Row # in the spreadsheet for the stop |
| SFRT | Route number |
| SFRTONLY | Displays only the Rt#, not Rt and Leg |
| SFSELECTED | Stop selected |
| SFSEQ | Sequence number of stop |
| SFSIZE | Size restriction |
| SFSTATE | State where stop is located |
| SFSYMBOL | Symbol assigned to the Stop |
| SFUNLDRATE001 | Unload rate1 |
| SFUNLDRATE002 | Unload rate2 |
| SFUNLDRATE003 | Unload rate3 |
| SFUNLDRATE004 | Unload rate4 |
| SFUNLDRATE005 | Unload rate5 |
| SFUNLDRATE006 | Unload rate6 |
| SFUNLDRATE007 | Unload rate7 |
| SFUNLDRATE008 | Unload rate8 |
| SFUNLDRATE009 | Unload rate9 |
| SFUNLDRATE010 | Unload rate10 |
| SFUSERFLD001 | Stop File user field1 (20 fields available) |
| SFUSERFLD002 | Stop File user field2 |
| SFUSERFLD003 | Stop File user field3 |
| SFUSERFLD004 | Stop File user field4 |
| SFUSERFLD005 | Stop File user field5 |
| SFUSERFLD006 | Stop File user field6 |
| SFUSERFLD007 | Stop File user field7 |
| SFUSERFLD008 | Stop File user field8 |
| SFUSERFLD009 | Stop File user field9 |
| SFUSERFLD010 | Stop File user field10 |
| SFUSERFLD011 | Stop File user field11 |
| SFUSERFLD012 | Stop File user field12 |
| SFUSERFLD013 | Stop File user field13 |
| SFUSERFLD014 | Stop File user field14 |
| SFUSERFLD015 | Stop File user field15 |
| SFUSERFLD016 | Stop File user field16 |
| SFUSERFLD017 | Stop File user field17 |
| SFUSERFLD018 | Stop File user field18 |
| SFUSERFLD019 | Stop File user field19 |
| SFUSERFLD020 | Stop File user field20 |
| SFZIP | Zip code where stop is located |
| SFZONE | user defined zone of stop |
| SPDISTTODEPOT | dist from stop to depot |
| SPDISTTODEPOTSUM | sum of distance from stops to depot |
| SFDAYSBETWEENROUTES | Days between routes |
| SFFREQUENCY | Frequency for stop |
| SFGEORESULT | Geocode results |
| SFLEG | Leg number for stop |
| SFLTLCOST | LTL cost for the stop |
| SFMAXSPLITS | Max number of splits allowed per stop |
| SFAMSTART | Specifies start time of AM rush hour |
| SFAMEND | Specifies end time of AM rush hour |
| SFPMSTART | Specifies start time of PM rush hour |
| SFPMEND | Specifies end time of PM rush hour |
| SFPMADJ | Amount to adjust PM drive time |
| SFAMADJ | Amount to adjust AM drive time |
| RFTOLLCOST | Cost of toll for a stop |
| TW_GRAPH | Time window graph |
| RFCAPUSED001 | Capacity1 used per stop (10 cap fields avail) |
| RFCAPUSED002 | Capacity2 used per stop |
| RFCAPUSED003 | Capacity3 used per stop |
| RFCAPUSED004 | Capacity4 used per stop |
| RFCAPUSED005 | Capacity5 used per stop |
| RFCAPUSED006 | Capacity6 used per stop |
| RFCAPUSED007 | Capacity7 used per stop |
| RFCAPUSED008 | Capacity8 used per stop |
| RFCAPUSED009 | Capacity9 used per stop |
| RFCAPUSED010 | Capacity10 used per stop |
| Truck Fields | Description of Field Info |
| TFCAP001 | Vehicle capacity1 |
| TFCAP002 | Vehicle capacity2 |
| TFCAP003 | Vehicle capacity3 |
| TFCAP004 | Vehicle capacity4 |
| TFCAP005 | Vehicle capacity5 |
| TFCAP006 | Vehicle capacity6 |
| TFCAP007 | Vehicle capacity7 |
| TFCAP008 | Vehicle capacity8 |
| TFCAP009 | Vehicle capacity9 |
| TFCAP010 | Vehicle capacity10 |
| TFDROPCOST | Drop Cost |
| TFEARSTART | Earliest time vehicle can be dispatched |
| TFEDATE | Earliest date vehicle may be dispatched |
| TFFIXEDCOST | Fixed cost for operating vehicle |
| TFHRCOST | Cost per hour to operate the vehicle |
| TFLATFINISH | Latest time vehicle can finish the route |
| TFLAYOVERCOST | Cost per layover of vehicle |
| TFLDATE | Latest date vehicle may be dispatched |
| TFLOCK | Lock route |
| TFMAXDRIVETM | Maximum drive time for the vehicle/driver |
| TFMAXLAYOVER | Maximum layover allowed |
| TFMAXWORKTM | Maximum work time for vehicle/driver |
| TFMICOST | Cost per mile to operate the vehicle |
| TFMINLAYOVER | Minimum layover required |
| TFOTCOST | Over time cost |
| TFSPEQ | Special equipment identifier (corresponds to equipment code in Stop File) |
| TFSTATUS | Vehicle utilized (Y or N) |
| TFTRKID | Unique identifier for vehicle |
| TFUNITCOST | Cost per unit on vehicle |
| TFUSERFLD001 | user defined field1 |
| TFUSERFLD002 | user defined field2 |
| TFUSERFLD003 | user defined field3 |
| TFUSERFLD004 | user defined field4 |
| TFUSERFLD005 | user defined field5 |
| TFUSERFLD006 | user defined field6 |
| TFUSERFLD007 | user defined field7 |
| TFUSERFLD008 | user defined field8 |
| TFUSERFLD009 | user defined field9 |
| TFUSERFLD010 | user defined field10 |
| TFUNLDHRCOST | Unload hour cost |
| TFWAITHRCOST | Wait time cost per hour |
| TFBREAKTM | Break time for driver |
| TRDIST | Total distance driven (all routes) |
| TRDROPCOST | Total drop cost |
| TRDRV_TM | Total drive time |
| TRELAPSED_TIME | Total elapsed time |
| TRFIXEDCOST | Total fixed cost |
| TRHRCOST | Total hourly pay cost |
| TRLAYOVERCOST | Total layover cost |
| TRMICOST | Total mileage cost |
| TROTCOST | Total over time cost |
| TRSTOPS | Total stops serviced |
| TRTOTCOST | Total overall cost |
| TRTOTTM | Total time used |
| TRUNITCOST | Total unit costs |
| TRUNLD_TM | Total unload time |
| TRUNLDHRCOST | Total unload hour cost |
| TRWAIT_TM | Total wait time |
| TRWAITHRCOST | Total wait time cost |
| TRWRK_TM | Total work time |
| TFCITY | City the truck is located in |
| TFLATITUDE | Truck latitude |
| TFLONGITUDE | Truck longitude |
| TFPRETRIP | Pre Trip |
| TFPOSTTRIP | Post trip |
| TFUNLDPERF | Unload performance |
| ResourcePro Fields | Description of Field Info |
| RPDRIVER | Driver assigned to route in ResourcePro |
| RPTRUCK | Truck assigned in ResourcePro |
| RPTRAILER | Trailer assigned in ResourcePro |
| RPSTARTINGDRIVETIME | Drive Time Start in ResourcePro |
| RPSTARTINGWORKTIME | Work Time Start in ResourcePro |
| RPWORKHOURSBEFORE | Work Hrs before next route (Hrs between routes) |