Manufacturing Model

This document describes how the data model of the ofbiz manufacturing application works.

Terminology

Manufacturing Tasks:

• A production run is a series of tasks which converts raw materials to finished products.
• A production run task is a particular task of the production run.
• A routing is a template of tasks to be performced to produce a product.
• A routing task is one particular task in the routing.

Data Model Usage

Only a few entities are used to do everything in manufacturing. Different type keys (workEffortTypeId, workEffortAssocTypeId, workEffortGoodStdTypeId) are used to make the same entities perform different roles. I will not re-type all the keys here. Run a few production runs and take a look at what data is in the entity model, and this will make more sense. The following entities are used by the manufacturing application:

• WorkEffort (WE): All manufacturing tasks are modeled as WorkEffort with different workEffortTypeId's. The workEffortParentId is used to associate production run tasks to the parent production task. Descriptive information, times, and dates are all stored on WorkEffort.
• WorkEffortAssoc (WEA): Routing tasks are associated to routing via WEA. When a production run is created, production run tasks are associated to routing task via WEA.
• WorkEffortGoodStandard (WEGS) is used to do three things:
  • Record which routing (template) is used to produce a product
  • Record which products are needed for a particular production run task
  • Record which product is actually produced by a production run
  • Record which product is used to define the purchasing of outsourcing for a routing task (in opentaps Warehouse application.)
• WorkEffortInventoryAssign (WEIA) is used to record actual inventory items issued to a production run task.
• WorkEffortInventoryProduced (WEIP) is used to record actual inventory items produced by a production run.
• WorkRequirementFulfillment (WRP) records how Requirements are fulfilled by actual production runs.
• WorkEffortFixedAssetStd (WEFAS) may be used to set the fixed asset for a routing and tasks
• WorkEffortFixedAssetAssign (WEFAA) may be used to set the fixed asset for actual production run and tasks