Delivered Shipments

Internal Table Name: VRPOutputDeliveredShipments

The Delivered Shipments table provides information about the shipments that have been placed on vehicle routes by Transportation Optimization.

Scenario

Table: VRPOutputDeliveredShipments

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

The scenario for which the output data was generated.

Shipment ID

Table: VRPOutputDeliveredShipments

Internal Name: ShipmentID

The identifier of the delivered shipment.

Route ID

Table: VRPOutputDeliveredShipments

Internal Name: RouteID

The identifier of the route used by the shipment, from the Route table.

Source Site

Table: VRPOutputDeliveredShipments

Internal Name: SourceSite

The source site for the shipment.

Destination Site

Table: VRPOutputDeliveredShipments

Internal Name: DestinationSite

The destination site for the shipment.

Pickup Date Time

Table: VRPOutputDeliveredShipments

Internal Name: PickupDateTime

The date and time at which the shipment was picked up.

Delivery Date Time

Table: VRPOutputDeliveredShipments

Internal Name: DeliveryDateTime

The date and time at which the shipment was delivered.

Product Name

Table: VRPOutputDeliveredShipments

Internal Name: ProductName

The product that is the delivered shipment.

Class Name

Table: VRPOutputDeliveredShipments

Internal Name: ClassName

Displays the valued defined in the Class Name column on the Shipments input table.

Weight

Table: VRPOutputDeliveredShipments

Internal Name: Weight

The weight of the delivered shipment. This may be less than the total weight of the original shipment, if the shipment was split.

Cubic

Table: VRPOutputDeliveredShipments

Internal Name: Cubic

The cubic volume of the delivered shipment. This may be less than the total cubic volume of the original shipment, if the shipment was split.

Qty

Table: VRPOutputDeliveredShipments

Internal Name: Qty

The quantity of the delivered shipment. This may be less than the total quantity of the original shipment, if the shipment was split.

Pickup Stop ID

Table: VRPOutputDeliveredShipments

Internal Name: PickupStopID

The identifier of the stop (from the Stops table) at which the shipment is picked up.

Delivery Stop ID

Table: VRPOutputDeliveredShipments

Internal Name: DeliveryStopID

The identifier of the stop, from the Stops table, at which the shipment is delivered.

Pickup Date Time Local

Table: VRPOutputDeliveredShipments

Internal Name: PickupDateTimeLocal

The local date and time at which the shipment was picked up.

Delivery Date Time Local

Table: VRPOutputDeliveredShipments

Internal Name: DeliveryDateTimeLocal

The local date and time at which the shipment was delivered.

Hub Used

Table: VRPOutputDeliveredShipments

Internal Name: HubUsed

When Hub Optimization is run, this field displays the Hub that was assigned to the shipment.

Comp2 Qty

Table: VRPOutputDeliveredShipments

Internal Name: Comp2Qty

The quantity for this shipment specified for the second asset compartment.

Comp2 Weight

Table: VRPOutputDeliveredShipments

Internal Name: Comp2Weight

The weight for this shipment specified for the second asset compartment.

Comp2 Cubic

Table: VRPOutputDeliveredShipments

Internal Name: Comp2Cube

The cubic volume for this shipment specified for the second asset compartment.

Cost To Route

Table: VRPOutputDeliveredShipments

Internal Name: CostToRoute

Displays what it cost to add the shipment to the route. Given a route, if Shipment A is removed, Cost to Route is the difference between the original cost and the cost without Shipment A. Only the delivery or pickup cost is removed from the total route cost, and the route is not reconstructed. For detailed information, refer to Cost to Route and Allocated Cost.

Distance-Based Allocated Cost

Table: VRPOutputDeliveredShipments

Internal Name: DistanceBasedAllocatedCost

Displays a distance-based allocated cost to route the shipment. It is an apportionment of the total cost of the route to each of its shipments based on each shipment’s travel distance. This is the allocated cost to route the shipment, weighting the shipment using the product of the shipment's quantity and its travel distance on the route. For example, assume you have three stops on a route. This is the cost to remove each stop one at a time, then allocate the fixed cost back to the shipment based on the quantity per shipment and its travel distance. For detailed information, refer to Cost to Route and Allocated Cost.

Time-Based Allocated Cost

Table: VRPOutputDeliveredShipments

Internal Name: TimeBasedAllocatedCost

Displays a time-based allocated cost to route the shipment. It is an apportionment of the total cost of the route to each of its shipments based on each shipment’s surface time. This is the allocated cost to route the shipment, weighting the shipment using the product of the shipment's quantity and its surface time (its travel time on the route combined with its load and unload time). For example, assume you have three stops on a route. This is the cost to remove each stop one at a time, then allocate the fixed cost back to the shipment based on the quantity per shipment and the time incurred. For detailed information, refer to Cost to Route and Allocated Cost.

Direct Shipping Cost

Table: VRPOutputDeliveredShipments

Internal Name: LTLCost

Displays the Direct Shipping Cost (if any) applied to the shipment. You enter the Direct Shipping Cost on the Shipments table.

LTL Confidence %

Table: VRPOutputDeliveredShipments

Internal Name: LTLConfidencePercent

Displays a measure of the confidence in recommending Direct Ship as the Mode, and relates to the Mode Suggestion value as shown:

• Route – Value is 0, indicating that Direct Ship should not be the mode.
• Consider Direct Ship – Value between 0 and 1 using the ratio of the Cost to Route / Direct Shipping Cost.
• Direct Ship – Value is 1, indicating that Direct Ship should be the mode.

Decomposition ID

Table: VRPOutputDeliveredShipments

Internal Name: DecompositionID

Displays the decomposition value based on the selected Shipments Decomposition Field in Transportation Optimization Options. For example, if you have selected Shipment Destination Country as the Shipments Decomposition Field, shipments with destinations in Spain are not routed with shipments to France.

Sortie ID

Table: VRPOutputDeliveredShipments

Internal Name: SortieID

The identifier of the sortie if the shipment has been delivered by a drone on a sortie.

Scenario ID

Table: VRPOutputDeliveredShipments

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: VRPOutputDeliveredShipments

Internal Name: StepNumber

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