vLocalDispatchGrid Data View

 

This view allows you to access data displaying within the Dispatch Center grid.

 

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

 

 

Notes

This views list the lead crew person and only one piece of assigned equipment.

Use the Local Service (Loc Serv) Branch ID and Order ID references to connect to related table data.

 

 

Fields included in this view

Service Date

Shipper Name

Order Number

Service

Crew

Hours

Job Start

Lead Crew Name

Equipment

Note

Origin Address

Origin City

Origin State

Origin Zip

Destination Address

Destination City

Destination State

Destination Zip

Order Weight

Total Containers

Total Crates

Origin Phone

Origin Work Phone

Destination Phone

Destination Work Phone

Dispatch Status

Local Service (Loc Serv) Branch ID

Order ID

 

RELATED TOPICS:

Dispatch Center

Local Dispatch

vOrderActualCPU Data View