Import Specifications for Routing Orders

Route planning order data is a required element for the Syntelic Route Planning system.  These records typically represent aggregate order lines (quantity, cube, weight, pallets, etc) for each delivery to be planned for shipment.  Alternatively, multiple routing orders can be generated for each stop if it is desirable to break out quantities by product types, trailer compartment, container type or other criteria that is relevant to the route planning process.

Order data is typically generated daily (once or multiple times based on order cut-off times) and transferred to the route planning system for processing.

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

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

Field NameDescriptionData TypeLength
Ship Date*Invoice date or delivery date of the order.Date/Time
Division ID*Identifier of the owner Division of this transaction record.Text25
ID*Unique identifier of the order record.Text25
Location ID*Customer ID of the order addressee.Text25
Bill To IDOptional bill-to-ID different from above.Text25
Route IDIdentifier of the route or load associated with the order.Text25
Stop NumberNumber identifying the sequence of the delivery within the route.Numeric
Commodity or PRoduct TypeUsed when route planners require more detailed information about each delivery’s order.Text25
Invoice or Order IDInvoice number of the order recordText25
Quantity*Cases or sale units.Numeric
Cube*Total cubic volume of the order.Numeric
Weight*Total weight of the order.Numeric
PalletsTotal number of pallets.Numeric
25
Special InstructionsText200
Flexible ColumnsOptional field(s) as defined by the client.Text, Numeric, Boolean, DateVariable