Baseline Output Shipments
Internal Table Name: VRPOutputBaselineShipments
The Baseline Output Shipments output table displays those shipments that have been placed on baseline routes.
For all models, whether you have specifically defined baseline shipments or not, the Baseline Output Shipments table is populated when you run Transportation Optimization. The routed shipments are assigned to a Baseline Solution of “1”. If the solution includes shipments that are cheaper to deliver with direct shipping (based on the Direct Shipping Cost in the Shipments table), these shipments are assigned to a Baseline Solution of “0”.
If you have defined records in the Shipment Constraints table, you can specify the Baseline Solution value.
Scenario
Table: VRPOutputBaselineShipments
Internal Name: Not Applicable (Scenario column not in table)
The scenario for which the output data was generated.
Baseline Solution
Table: VRPOutputBaselineShipments
Internal Name: BaselineSolutionID
The Baseline Solution from the Shipment Constraints input table. Use this field to identify sets of baseline shipments.
If you have not defined a Baseline Solution in the Shipment Constraints table, or if there are no Shipment Constraints defined, the routed shipments are assigned to a Baseline Solution of “1”. If the solution includes shipments that are cheaper to deliver with direct shipping (based on the Direct Shipping Cost in the Shipments table), these shipments are assigned to a Baseline Solution of “0”.
Shipment
Table: VRPOutputBaselineShipments
Internal Name: ShipmentID
The identifier of the baseline shipment.
Route ID
Table: VRPOutputBaselineShipments
Internal Name: RouteID
The identifier of the route used by the shipment, from the Route table.
Route Start Date
Table: VRPOutputBaselineShipments
Internal Name: RouteStartDate
Displays the start date and time of the route on which the baseline shipment is routed.
Pickup Sequence
Table: VRPOutputBaselineShipments
Internal Name: PickupSequenceId
Displays the pickup sequence number of the baseline shipment on the route.
Delivery Sequence
Table: VRPOutputBaselineShipments
Internal Name: DeliverySequenceId
Displays the delivery sequence number of the baseline shipment on the route.
Asset Name
Table: VRPOutputBaselineShipments
Internal Name: AssetName
The name of the asset used for route on which the baseline shipment is routed.
Asset Site Name
Table: VRPOutputBaselineShipments
Internal Name: AssetSiteName
Displays the name of the site at which the asset used for the route was located.
Tour
Table: VRPOutputBaselineShipments
Internal Name: TourId
The name of the tour on which the baseline shipment is routed.
Route Sequence
Table: VRPOutputBaselineShipments
Internal Name: RouteSequenceId
Displays the sequence number of the route as defined on the Tour.
Force Ship Direct
Table: VRPOutputBaselineShipments
Internal Name: ForceShipDirect
Indicates whether or not the baseline shipment was defined with Force Ship Direct. When this field is Yes, it means the solver forced the shipment to use the Direct Shipping Method. When set to No, the solver used a multi-stop routing method. This field is also set to Yes for regular shipments that are cheaper to send direct based on the Direct Shipping Cost in the Shipments table.
Linehaul Route
Table: VRPOutputBaselineShipments
Internal Name: LinehaulRouteId
If you used the Hub Optimization problem type, this field displays the route ID for the linehaul route into or out of the hub.
Hub
Table: VRPOutputBaselineShipments
Internal Name: HubID
If you used the Hub Optimization problem type, this field displays the name of the hub through which the baseline shipment is routed.
Pickup Location
Table: VRPOutputBaselineShipments
Internal Name: PickupLocationID
Displays the location at which the baseline shipment was picked up.
Delivery Location
Table: VRPOutputBaselineShipments
Internal Name: DeliveryLocationID
Displays the location at which the baseline shipment was delivered.
Scenario ID
Table: VRPOutputBaselineShipments
Internal Name: ScenarioID
The identifier of the scenario for which the output data was generated.
Sub-Scenario ID
Table: VRPOutputBaselineShipments
Internal Name: StepNumber
The identifier of the sub-scenario, if applicable, for which the output data was generated.
Last modified: Wednesday May 15, 2024