Import Specifications for Locations

By Patrick Bracken | December 28, 2015

Location data is a required element for the Syntelic Route Planning system.  The Location import can also include distribution centers, pickup or backhaul sites, and other service or layover location data.

More guidelines for the formatting of imports can be found here: Import Formatting Guidelines

A summary of the attributes importable for each Location are summarized in the table below.  Some of the data fields are optional, but a few are required, as indicated by the asterisk (*).

Division ID* Identifier of the owner Division of this resource. Text 25
ID* Customer number or identifier. Text 25
Name* Descriptive name of location. Text 100
Address 1* Street Adress (Not PO Box). Text 100
Address 2 Additional address information such as PO Box, Suite #, etc. Text 100
City* City name. Text 100
State* State or Province abbreviation. Text 25
Zip or Postal Code Standard or +4 postal code. Text 25
Comments User-defined delivery information. Text 500
Contact Primary contact name. Text 100
Phone Telephone number which can include country code, area code, and extension. Text 25
Stop Type* Delivery, pickup, distribution center, other. Text 25
Time Zone* Standard time zone code. Text 25
Account Type Customer or location category, e.g., convenience store, institutional, fast food. Text 25
Latitutde Includes positive/negative indicator and decimal degrees. Numeric
Longitude Includes positive/negative indicator and decimal degrees Numeric
Delivery Days Character string, e.g. MWF that indicates the regular delivery days of each location. Text 25
Time Windows Format to be discussed
Service Time Factors Format to be discussed Numeric
Flexible Columns Optional field(s) as defined by the client. Text, Numeric, Boolean, Date Variable

Related Posts