ISA-95: Material Model
The material model
defines the actual materials, material definitions, and information about classes
of material definitions. Material information includes the inventory of raw, finished,
and intermediate materials. The current material information is contained in the
material lot and material sublot information. Material classes are defined to organize
materials.
Database

To store the whole
data associated to the Material Model we have defined 12 tables. Any custom material
defined by a material class become a new table like customMaterial_Xxx. This helps
you to obtain excellent performances.
Assembly

The material assembly
is composed by 12 classes in order to be fully ISA-95 compliamt. The custom class
generator helps you to build the necessary code for defining a custom material and
a custom material lot and sublot. For example you can configure your material class
properties with the Mdf Manager utility, after that the CCG engine writes for you,
in few seconds, all the required code to have a performant store layer and a wrapper
.NET classes.
The classes of the assembly
|
MaterialClass |
Material class |
|
PropertiesInMaterialClass |
|
|
MaterialClassProperty |
Material class property |
|
MaterialClassPropertySetOfValues |
|
|
MaterialDefinition |
Material definition |
|
MaterialLot |
Material lot |
|
MaterialLotStatus |
|
|
MaterialSubLot |
Material sub lot |
|
MaterialSubLotStatus |
|
|
MaterialSubLotComposition |
|
|
QATestSpecification |
QA test specification |
|
QATestResult |
QA test result |
Mdf - Mes development framework
Mdf - MES Development
Framework has been defined from experienced developers to respond to both customers and developers needs.
Write complex Manufacturing Execution Systems fully ISA-95 compliant will never be easier using
c# or VB.NET with LINQ to Entity technology,
SQL Server 2005/2008 as storage layer,
ASP.NET 3.5 with extensive use of Ajax and
ASP.NET MVC for user interface,
OPC to communicate with PLCs and field devices and
Windows Workflow Foundation for plant business rules.
Download the Mdf latest version here.
Mdf Demo