Stops

Internal Table Name: VRPOutputStops

The Stops table provides information about each stop on the routes generated by Transportation Optimization.

Scenario

Table: VRPOutputStops

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

The scenario for which the output data was generated.

Stop ID

Table: VRPOutputStops

Internal Name: StopID

The identifier of the stop.

Route ID

Table: VRPOutputStops

Internal Name: RouteID

The identifier of the route (from the Route Summary table) on which the stop is located.

Sequence ID

Table: VRPOutputStops

Internal Name: SequenceID

The sequence number of the stop on the route.

Stop Type

Table: VRPOutputStops

Internal Name: StopType

The type of stop. The value will be one of:

  • Equipment Start - The equipment is initially located at this stop. This stop type may be combined with Pickup (Equipment Start - Pickup).
  • Pickup - Shipments are picked up at this stop.
  • Delivery - Shipments are delivered at this stop.
  • Charge - An asset with an electric vehicle battery is charged at this stop. This stop type may be combined with Equipment Return (Equipment Return - Charge).
  • Equipment Return - The equipment (asset) is returned to its original location. This stop type may be combined with Delivery (Equipment Return - Delivery).

Site Name

Table: VRPOutputStops

Internal Name: SiteName

The site name of the stop location.

Arrive Date Time

Table: VRPOutputStops

Internal Name: ArriveDateTime

The date and time at which the asset arrives at the stop.

Delivery Date Time

Table: VRPOutputStops

Internal Name: DeliveryDateTime

The date and time at which the shipment(s) are delivered at the stop.

Leave Date Time

Table: VRPOutputStops

Internal Name: LeaveDateTime

The date and time at which the asset leaves at the stop.

Qty

Table: VRPOutputStops

Internal Name: Qty

The shipment quantity picked up or delivered at the stop.

Weight

Table: VRPOutputStops

Internal Name: Weight

The shipment weight picked up or delivered at the stop.

Cubic

Table: VRPOutputStops

Internal Name: Cubic

The shipment cubic volume picked up or delivered at the stop.

Pickup Cubic

Table: VRPOutputStops

Internal Name: PickupCubic

Displays the cubic volume that is picked up at the stop.

Pickup Weight

Table: VRPOutputStops

Internal Name: PickupWeight

Displays the weight that is picked up at the stop.

Pickup Qty

Table: VRPOutputStops

Internal Name: PickupQty

Displays the quantity that is picked up at the stop.

Delivered Cubic

Table: VRPOutputStops

Internal Name: DeliveredCubic

Displays the cubic volume that is delivered at the stop.

Delivered Weight

Table: VRPOutputStops

Internal Name: DeliveredWeight

Displays the weight that is delivered at the stop.

Delivered Qty

Table: VRPOutputStops

Internal Name: DeliveredQty

Displays the quantity that is delivered at the stop.

Remaining Cubic

Table: VRPOutputStops

Internal Name: RemainingCubic

Displays the cubic volume that remains on the asset after shipments have been picked up or delivered (or both) at the stop.

Remaining Weight

Table: VRPOutputStops

Internal Name: RemainingWeight

Displays the weight that remains on the asset after shipments have been picked up or delivered (or both) at the stop.

Remaining Qty

Table: VRPOutputStops

Internal Name: RemainingQty

Displays the quantity that remains on the asset after shipments have been picked up or delivered (or both) at the stop.

Longitude

Table: VRPOutputStops

Internal Name: Longitude

The longitude of the stop location.

Latitude

Table: VRPOutputStops

Internal Name: Latitude

The latitude of the stop location.

Arrive Date Time Local

Table: VRPOutputStops

Internal Name: ArriveDateTimeLocal

The local date and time at which the asset arrives at the stop.

Delivery Date Time Local

Table: VRPOutputStops

Internal Name: DeliveryDateTimeLocal

The local date and time at which the shipment(s) are delivered at the stop.

Leave Date Time Local

Table: VRPOutputStops

Internal Name: LeaveDateTimeLocal

The local date and time at which the asset leaves at the stop.

Charging Option

Table: VRPOutputStops

Internal Name: ChargingOption

If the transportation asset used by the route is an electric vehicle, this column displays the name of the Charging Option that was used for the vehicle as defined in the Charging Option Definitions input table.

Range At Arrival

Table: VRPOutputStops

Internal Name: RangeAtArrival

If the transportation asset used by the route is an electric vehicle, this column displays the vehicle's remaining distance range when it arrives at the stop. When the Stop Type is "Charge", the Range When Leaving minus Range At Arrival defines how much the battery has been charged at the stop.

Range When Leaving

Table: VRPOutputStops

Internal Name: RangeWhenLeaving

If the transportation asset used by the route is an electric vehicle, this column displays the vehicle's remaining distance range when it leaves the stop. When the Stop Type is "Charge", the Range When Leaving minus Range At Arrival defines how much the battery has been charged at the stop.

Scenario ID

Table: VRPOutputStops

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: VRPOutputStops

Internal Name: StepNumber

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

Last modified: Wednesday May 15, 2024

Is this useful?