Sortie 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

Sortie Details

Internal Table Name: SortieSummary

The Sortie Details table provides details about the sorties that are carried out by drones. These details include the start and end locations, load/unload quantity, weight and volume, and shipment counts.

Scenario

Table: SortieSummary

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

The scenario for which the output data was generated.

Drone

Table: SortieSummary

Internal Name: DroneTypeName

The drone type used on the sortie.

Drone ID

Table: SortieSummary

Internal Name: DroneId

The identifier of the drone used on the sortie.

Sortie ID

Table: SortieSummary

Internal Name: SortieId

The identifier of the sortie.

Gantt ID

Table: SortieSummary

Internal Name: GanttID

The identifier used to represent the sortie on a gantt chart.

Start Location

Table: SortieSummary

Internal Name: StartLocationName

The start location of the sortie.

End Location

Table: SortieSummary

Internal Name: EndLocationName

The end location of the sortie.

Activity Type

Table: SortieSummary

Internal Name: ActivityType

The type of activity carried out on the sortie. Activities include: Equipment Start, Wait, Load, Travel, Unload, Retrieve and Equipment End.

Activity Start Time

Table: SortieSummary

Internal Name: ActivityStartDateTime

The start time for the sortie activity.

Activity End Time

Table: SortieSummary

Internal Name: ActivityEndDateTime

The end time for the sortie activity.

Distance

Table: SortieSummary

Internal Name: Distance

If the Activity Type is "Travel", this is the distance incurred for that activity. For other activities, the Distance is 0.

Cumulative Distance

Table: SortieSummary

Internal Name: CumulativeDistance

The total distance traveled on the sortie at the point of the specific activity. Distance is only incurred for Travel, so you will see any travel distance reported prior to the current activity.

Activity Time

Table: SortieSummary

Internal Name: ActivityTime

The time incurred for the activity on the sortie.

Cumulative Time

Table: SortieSummary

Internal Name: CumulativeTime

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

Load Unload Quantity

Table: SortieSummary

Internal Name: LoadUnloadQty

The quantity that is loaded/unloaded on the sortie.

Load Unload Weight

Table: SortieSummary

Internal Name: LoadUnloadWeight

The weight that is loaded/unloaded on the sortie.

Load Unload Volume

Table: SortieSummary

Internal Name: LoadUnloadCubic

The volume that is loaded/unloaded on the sortie.

Load Unload Shipment Count

Table: SortieSummary

Internal Name: LoadUnloadShipmentCount

The number of shipments that are loaded/unloaded on the sortie.

Total Quantity

Table: SortieSummary

Internal Name: TotalQty

The total quantity on the sortie.

Total Weight

Table: SortieSummary

Internal Name: TotalWeight

The total weight on the sortie.

Total Volume

Table: SortieSummary

Internal Name: TotalCubic

The total volume on the sortie.

Total Shipment Count

Table: SortieSummary

Internal Name: TotalShipmentCount

The total number of shipments on the sortie.

Remaining Quantity Capacity

Table: SortieSummary

Internal Name: RemainingQtyCapacity

The quantity capacity remaining for the drone assigned to the sortie.

Remaining Weight Capacity

Table: SortieSummary

Internal Name: RemainingWeightCapacity

The weight capacity remaining for the drone assigned to the sortie.

Remaining Volume Capacity

Table: SortieSummary

Internal Name: RemainingCubicCapacity

The volume capacity remaining for the drone assigned to the sortie.

Start Location Latitude

Table: SortieSummary

Internal Name: StartLocationLatitude

The latitude of the start location for the sortie.

Start Location Longitude

Table: SortieSummary

Internal Name: StartLocationLongitude

The longitude of the start location for the sortie.

End Location Latitude

Table: SortieSummary

Internal Name: EndLocationLatitude

The latitude of the end location for the sortie.

End Location Longitude

Table: SortieSummary

Internal Name: EndLocationLongitude

The longitude of the start location for the sortie.

Activity Start Time Local

Table: SortieSummary

Internal Name: ActivityStartTimeLocal

The number of drones assigned to this carrier asset that are used in the solution.

Activity End Time Local

Table: SortieSummary

Internal Name: ActivityEndTimeLocal

The start time for the sortie activity in the local time zone.

Scenario ID

Table: SortieSummary

Internal Name: ScenarioId

The end time for the sortie activity in the local time zone.

Sub-Scenario ID

Table: SortieSummary

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