Segments
Internal Table Name: VRPOutputSegments
The Segments table provides information about each leg between an origin and destination on the vehicle routes generated by Transportation Optimization.
Scenario
Table: VRPOutputSegments
Internal Name: Not Applicable (Scenario column not in table)
The scenario for which the output data was generated.
Route ID
Table: VRPOutputSegments
Internal Name: RouteID
The identifier of the route (from the Route table) on which the segment is located.
Start Date Time
Table: VRPOutputSegments
Internal Name: StartDateTime
The start date and time at the first stop on the segment.
End Date Time
Table: VRPOutputSegments
Internal Name: EndDateTime
The end date and time at the last stop on the segment.
Distance
Table: VRPOutputSegments
Internal Name: Distance
The distance from the first stop to the last stop on the segment.
Drive Time
Table: VRPOutputSegments
Internal Name: OperatingTime
The total time from the first stop to the last stop on the segment (drive time plus any handling time).
Start Date Time Local
Table: VRPOutputSegments
Internal Name: StartDateTimeLocal
The start date and time in local time at the first stop on the segment.
End Date Time Local
Table: VRPOutputSegments
Internal Name: EndDateTimeLocal
The end date and time in local time at the last stop on the segment.
Segment ID
Table: VRPOutputSegments
Internal Name: SegmentID
The identifier of the segment.
Sequence ID
Table: VRPOutputSegments
Internal Name: SequenceID
The sequence number of the segment on the route.
Start Stop ID
Table: VRPOutputSegments
Internal Name: StartStopID
The identifier of the first stop on the segment. The identifier is from the Stops table.
Start Site
Table: VRPOutputSegments
Internal Name: StartSite
This field displays the name of the site represented by the Start Stop ID.
End Stop ID
Table: VRPOutputSegments
Internal Name: EndStopID
The identifier of the last stop on the segment. The identifier is from the Stops table.
End Site
Table: VRPOutputSegments
Internal Name: EndSite
This field displays the name of the site represented by the End Stop ID.
CO2 Emission
Table: VRPOutputSegments
Internal Name: CO2Emission
Displays the CO2 emission incurred on the segment. The emission is calculated as:
((Tare weight of vehicle + weight of shipments onboard) * CO2 factor) * Distance traveled
The CO2 factor is defined on the Transportation Assets table.
Additive Cost
Table: VRPOutputSegments
Internal Name: AdditiveCost
The cost added to the calculated cost on the segment when Additive Cost is defined in the Transit Matrix table.
Scenario ID
Table: VRPOutputSegments
Internal Name: ScenarioID
The identifier of the scenario for which the output data was generated.
Sub-Scenario ID
Table: VRPOutputSegments
Internal Name: StepNumber
The identifier of the sub-scenario, if applicable, for which the output data was generated.
Last modified: Wednesday May 15, 2024