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 Article type | 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 Units | 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: | ||||
Discontinued Article (Auslaufartikel) Important! Observe the process for deletion |
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 Countries | 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 | Number of packages contained in the article | No | Integer 8 | 3 | Number of packages of the basic article. | Anzahl_Packstuecke | |
39 | VAT class of the article | Yes |
Codeliste Tax rates | 1 | The VAT class specified for the item. | Umsatzsteuerklasse | ||||
40 | Indication of the standard delivery time in days. This field is mandatory for standard items, spare part A, spare part B, variant and bulk. | Yes | Integer 8 | 2 | The value must be specified greater than "0". Calculated in 5 working days per week. | Standardlieferzeit | |
Price | |||||||
41 | Factory list price of the article | Yes | Decimal 15,2 | 3 | The factory list price must always be indicated. A value of "0" is only permissible if the article also costs 0 euros and this is recognizable analogously in the price list. If only one RRP is available, this must be supplied redundantly as the factory list price and as the RRP. Exception with custom-made products, a "price on request" can be indicated. | Werkslistenpreis_Preiswert | |
42 | Price currency Note: Mandatory information if a factory list price is specified as the price value. | No | Codelist Currency | 3 | Werkslistenpreis_Waehrung | ||
43 | Quantity of the item to which the price refers: Only the values 1,10,100,1000 are allowed. Note: Mandatory information if a factory list price is specified as the price value | No | Integer 9 | 3 | Werkslistenpreis_Preisbasis | ||
44 | Quantity unit of the item to which the price refers. Note: Mandatory information if a factory list price is specified as the price value | No | Codelist Units | 3 | Werkslistenpreis_Preismengeneinheit | ||
45 | RRP price without tax of the item | No | Decimal 15,2 | 5 | If only one RRP is available, it must be supplied redundantly as the factory list price and the RRP. | UVP_ohne_Steuer_Preiswert | |
46 | Currency | No | Codelist Currency | 3 | - | UVP_ohne_Steuer_Waehrung | |
47 | Quantity of the item to which the price refers: Only the values 1,10,100,1000 are allowed. | No | Integer 9 | 3 | - | UVP_ohne_Steuer_Preisbasis | |
48 | Quantity unit of the item to which the price refers. | No | Codelist Units | 3 | - | UVP_ohne_Steuer_Preismengeneinheit | |
Packaging units (PU) | |||||||
49 | Type of packing unit 1 (carton, basket,...) | No | Codelist Type of packaging | 3 | The specification is mandatory if a packaging unit exists for the article. | VPE_1_Verpackungsart | |
50 | Number of (basic) items contained in packaging unit 1 | No | Decimal 16,3 | 3 | The specification is mandatory if a packaging type ( PU 1) was previously specified. | VPE_1_Menge | |
51 | GTIN of packing unit 1 | No | GTIN | 3 | VPE_1_GTIN | ||
52 | Length of packaging unit 1 in mm | No | Number between 0.001 and 20000 with max. 3 decimal places | 3 | The specification is mandatory if a packaging type ( PU 1) was previously specified. | VPE_1_Mass_A_mm | |
53 | Wide of packaging unit 1 in mm | No | Number between 0.001 and 20000 with max. 3 decimal places | 3 | see "Length" | VPE_1_Mass_B_mm | |
54 | Height of packaging unit 1 in mm | No | Number between 0.001 and 20000 with max. 3 decimal places | 3 | see "Length" | VPE_1_Mass_C_mm | |
55 | Weight of packing unit 1 in kg | No | Number between 0.001 and 15000 with max. 3 decimal places | 3 | The specification is mandatory if a packaging type ( PU 1) was previously specified. | VPE_1_Gewicht_kg | |
56 | Type of packing unit 2 (carton, basket,...) | No | |||||
Codelist Type of packaging | 3 | The specification is mandatory if a packaging unit exists for the article. | VPE_2_Verpackungsart | ||||
57 | Number of (basic) items contained in packaging unit 2 | No | Decimal 16,3 | 3 | The specification is mandatory if a packaging type ( PU 2) was previously specified. | VPE_2_Menge | |
58 | GTIN of packing unit 2 | No | GTIN | 3 | - | VPE_2_GTIN | |
59 | Length of packaging unit 2 in mm | No | Number between 0.001 and 20000 with max. 3 decimal places | 3 | The specification is mandatory if a packaging type ( PU 2) was previously specified. | VPE_2_Mass_A_mm | |
60 | Wide of packaging unit 2 in mm | No | Number between 0.001 and 20000 with max. 3 decimal places | 3 | see "Length" | VPE_2_Mass_B_mm | |
61 | Height of packaging unit 2 in mm | No | Number between 0.001 and 20000 with max. 3 decimal places | 3 | see "Length" | VPE_2_Mass_C_mm | |
62 | Weight of packing unit 2 in kg | No | Number between 0.001 and 15000 with max. 3 decimal places | 3 | The specification is mandatory if a packaging type ( PU 2) was previously specified. | VPE_2_Gewicht_kg | |
63 | Type of packing unit 3 (carton, basket,...) | No |
Codelist Type of packaging | 3 | The specification is mandatory if a packaging unit exists for the article. | VPE_3_Verpackungsart | ||||
64 | Number of (basic) items contained in packaging unit 3 | No | Decimal 16,3 | 1* | The specification is mandatory if a packaging type ( PU 3) was previously specified. | VPE_3_Menge | |
65 | GTIN of packing unit 3 | No | GTIN | 3 | - | VPE_3_GTIN | |
66 | Length of packaging unit 3 in mm | No | Number between 0.001 and 20000 with max. 3 decimal places | 3 | The specification is mandatory if a packaging type ( PU 3) was previously specified. | VPE_3_Mass_A_mm | |
67 | Wide of packaging unit 3 in mm | No | Number between 0.001 and 20000 with max. 3 decimal places | 3 | see "Length" | VPE_3_Mass_B_mm | |
68 | Height of packaging unit 3 in mm | No | Number between 0.001 and 20000 with max. 3 decimal places | 3 | see "Length" | VPE_3_Mass_C_mm | |
69 | Weight of packing unit 3 in kg | No | Number between 0.001 and 15000 with max. 3 decimal places | 3 | The specification is mandatory if a packaging type ( PU 3) was previously specified. | VPE_3_Gewicht_kg | |
70 | Type of packing unit 4 (carton, basket,...) | No |
Codelist Type of packaging | 3 | The specification is mandatory if a packaging unit exists for the article. | VPE_4_Verpackungsart | ||||
71 | Number of (basic) items contained in packaging unit 4 | No | Decimal 16,3 | 3 | The specification is mandatory if a packaging type ( PU 4) was previously specified. | VPE_4_Menge | |
72 | GTIN of packing unit 4 | No | GTIN | 3 | - | VPE_4_GTIN | |
73 | Length of packaging unit 4 in mm | No | Number between 0.001 and 20000 with max. 3 decimal places | 3 | The specification is mandatory if a packaging type ( PU 4) was previously specified. | VPE_4_Mass_A_mm | |
74 | Wide of packaging unit 4 in mm | No | Number between 0.001 and 20000 with max. 3 decimal places | 3 | see "Length" | VPE_4_Mass_B_mm | |
75 | Height of packaging unit 4 in mm | No | Number between 0.001 and 20000 with max. 3 decimal places | 3 | see "Length" | VPE_4_Mass_C_mm | |
76 | Weight of packing unit 4 in kg | No | Number between 0.001 and 15000 with max. 3 decimal places | 3 | The specification is mandatory if a packaging type ( PU 4) was previously specified. | VPE_4_Gewicht_kg | |
77 | Type of packing unit 5 (carton, basket,...) | No |
Codelist Type of packaging | 3 | The specification is mandatory if a packaging unit exists for the article. | VPE_5_Verpackungsart | ||||
78 | Number of (basic) items contained in packaging unit 5 | No | Decimal 16,3 | 3 | The specification is mandatory if a packaging type ( PU 5) was previously specified. | VPE_5_Menge | |
79 | GTIN of packing unit 5 | No | GTIN | 3 | VPE_5_GTIN | ||
80 | Length of packaging unit 5 in mm | No | Number between 0.001 and 20000 with max. 3 decimal places | 3 | The specification is mandatory if a packaging type ( PU 5) was previously specified. | VPE_5_Mass_A_mm | |
81 | Wide of packaging unit 5 in mm | No | Number between 0.001 and 20000 with max. 3 decimal places | 3 | see "Length" | VPE_5_Mass_B_mm | |
82 | Height of packaging unit 5 in mm | No | Number between 0.001 and 20000 with max. 3 decimal places | 3 | see "Length" | VPE_5_Mass_C_mm | |
83 | Weight of packing unit 5 in kg | No | Number between 0.001 and 15000 with max. 3 decimal places | 3 | The specification is mandatory if a packaging type ( PU 5) was previously specified. | VPE_5_Gewicht_kg | |
84 | Specify with <true> or <false>. | No | Boolean: true/false | 2 | Articles that are no longer distributed by the manufacturer should be provided with a deletion indicator at least once. | Loeschkennzeichen | |
85 | Indication of the quantity in the content unit related to the order unit. | No | Decimal 16,3 | 5 | Inhaltsmenge | ||
86 | Content unit | No | Codelist Units: |
5 | Inhaltseinheit |