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