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 born after an experience in MES Development with standard development
tools like Visual Studio .NET 2005. We were unsatisfied from the available tools
nowadays, so we are looking for a methodology that can help you to write robust
industrial solution compliant to ISA-95 standards.
Download the Mdf latest version here.