NameDescriptionTypeAdditional information
Display

Display number for the display

string

None.

MPNr

Auto value (primary index) of the table MV_Menueplan

integer

None.

MBNr

Auto value (primary index) of the table MV_MenueBez --> menu line

integer

None.

GNr

Auto value (primary index) of the table MV_MenueGang --> menu component

integer

None.

K_NameKarte

Name of the component (e.g. main course)

string

None.

K_Artikel

Name of the item being sold (e.g.: smoked pork loin)

string

None.

K_Zucker

Sugar in mg of the component

string

None.

K_Kochsalz

Table salt in mg of the component

string

None.

K_FettGesaettigt

saturated fatty acids in mg of the component

string

None.

K_EnergieKC

Energy in kilocalories of the component

string

None.

K_EnergieKJ

Energy in kilojoules of the component

string

None.

K_Eiweiss

Protein in mg of component

string

None.

K_Kohlenhydrate

Carbohydrates in mg of component

string

None.

K_Fett

Fat in mg of component

string

None.

K_Allergene

Allergens of the component

string

None.

K_Inhaltsstoffe

Ingredients of the component

string

None.

K_verwertbaresGewicht

usable weight of the component

string

None.

Bild1

Image 1 of the component

string

None.

Bild2

Image 2 of the component

string

None.

Bild3

Image 3 of the component

string

None.

Bild4

Image 4 of the component

string

None.

Bild5

Image 5 of the component

string

None.

NW100G

Comes from the settings in the diet management, if -1 here then the nutritional values ​​are again valid for 100 grams

string

None.

K_Symbol

menu component symbol

string

None.

K_Symbol1

up to five symbols per component

string

None.

K_Symbol2

up to five symbols per component

string

None.

K_Symbol3

up to five symbols per component

string

None.

K_Symbol4

up to five symbols per component

string

None.

K_Symbol5

up to five symbols per component

string

None.

K_ListPos

Sorting order of the component

string

None.

PLUNr

PLU number of the component

integer

None.

Preis

Price of the component

decimal number

None.

Preis1

Second pricelevel of the component

decimal number

None.

Ausverkauft

-1 when the component is sold out

boolean

None.

DisplayCode

display code

string

None.

K_Allergene_ID

comma separated list of the Ids of the allergens of the component

string

None.

K_Inhaltsstoffe_ID

comma separated list of the Ids of the ingredients of the component

string

None.

OptAllergene

Should allergens be printed?

boolean

None.

OptInhaltsstoffe

Should ingredients be printed?

boolean

None.

OptLegende

Should the legend be printed?

boolean

None.

OptCSB

Sorting by code(=0), by sorting code(=1, additional 2) or description(=2)

integer

None.

K_ArtikelLng

Name of the sales item, second language

string

None.

K_Zusatzinfos

additional info of the component

string

None.

K_Zutaten

ingredients of the component

string

None.

VKARNR

primary index of the sales item

string

None.

ZusWert1

string

None.

ZusWert2

string

None.

ZusWert3

string

None.

ZusWert4

string

None.

ZusWert5

string

None.

ZusWert6

string

None.

ZusWert7

string

None.

ZusWert8

string

None.

ZusWert9

string

None.

ZusWert10

string

None.

sustainabilityValues

Collection of Sustainability

None.