URP Field Names Table

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 → RFCUMQTY010

Cumulative Quantity of Order (10 fields available)

RFDEPDAY

Day of departure/dispatch day

RFDEPT_DATE

Date of route departure

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 → RFREMAINCAP010

Remaining Capacity (10 fields available)

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 → RT%_ABSCAP010_USED

Absolute value of Qty for each stop on route divided by Trk capacity * 2 (pickup, delivery) (10 fields available)

RTCAP001_USED → RTCAP010_USED

Route capacity used (10 fields available)

RTBACKHAUL001 → RTBACKHAUL010

Backhaul (10 fields available)

RTDEL001 → RTDEL010

Total value of Qty delivered (10 fields available)

RTCOSTPERQTY001 → RTCOSTPERQTY010

Cost per Quantity (10 fields available)

RTEARLIESTLATEDATE

Shows the critical latest delivery date when Earliest/Latest Date is used.

RTENDDATE

End date of route

RTENDDAY

End day of route

RTENDTIME

End time of route

RTSTARTDATE

Start date of route

RTSTART_DAY

Start day of route

RTSTARTTIME

Start time of route

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 → RTPICKUP010

Total value of Qty delivered (shown as negative quantities) (10 fields available)

RTQTYPERHR001 → RTQTYPERHR010

Quantity per hour (10 fields available)

RTQTYPERMI001 → RTQTYPERMI010

Quantity per mile (10 fields available)

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 on 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 number of layovers on a route

RTTOLLCOST

Toll cost per route

RTQTY001 → RTQTY002

Total Qty per route (2 fields available)

RTMILESPERQTY001 → RTMILESPERQTY002

Route miles per QTY (2 fields available)

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 → SFDELQTY010

Quantity delivered to stop (10 fields available)

SFEQCODE

Equipment code

SFFIXEDTIME

Fixed time for stop

SFEARLIESTDATE

EarliestDate for stop

SFID1 → SFID3

Identifier for Customer/Acct (Account #/ Order # / Line item) (3 fields available)

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 → SFPICKUPQTY010

Pickup quantity (negative number) (10 fields available)

SFQTY001 → SFQTY010

Quantity of order (10 fields available)

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 → SFUNLDRATE010

Unload rate (10 fields available)

SFUSERFLD001 → SFUSERFLD020

Stop File user fields (20 fields available)

SFZIP

Zip code where stop is located

SFZONE

User-defined zone of stop

SPDISTTODEPOT

Distance 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 → RFCAPUSED010

Capacity used per stop (10 fields available)

Truck Fields

Description of Field Info

TFCAP001 → TFCAP010

Vehicle capacity (10 fields available)

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 → TFUSERFLD010

User-defined fields (10 fields available)

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 assigend 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)