Shipment Output

Supply Chain Guru X Help

Home >

Submit Search

A new home for the Coupa Supply Chain documentation

Starting with Supply Chain 42, our documentation will be located on Coupa Compass. The help here will continue to be accessible for the foreseeable future, but will no longer be updated. If you need a Compass user account, contact your company’s Designated Support Contact (DSC).

You can access new and updated Supply Chain documentation in the following location on Compass:

https://compass.coupa.com/en-us/products/supply-chain-design-and-planning

Shipment Output

Internal Table Name: VRPOutputShipmentOutput

Scenario

Table: VRPOutputShipmentOutput

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

The scenario for which the output data was generated.

Shipment Name

Table: VRPOutputShipmentOutput

Internal Name: ShipmentName

The shipment for which the output data is generated.

Product

Table: VRPOutputShipmentOutput

Internal Name: Product

The product on the shipment for which the output data is generated.

Class Name

Table: VRPOutputShipmentOutput

Internal Name: ClassName

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

Source

Table: VRPOutputShipmentOutput

Internal Name: Source

The source location for the shipment.

Destination

Table: VRPOutputShipmentOutput

Internal Name: Destination

The destination location for the shipment.

Weight

Table: VRPOutputShipmentOutput

Internal Name: Weight

The weight of the shipment.

Cubic

Table: VRPOutputShipmentOutput

Internal Name: Cubic

The cubic volume of the shipment.

Quantity

Table: VRPOutputShipmentOutput

Internal Name: Quantity

The quantity of the shipment.

Status

Table: VRPOutputShipmentOutput

Internal Name: Status

This field indicates if the shipment was Routed, Unrouted or Invalid in the Transportation Optimization solution.

Comment

Table: VRPOutputShipmentOutput

Internal Name: Comment

For shipments with a Status of Unrouted or Invalid, this field provides the reason as to why the shipment was not routed.

Pickup Time

Table: VRPOutputShipmentOutput

Internal Name: PickupTime

The time at which the shipment was picked up from the source.

Delivery Time

Table: VRPOutputShipmentOutput

Internal Name: DeliveryTime

The time at which the shipment was delivered to the destination.

Earliest Pickup Time

Table: VRPOutputShipmentOutput

Internal Name: EarliestPickupTime

The start of the shipment’s pickup time window.

Latest Pickup Time

Table: VRPOutputShipmentOutput

Internal Name: LatestPickupTime

The end of the shipment’s pickup time window.

Earliest Delivery Time

Table: VRPOutputShipmentOutput

Internal Name: EarliestDeliveryTime

The start of the shipment’s delivery time window.

Latest Delivery Time

Table: VRPOutputShipmentOutput

Internal Name: LatestDeliveryTime

The end of the shipment’s delivery time window.

Route ID

Table: VRPOutputShipmentOutput

Internal Name: RouteID

The ID of the route on which the shipment was routed.

Route Start Time

Table: VRPOutputShipmentOutput

Internal Name: RouteStartTime

The start time of the route on which the shipment was routed.

Pickup Sequence ID

Table: VRPOutputShipmentOutput

Internal Name: PickupSequenceID

The sequence in which the shipment was picked up on the route.

Delivery Sequence ID

Table: VRPOutputShipmentOutput

Internal Name: DeliverySequenceID

The sequence in which the shipment was delivered on the route.

Asset ID

Table: VRPOutputShipmentOutput

Internal Name: AssetID

The ID of the asset used for the route on which the shipment was routed.

Asset Name

Table: VRPOutputShipmentOutput

Internal Name: AssetName

The name of the asset used for the route on which the shipment was routed.

Asset Site Name

Table: VRPOutputShipmentOutput

Internal Name: AssetSiteName

The name of the site at which the asset used on the route is located.

Route Sequence ID

Table: VRPOutputShipmentOutput

Internal Name: RouteSequenceID

The sequence of the shipment’s route on a tour.

Hub Used

Table: VRPOutputShipmentOutput

Internal Name: HubUsed

The name of the hub used when the shipment was routed.

Direct Shipment Cost

Table: VRPOutputShipmentOutput

Internal Name: HubUsed

The cost incurred based on the Direct Shipping Cost from the Shipments table. This cost is incurred when shipments are assigned to Direct routing rather than on routes generated by Transportation Optimization.

Cost To Route

Table: VRPOutputShipmentOutput

Internal Name: CostToRoute

This is 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.

Distance-Based Allocated Cost

Table: VRPOutputShipmentOutput

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: VRPOutputShipmentOutput

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.

Service Days

Table: VRPOutputShipmentOutput

Internal Name: ServiceDays

This value is calculated based on the date and time of delivery for a shipment in relation to its earliest pickup time. If no pickup date/time is provided, the start of the model horizon is used. For example, if a shipment has an earliest pickup time of 1/1/2017 12:00 AM and is delivered on 1/2/2017 12:00 AM (midnight) then Service Days = 1. For a shipment delivered on 1/2/2017 12:00 PM (noon), the Service Days will be 1.5.

PVRP Visit Sequence ID

Table: VRPOutputShipmentOutput

Internal Name: PVRPVisitSequenceID

The identifier of the visit sequence for periodic vehicle routing problems

Cluster ID

Table: VRPOutputShipmentOutput

Internal Name: ClusterID

Not currently implemented: When you manually group shipments into clusters, this displays the user defined cluster ID.

Compartment ID

Table: VRPOutputShipmentOutput

Internal Name: CompartmentID

If the problem was solved using multiple asset compartments, this is the compartment that was used for the shipment.

Decomposition ID

Table: VRPOutputShipmentOutput

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.

Allocated Sourcing Cost

Table: VRPOutputShipmentOutput

Internal Name: AllocatedSourcingCost

Displays the cost incurred by the shipment if it has been dynamically sourced. Shipments that do not have a source defined can be assigned a source site and will incur cost based on the selected source.

Sortie ID

Table: VRPOutputShipmentOutput

Internal Name: SortieID

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

Scenario ID

Table: VRPOutputShipmentOutput

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: VRPOutputShipmentOutput

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?

Yes No