Spalte

Format

Beschreibung

Anmerkungen

Pflicht

manufacturer_ID

String 35 

Manufacturer ID

Serves to uniquely identify the manufacturer. The ID is assigned by the VGH and can be requested there by the respective suppliers.

Yes

manufacturers_name

String 20 

Manufacturer short name

Specification of the company name in brief

-

brand_name

String 50 

Brand name

Name of the specific brand

-

manufacturer_GLN

String 13 

Manufacturer GLN

Companies can use the GLN (Global Location Number) for global identification of the entire company or works description as well as the address.

-

data_delivery_update

Boolean
true/false 

Type of data delivery

Specifies whether the data delivery is an update. If the entry is given with "no" it follows that it is a total stock.

Yes

catalogue_name

String 35 

Catalogue name

Descriptive name of the data delivery and thus of the catalog

-

data_delivery_country

String 2 

code set country 

Target country

Indication for which country this data delivery is valid
(one delivery per country is required) (ISO 3166-1 alpha-2 codes)

Yes

data_delivery_language

String 2 

code set language 

Language

Language of data delivery and in particular of the texts contained therein (ISO 639-1 codes)

Yes

start_of_validity

Date 

(DDMMYYYY) 

Validity (from) of the catalog of data delivery

The start of validity indicates the date from which the catalog should be valid.

Yes

end_of_validity

Date 

(DDMMYYYY) 

Validity (until) of the catalog of data delivery

The end of validity indicates when the catalog should be valid in total. If not specified, the validity will be up to a new data delivery

-

Spalte

Format

Beschreibung

Anmerkungen

Pflicht

factory_article_number

String 30 

Unique article number

Consisting of figures and letters, without spaces and special characters; example: JKS300620112

The factory article number is the central key identifier and is issued to enable unique (re-)identification of an article. It must clearly identify the article across all sub-ranges, catalogues and variants and is issued by the company ex works.

Yes

suppliers_gtin

GTIN 

GTIN (EAN) supplier

If the supplier uses GTINs, these should be supplied for all articles.

No

manufacturers_gtin

GTIN 

GTIN (EAN) manufacturer

In the case of an item that the supplier purchases from another manufacturer and this manufacturer uses the GTIN, it should be delivered consistently for all items.

-

short_text

String 70 

Short text for a clear description of the article

The short text is needed for the most unambiguous description of an article in business processes. This is especially true for the further use of the short text without revision in downstream systems and for example in offers, orders, delivery notes, shops or invoices.

It contains a clear, readable, understandable and product-related description of an article.

Text duplicates should always be avoided.

-

short_text_en

String 70 

Short text for a clear description of the article, additional in english

-

alternative_article

String 35 

Article number of the alternative article

Alternative articles are articles that resemble the original article and can be used in its place. Alternative articles must therefore be available in the product range.

-

discontinuation_date

Date
(DDMMYYYY) 

Date of discontinuation

Specification of an expiry date

-

follow-up_article_number_1

String 30 

Article number of the first follow-up article

If there is a follow-up article for a discontinued product, this will be marked accordingly and the article number of the successor article will be required. If required, up to three follow-up articles can be specified. Follow-up articles must also be present in the assortment.

-

follow-up_article_number_2

String 30

Article number of the second follow-up article

-

follow-up_article_number_3

String 30

Article number of the third follow-up article

-

deep_link_URL

String 200 

Specification of deep link URL

The specification of a deep link (URL) is an addition and links to the corresponding web page of the supplier where further information about the article may be found.

Note that a system modification will also entail an update of the data sets.

-

energy_efficiency_category

Code set 

Energy efficiency class 

Specification of an energy efficiency category from A+++ to G in accordance with the EU regulation

Energy efficiency is a measure of the energy a product requires. It is stated on the energy label.

When the article is subject to the ERP (Energy-Related Product) directive and possesses an energy efficiency class, specification of the following information is recommended in the interests of enhanced data quality.

Specification of an energy efficiency category requires an additional datasheet and a label as a document.

-

series

String 50 

Article series

Series name of the article if applicable

-

variation

String 50 

Article variation

Subtype of the article within the series name if applicable

-

factory_list_price_value

Decimal 18,2 

