Shipment Handling 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 Handling Log

Internal Table Name: SimulationOutputShipmentHandlingDetail

This table displays the handling that occurs at a site, for both assets and work resources.

Scenario

Table: SimulationOutputShipmentHandlingDetail

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

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

Site

Table: SimulationOutputShipmentHandlingDetail

Internal Name: Site

Displays the site which handled the shipment.

Organization Name

Table: SimulationOutputShipmentHandlingDetail

Internal Name: OrganizationName

The Organization to which the shipment information is allocated. When the Site that handles the shipment belongs to the Organization, the shipment handling information is attributed to the Organization as required.

Shipment ID

Table: SimulationOutputShipmentHandlingDetail

Internal Name: ShipmentID

Displays the unique shipment number.

Start Date

Table: SimulationOutputShipmentHandlingDetail

Internal Name: StartDate

Displays the date and time at which the shipment was first handled by the site.

Handling Time

Table: SimulationOutputShipmentHandlingDetail

Internal Name: HandlingTime

Displays the amount of time the shipment was handled by the site.

Operation

Table: SimulationOutputShipmentHandlingDetail

Internal Name: Operation

Displays the operation which the site conducted to the shipment.

Asset Name

Table: SimulationOutputShipmentHandlingDetail

Internal Name: AssetName

Displays the asset type that was used in the shipment.

Asset Unit Number

Table: SimulationOutputShipmentHandlingDetail

Internal Name: AssetUnitNumber

Displays the unique asset ID number of the asset type that was used in the shipment handling.

Consignment Name

Table: SimulationOutputShipmentHandlingDetail

Internal Name: ConsignmentName

Displays the unique order (or consignment) from which the handling was based.

Quantity

Table: SimulationOutputShipmentHandlingDetail

Internal Name: Quantity

Displays the quantity of units handled by the site.

Work Resource Name

Table: SimulationOutputShipmentHandlingDetail

Internal Name: WorkResourceName

Displays the last work resource to handle the shipment at the site.

Internal Tracking ID

Table: SimulationOutputShipmentHandlingDetail

Internal Name: InternalTrackingID

Displays the tracking number as defined in the shipment table.

User Defined Tracking ID

Table: SimulationOutputShipmentHandlingDetail

Internal Name: UserDefinedTrackingID

Displays the Tracking ID entered on the Customer Demand, Customer Orders, Site Demand, Site Orders, or Shipments table.

If you have populated Shelf Life for products, the User Defined Tracking ID value is appended with the term ‘Expiry Replenishment’ if the product on this orders/shipment has reached its shelf life.

Average

Table: SimulationOutputShipmentHandlingDetail

Internal Name: AVERAGE

Displays the time series average value.

SimpleAverage

Table: SimulationOutputShipmentHandlingDetail

Internal Name: SIMPLEAVERAGE

Displays the time series simple average value.

StdDev

Table: SimulationOutputShipmentHandlingDetail

Internal Name: STDDEV

Displays the time series standard deviation value.

Min

Table: SimulationOutputShipmentHandlingDetail

Internal Name: MIN

Displays the time series minimum value.

Max

Table: SimulationOutputShipmentHandlingDetail

Internal Name: MAX

Displays the time series maximum value.

Current

Table: SimulationOutputShipmentHandlingDetail

Internal Name: CURRENT

Displays the time series current value.

Total

Table: SimulationOutputShipmentHandlingDetail

Internal Name: TOTAL

Displays the time series total value.

Period

Table: SimulationOutputShipmentHandlingDetail

Internal Name: Period

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

Expired Quantity

Table: SimulationOutputShipmentHandlingDetail

Internal Name: ExpiredQuantity

Displays the number of product units that have expired at the site due to shelf life considerations. When you populate the Shelf Life column in the Products table, those products still at the site when the shelf life is reached will be expired.

Idle Time

Table: SimulationOutputShipmentHandlingDetail

Internal Name: IdleTime

The Idle Time indicates how long a shipment waits after unload to be "received" at the location. This is based on business hours and is defined as a number of hours.

Scenario ID

Table: SimulationOutputShipmentHandlingDetail

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: SimulationOutputShipmentHandlingDetail

Internal Name: StepNumber

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

Rep

Table: SimulationOutputShipmentHandlingDetail

Internal Name: Rep

Displays the replication number to which this data corresponds.

Last modified: Wednesday May 15, 2024

Is this useful?

Yes No