🌐 NL · Last reviewed: 27 May 2026
Certificate master data
Five lookup tables underpin the certificate functionality. Set them up once during implementation; they appear in dropdown lists on certificates, requests, and links.
1. Certificate Types
EN 10204 classes or similar (2.2, 3.1, 3.2). The optional Ranking field matters: higher ranking = stricter certificate. With Check Ranking Cert. Sales = On, DXSteel can substitute a higher-ranked type when the exact type is unavailable.
|
Field |
Purpose |
|---|---|
|
Type |
Code (max 10), primary key. |
|
Description |
Free text. |
|
Ranking |
Numeric; unique per record. For ranking fallback. |
2. Certificate Specifications
Controlled-vocabulary values for dropdown fields on certificates. The Type column decides where the value is used.
|
Type |
Used for |
|---|---|
|
Norm-Flatness |
Flatness norm on a certificate |
|
Norm-Thickness |
Thickness norm |
|
Norm-Surface |
Surface norm |
|
Delivery-Condition |
Delivery condition |
|
Test-Ultrasone / Test-Z / Test-Impact |
Test norms |
|
Stamping |
Stamp codes (CE, AD 2000, PED, …) |
Define allowed values per type. Translations live in Certificate Translations.
3. Classification Companies
External certification bodies: TÜV, Lloyd's Register, Bureau Veritas, SGS, DNV. One code per organisation. Used on certificates, requests, and ranking checks.
4. Factories
Production locations issuing certificates. Important: picking a factory auto-fills the Country/Region on the certificate header, allowing DXSteel to set the European flag correctly.
|
Field |
Purpose |
|---|---|
|
Code |
Max 10 chars. |
|
Description |
Factory name. |
|
Country/Region |
Determines origin for customs and compliance. |
5. Conversions
Mapping table for inbound certificate data via Conversion Import (XmlPort). Translates vendor-specific codes to internal DXSteel codes.
|
Conversion type |
Example |
|---|---|
|
Item Profile |
Vendor product code → internal profile |
|
Quality |
Vendor quality → DXSteel quality |
|
Certificate Type |
Vendor classification → EN 10204 class |
|
Classification Company |
Local name → standard code |
|
Factory / Country/Region / Vendor |
External name → internal code |
|
Norm-* / Test-* / Stamping |
Vendor string → standard norm |
Best practices
Standardise master data first (types, specifications, classification companies). Then configure Conversions per vendor whose data deviates from your standard. The conversion table grows steadily — plan periodic cleanup.
Always fill Ranking on Certificate Types if you want to use Check Ranking Cert. Sales. Class 3.2 = higher ranking than 3.1 = higher than 2.2.
Common errors
|
Message |
Cause |
|---|---|
|
"Certificate type with ranking %1 already exists." |
Two certificate types can't share the same ranking. |
[Screenshot: Conversions page with multiple conversion types and mappings]