Factory list price of the supplier

The specification 0 of a factory list price is inadmissible

Yes

factory_list_price_currency

Code set 

Currency 

Specification of currency in which the price is stated

Yes

factory_list_price_basis

Integer 9 

Quantity of the article on which the price is based

Yes

factory_list_price_price_quantityunit

Code set 

Units of measure 

Unit of quantity of the article on which the price is based

Yes

value_added_tax

Decimal 2,2 

VAT rate of the article

VAT of the article in percent

No

RRP_price_value

Decimal 18,2 

Suggested retail price

-

RRP_currency

Code set 

Currency 

Specification of currency in which price is stated

If an RRP is used, specification of the currency is mandatory.

Conditional

RRP_price_basis

Integer 9 

Quantity of the article on which the price is based

If an RRP is used, specification of the price basis is mandatory.

Conditional

RRP_quantityunit

Code set 

Units of measure 

Unit of quantity of the article on which the price is based e.g.: piece, set, litre, kilogramme

If an RRP is used, specification of the price quantity unit is mandatory.

Conditional

commodity_group_ID

String 3 

ID of commodity group 

The commodity group assigns the article to a specific group in the context of the usage

-

commodity_group_description

String 40 

description of commodity group

Conditional

product_group_ID

String 10 

ID of product group

The product group organizes the article in terms of, for example, brand names, series names, or model names. The product group is not mandatory if a net price is used.

Conditional

product_group_description

String 40 

description of product group

Conditional

discount_group_ID

String 4 

ID of discount group

Discount groups allow articles to be assigned possible conditions. Thereby only one grouping and no concrete information or values are transmitted. The discount group is not mandatory if a net price is used.

Conditional

discount_group_description

String 40 

description of discount group

Conditional

bonus_group_ID

String 35 

ID of bonus group

Bonus groups allow articles to be assigned possible conditions. Thereby only one grouping and no concrete information or values are transmitted

-

bonus_group_description

String 40 

description of bonus group

Conditional

measure_A

Decimal 16,3 

Dimension A of packaged basic article incl. packaging

-

measure_A_unit

Code set 

Units of measure 

Conditional

measure_B

Decimal 16,3 

Dimension B of packaged basic article incl. packaging

-

measure_B_unit

Code set 

Units of measure 

Conditional

measure_C

Decimal 16,3 

Dimension C of packaged basic article incl. packaging

-

measure_C_unit

Code set 

Units of measure 

Conditional

weight

Decimal 18,3 

Specification of weight of packaged basic article incl. packaging

-

weight_unit

Code set 

Units of measure 

Conditional

weight_net

Decimal 18,3 

Specification of weight of basic article

-

weight_net_unit

Code set 

Units of measure 

Conditional

packaging_quantity

Integer 8 

Number of packages

Indication of the quantity of packages that make up the basic article

-

min_order_quantity

Decimal 15,3 

Minimum order quantity

The minimum order quantity of an item includes the smallest orderable quantity of an item

Yes

min_order_unit

Code set 

Units of measure 

Minimum order unit

Unit of the smallest orderable quantity of an item. The unit of the basic article is equal to the minimum order unit

Yes

commodity_number

Integer 8 

Commodity code

Commodity code required for customs (import / export) and Intrastat reporting

No

country_of_origin

Code set 

Country 

Country of origin

The country in which the article was produced or the last essential part of the processing was performed

Yes

standard_delivery_period

Integer 8 

Standard delivery time in working days

Indication of an average delivery time of the article, calculated in working days. Basis are the expected days until the goods are in the warehouse of the wholesaler.

Yes

durability_period

Integer 2 

Indicate the shelf life in months

Specifying a shelf life is useful for products. Especially if they are limited in their function after a certain time or can no longer be used (eg self-adhesive pipe insulation). The indication 99 means indefinitely. If it is used possible value is from 1 up to 99.

-

warranty_period

Integer 3 

Period of warranty

Period of guarantee acceptance by the supplier, stated in months

-

hazardous_material

Boolean 

Labeling dangerous goods

Dangerous goods must be marked as such

Yes

un_number

String 35 

UN number

UN number of the dangerous goods

Conditional

danger_class

String 35 

danger class

Specification of danger class

Conditional

