Sourcing Process Flows
Internal Table Name: OptimizationOutputSourcingProcessFlows
This output table summarizes the specifics of all sourcing process flows in the network.
Scenario
Table: OptimizationOutputSourcingProcessFlows
Internal Name: Not Applicable (Scenario column not in table)
The scenario for which the summary data was generated.
Period Name
Table: OptimizationOutputSourcingProcessFlows
Internal Name: PeriodName
The period in which this flow occurs.
Source Name
Table: OptimizationOutputSourcingProcessFlows
Internal Name: SourceName
The source site for the process flow.
Destination Name
Table: OptimizationOutputSourcingProcessFlows
Internal Name: DestinationName
The destination site for the process flow.
Product Name
Table: OptimizationOutputSourcingProcessFlows
Internal Name: ProductName
The name of the product being sourced.
Process Type
Table: OptimizationOutputSourcingProcessFlows
Internal Name: ProcessType
The type of process used with this sourcing process flow.
Process Name
Table: OptimizationOutputSourcingProcessFlows
Internal Name: ProcessName
The name of the process.
Process Step Name
Table: OptimizationOutputSourcingProcessFlows
Internal Name: ProcessStepName
The name of this process step.
Next Process Step Name
Table: OptimizationOutputSourcingProcessFlows
Internal Name: NextProcessStepName
The process step that occurs after the Process Step Name.
Work Center Name
Table: OptimizationOutputSourcingProcessFlows
Internal Name: WorkCenterName
The name of the work center, if applicable, used by the process.
Work Resource Name
Table: OptimizationOutputSourcingProcessFlows
Internal Name: WorkResourceName
The name of the work resource, if applicable, used by the process.
Flow Units
Table: OptimizationOutputSourcingProcessFlows
Internal Name: FlowUnits
The number of units handled in this process flow.
Flow Weight
Table: OptimizationOutputSourcingProcessFlows
Internal Name: FlowWeight
The weight of all units handled in this process flow.
Flow Cubic
Table: OptimizationOutputSourcingProcessFlows
Internal Name: FlowCubic
The cubic size of all units handled in this process flow.
Flow Cost
Table: OptimizationOutputSourcingProcessFlows
Internal Name: FlowCost
The total cost involved this flow.
flow cost = total number of flow units * unit process cost
Flow Setup Cost
Table: OptimizationOutputSourcingProcessFlows
Internal Name: SetupCost
The total cost involved in setting up this process.
setup cost = (total number of flow units * setup cost from Process Steps table) / lot size
Total Cost
Table: OptimizationOutputSourcingProcessFlows
Internal Name: TotalCost
The total cost incurred for the sourcing process flow of the product in the specified period.
Process Time
Table: OptimizationOutputSourcingProcessFlows
Internal Name: ProcessTime
The time incurred for the sourcing process of the product in the specified period.
Changeover Time
Table: OptimizationOutputSourcingProcessFlows
Internal Name: ChangeoverTime
The time incurred during work center changeovers required for the process.
Process Time
Table: OptimizationOutputSourcingProcessFlows
Internal Name: WorkCenterUsageTime
This is the time incurred when work centers are utilized for the sourcing process flows of the product at the site in the specified period.
Work Resource Usage Time
Table: OptimizationOutputSourcingProcessFlows
Internal Name: WorkResourceUsageTime
The time incurred when work resources are utilized.
Period No
Table: OptimizationOutputSourcingProcessFlows
Internal Name: PeriodNo
The sequence number for the period. This value is useful in sorting periods sequentially rather than by name.
Scenario ID
Table: OptimizationOutputSourcingProcessFlows
Internal Name: ScenarioID
The identifier of the scenario for which the summary data was generated.
Sub-Scenario ID
Table: OptimizationOutputSourcingProcessFlows
Internal Name: StepNumber
The identifier of the sub-scenario, if applicable, for which the summary data was generated.
Last modified: Wednesday May 15, 2024