Shipment Transactions

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 Transactions

Internal Table Name: SimulationOutputShipmentTransactionDetail

This table shows all the shipments that occur during the simulation. Records are populated in this table if the Shipment Transactions option is checked on the Detailed Output tab of Simulation Options.

Scenario

Table: SimulationOutputShipmentTransactionDetail

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

Displays the name of the scenario which generated the shipment transaction data.

Source Name

Table: SimulationOutputShipmentTransactionDetail

Internal Name: SourceName

Displays where the product is shipped from.

Destination Name

Table: SimulationOutputShipmentTransactionDetail

Internal Name: DestinationName

Displays where the product is shipped to.

Product Name

Table: SimulationOutputShipmentTransactionDetail

Internal Name: ProductName

Displays the name of the product that is being shipped in this transaction.

Quantity

Table: SimulationOutputShipmentTransactionDetail

Internal Name: Quantity

Displays the number of units of product shipped in the particular transaction

Time

Table: SimulationOutputShipmentTransactionDetail

Internal Name: Time

Displays the time when the shipment arrived at the destination.

CO2

Table: SimulationOutputShipmentTransactionDetail

Internal Name: CO2

Displays the CO2 emissions due to the shipment. This is based on the CO2 and CO2 Basis values in the Transportation Policies table. The value is displayed in your model default weight unit of measure.

Weight

Table: SimulationOutputShipmentTransactionDetail

Internal Name: Weight

Displays the total weight of items shipped in this transaction.

Cubic

Table: SimulationOutputShipmentTransactionDetail

Internal Name: Cubic

Displays the total volume of items shipped in this transaction.

Mode

Table: SimulationOutputShipmentTransactionDetail

Internal Name: Mode

Displays the mode used on this transportation lane.

Shipment Number

Table: SimulationOutputShipmentTransactionDetail

Internal Name: ShipmentNumber

Displays the unique shipment ID number for this transaction.

Transportation Cost

Table: SimulationOutputShipmentTransactionDetail

Internal Name: Cost

Displays the cost incurred due to the shipment. This is calculated based on the Variable Cost Basis and Variable Transportation Cost values in Transportation Policies. For example, if Variable Cost Basis = Distance, Transportation Cost is (Distance * Transportation Cost).

Duty

Table: SimulationOutputShipmentTransactionDetail

Internal Name: Duty

Displays the duty or tariff incurred by the shipment transaction. The duty cost is calculated by multiplying the duty from Transportation Policies by the shipment’s total value. The total value is the Value from the Product table multiplied by shipment quantity.

Total Sourcing Process Cost

Table: SimulationOutputShipmentTransactionDetail

Internal Name: TotalSourcingProcessCost

The total cost incurred for all sourcing processes.

Total Transportation Process Cost

Table: SimulationOutputShipmentTransactionDetail

Internal Name: TotalTransportationProcessCost

The total cost incurred for all transportation processes.

Total Inventory Process Cost

Table: SimulationOutputShipmentTransactionDetail

Internal Name: TotalInventoryProcessCost

The total cost incurred for all inventory processes.

Due Date

Table: SimulationOutputShipmentTransactionDetail

Internal Name: DueDate

Displays the original due date for the shipment to reach its destination.

Transportation Policy

Table: SimulationOutputShipmentTransactionDetail

Internal Name: TransportationPolicy

Displays the name of the transportation policy used to conduct the shipment.

Asset Name

Table: SimulationOutputShipmentTransactionDetail

Internal Name: AssetName

Displays the type of asset used to conduct the shipment.

Asset Unit

Table: SimulationOutputShipmentTransactionDetail

Internal Name: AssetUnit

Displays the specific unit of the asset type that conducted the individual shipment.

Internal Tracking ID

Table: SimulationOutputShipmentTransactionDetail

Internal Name: InternalTrackingID

Displays the unique internally generated tracking number as defined in the original shipment table.

User Defined Tracking ID

Table: SimulationOutputShipmentTransactionDetail

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 order/shipment has reached its shelf life.

Expired Quantity

Table: SimulationOutputShipmentTransactionDetail

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.

Scenario ID

Table: SimulationOutputShipmentTransactionDetail

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: SimulationOutputShipmentTransactionDetail

Internal Name: StepNumber

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

Rep

Table: SimulationOutputShipmentTransactionDetail

Internal Name: Rep

Displays the replication number that the data on this row applies to.

Last modified: Wednesday May 15, 2024

Is this useful?

Yes No