Import Specifications for Route Orders

The Route Orders table is used by Syntelic Load Planning as a primary input to the load diagramming process. Each Route Order represents a specific quantity of one Item for a specific delivery location that must be loaded onto a vehicle. Most Syntelic customers load Route Orders in batches, several times per day, where each batch represents all of the orders for one or more routes (or loads). The Route Orders are typically derived from an upstream system such as order processing or a warehouse management system.

Route orders may be viewed as the lowest level of a hierarchy that is central to the Syntelic data structure. Each Route Order is owned by a Route Stop, which represents a delivery point along a route. Each Route Stop is owned by a Route, which represents a load to be dispatched. Each Route is owned by a Trip Set, which represents a collection or routes or loads attributable to one specific accounting date known as the Trip Date. And each Trip Set is owned by a Division, which represents an organizational unit within your distribution operations (typically one distribution center or DC)

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

A summary of the attributes importable for each Route Order are summarized in the table below. Due to the flexibility of Load Planning, many of the data fields are optional, but a few are required, as indicated by the asterisk (*).

Field NameDescriptionData Type
Division ID*Identifier of the owner division of this record.Text
Post Date*Date on which the order was posted.Date/Time
Trip Set ID*Uniquely identifies one set of routes or loads within one Trip DateText
Route ID*Identifier of the route or load associated with the order.Text
Plan Stop Number*Number identifying the sequence of the delivery within the route.Numeric
Location ID*Ship-to location ID to which the order will be delivered.Text
Invoice IDInvoice or order number.Text
Bill to Location IDOptional bill-to location ID if different from above.Text
Order Line ID*Unique identifier of the order line record. Usually a combination of the order ID and an order line number.Text
Item IDItem ID of the product.Text
QuantityCases or eaches ordered.Numeric
Is EachesIndicates if the quantity of the order is in units of eaches as opposed to case units.Boolean
Override Product TypeAn identifier that categorizes the items into groupings appropriate for warehouse operations. This is usually a relatively short character string or number.Text
Pre-Select IDAn identifier that describes the ship pallet on which the order line will be loaded, if pallets are preassembled. Must be unique for the route.Text
Active Slot ID*Warehouse slot location allocated to this order and the associated quantity; required if different from the slot location specified for the associated item.Text
Is Deferred LoadIndicates that the order will be handled last in the loading process regardless of loading sequence.Boolean
Flexible ColumnsOptional field(s) as defined by the client.Text, Numeric, Boolean, Date