Artikeldaten DQR 10.0 (Article Data)
The basic data in the article table is transferred for an article. Details that can occur several times per article (e.g. document assignments) are mapped in article details in the following details.
No. | Content | Description | Obligation | Format | Quality category | Additional information | Column heading |
|---|---|---|---|---|---|---|---|
1 | Article number | Yes | String 15 | 1 | Article number to identify the article within the catalog. | Werksartikelnummer | |
2 | GTIN (EAN) | No | GTIN | 13 or 14 digits | GTIN is alternatively used to identify the article within the catalog. | GTIN | |
3 | Type of the article | Yes | Codelist https://itek-branchenwissen.atlassian.net/wiki/x/_oJbY | 1 | Specific quality requirements are determined by the article type. | Artikeltyp | |
4 | Start of validity | Yes | Date | 1 | Time from which the data for the item is/will be valid. | Gueltigkeitsbeginn | |
5 | End of validity | No | Date | 5 |
| Gueltigkeitsende | |
6 | Article short text 1 | Yes | String 40 | 1 | - | Kurztext_1 | |
7 | Article short text 2 | No | String 40 | 5 | - | Kurztext_2 | |
8 | ID of the commodity group | Yes | String 3 | 2 | If the manufacturer uses commodity groups, this information must be provided. | Warengruppen_ID | |
9 | ID of the product group | Yes | String 10 | 2 | If the manufacturer uses product groups, this information must be provided. | Produktgruppen_ID | |
10 | ID of the discount group | Yes | String 4 | 2 | If the manufacturer uses discount groups, this information must be provided. | Rabattgruppen_ID | |
11 | ID of the bonus group | Yes | String 35 | 3 | If the manufacturer uses discount groups in his calculation structures, the transfer is obligatory. | Bonusgruppen_ID | |
12 | Minimum order quantity | Yes | Decimal 16,3 | 1 | Minimum order quantity (the minimum order quantity must be greater than 0) | MinBestellmenge | |
13 | Minimum order quantity unit | Yes | Codelist https://itek-branchenwissen.atlassian.net/wiki/x/t4NbY | 1 | - | MinBestellmengeEinheit | |
14 | Article number catalogue (Print) | No | String 35 | 5 | If a factory article number is used in price lists, which has been supplemented by filler characters (blanks, dots or dashes), this must be transferred. | Werksartikelnummer_Katalog | |
15 | Article number of the alternative article | No | String 15 | 3 | Article number of an alternative article. | Alternativartikel | |
Specifying the successor articles. Up to three successor articles can be specified. | |||||||
16 | Article number of a successor article_1 | No | String 15 | 3 | The article must exist in the data delivery. The specification is mandatory if the article is a discontinued article ("Yes, with successor). The specification may only be supplied if the article is a discontinued article ("Yes, with successor). | Nachfolgeartikelnummer_1 | |
17 | Article number of a successor article_2 | No | String 15 | 5 | See successor article number 1 | Nachfolgeartikelnummer_2 | |
18 | Article number of a successor article_3 | No | String 15 | 5 | See successor article number 1 | Nachfolgeartikelnummer_3 | |
19 | Reference to the long text | No | String 8 | 3 | The long text must be contained in the long texts worksheet (exception for spare parts contained in spare parts lists). | Langtextnummer | |
20 | URL of a web page to call up further article information. Example: http://www.hersteller.de/artike/4711211 | No | String 256 (Text) | 5 | The URL must be a valid URL to the detailed information of the article. | URL | |
21 | Discontinued article indication Yes / No / Yes, with successor article | Yes | Codeliste Discontinued: Important! Observe the process for deletion Deletion of articles | 1 | If the discontinuation indication is given with "Yes" or "Yes-Successor", the indication of the discontinuation date is mandatory. If the discontinuation indicator is specified with "Yes-Successor", the specification of a successor article is mandatory. | Auslaufartikel | |
22 | Expected expiration date | No | Date | 3 | The indication is mandatory if the article is a discontinued article (discontinued article="Yes" or "Yes-Successor"). | Auslaufdatum | |
23 | Reference to the spare parts list | No | String 35 | 5 | The spare parts list must be defined. | Ersatzteillistennummer | |
Year of manufacture Production periods can be specified for all articles from the range. | |||||||
24 | Start of the production period | No | Date 21062016 | 5 | - | Baujahr_von | |
25 | End of the production period | No | Date 21062016 | 5 | - | Baujahr_bis | |
26 | Notes / remarks on the years of manufacture | No | String 15 | 5 | - | Baujahr_Text | |
27 | Indication whether an article is exportable | Yes | Boolean | 2 |
| Exportfaehig | |
28 | Commodity number for use within Intrastad and Customs declarations. | No | Integer 8 | 3 | Not applicable for services and software. | Warennummer | |
29 | Indication of the country of origin of the article | No | Codelist https://itek-branchenwissen.atlassian.net/wiki/x/JINbY | 3 | Not applicable for services and software. | Ursprungsland | |
30 | Shelf life of the article in months. | Yes | Integer 1-99 | 1 | If shelf life is unlimited, "99" must be specified. The specification of a shelf life does not make any statements about warranty claims and does not take into account any information about possible intermediate storage at the manufacturer. | Haltbarkeitszeitraum | |
31 | Name of the associated product series | No | String 1000 | 5 | Specification of several series possible. These are separated by a comma. | Serie | |
32 | Model number of the article | No | String 15 | 5 |
| Modellnummer | |
33 | Indicator whether the item is subject to a price on request | Yes | Boolean | 1 | Can only be used for the article types software / services and custom-made products. | Preis_auf_Anfrage | |
34 | Length of the packaged basic article in mm | No | Number between 0.001 and 20000 with max. 3 decimal places | 3 | Exception only for article types services and custom-made products, as well as for articles that are invoiced per length, area, volume or weight or whose number of packages is not equal to "1". The specification is always in mm. | Mass_A_mm | |
35 | Wide of the packaged basic article in mm | No | Number between 0.001 and 20000 with max. 3 decimal places | 3 | see "Length" | Mass_B_mm | |
36 | Height of the packaged basic article in mm | No | Number between 0.001 and 20000 with max. 3 decimal places | 3 | see "Length" | Mass_C_mm | |
37 | Weight of the article in kg. | No | Number between 0.001 and 15000 with max. 3 decimal places | 3 | Exception only for article types services and custom-made products, as well as for articles that are invoiced per length, area, volume or weight or whose number of packages is not equal to "1". The specification is always in kg | Gewicht_kg | |
38 | |||||||