Versions Compared

Version Old Version 1 New Version Current
Changes made by

Daniela Ludwig

Daniela Ludwig

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Interface recommendation for basic data

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

Version history

Version 910.0 from 07.01.02.20232025

Changes to version 89.0 of the DG -Haustechnik Building Services data recommendation.

Definition of article type variants clarified
Note added as to when an article type may be changed

  • Article type “Package/SET” (PAK) is now referred to as article type “SET” (PAK)Addition of mandatory field "Data supplier ID type" in fields in the header data with the possible values:

    • duns

    • gln

    • opendatacheck_shk

    • buildingmasterdata_shk

      Addition of the text field "Notes on data delivery" with up to 1000 characters of formatted text including HTML formatting

  • Definition for the permitted use of GTIN numbers added

  • Expiry date should be one year in the past in relation to the start of validity date in the header data before an article deletion instead of "one year in the past in relation to the processing time" as in DQR 8

  • Multiple entries of series per article are possible for series.

  • Dimensions in basic packaging and PU 1 to PU 5 are redefined from dimension a,b,c to dimension length,width,height

  • Note on permissible use of data from different ETIM versions added to DQR 8 and 9

  • Information on the permissibility of multiple usability of attributes of a type on an article in Regulations added

  • For article sets and logistical sets, changes to these sets (e.g. deletion articles, article number changes in the set, etc.) are not permitted.

  • The maximum length for media file names increases from 35 to 256 characters

    If several media of the same document type are assigned to the same article or historical product, the specification of a unique sort sequence is mandatory for all assignments of this document type to the article.

    For article sets (PAK), image data is now conditionally mandatory instead of optional as in DQR 8

    Maximum permitted size for images for image use Web increases from 640 x 480 pixels to 1920 x 1080 pixels.
    New document type Sustainability certificate (NZ) added

    • Version number is a constant value ‘10.0’

    • Postal address

    • Electronic address

  • Addition of further fields in the header data:

    • URL Spare parts system

    • Description of spare parts system

  • Extended exceptions for article type changes :

    • Standard article (STD) for spare parts (ERA, ERB and ERC)

    • Standard article (STD) for logistics set (LOS)

    • Standard article (STD) to package (PSK)

  • Specification of the content of the model number.

  • New document types :

    • EPD sustainability certificate = ‘EPD’

    • QNG seal = ‘QNG’

    • Contract form = ‘VF’

  • When using the document types ‘KB’ and ‘BF’, it is no longer possible to store files.

  • For images, the sorting sequence is used across the usage.

  • It is mandatory to store a safety data sheet (SDS) if the articles contain information on hazardous goods and hazardous substances.

  • The permitted characters for usage instructions have been extended from 512 to 10,000 characters.

  • There is a new group type ‘ZG’ accessory groups. This is defined in the article attributes of the individual articles and the attribute value2 enables a sort order.

  • The article attributes are updated to ETIM version 10, while ETIM version 7 is no longer applicable.

  • The dangerous goods attribute class is extended by two points:

    • Kemler number/hazard number to indicate the main and secondary hazard.

    • Battery weight for the kilogram specification with nominal energy of over 100Eh.

  • Two new features have been added to the attribute classes:

    • GPSR with the attribute names Postal address and Electronic address.

    • EPD with the attribute name Declaration number.

  • In addition, the information from the safety data sheet is omitted if several have been assigned to one plant article number.

Handout with changes in the DQR

9

10.0

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

View file
nameÄnderungen in der DQR9Handout_Änderungen zur DQR 10.pdf

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.

Child pages (Children Display)
alltrue