carriage_category

Code set

Carriage Category 

Carriage category

If an article is classified as hazardous material, additional information about the carriage category is mandatory.

Conditional

reach_label

Codelist 

REACH 

Labelling REACH-list

Products containing substances of very high concern (SVHC) according to the REACH Regulation must be labeled as such

Yes

reach_list_date

Date 

(DDMMYYYY) 

Date of REACH list

If the REACH label field is marked with true or false, this is mandatory.

Conditional

rohs_

Boolean 

Conformity RoHS

EU Directive 2011/65 / EU restricts the use of certain hazardous substances in electrical and electronic equipment. It regulates the use and marketing of hazardous substances in electrical appliances and electronic components. Both guidelines are unofficially abbreviated RoHS (Restriction of hazardous substances).

-

component_elec

Boolean 

Electrical components

Article contains electrical / electronic components

-

component_rigid

Boolean 

Rigid components

Article contains rigid components longer than 50 cm

-

battery

Boolean 

Included battery

Article contains an included battery

-

battery_weight

Decimal 18,3 

Weight of the included battery

If an item contains a battery, the weight of that item must be specified in kg

Conditional

weee_category

Code set WEEE 

Category WEEE

Specification of WEEE category (Waste Electrical and Electronic Equipment), if applicable

-

packaging_unit_1_packaging_type

Code set
Package kind 

Definition of the type of packaging of packaging unit

When packaging units are defined, specification of the packaging type is

Optional

packaging_unit_1_quantity

Decimal 18,3 

Number of basic articles included in packaging unit

If packaging units for articles are deposited, the indication of the respective quantity is

Conditional

packaging_unit_1_GTIN

GTIN Format 

GTIN for packaging unit

-

packaging_unit_1_measure_A

Decimal 18,3 

Dimension A of packaging unit

-

packaging_unit_1_measure_A_unit

Code set
Units of measure 

Unit of dimension A of packaging unit

Conditional

packaging_unit_1_measure_B

Decimal 18,3 

Dimension B of packaging unit

-

packaging_unit_1_measure_B_unit

Code set
Units of measure 

Unit of dimension B of packaging unit

Conditional

packaging_unit_1_measure_C

Decimal 18,3 

Dimension C of packaging unit

-

packaging_unit_1_measure_C_unit

Code set
Units of measure 

Unit of dimension C of packaging unit

Conditional

packaging_unit_1_weight

Decimal 18,3 

Weight of packaging unit

-

packaging_unit_1_weight_unit

Code set
Units of measure 

Unit of weight of packaging unit

Conditional

packaging_unit_2_packaging_type

Code set
Package kind 

Definition of the type of packaging of packaging unit

Optional

packaging_unit_2_quantity

Decimal 18,3 

Number of basic articles included in packaging unit

Conditional

packaging_unit_2_GTIN

GTIN Format 

GTIN for packaging unit

-

packaging_unit_2_measure_A

Decimal 18,3 

Dimension A of packaging unit

-

packaging_unit_2_measure_A_unit

Code set
Units of measure 

Unit of dimension A of packaging unit

Conditional

packaging_unit_2_measure_B

Decimal 18,3 

Dimension B of packaging unit

-

packaging_unit_2_measure_B_unit

Code set
Units of measure 

Unit of dimension B of packaging unit

Conditional

packaging_unit_2_measure_C

Decimal 18,3 

Dimension C of packaging unit

-

packaging_unit_2_measure_C_unit

Code set
Units of measure 

Unit of dimension C of packaging unit

Conditional

packaging_unit_2_weight

Decimal 18,3 

Weight of packaging unit

-

packaging_unit_2_weight_unit

Code set
Units of measure 

Unit of weight of packaging unit

Conditional

packaging_unit_3_packaging_type

Code set
Package kind 

Definition of the type of packaging of packaging unit

Optional

packaging_unit_3_quantity

Decimal 18,3 

Number of basic articles included in packaging unit

Conditional

packaging_unit_3_GTIN

GTIN Format 

GTIN for packaging unit

-

packaging_unit_3_measure_A

Decimal 18,3 

Dimension A of packaging unit

-

packaging_unit_3_measure_A_unit

Code set
Units of measure 

