XML Order Import Table

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