Multi-Stop Estimation Failure Summary

Internal Table Name: OptimizationOutputPseudoRoutingFailedSummary

The Multi-Stop Estimation Failure Summary provides information about those lanes where the multi-stop estimated cost could not be returned based on the Multi-Stop Estimation Matrix. A cost of 9999 is incurred per lane for these records.

Scenario

Table: OptimizationOutputPseudoRoutingFailedSummary

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

Displays the name of the scenario which generated the multi-stop estimation output data.

Source

Table: OptimizationOutputPseudoRoutingFailedSummary

Internal Name: SourceName

This column displays the Source from the Transportation Policies table for this flow.

Customer

Table: OptimizationOutputPseudoRoutingFailedSummary

Internal Name: CustomerName

This column displays the Destination customer from the Transportation Policies table for this flow.

Customer Transportation Region

Table: OptimizationOutputPseudoRoutingFailedSummary

Internal Name: CustomerTransportRegion

This column displays the Transportation Region to which the Customer is assigned.

Product

Table: OptimizationOutputPseudoRoutingFailedSummary

Internal Name: ProductName

This column displays the Product that is on the flow.

Vehicle

Table: OptimizationOutputPseudoRoutingFailedSummary

Internal Name: VehicleName

This column displays the type of vehicle from the multi-stop estimated cost matrix.

Mode

Table: OptimizationOutputPseudoRoutingFailedSummary

Internal Name: ModeName

This column displays the name of the Mode to which the Vehicle is assigned. This mode has a Multi-Stop Estimation Vehicle Cost value populated as the Fixed Shipment Cost.

Departing Period Name

Table: OptimizationOutputPseudoRoutingFailedSummary

Internal Name: DepartingPeriodName

The period in which the flow leaves the source.

Arriving Period Name

Table: OptimizationOutputPseudoRoutingFailedSummary

Internal Name: ArrivingPeriodName

The period in which the flow arrives at the customer.

Service Distance

Table: OptimizationOutputPseudoRoutingFailedSummary

Internal Name: ServiceDistance

The distance between the source and the customer.

Shipment Size

Table: OptimizationOutputPseudoRoutingFailedSummary

Internal Name: ShipmentSize

This column displays the shipment size used for the lane.

Occurrences

Table: OptimizationOutputPseudoRoutingFailedSummary

Internal Name: Occurrences

This column displays the number of movements on the lane that are affected by the failure.

Vehicle Range

Table: OptimizationOutputPseudoRoutingFailedSummary

Internal Name: VehicleRange

Displays the distance range of the vehicle. This is the largest distance breakpoint as populated in the multi-stop estimated cost matrix.

Reason

Table: OptimizationOutputPseudoRoutingFailedSummary

Internal Name: Reason

This column provides the reason why the multi-stop estimated cost lookup was unsuccessful. For example, this may be due to capacity or time constraints on the vehicle.

Departing Period Num

Table: OptimizationOutputPseudoRoutingFailedSummary

Internal Name: DepartingPeriodNum

The sequence number for the period when the flow leaves the source. This value is useful in sorting periods sequentially rather than by name.

Arriving Period Num

Table: OptimizationOutputPseudoRoutingFailedSummary

Internal Name: ArrivingPeriodNum

The sequence number for the period when the flow arrives at the customer. This value is useful in sorting periods sequentially rather than by name.

Scenario ID

Table: OptimizationOutputPseudoRoutingFailedSummary

Internal Name: ScenarioID

Displays the identifier of the scenario for which the summary data was generated.

Sub-Scenario ID

Table: OptimizationOutputPseudoRoutingFailedSummary

Internal Name: StepNumber

Displays the identifier of the sub-scenario, if applicable, for which the summary data was generated.