Interface recommendation for basic data

The interface recommendation of the DG-Haustechnik for DQR 11.0 maps the content, structural and qualitative requirements for the article master data of the German HVAC industry. The guideline is based on the joint DQR 11.0 of the SHK industry.

Version history

Version 10.0 from 07.01.2025

Changes to version 10.0 of the DG Building Services data recommendation.

Introduction of new, optional content for product launches
Cannot be ordered before (date)
Not available before (date)
No marketing before (date)
Add an exception for the deletion of item sets and logistics sets
Item sets and logistics sets may be removed or deleted immediately upon reaching the expiration date
Rule for changing the components of logistics sets
Inclusion of the stipulation that deleted items may not be reactivated
Enable cross-catalog referencing of items by including the manufacturer identification in all references.
Alternative items, accessories, successor items, replacement parts, set items, and packages in logistics sets
Add the option to mark items as accessories
Include ETIM classification 11 and remove ETIM classification 8
Define a default value when no ETIM class exists
Include the EPREL registration number in the attributes
Include the Deforestation Regulation (EUDR)
Include the Regulation on Connected Products (EU Data Act)
Tagging via attributes and a new document type (EDA) to provide additional information
Improvement of the description of raw material surcharges in the plant list price
Limit the standard delivery time in days to 3 digits
Adjust the sort order for images
This does not need to be consistent across all uses.
Include the SVG format with restrictions on the use of non-static content
Expand the possible packaging units to include Wrapped (WRP) and Envelope (EN)

Handout with changes in the DQR 11.0

In the following handout you will find all the changes made to DQR 11.0 (the handout is in german):

Videos Featuring New Features in DQR 11.0

Click the link below to view the playlist of explanatory videos on the new features of DQR 11.0 (the video is in german): https://www.youtube.com/watch?v=bonLg_m1cj8

Technical framework conditions

The following requirements apply to all files:

Character set		UTF-8
Allowed character set	Alphanumeric characters:	A-Z, a-z, 0-9
	Umlauts:	ÄäÜüÖöß
	Special characters:	!"#$%&'()*+,-./:<=>?@^_`§
	Spaces
Allowed number of characters and formatting for optional article texts: (Article short description, article description, marketing text, usage note)	U0020 – U007F Latin Basic without control characters U00A0 – U00FF Latin-1 Supplement without control characters U0100 – U017F Latin Extended-A U0370 – U03FF Greek, Coptic U0400 – U04FF Cyrillic U000A Line feed U000D Line feed U2200 - U22FF Mathematical characters U2300 Diameter characters Formatting: Paragraph, Line Break <p>, <br> Bold, Italic, Underlined <b>, <strong>, <i>, <u> Ordered and Unordered List <ol>, <ul>, <li> Font Sizes (Headline) <h1>, <h2>, <h3>, <h4>
Line separator	CR LF (0D 0A)
Field separator	Semicolon ( ; )
Text isolation character/masking character	quotation marks ( " )
Decimal separator	Comma (,)
Thousands separator	Not used
Date format	DDMMYYYYY (31122012) (valid range: 01011900-31122099)
Logical content	„true" / „false"
GTIN (EAN)	13 or 14 digits Numeric with valid check digit
Code lists	See individual chapters
Headerline	Each file must contain a header line

Definition and verification of data quality

In order to achieve uniform data quality, requirements are placed on the structure and content of the individual data contents. The following quality categories apply when evaluating the content:

Quality category	Rating
1	Quality category 1 - technically required These contents are necessary solely from a technical perspective to process a master data record (e.g., article number).
1*	*Quality category 1 - technically required when utilized** Those content comprises various detailed pieces of information. Starting with the first detail information may necessitate additional details. For example, a price entry consists of the actual value, i.e., the price, as well as the additional necessary information such as price type, currency, price basis, and price unit.
2	Quality category 2 - mandatory quality criterion These are contents that, from a purely technical perspective, are not mandatory, such as an article number, but are indeed mandatory from a content perspective. For example, in cross-border trade, the commodity code is required for customs and Intrastat reporting.
3	Quality category 3 - conditional mandatory quality criterion A condition such as a product characteristic leads to the need for certain additional information. The property that a product is a dangerous good means that additional information such as the UN number, the hazard class or the transport category must be provided. Another condition for the mandatory provision of data content is the use in publications, e.g. print media or the Internet, if these are publicly accessible documents.
4	Quality category 4 - supplementary quality criterion for good data quality By providing information such as the definition of accessory lists for an article, a service can be delivered to our own customers. This is a content with which a quality standard for the data is met, thus achieving a quality criterion.
5	Quality category 5 - optional The data additionally includes content that further enhances the quality, such as URLs to additional item information or documents like assembly or maintenance manuals.