Unit of dimension A of packaging unit

Conditional

packaging_unit_3_measure_B

Decimal 18,3 

Dimension B of packaging unit

-

packaging_unit_3_measure_B_unit

Code set
Units of measure 

Unit of dimension B of packaging unit

Conditional

packaging_unit_3_measure_C

Decimal 18,3 

Dimension C of packaging unit

-

packaging_unit_3_measure_C_unit

Code set
Units of measure 

Unit of dimension C of packaging unit

Conditional

packaging_unit_3_weight

Decimal 18,3 

Weight of packaging unit

-

packaging_unit_3_weight_unit

Code set
Units of measure 

Unit of weight of packaging unit

Conditional

packaging_unit_4_packaging_type

Code set
Package kind 

Definition of the type of packaging of packaging unit

Optional

packaging_unit_4_quantity

Decimal 18,3 

Number of basic articles included in packaging unit

Conditional

packaging_unit_4_GTIN

GTIN Format 

GTIN for packaging unit

-

packaging_unit_4_measure_A

Decimal 18,3 

Dimension A of packaging unit

-

packaging_unit_4_measure_A_unit

Code set
Units of measure 

Unit of dimension A of packaging unit

Conditional

packaging_unit_4_measure_B

Decimal 18,3 

Dimension B of packaging unit

-

packaging_unit_4_measure_B_unit

Code set
Units of measure 

Unit of dimension B of packaging unit

Conditional

packaging_unit_4_measure_C

Decimal 18,3 

Dimension C of packaging unit

--

packaging_unit_4_measure_C_unit

Code set
Units of measure 

Unit of dimension C of packaging unit

Conditional

packaging_unit_4_weight

Decimal 18,3 

Weight of packaging unit

packaging_unit_4_weight_unit

Code set
Units of measure 

Unit of weight of packaging unit

Conditional

packaging_unit_5_packaging_type

Code set
Package kind 

Definition of the type of packaging of packaging unit

Optional

packaging_unit_5_quantity

Decimal 18,3 

Number of basic articles included in packaging unit

Conditional

packaging_unit_5_GTIN

GTIN Format 

GTIN for packaging unit

-

packaging_unit_5_measure_A

Decimal 18,3 

Dimension A of packaging unit

-

packaging_unit_5_measure_A_unit

Code set
Units of measure 

Unit of dimension A of packaging unit

Conditional

packaging_unit_5_measure_B

Decimal 18,3 

Dimension B of packaging unit

--

packaging_unit_5_measure_B_unit

Code set
Units of measure 

Unit of dimension B of packaging unit

Conditional

packaging_unit_5_measure_C

Decimal 18,3 

Dimension C of packaging unit

packaging_unit_5_measure_C_unit

Code set
Units of measure 

Unit of dimension C of packaging unit

Conditional

packaging_unit_5_weight

Decimal 18,3 

Weight of packaging unit

-

packaging_unit_5_weight_unit

Code set
Units of measure 

Unit of weight of packaging unit

Conditional

Spalte

Typ

Beschreibung

Anmerkungen

Pflicht

factory_article_number

String 30 

Unique article number

Consisting of figures and letters, without spaces and special characters; example: JKS300620112

Yes

document

String 35 

Name of the document file

Yes

document_url

String 200 

URL of document

The specification of a link (URL) corresponding to web page for download document.

-

document_type

Code set 

Document type 

Specification of document type

If a document is assigned to an article, the specification of the document type is obligatory, as well as the other information that is marked as a conditional obligation.

Yes

image_use

Code set 

Picture use 

Categorization as web image or print image (only for images)

When an image is assigned to an article, image usage is “web” or “print”.

Conditional

substitute

Boolean 

Specification whether the article shown corresponds to the article or is a substitute

When a web image is assigned to an article, specification of the Substitute_ID is mandatory.

Conditional

document_description

String 40 

description of content of allocated document

-

document_sort_sequence

Integer 3 

Specification of a sequence for multiple documents

-

Spalte

Typ

Beschreibung

Anmerkungen

Pflicht

factory_article_number

String 30 

Unique article number

Consisting of figures and letters, without spaces and special characters; example: JKS300620112

Yes

article_short_description

String 256 

Brief description

