NameDescriptionTypeAdditional information
ID

continuous auto value (primary index) of the table

integer

None.

MPGNr

Auto value (primary index) of the table MV_MenuePlanGrp --> MenuPlanGroup

integer

None.

MenuePlanGrp

Name of the menu plan , the cost centers are also attached here

string

None.

Ausgabetag

Date of the Menu

string

None.

AusgabetagUnspecified

Date of the Menu

string

None.

M_NameKarte

Name of the menu line (e.g.: regular meals)

string

None.

M_Symbol

Symbol of the menu line

string

None.

M_EnergieKC

Energy in kilocalories of the entire menu

string

None.

M_EnergieKJ

Energy in kilojoules of the entire menu

string

None.

M_Eiweiss

Protein in mg of the entire menu

string

None.

M_Kohlenhydrate

Carbohydrates in mg of the entire menu

string

None.

M_Fett

Fat in mg of the entire menu

string

None.

M_Allergene

Allergens of the entire menu

string

None.

M_Inhaltsstoffe

Ingredients of the entire menu

string

None.

M_Symbol1

up to five symbols per menu line

string

None.

M_Symbol2

up to five symbols per menu line

string

None.

M_Symbol3

up to five symbols per menu line

string

None.

M_Symbol4

up to five symbols per menu line

string

None.

M_Symbol5

up to five symbols per menu line

string

None.

M_Zucker

Sugar in mg of the entire menu

string

None.

M_Kochsalz

Table salt in mg of the entire menu

string

None.

M_FettGesaettigt

saturated fatty acids in mg of the entire menu

string

None.

M_Allergene_ID

comma separated list of the Ids of the allergens of the entire menu

string

None.

M_Inhaltsstoffe_ID

comma separated list of the Ids of the ingredients of the entire menu

string

None.

M_ListPos

Sorting order of the menu line

string

None.

MenuePLU

if entered, the PLU number for the menu item. Here you can find the menu price for the entire menu.

string

None.

Components

list of components for the menu line

Collection of MenuComponentItem

None.

sustainabilityValuesMenu

Collection of Sustainability

None.