Shipment Mileage Log

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 Mileage Log

Internal Table Name: SimulationOutputShipmentMileageDetail

Available only in Classic Simulation. The mileage log is written as shipments depart during the simulation.

Each row of the mileage log contains information about one leg of the trip. Thus for a simple out and back delivery there would be two rows, one for the outbound delivery and one for the return trip.

In a pooled delivery model there would potentially be more than two rows corresponding to a single trip.

Each shipment is assigned a Shipment ID that can be used to group all the legs belonging to the same shipment. This value can also be used to correlate data with the shipping item log.

Scenario

Table: SimulationOutputShipmentMileageDetail

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

Displays the name of the scenario which generated the shipment mileage log data.

Source Site

Table: SimulationOutputShipmentMileageDetail

Internal Name: SourceSite

Displays the name of the Source Site of the shipment.

Destination Site

Table: SimulationOutputShipmentMileageDetail

Internal Name: DestinationSite

Displays the name of the destination site of the shipment.

Shipment ID

Table: SimulationOutputShipmentMileageDetail

Internal Name: ShipmentID

Displays the unique ID number that is used to group and correlate data relating to the same shipment.

Departure Date

Table: SimulationOutputShipmentMileageDetail

Internal Name: DepartureDate

Displays the date and time of departure from the source location.

Arrival Date

Table: SimulationOutputShipmentMileageDetail

Internal Name: ArrivalDate

Displays the date and time of arrival at the destination location.

Distance

Table: SimulationOutputShipmentMileageDetail

Internal Name: Distance

Displays the distance traveled between the source and destination on this leg of the trip.

Asset Name

Table: SimulationOutputShipmentMileageDetail

Internal Name: AssetName

Displays the name of the asset. This field could be empty if no asset was used.

Asset Unit Number

Table: SimulationOutputShipmentMileageDetail

Internal Name: AssetUnitNumber

Displays the unit number of the asset. This field could be empty if no asset was used.

Container ID

Table: SimulationOutputShipmentMileageDetail

Internal Name: ContainerID

Displays the unique ID of the container used to transport the product, if used.

Average

Table: SimulationOutputShipmentMileageDetail

Internal Name: AVERAGE

Displays the time series average value.

SimpleAverage

Table: SimulationOutputShipmentMileageDetail

Internal Name: SIMPLEAVERAGE

Displays the time series simple average value.

StdDev

Table: SimulationOutputShipmentMileageDetail

Internal Name: STDDEV

Displays the time series standard deviation value.

Min

Table: SimulationOutputShipmentMileageDetail

Internal Name: MIN

Displays the time series minimum value.

Max

Table: SimulationOutputShipmentMileageDetail

Internal Name: MAX

Displays the time series maximum value.

Current

Table: SimulationOutputShipmentMileageDetail

Internal Name: CURRENT

Displays the time series current value.

Total

Table: SimulationOutputShipmentMileageDetail

Internal Name: TOTAL

Displays the time series total value.

Period

Table: SimulationOutputShipmentMileageDetail

Internal Name: Period

Displays the Period number for the log values. ALL indicates the record for the complete model horizon.

Scenario ID

Table: SimulationOutputShipmentMileageDetail

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: SimulationOutputShipmentMileageDetail

Internal Name: StepNumber

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

Rep

Table: SimulationOutputShipmentMileageDetail

Internal Name: Rep

Displays the replication number to which this data corresponds.

Last modified: Wednesday May 15, 2024

Is this useful?

Yes No