vLongDistanceDispatchGrid Data View

 

This view allows you to access data displaying within the Current Driver Activity grid.

 

The following table lists the data available through this view and in the order in which they display. Please refer to Current Driver Activity for field descriptions:

 

 

Notes

Use the Order ID reference to connect to related table data.

 

 

Fields included in this view

Driver Last Name

Driver First Name

Driver Number

Order Number

From City

From State (ST)

To City

To State (ST)

Start Load

Start Delivery

End Delivery

Linehaul

Status

Trip Number (No)

Weight

End Load

Actual Delivery Date

From Postal Code

To Postal Code

From Area

To Area

From Location Type

To Location Type

Commodity

Move Type

Service Type

Shipment Type

Miles

Cubic Feet

Linear Feet

Self Haul

Preferred Pack

Preferred Load

Preferred Delivery

Start Pack

End Pack

Pack Start Time

Pack End Time

Load Start Time

Load End Time

Delivery Start Time

Delivery End Time

Auto

Haul Agent Id

Haul Agent Name

National Account

 

Discount

Order ID

 

 

RELATED TOPICS:

Current Driver Activity

Long Distance Dispatch