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