Return Transactions

Internal Table Name: SimulationOutputReturnTransactionDetail

Available only for Classic Simulation. This table shows all individual return orders that occur during the simulation.

Scenario

Table: SimulationOutputReturnTransactionDetail

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

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

Source Name

Table: SimulationOutputReturnTransactionDetail

Internal Name: SourceName

Displays the name of the source site where the product return originated.

Destination Name

Table: SimulationOutputReturnTransactionDetail

Internal Name: DestinationName

Displays the name of the destination site where the product returned.

Product Name

Table: SimulationOutputReturnTransactionDetail

Internal Name: ProductName

Displays the product returned.

Mode

Table: SimulationOutputReturnTransactionDetail

Internal Name: Mode

Displays the mode used for the product return.

Shipment Departure Date

Table: SimulationOutputReturnTransactionDetail

Internal Name: ShipmentDepartureDate

Displays the date on which the return shipment left the source site.

Shipment Arrival Date

Table: SimulationOutputReturnTransactionDetail

Internal Name: ShipmentArrivalDate

Displays the date on which the return shipment arrived at the destination site.

Inventory Available Date

Table: SimulationOutputReturnTransactionDetail

Internal Name: InventoryAvailableDate

Displays the date on which the return shipment is available as inventory at the destination site.

Quantity

Table: SimulationOutputReturnTransactionDetail

Internal Name: Quantity

Displays the quantity of product in the return shipment.

Total Return Cost

Table: SimulationOutputReturnTransactionDetail

Internal Name: TotalReturnCost

Displays the total cost incurred for the product return.

Return Policy Cost

Table: SimulationOutputReturnTransactionDetail

Internal Name: ReturnPolicyCost

Displays the cost incurred based on the return policy used.

Transportation Policy Cost

Table: SimulationOutputReturnTransactionDetail

Internal Name: TransportationPolicyCost

Displays the cost incurred based on the transportation policy used.

Inventory Policy Cost

Table: SimulationOutputReturnTransactionDetail

Internal Name: InventoryPolicyCost

Displays the cost incurred based on the inventory policy used.

Total Return Process Cost

Table: SimulationOutputReturnTransactionDetail

Internal Name: TotalReturnProcessCost

Displays the total cost incurred for all returns processes.

Total Inventory Process Cost

Table: SimulationOutputReturnTransactionDetail

Internal Name: TotalInventoryProcessCost

Displays the total cost incurred for all inventory processes.

Total Transportation Process Cost

Table: SimulationOutputReturnTransactionDetail

Internal Name: TotalTransportationProcessCost

Displays the total cost incurred for all transportation processes.

Distance

Table: SimulationOutputReturnTransactionDetail

Internal Name: Distance

Displays the distance incurred on the return shipment from source site to destination site.

Time

Table: SimulationOutputReturnTransactionDetail

Internal Name: Time

Displays the time incurred on the return shipment from source site to destination site.

CO2

Table: SimulationOutputReturnTransactionDetail

Internal Name: CO2

Displays the CO2 produced on the return shipment from source site to destination site.

Weight

Table: SimulationOutputReturnTransactionDetail

Internal Name: Weight

Displays the weight of the return shipment.

Cubic

Table: SimulationOutputReturnTransactionDetail

Internal Name: Cubic

Displays the cubic volume of the return shipment.

Asset Name

Table: SimulationOutputReturnTransactionDetail

Internal Name: AssetName

Displays the name of the asset used for the return shipment.

Asset Unit

Table: SimulationOutputReturnTransactionDetail

Internal Name: AssetUnit

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

Scenario ID

Table: SimulationOutputReturnTransactionDetail

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: SimulationOutputReturnTransactionDetail

Internal Name: StepNumber

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

Rep

Table: SimulationOutputReturnTransactionDetail

Internal Name: Rep

Displays the replication number to which this data corresponds.

Last modified: Wednesday May 15, 2024

Is this useful?