XML Order Import Table
The data fields in the XML Order Import Table is divided into four data categories:
- General Fields Data – DRGeneralFields Data relays information related to the delivery of an order
- Volume Fields Data – DRVolumeFields Data relays the type (named), quantity (amount), and the unload rate of material to be delivered.
- Time Window Fields Data – DRTimeWindowFields Data relays authorized delivery times/days.
- User Fields – DRUserFields Data relays any optional information needed, as defined by the user.
The following fields (columns) are listed in the XML Order Import Table:
- Field Name
- Field Type
- Enumeration (E)
- String (S)
- Numeric (N)
- Duration (DU)
- Date (D)
- Time (T)
- Boolean (B)
- Field Width (Characters)
- Required or Optional (R, O)
- Field Description
- Sample Field Value
DRGeneralFields Data
Field Name | Field Type | Field Width | Req (R) or Opt (O) | Description | Sample Field Value |
Key | N |
| R | An unique identifier for each DRStop element | 1 |
Branch | S | 20 | R | The name of the branch the customer belongs | MAIN, OKC or DALLAS |
Name | S | 50 | R | The name of the customer | Appian |
Contact | S | 50 | O | The name of a contact at the customer site | Joe |
Phone | S | 25 | O | Telephone number of the customer | 800-893-1250 |
ID1 | S | 30 | R | A unique identifier for this stop. Typically, an account number | A0001 |
ID2 | S | 25 | R | A unique secondary ID normally used for order number | O0001 |
ID3 | S | 25 | R | Third Identifier field normally used for a line item number or SKU. Can be the default value for all records | L0001 |
Address | S | 100 | R | Street address for the customer | 10317 Greenbriar Pl |
Address2 | S | 100 | O | Secondary address information (e.g. suite number, building, etc.) | Ste 100 |
City | S | 35 | R | The name of the city for this customer | Oklahoma City |
State | S | 2 | R | 2 character abbreviation for the state or province | OK |
Zip | S | 10 | R | The zip code or postal code of the customer | 73159-1514 |
FixedTime | DU |
| R | Number of minutes at this customer. Each customer can have a different fixed time. Note: Service Time at delivery locations are calculated based upon FixedTime and UnldRate (time). Setting the UnldRate to 0 will make the FixedTime be the total service time. | PT0H25M. |
RouteNumber | N |
| O | Route number that this stop is normally placed on | 1 |
Leg | N |
| O | Leg number that this stop is normally placed on | 1 |
Seq | N |
| O | Position of this customer within a route | 1 |
SizeRestriction | N |
| O | This field corresponds to the Capacity 1 field in the Truck file | 42000 |
EqCode | S | 50 | O | Equipment code for assigning account to particular vehicles | @AB-BH |
DRVolume (unlimited) |
|
| R | Volume to be delivered. One field for each volume used (ie. weight, cube, pallets, etc.) | See DRVolumeFields Data for details |
DRTimeWindow
|
|
| O | Open time and close time of delivery time window and the day of delivery. | See DRTimeWindowFields Data for details |
Zone | N |
| O | Speed zones used to increase or decrease truck driving speed within a delivery area. An example would be if the customer is located within a congested downtown area. A value of 125 increases driving time by 25%. Similarly, a value of 90 decreases the driving time by 10%. | 125 |
OrderType | E |
| R | If Modify is set as OrderType and if that order doesn’t exist in DRTrack then it will be added as a new order. | Add – New Order, Modify – Update Order, Delete / Delete Order. |
Longitude | N |
| O | Longitude of the customer (calculated by Application) | -97.5225 |
Latitude | N |
| O | Latitude of the customer (calculated by Application) | 32.7545 |
DRUserFields (Unlimited) |
|
| O | Optional data fields with additional information pertaining to the account. | See DRUserFields Data for details |
Symbol | S | 10 | O | The symbol will be placed on the map when orders are downloaded to DirectRoute. | Diamond |
Size | N |
| O | The size of the symbol which is displayed on the map when orders are downloaded to DirectRoute. | 16 |
Color | S | 10 | O | The color of the symbol which is displayed on the map. | Green |
MaxSplits | N | 2 | O | The max number of times an order can be split. | 0 |
EarlyBuffer | DU |
| O | The EarlyBuffer, in conjunction with the LateBuffer and PenaltyCost, is used to create Soft Time Windows. The Early Buffer applies a buffer, noted in hours, to the Time Windows. A buffer set to half-an-hour (.5) would stretch the front of the Time Windows by a half-an-hour. (I.e.: Time Windows of 07:00-11:00 would actually be computed as 06:30-11:00). When a stop uses the offered buffer, a penalty cost can be applied as defined in the PenaltyCost field. | PT1H25M30S |
LateBuffer | DU |
| O | The LateBuffer, in conjunction with EarlyBuffer and PenaltyCost, is used to create Soft Time Windows. Late Buffer applies a buffer, noted in house, to the Time Windows. A buffer set to half-an-hour (.5) would stretch the back of the Time Windows by 30 minutes (I.e.: Time Windows of 07:00-11:00 would actually be computed as 07:00-11:30). When a stop uses the offered buffer, a penalty cost can be applied, as laid out in the PenaltyCost field. | PT2H |
PenaltyCost | N |
| O | The PenaltyCost column, used in conjunction with EarlyBuffer and LateBuffer, is used to apply a penalty to stops that use the buffers; penalty cost, applied in Cost per Hour. Penalty Cost is used to calculate not only penalty charges for a stop using the buffer but also during optimization. DRTrack will attempt to move a stop with a penalty cost to another route, eliminating the penalty. | 50 |
Estimated DeliveryDate | D |
| R | The delivery date time the order should be shipped | 2010-01-10T18:05:00 |
EarliestDate | D |
| O | When a Stop must be delivered within a certain timeframe, then EarliestDate may be used to ensure that the stop is completed within the restrictive time. | 2010-01-08 |
LatestDate | D |
| O | LatestDate is used in conjunction with EarliestDate. This is the latest that a stop may be serviced. LatestDate may be the same as the EarliestDate if there is only one day in which the stop may be serviced | 2010-01-12 |
CloseTW | B |
| O | If the customer's delivery must be completed (delivered, unloaded and out) by the late time window time, then set to TRUE. | TRUE or FALSE |
DRVolumeFields Data
1 | 2 | 3 | 4 | 5 | 6 |
No | N |
| R | ID | A number increment from 1 |
Name | S | 25 | R | Name of the Qty Field. | Weight, Cube, Pallet |
Volume | N |
| R | The amount of material to be delivered to this stop | 2000 |
UnldRate | N |
| R | The amount of time it will take to unload material per hour. It will take 2 hours to deliver 2000 units at an UnldRate of 1000 units/hr (Pass 0 to ignore unload rates) | 1000. Note: Service Time at delivery locations are calculated based upon Fixed Time and UnldRate (time). Setting the UnldRate to 0 will make the Fixed Time be the total service time. |
DRTimeWindowFields Data
1 | 2 | 3 | 4 | 5 | 6 |
Open | T |
| R | Open time of the delivery time window. (Seconds are ignored) | 07:00:00 |
Close | T |
| R | Close time of the delivery time window. (Seconds are ignored) | 13:30:00 |
Pattern | S | 7 | R | Day of the delivery. Allowed Characters: S – Sunday, M – Monday, T- Tuesday W – Wednesday, R- Thursday F – Friday, A – Saturday | MWFA, SMF, RFA |
DRUserFields Data
1 | 2 | 3 | 4 | 5 | 6 |
No | N |
| R | ID | A number incremented from 1 |
Name | S | 25 | R | Name of the user field | SalesPerson |
Value | S | 255 | R | Value of the user field | Bob |