Skip to content

Reference & Data Model

Specification (good_type_spec, spec_category, spec_value)

Specifications are technical attributes of a material category; articles carry values for them, technical requirements check them.

A Technical specification (good_type_spec) defines an attribute with data type and unit on a material category. Specification categories (spec_category) group attributes. The Specification value (spec_value) is the concrete value of an article for an attribute. All three are master data that feed spec matching in engineering.

Stammdaten › Material-Katalog (Master data › Material catalog): on the material category the area „Technische Kategorie-Spezifikationen“ (technical category specifications) with „Spezifikation-Kategorie hinzufügen“ (Add specification category), „Technische Spezifikation hinzufügen“ (Add technical specification) and „Merkmal bearbeiten“ (Edit attribute); on the article „Technische Daten“ (technical data) with „Spezifikationswert hinzufügen“ (Add specification value). On the product a matrix of the values of all articles. See Guides › Material catalog.

Field Technical Type Required Meaning Notes
Title name Text yes Name of the attribute
Data type data_type Selection yes „Text“, „Zahl“ (number), „Auswahl“ (selection), „Ja/Nein“ (yes/no) fixed after creation
Unit unit Text only visible for „Zahl“ Unit of the attribute required in DB; stored empty for other types
Options options Text only for „Auswahl“ Comma-separated allowed values options can later only be added, not removed
Material category good_type_id Reference yes Defining category from the tree
Specification category spec_category_id Reference no Group in the data sheet without a group under „Allgemein“ (General)

One field Category name (name, required) and the material category (good_type_id, required).

Field Technical Type Required Meaning Notes
Value value per data type yes Number (single value or range from–to), text, selection from options, yes/no unit is displayed from the specification
Article / Specification good_variant_id / good_type_spec_id Reference yes Assignment
Related to Kind Required On archive On delete
Specification → material category belongs to yes – deleted along
Specification → specification category belongs to no – reference cleared
Specification → specification value has many – – deleted along
Specification ← specification requirement (technical_structure_spec_req) has many – – reference kept without a rule (no delete action declared)
Specification category → material category belongs to yes – deleted along
Specification value → article belongs to yes – deleted along
  • Inheritance: An article has all specifications of its material category and of all parent categories. The data sheet shows „Geerbt von“ (inherited from). The „Spezifikationsabdeckung“ (specification coverage) measures how many effective specifications have values.
  • Spec matching (engineering): Requirements use the conditions =, ≥, ≤, „zwischen“ (between) and „einer von“ (one of). A numeric value satisfies a condition when its whole interval (single value or range) lies within the bounds. Text and selection compare exactly (text without leading/trailing whitespace). A missing or type-mismatched value yields „ungeprüft“ (unchecked), never „verletzt“ (violated). See Specification requirement.
  • Master data character: A changed specification value immediately changes the matching result in all technical structures that use the article. Deleting a specification deletes all values of all articles for it. The fixed data type prevents existing values from becoming invalid.

Material · Component requirement · Technical component · Guides › Technical structure