Resources
Import Specifications for Locations
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 (*).
| FIELD NAME | DESCRIPTION | DATA TYPE | LENGTH |
|---|---|---|---|
| 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 |