Dock Door Assignment

Internal Table Name: VRPDockDoorAssignment

The Dock Door Assignment table provides details about the dock doors used at sites and customers in multi-stop routes. This information includes the route, asset and location, as well as the dock door ID, plus the start and end date and time for each dock door use.

Scenario

Table: VRPDockDoorAssignment

Internal Name: Not Applicable (Scenario column not in table)

The scenario for which the output data was generated.

Asset Name

Table: VRPDockDoorAssignment

Internal Name: AssetName

The name of the asset used for the route.

Asset ID

Table: VRPDockDoorAssignment

Internal Name: AssetID

The identifier of the asset that was used for the route.

Route ID

Table: VRPDockDoorAssignment

Internal Name: RouteID

The identifier of the route where the dock door is used.

Location Name

Table: VRPDockDoorAssignment

Internal Name: SiteName

The name of the Site or Customer location of a stop on the route.

Dock Door ID

Table: VRPDockDoorAssignment

Internal Name: DockDoorID

The identifier of the dock door that serviced the route at the stop location. This column is populated only if you have defined the Number of Dock Doors for the location.

Dock Door Start Time

Table: VRPDockDoorAssignment

Internal Name: DockDoorStartTime

Displays the time the vehicle started use of the dock door.

Dock Door End Time

Table: VRPDockDoorAssignment

Internal Name: DockDoorEndTime

Displays the time the vehicle finished use of the dock door. The time between the Dock Door Start Time and Dock Door End Time includes all fixed and variable loading and unloading time. It also includes the Dock Door Reset Time as specified at the Site or Customer location.

Scenario ID

Table: VRPDockDoorAssignment

Internal Name: ScenarioID

The identifier of the scenario for which the output data was generated.

Sub-Scenario ID

Table: VRPDockDoorAssignment

Internal Name: StepNumber

The identifier of the sub-scenario, if applicable, for which the output data was generated.