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 
    1. Enumeration (E)
    2. String (S)
    3. Numeric (N)
    4. Duration (DU)
    5. Date (D)
    6. Time (T)
    7. 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