Skip to main content

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 3rd 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.

Legacy / Flat File

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 NameDescriptionRequired
NameThe name of the Customer/Stop to be delivered.Required
ContactThe name of a contact at the Customer/Stop.Optional
PhoneTelephone number at the stop location. If the Area Code is included, The Legacy application (DirectRoute) can use it for geocoding.Optional
ID1Primary unique identifier for Customer/Stop (user defined field in Preferences/Config settings) used in the extract process.
Example: Account or Customer number.
Required
ID2Secondary unique identifier for the Customer/Stop (user defined field in Preferences/Config settings).
Example: Store or Stop number.
Optional
ID3Tertiary unique identifier for the Customer/Stop (user defined field in Preferences/Config settings). Example: Line Item or SKU.Optional
AddressStreet Address for the Customer. Address, along with City, State, and Zip Code are used to geocode by Address.Required
Address2Additional Address Information.
Example: Suite, building, Door, or Dock number.
Optional
CityName of the City (Address). Can be used in conjunction with the Distance File to determine distances and Drive Time. (Required to geocode).Required
State2 letter State (Address) abbreviation.
Example: WA, CA, OR. (Required to geocode).
Required
ZipZip Code (Address). Can be used for geocoding in conjunction with the Address field, or geocoding by 5- or 9-Digit Zip.Required
LongitudeThe Longitude and Latitude fields are coordinates that define where a Customer is located. Geocoding is the process used to identify these coordinates.Required
LatitudeSee Longitude.Required
FixedTimeUsed 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
SzRestrictionSize 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
EqCodeAn 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
UnldRateIdentifies 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
Open1Earliest 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
Close1Latest time of day that customer will accept delivery. See Open1 for additional info.Required
Pattern1Days 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
EarlyBufferEarlyBuffer 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
LateBufferLateBuffer 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
MaxSplitsMax Number of Splits Allowed for a StopOptional
PenaltyCostThe 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
RtThe 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 StopOptional
SeqThe 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 NameDescriptionRequired?
NameThe name of the customer/business (stop) to be delivered.Optional
ContactThe name of a contact at the customer stop.Optional
PhoneTelephone number at the stop location. If the Area code is included, the software can use it for geocoding.Optional
ID1Primary unique identifier for the customer/stop (Acct#, Customer#). User defined (Preferences→Configuration) used in extract process.Required
ID2Secondary unique identifier for the customer/stop. Example: Store#, Stop#. User defined field in Preferences→Configuration.Required
ID3Tertiary unique identifier for the customer/stop. Example: Line Item, SKU. User defined field in Preferences→Configuration.Optional
AddressStreet Address for the customer. Address, along with City, State, and Zip are used to geocode by address. Also used by Address Cleanup.Optional
Address2Additional Address information. Example: Suite#, building#, Door#, Dock#.Optional
CityName 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
State2 letter state (Address) abbreviation. Example: WA, CA, OR. Required to geocode.Optional
ZipThe zip code (Address). Can be used for geocoding in conjunction with the Address field, or geocoding by 5-Digit or 9-Digit Zip.Optional
FixedTimeUsed 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
SzRestrictionSize 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
EqCodeAn 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 FieldsThe 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
CloseTWTRUE 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
ZoneA 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. 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
AMStartSet AM start time to adjust speed to account for heavier/lighter traffic.Optional
AMEndSet AM end time to adjust speed to account for heavier/lighter traffic.Optional
AMAdjSet 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. 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
PMStartSet PMStart to adjust speed to account for heavier or lighter traffic.Optional
PMEndSet PMEnd to adjust speed to account for heavier or lighter traffic.Optional
PMAdjSet drive time adjustment for PMStart and PMEnd. See AMAdj for additional info.Optional
Open1Earliest 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
Close1Latest time a delivery can be made. See Open1 for additional info.Optional
Pattern1Days 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=SaturdayOptional
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
EarlyBufferUsed 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
LateBufferUsed 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
PenaltyCostUsed 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 FIELDSDESCRIPTION
RFARV_DATEArrival date at delivery location
RFARV_DAYArrival day at delivery location
RFARV_TIMEArrival time at delivery location
RFBREAKTMBreak time for driver
RFCUM_DRV_TMCumulative drive time
RFCUM_WRK_TMCumulative work time on route
RFCUMQTY001Cumulative Quantity1 of Order
RFCUMQTY002Cumulative Quantity2 of Order
RFCUMQTY003Cumulative Quantity3 of Order
RFCUMQTY004Cumulative Quantity4 of Order
RFCUMQTY005Cumulative Quantity5 of Order
RFCUMQTY006Cumulative Quantity6 of Order
RFCUMQTY007Cumulative Quantity7 of Order
RFCUMQTY008Cumulative Quantity8 of Order
RFCUMQTY009Cumulative Quantity9 of Order
RFCUMQTY010Cumulative Quantity10 of Order
RFDEPDAYDay of departure/dispatch day
RFDEPT_DATERoute departure date
RFDEPT_TIMETime of route departure
RFDIST_TO_PREV_STOPDistance from previous stop
RFINCR_COSTIncremental cost of a stop; calculates difference in miles, drvtm; if a stop is added, applies mileage and hr cost
RFLAYOVER_TMOvernight layover time within a route
RFREMAINCAP001Remaining Capacity1
RFREMAINCAP002Remaining Capacity2
RFREMAINCAP003Remaining Capacity3
RFREMAINCAP004Remaining Capacity4
RFREMAINCAP005Remaining Capacity5
RFREMAINCAP006Remaining Capacity6
RFREMAINCAP007Remaining Capacity7
RFREMAINCAP008Remaining Capacity8
RFREMAINCAP009Remaining Capacity9
RFREMAINCAP010Remaining Capacity10
RFSEQ_NOSequence number of stop within a route
RFTIME_TO_PREV_STOPTime to Previous Stop
RFUNLOAD_TIMEUnload Time
RFWAIT_TM_AT_STOPWait time at stop
RFWINDOW_VIOLATIONWindow Violation
RT_NUMRoute Number
RT%_ABSCAP001_USEDAbsolute value of Qty1 for each stop on route divided by Trk capacity * 2 (pickup, delivery)
RT%_ABSCAP002_USEDAbsolute value of Qty2 for each stop on route divided by Trk capacity * 2
RT%_ABSCAP003_USEDAbsolute value of Qty3 for each stop on route divided by Trk capacity * 2
RT%_ABSCAP004_USEDAbsolute value of Qty4 for each stop on route divided by Trk capacity * 2
RT%_ABSCAP005_USEDAbsolute value of Qty5 for each stop on route divided by Trk capacity * 2
RT%_ABSCAP006_USEDAbsolute value of Qty6 for each stop on route divided by Trk capacity * 2
RT%_ABSCAP007_USEDAbsolute value of Qty7 for each stop on route divided by Trk capacity * 2
RT%_ABSCAP008_USEDAbsolute value of Qty8 for each stop on route divided by Trk capacity * 2
RT%_ABSCAP009_USEDAbsolute value of Qty9 for each stop on route divided by Trk capacity * 2
RT%_ABSCAP010_USEDAbsolute value of Qty10 for each stop on route divided by Trk capacity * 2
RT%_CAP001_USEDPercent of cap1 used on route (10 cap fields avail)
RT%_CAP002_USEDPercent of cap2 used on route
RT%_CAP003_USEDPercent of cap3 used on route
RT%_CAP004_USEDPercent of cap4 used on route
RT%_CAP005_USEDPercent of cap5 used on route
RT%_CAP006_USEDPercent of cap6 used on route
RT%_CAP007_USEDPercent of cap7 used on route
RT%_CAP008_USEDPercent of cap8 used on route
RT%_CAP009_USEDPercent of cap9 used on route (
RT%_CAP010_USEDPercent of cap10 used on route
RTCAP001_USEDRoute capacity1 used (10 cap fields avail)
RTCAP002_USEDRoute capacity2 used
RTCAP003_USEDRoute capacity3 used
RTCAP004_USEDRoute capacity4 used
RTCAP005_USEDRoute capacity5 used
RTCAP006_USEDRoute capacity6 used
RTCAP007_USEDRoute capacity7 used
RTCAP008_USEDRoute capacity8 used
RTCAP009_USEDRoute capacity9 used
RTCAP010_USEDRoute capacity10 used
RTBACKHAUL001Backhaul1
RTBACKHAUL002Backhaul2
RTBACKHAUL003Backhaul3
RTBACKHAUL004Backhaul4
RTBACKHAUL005Backhaul5
RTBACKHAUL006Backhaul6
RTBACKHAUL007Backhaul7
RTBACKHAUL008Backhaul8
RTBACKHAUL009Backhaul9
RTBACKHAUL010Backhaul10
RTCOSTPERSTOPCost per Stop
RTDEL001Total value of Qty1 delivered (Non negative quantities and excludes backhauls)
RTDEL002Total value of Qty2 delivered
RTDEL003Total value of Qty3 delivered
RTDEL004Total value of Qty4 delivered
RTDEL005Total value of Qty5 delivered
RTDEL006Total value of Qty6 delivered
RTDEL007Total value of Qty7 delivered
RTDEL008Total value of Qty8 delivered
RTDEL009Total value of Qty9 delivered
RTDEL010Total value of Qty10 delivered
RTCOSTPERQTY001Cost per Quantity1
RTCOSTPERQTY002Cost per Quantity2
RTCOSTPERQTY003Cost per Quantity3
RTCOSTPERQTY004Cost per Quantity4
RTCOSTPERQTY005Cost per Quantity5
RTCOSTPERQTY006Cost per Quantity6
RTCOSTPERQTY007Cost per Quantity7
RTCOSTPERQTY008Cost per Quantity8
RTCOSTPERQTY009Cost per Quantity9
RTCOSTPERQTY010Cost per Quantity10
RTEARLIESTLATEDATEShows the critical latest delivery date when Earliest/Latest Date is used.
RTENDDATEEnd date of route
RTENDDAYEnd day of route
RTENDTIMETime route ends
RTSTARTDATEDate route starts
RTSTART_DAYDay route starts
RTSTARTTIMETime route starts
RTFARTHESTSTOPDistance to the farthest stop on the route
RTJULIANPLUSRTUsed to generate rt # for peoplenet day of year +Rt# (ex. 050012 is rt 12 on the 50th day of the year)
RTNONSTEMDISTNone Stem distance
RTPENALTYCOSTPenalty Cost
RTPICKUP001Total value of Qty1 delivered (shown as negative quantities)
RTPICKUP002Total value of Qty2 delivered
RTPICKUP003Total value of Qty3 delivered
RTPICKUP004Total value of Qty4 delivered
RTPICKUP005Total value of Qty5 delivered
RTPICKUP006Total value of Qty6 delivered
RTPICKUP007Total value of Qty7 delivered
RTPICKUP008Total value of Qty8 delivered
RTPICKUP009Total value of Qty9 delivered
RTPICKUP010Total value of Qty10 delivered
RTQTYPERHR001Quantity1 per hour
RTQTYPERHR002Quantity2 per hour
RTQTYPERHR003Quantity3 per hour
RTQTYPERHR004Quantity4 per hour
RTQTYPERHR005Quantity5 per hour
RTQTYPERHR006Quantity6 per hour
RTQTYPERHR007Quantity7 per hour
RTQTYPERHR008Quantity8 per hour
RTQTYPERHR009Quantity9 per hour
RTQTYPERHR010Quantity10 per hour
RTQTYPERMI001Quantity1 per mile
RTQTYPERMI002Quantity2 per mile
RTQTYPERMI003Quantity3 per mile
RTQTYPERMI004Quantity4 per mile
RTQTYPERMI005Quantity5 per mile
RTQTYPERMI006Quantity6 per mile
RTQTYPERMI007Quantity7 per mile
RTQTYPERMI008Quantity8 per mile
RTQTYPERMI009Quantity9 per mile
RTQTYPERMI010Quantity10 per mile
RTSTEMDISTRoute stem distance
RTSTOPSPERHRStops per hour on route
RTSTOPSPERMIStops per mile on route
RTTOAT_UNLD_TMRoute total unload time
RTTOT_DAYSTotal number of days on a route
RTTOT_DISTTotal distance of a route
RTTOT_DROPCOSTTotal drop cost of a route
RTTOT_ELAPSED_TIMETotal elapsed time of a route
RTTOT_FIXEDCOSTTotal fixed cost of a route
RTTOT_HRCOSTTotal hourly pay cost of route
RTTOT_LAYOVERCOSTTotal cost of layovers on a route
RTTOT_MICOSTTotal mileage cost of a route
RTTOT_OTCOSTTotal overtime cost of a route
RTTOT_PREPOSTTotal pre and post time for a route
RTTOT_UNITCOSTTotal unit cost on a route
RTTOT_UNLDHRCOSTTotal unload hour cost on a route
RTTOT_WAITHRCOSTTotal wait hour cost of a route
RTTOTAL_COSTTotal cost of a route
RTTOTAL_DRV_TMTotal drive time
RTTOTAL_STOPSTotal stops serviced
RTTOTAL_WAIT_TMTotal wait time on a route
RTTOTAL_WRK_TMTotal work time on a route
RTVIOLATIONSYNViolations yes or no
RTVIOLATIONSFULLViolations (equip/capacity) on a route-Full
RTVIOLATIONSBRIEFViolations (equip/capacity) on a route-Brief
RFEMPTYMILESEmpty Miles
RTTOTAL_HOURS_PERROUTEDAYTotal hours per route day
RTTOT_LAYOVERTIMETotal layover time of a route
RTTOTAL_MILES_PERROUTEDAYTotal miles per route day
RTTOT_LAYOVERSTotal no of layovers on a route
RTTOLLCOSTToll cost per route
RTQTY001Total Qty1 per route
RTQTY002Total Qty2 per route
RTMILESPERQTY001Route miles per QTY1
RTMILESPERQTY002Route miles per QTY2
Stop FieldsDescription of Field Info
SFADDRESSAddress of stop
SFADDRESS2Extra address information
SFAMADJAM Rush Hour Speed Adjustment
RFBUFFERUSEDTotal untilized buffer time
SFCITYCity the stop is located in
SFCOLORColor of stop displayed on the map
SFCONTACTContact name for stop
SFOPEN1Earliest time for 1st delivery Time Window
SFCLOSE1Latest time for 1st delivery Time Window
SFPATTERN1Avail Del Days for first set of Time Windows
SFOPEN2Earliest time for 2nd delivery Time Window
SFCLOSE2Latest time for 2nd delivery Time Window
SFPATTERN2Avail Del Days for 2nd set of Time Windows
SFDELQTY001Quantity1 delivered to stop
SFDELQTY002Quantity2 delivered to stop
SFDELQTY003Quantity3 delivered to stop
SFDELQTY004Quantity4 delivered to stop
SFDELQTY005Quantity5 delivered to stop
SFDELQTY006Quantity6 delivered to stop
SFDELQTY007Quantity7 delivered to stop
SFDELQTY008Quantity8 delivered to stop
SFDELQTY009Quantity9 delivered to stop
SFDELQTY010Quantity10 delivered to stop
SFEQCODEEquipment code
SFFIXEDTIMEFixed time for stop
SFEARLIESTDATEEarliestDate for stop
SFID1First Identifier for Customer/Acct (Account#)
SFID2Second Identifier for Customer/Acct (Order#)
SFID3Third Identifier for Customer/Acct (LineItem)
SFLATITUDELatitude coordinates of stop
SFLONGITUDELongitude coordinates of stop
SFLATESTDATELatestDate
SFNAMECustomer name
SFOUTPFROUTECOSTOut of Route cost for Stop
SFPHONECustomer phone number
RFPENALTYCOSTCost incurred for utilizing Early/Late Buffer
SFPICKUPQTY001Pickup quantity1 (negative number)
SFPICKUPQTY002Pickup quantity2 (negative number)
SFPICKUPQTY003Pickup quantity3 (negative number)
SFPICKUPQTY004Pickup quantity4 (negative number)
SFPICKUPQTY005Pickup quantity5 (negative number)
SFPICKUPQTY006Pickup quantity6 (negative number)
SFPICKUPQTY007Pickup quantity7 (negative number)
SFPICKUPQTY008Pickup quantity8 (negative number)
SFPICKUPQTY009Pickup quantity9 (negative number)
SFPICKUPQTY010Pickup quantity10 (negative number)
SFQTY001Quantity1 of order
SFQTY002Quantity2 of order
SFQTY003Quantity3 of order
SFQTY004Quantity4 of order
SFQTY005Quantity5 of order
SFQTY006Quantity6 of order
SFQTY007Quantity7 of order
SFQTY008Quantity8 of order
SFQTY009Quantity9 of order
SFQTY010Quantity10 of order
SFROWRow # in the spreadsheet for the stop
SFRTRoute number
SFRTONLYDisplays only the Rt#, not Rt and Leg
SFSELECTEDStop selected
SFSEQSequence number of stop
SFSIZESize restriction
SFSTATEState where stop is located
SFSYMBOLSymbol assigned to the Stop
SFUNLDRATE001Unload rate1
SFUNLDRATE002Unload rate2
SFUNLDRATE003Unload rate3
SFUNLDRATE004Unload rate4
SFUNLDRATE005Unload rate5
SFUNLDRATE006Unload rate6
SFUNLDRATE007Unload rate7
SFUNLDRATE008Unload rate8
SFUNLDRATE009Unload rate9
SFUNLDRATE010Unload rate10
SFUSERFLD001Stop File user field1 (20 fields available)
SFUSERFLD002Stop File user field2
SFUSERFLD003Stop File user field3
SFUSERFLD004Stop File user field4
SFUSERFLD005Stop File user field5
SFUSERFLD006Stop File user field6
SFUSERFLD007Stop File user field7
SFUSERFLD008Stop File user field8
SFUSERFLD009Stop File user field9
SFUSERFLD010Stop File user field10
SFUSERFLD011Stop File user field11
SFUSERFLD012Stop File user field12
SFUSERFLD013Stop File user field13
SFUSERFLD014Stop File user field14
SFUSERFLD015Stop File user field15
SFUSERFLD016Stop File user field16
SFUSERFLD017Stop File user field17
SFUSERFLD018Stop File user field18
SFUSERFLD019Stop File user field19
SFUSERFLD020Stop File user field20
SFZIPZip code where stop is located
SFZONEuser defined zone of stop
SPDISTTODEPOTdist from stop to depot
SPDISTTODEPOTSUMsum of distance from stops to depot
SFDAYSBETWEENROUTESDays between routes
SFFREQUENCYFrequency for stop
SFGEORESULTGeocode results
SFLEGLeg number for stop
SFLTLCOSTLTL cost for the stop
SFMAXSPLITSMax number of splits allowed per stop
SFAMSTARTSpecifies start time of AM rush hour
SFAMENDSpecifies end time of AM rush hour
SFPMSTARTSpecifies start time of PM rush hour
SFPMENDSpecifies end time of PM rush hour
SFPMADJAmount to adjust PM drive time
SFAMADJAmount to adjust AM drive time
RFTOLLCOSTCost of toll for a stop
TW_GRAPHTime window graph
RFCAPUSED001Capacity1 used per stop (10 cap fields avail)
RFCAPUSED002Capacity2 used per stop
RFCAPUSED003Capacity3 used per stop
RFCAPUSED004Capacity4 used per stop
RFCAPUSED005Capacity5 used per stop
RFCAPUSED006Capacity6 used per stop
RFCAPUSED007Capacity7 used per stop
RFCAPUSED008Capacity8 used per stop
RFCAPUSED009Capacity9 used per stop
RFCAPUSED010Capacity10 used per stop
Truck FieldsDescription of Field Info
TFCAP001Vehicle capacity1
TFCAP002Vehicle capacity2
TFCAP003Vehicle capacity3
TFCAP004Vehicle capacity4
TFCAP005Vehicle capacity5
TFCAP006Vehicle capacity6
TFCAP007Vehicle capacity7
TFCAP008Vehicle capacity8
TFCAP009Vehicle capacity9
TFCAP010Vehicle capacity10
TFDROPCOSTDrop Cost
TFEARSTARTEarliest time vehicle can be dispatched
TFEDATEEarliest date vehicle may be dispatched
TFFIXEDCOSTFixed cost for operating vehicle
TFHRCOSTCost per hour to operate the vehicle
TFLATFINISHLatest time vehicle can finish the route
TFLAYOVERCOSTCost per layover of vehicle
TFLDATELatest date vehicle may be dispatched
TFLOCKLock route
TFMAXDRIVETMMaximum drive time for the vehicle/driver
TFMAXLAYOVERMaximum layover allowed
TFMAXWORKTMMaximum work time for vehicle/driver
TFMICOSTCost per mile to operate the vehicle
TFMINLAYOVERMinimum layover required
TFOTCOSTOver time cost
TFSPEQSpecial equipment identifier (corresponds to equipment code in Stop File)
TFSTATUSVehicle utilized (Y or N)
TFTRKIDUnique identifier for vehicle
TFUNITCOSTCost per unit on vehicle
TFUSERFLD001user defined field1
TFUSERFLD002user defined field2
TFUSERFLD003user defined field3
TFUSERFLD004user defined field4
TFUSERFLD005user defined field5
TFUSERFLD006user defined field6
TFUSERFLD007user defined field7
TFUSERFLD008user defined field8
TFUSERFLD009user defined field9
TFUSERFLD010user defined field10
TFUNLDHRCOSTUnload hour cost
TFWAITHRCOSTWait time cost per hour
TFBREAKTMBreak time for driver
TRDISTTotal distance driven (all routes)
TRDROPCOSTTotal drop cost
TRDRV_TMTotal drive time
TRELAPSED_TIMETotal elapsed time
TRFIXEDCOSTTotal fixed cost
TRHRCOSTTotal hourly pay cost
TRLAYOVERCOSTTotal layover cost
TRMICOSTTotal mileage cost
TROTCOSTTotal over time cost
TRSTOPSTotal stops serviced
TRTOTCOSTTotal overall cost
TRTOTTMTotal time used
TRUNITCOSTTotal unit costs
TRUNLD_TMTotal unload time
TRUNLDHRCOSTTotal unload hour cost
TRWAIT_TMTotal wait time
TRWAITHRCOSTTotal wait time cost
TRWRK_TMTotal work time
TFCITYCity the truck is located in
TFLATITUDETruck latitude
TFLONGITUDETruck longitude
TFPRETRIPPre Trip
TFPOSTTRIPPost trip
TFUNLDPERFUnload performance
ResourcePro FieldsDescription of Field Info
RPDRIVERDriver assigned to route in ResourcePro
RPTRUCKTruck assigned in ResourcePro
RPTRAILERTrailer assigned in ResourcePro
RPSTARTINGDRIVETIMEDrive Time Start in ResourcePro
RPSTARTINGWORKTIMEWork Time Start in ResourcePro
RPWORKHOURSBEFOREWork Hrs before next route (Hrs between routes)
Last updated December 15, 2021.
Contents