Working with Distance data

In addition to using a third-party tool such as PC Miler and Rand McNally, you can upload distance data using the Reference Data Manager. You can upload distance data (either miles or kilometers) using a CSV distance data template.

You can download the Distance Data template from the Reference Data Manager Help page. The existing table is too large to download.

Specify a lane in Rate Query to see if the miles for a mileage pair already exist before you upload a new pair.

Click the file name below or go to Xtreme Online Support at www.infor.com/xtreme http://www.infor.com/xtreme to access the document.

distance_data.csv

This table shows the columns in the downloaded distance data .csv template and provides the format of the data required:

Column heading	Description
EndPoint Type(1|6)	Specify 1 for zip code endpoint or 6 for City State endpoints.
Post Code1	Specify only when EndPoint Type value is 1. If the country code is US, the zip code format is, for example, 01US75201. If the country code is CA, the zip code format is, for example, 01CAB1C2D3.
City1	Specify only when EndPoint Type value is 6.
State1	Specify only when EndPoint Type value is 6.
Country1	Specify to qualify zip code endpoint or City State endpoints; required.
Post Code2	Specify only when EndPoint Type value is 1. If the country code is US, the zip code format is, for example, 01US75201. If the country code is CA, the zip code format is, for example, 01CAB1C2D3.
City2	Specify only when EndPoint Type value is 6.
State2	Specify only when EndPoint Type value is 6.
Country2	Specify to qualify zip code endpoint or City State endpoints; required.
Distance Source	The distance source value must be one of the following: PC Miler Rand McNally User Defined
Distance	Specify the distance between the origin and destination used in the endpoints; float-point format accepted.
Units(MI|KM)	Specify Miles as MI and Kilometers as KM.