Description of the article

-

article_description

String 10000 

Description

Description of the technical characteristics of an article. Within the text it is possible to specify formatting. Please consider the format requirements – formatted continuous text (5.)

-

marketing_description

String 10000 

Marketing description

User-oriented description of an article. Within the text it is possible to specify formatting. Please consider the format requirements – formatted continuous text (5.)

-

application_description

String 512 

Application description

Notes on processing techniques. Within the text it is possible to specify formatting. Please consider the format requirements – formatted continuous text (5.)

-

Spalte

Typ

Beschreibung

Anmerkungen

Pflicht

factory_article_number

String 30 

Unique article number

Consisting of figures and letters, without spaces and special characters; example: JKS300620112

Yes

attribute_system

Code set 

Attribute system 

Information on which system (ETIM, Heating Label, etc.) the attribute is based on. When table attributes are filled, the specification of the system is mandatory

Information on which system (ETIM, Heating Label, etc.) the attribute is based on. When table attributes are filled, the specification of the system is mandatory

Yes

attribute_class

String 60 

Depending on the system, a free class or with ETIM the ClassID. If table attributes are filled, the specification of the class is mandatory

Depending on the system, a free class or with ETIM the ClassID. If table attributes are filled, the specification of the class is mandatory

-

attribute_feature

String 60 

Depending on the system, a free attribute of the attribute or with ETIM AttributeID

Depending on the system, a free attribute of the attribute or with ETIM AttributeID

Yes

attribute_value

String 60 

Depending on the system, a free attribute of the attribute or with ETIM ValueID

Depending on the system, a free attribute of the attribute or with ETIM ValueID

Yes

attribute_value2

String 60 

Depending on the system, a free attribute of the attribute or with ETIM ValueID

Depending on the system, a free attribute of the attribute or with ETIM ValueID

-

attribute_unit

String 60 

Depending on the system and the value, the unit of value

Depending on the system and the value, the unit of value

-

Spalte

Typ

Beschreibung

Anmerkungen

Pflicht

factory_article_number

String 30

Unique article number

Consisting of figures and letters, without spaces and special characters; example: JKS300620112

Yes

PT_packaging_type

Code set 

Package type 

Type of packaging

Type of packaging  (plastic, cardboard box, steel, wood)

-

PT_packaging_weight

Decimal 18,3 

Weight of the empty package

Weight of the empty package specified in kg

-

Code

Name

Description

Art

B_

Coloured image

Image (black & white or colour) of a free-standing article (no back- ground)

Picture

S_

Black+white image

Image (black & white or colour) of a free-standing article (no back- ground)

Picture

U_

Undimensioned line drawing

Illustration of an article in a varyingly simplified manner using lines

Picture

V_

Dimensioned line drawing

Illustration of an article in a varyingly simplified manner using lines

Picture

X_

Exploded view drawing

An exploded view drawing (also known as exploded drawing, exploded image) is a way of presenting drawings and graphics that breaks down a complex object into its constituent parts (where relevant presented in perspective form). The individual parts or components of a product are spatially separated from one another and presented as if they have been pulled apart.

A document of the media type exploded view drawing can be assigned once per article.

Picture

MI

Scenario image

Image of an article in an application scenario e.g. bathroom

Picture

DT

Detailed image

View of an article in detail

Picture

KV

KeyVisual

Technical marketing term; describes an image element from advertisements that depicts the promoted article

Picture

LS

Lifestyle

Pictorial representation of a practically structured situation from everyday life

Picture

LO

Logos

Company and product logos

Picture

Code

Beschreibung

Art

2D

2D plan view

Document

2F

2D frontal view

Document

2S

2D side view

Document

3C

3D data

Document

3B

3D data

Document

3A

3D data for presentation in browser

Document

AN

Animation

Document

DB

Data sheet

Document

GG

Hazardous materials data sheet

Document

IS

Instructions/operating manual

Document

MA

Installation instructions

Document

TI

Technical info

Document

TZ

Technical drawing

Document

VI

Video

Document

WA

Maintenance instructions

Document

PA

Planning instructions

Document

PP

Brochures

Document

ZL

Approval

Document

SB

Circuit diagram

Document

SF

Training slide

Document

PF

