Route Details

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

Route Details

Internal Table Name: VRPOutputRouteDetails

This table contains the data that is used to represent Transportation Optimization routing on a Gantt chart. The Gantt chart can show various activities that occur during the route.

Scenario

Table: VRPOutputRouteDetails

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

The scenario for which the output data was generated.

Asset Name

Table: VRPOutputRouteDetails

Internal Name: AssetName

The name of the asset used for the route.

Asset ID

Table: VRPOutputRouteDetails

Internal Name: AssetID

The ID of the asset that was used for the route.

Route ID

Table: VRPOutputRouteDetails

Internal Name: RouteID

The ID of the route.

Gantt ID

Table: VRPOutputRouteDetails

Internal Name: GanttID

The ID for the specific activity (such as Load, Transit) on the route.

Start Location

Table: VRPOutputRouteDetails

Internal Name: StartLocation

The start location of the route.

End Location

Table: VRPOutputRouteDetails

Internal Name: EndLocation

The end location of the route.

Activity Type

Table: VRPOutputRouteDetails

Internal Name: ActivityType

This is the specific activity that occurred on the route, such as Load, Transit, Unload, LongBreak and ShortBreak. LongBreak is determined by Rest Time in the Transportation Assets table. ShortBreak is determined by Break Time in the Transportation Assets table.

If you have defined assets with electric vehicle batteries, you will see an activity of Charge at the location where the battery is charged.

Activity Start Time

Table: VRPOutputRouteDetails

Internal Name: ActivityStartTime

The time at which the activity (such as Load) began.

Activity End Time

Table: VRPOutputRouteDetails

Internal Name: ActivityEndTime

The time at which the activity (such as Load) ended.

Distance

Table: VRPOutputRouteDetails

Internal Name: Distance

If the Activity Type is Transit, this is the distance traveled during that transit from Start Location to End Location.

Cumulative Distance

Table: VRPOutputRouteDetails

Internal Name: CumulativeDistance

The total distance traveled on the route at the point of the specific activity.

Activity Time

Table: VRPOutputRouteDetails

Internal Name: ActivityTime

The duration of the activity.

When using electric vehicles and the Activity Type is "Charge", the Activity Time is calculated as:

60 * Per Distance Consumption Rate * (Range When Leaving charging station - Range At Arrival at charging station) / (Battery Capacity * Charging Speed)

For example, assume the following values:

Per Distance Consumption Rate = 0.5

Range When Leaving = 153

Range At Arrival = 60.6

Battery Capacity = 90

Charging Speed = 1.5

The Activity Time in minutes is 60 * 0.5 * (153 - 60.6) / (90 * 1.5) = 20.53

Cumulative Time

Table: VRPOutputRouteDetails

Internal Name: CumulativeTime

The total time incurred on the route at the point of the specific activity.

Activity Cost

Table: VRPOutputRouteDetails

Internal Name: ActivityCost

The cost incurred for the specific activity.

When using electric vehicles and the Activity Type = "Charge", the Activity Cost is calculated as:

Fixed Cost + (Variable Cost * (Range When Leaving charging station - Range At Arrival at charging station) * Per Distance Consumption Rate)

where:

Fixed Cost and (Variable Cost are defined in the Battery Charging Option Definitions table

Per Distance Consumption Rate is defined in the Electric Vehicle Battery Definitions table

Range When Leaving and Range At Arrival are populated in the Stops output table

For example, assume:

Fixed Cost = 15
Variable Cost = 11.25
Per Distance Consumption Rate = 0.5
Range At Arrival = 27.16
Range When Leaving = 153

The total Activity Cost is:

15 + (11.25 * (153 - 27.16) * 0.5) = 722.85

Cumulative Cost

Table: VRPOutputRouteDetails

Internal Name: CumulativeCost

The total cost incurred on the route at the point of the specific activity.

Load Unload Quantity

Table: VRPOutputRouteDetails

Internal Name: LoadUnloadQuantity

If the Activity Type is Load or Unload, this is the quantity that is loaded/unloaded for the specific activity.

Load Unload Weight

Table: VRPOutputRouteDetails

Internal Name: LoadUnloadWeight

If the Activity Type is Load or Unload, this is the weight that is loaded/unloaded for the specific activity.

Load Unload Cubic

Table: VRPOutputRouteDetails

Internal Name: LoadUnloadCubic

If the Activity Type is Load or Unload, this is the cubic volume that is loaded/unloaded for the specific activity.

Load Unload Shipment Count

Table: VRPOutputRouteDetails

Internal Name: LoadUnloadShipmentCount

If the Activity Type is Load or Unload, this is the number of shipments unloaded at the time of the specific activity on the route.

Total Quantity

Table: VRPOutputRouteDetails

Internal Name: TotalQuantity

The total quantity for the shipments carried at the time of the specific activity on the route.

Total Weight

Table: VRPOutputRouteDetails

Internal Name: TotalWeight

The total weight for the shipments carried at the time of the specific activity on the route.

Total Cubic

Table: VRPOutputRouteDetails

Internal Name: TotalCubic

The total cubic volume for the shipments carried at the time of the specific activity on the route.

Total Shipment Count

Table: VRPOutputRouteDetails

Internal Name: TotalShipmentCount

The total number of shipments at the time of the specific activity on the route.

Remaining Quantity Capacity

Table: VRPOutputRouteDetails

Internal Name: RemainingQuantityCapacity

The remaining capacity in terms of quantity at the time of the specific activity.

Remaining Weight Capacity

Table: VRPOutputRouteDetails

Internal Name: RemainingWeightCapacity

The remaining capacity in terms of weight at the time of the specific activity.

Remaining Cubic Capacity

Table: VRPOutputRouteDetails

Internal Name: RemainingCubicCapacity

The remaining capacity in terms of weight at the time of the specific activity.

Start Location Latitude

Table: VRPOutputRouteDetails

Internal Name: StartLocationLatitude

If the Activity Type is Transit, this is the latitude of the activity’s start location.

Start Location Longitude

Table: VRPOutputRouteDetails

Internal Name: StartLocationLongitude

If the Activity Type is Transit, this is the longitude of the activity’s start location.

End Location Latitude

Table: VRPOutputRouteDetails

Internal Name: EndLocationLatitude

If the Activity Type is Transit, this is the latitude of the activity’s end location.

End Location Longitude

Table: VRPOutputRouteDetails

Internal Name: EndLocationLongitude

If the Activity Type is Transit, this is the longitude of the activity’s end location.

Activity Start Time Local

Table: VRPOutputRouteDetails

Internal Name: ActivityStartTimeLocal

The time at which the activity (such as Load) began, displayed in local time.

Activity End Time Local

Table: VRPOutputRouteDetails

Internal Name: ActivityEndTimeLocal

The time at which the activity (such as Load) ended, displayed in local time.

Scenario ID

Table: VRPOutputRouteDetails

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: VRPOutputRouteDetails

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