Detailed image/view

Document

LE

Construction Products Directive

Document

EL

ErP label

Document

DC

Declaration of conformity

Document

UP

UBA positive list

Document

DOP

Declaration of performance

Document

VP

Product video

Document

VM

Installation video

Document

VT

Tutorial

Document

EP

Single prospect

Document

BS

Fire protection

Document

EX

Explosion protection

Document

AS

Occupational safety

Document

KS

Corrosion protection

Document

CE

CE-conformity declaration

Document

VD

VDS-license

Document

SS

Sound insulation requirements

Document

Code

Description

print

Image is suitable for printing

web

Image is suitable for web use

Code

Description

CMK

Square centimeter

CMQ

Cubic centimeter

CMT

Centimeter

DMT

Decimeter

DZN

Dozen

GRM

Gram

HLT

Hectoliter

KGM

Kilogram

KTM

Kilometer

LTR

Liter

MMT

Millimeter

MTK

Square meter

MTQ

Cubic meter

MTR

Meter

PCE

Piece

PR

Pair

SET

Set

TNE

Ton

FTK

Square foot

YDK

Square yard

FTQ

Cubic foot

YDQ

Cubic yard

DWT

Pennyweight, UK, USA (1.555174 g)

PTI

Pint (0.568262 dm)

LBR

Pound UK, USA (0,45359237 kg)

FOT

Foot (0,3048 m)

CNT

Cental UK (45,359237 kg)

YRD

Yard (0,9144 m)

Code

Description

BB

Coil

BG

Sack

BH

Bunch/bundle

BK

Basket

CF

Crate/Case

CG

Cage

CH

Skeleton box

CT

Cardboard box

PA

Packet

PC

Parcel

PG

Disposable pallet

PK

Package

PN

Euro pallet

PU

Case

RG

Ring

SC

Mixed pallet

HP

Half-pallet

TU

Tube

BTL

Bag

BX

Box

CO

Container

DY

Display

STG

Bar

TRO

Drum

PLA

Plate

CI

Jerrican

GEB

Package

Code

Description

PL

 Plastic

CB

Cardboard box

ST

Steel

WO

Wood

Code

Description

BAM

Convertible mark

BGN

Bulgarian Lev

CHF

Swiss franc

CZK

Czech koruna

DKK

Danish krone

EUR

Euro

GBP

Pound sterling

GEL

Lari

HRK

Kuna

KZT

Tenge

LTL

Litas

LVL

Lats

NOK

Norwegian krone

PLN

Zloty

RON

Romanian leu

RSD

Serbian dinar

RUB

Russian rouble

SEK

Swedish krona

USD

US Dollar

Code

Description

true

Article has been tested and is subject to the REACH Regulation

false

Article has been tested and is not subject to the REACH Regulation

no data

There are no REACH information available

Code

Description

A+++

A+++

A++

A++

A+

A+

B

B

C

C

D

D

E

E

F

F

G

G

Code

Description

0

Maximum total amount (in kg or liter) per transport unit:  0

1

Maximum total amount (in kg or liter) per transport unit:  20

2

Maximum total amount (in kg or liter) per transport unit:  333

3

Maximum total amount (in kg or liter) per transport unit:   1000

4

Maximum total amount (in kg or liter) per transport unit:   unlimited

Code

Description

ETIM 5.0

ETIM classification model 5.0

ETIM 6.0

ETIM classification model 6.0

ETIM 7.0

ETIM classification model 7.0

ETIM dyn

ETIM classification model dynamic

ERP 1.0

ErP Heating Label 1.0

ERP 1.15

ErP Heating Label 1.15

ERP 2.0

ErP Heating Label 2.0

ERP 2.3

ErP Heating Label 2.3

ERP 2.5

ErP Heating Label 2.5

INDIV

individual attributes

Code

Description

1

Large household appliances

2 

Small household appliances 

3

IT and telecommunications equipment

4 

Consumer equipment and photovoltaic panels

5

Lighting equipment

6

Electrical and electronic tools (with the exception of large-scale stationary industrial tools)

7

Toys, leisure and sports equipment

8

Medical devices (with the exception of all implanted and infected products)

9

Monitoring and control instruments

10 

Automatic dispensers