invantive documentation
Invantive Support ForumsLog In / Sign Up

DishNutrientMarkQualityMarks: Horeko Dish Nutrient Quality Marks

read only

  • Catalog: Horeko
  • Schema: Views
  • Label: Dish Nutrient Quality Marks

Can only retrieve data.

Table Columns

The columns of the table DishNutrientMarkQualityMarks are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
Carbohydrates double Carbohydrates
DishCreatedOn datetime Created on
DishDescription varchar2 Description
DishFolder_Id int32 Folder ID
DishFolder_Name varchar2 Folder Name
DishId int32 ID
DishLaborPreparationTime varchar2 Labor Preparation Time
DishLaborWashingTime varchar2 Labor Washing Time
DishLastModifiedOn datetime Last Modified on
DishName varchar2 Name
DishNumberOfPersons int32 Number of Persons
DishPluNumber varchar2 PLU Number
DishPreparationDescription varchar2 Preparation Description
DishRecipeComments varchar2 Recipe Comments
DishServingDescription varchar2 Serving Description
DishType_Id int32 Type ID
DishType_Name varchar2 Type Name
DishUnitType_Id int32 Unit Type ID
DishUnitType_Name varchar2 Unit Type Name
DishUsableAmount double Usable Amount
Energykcal double Energy (kcal)
EnergykJ double Energy (kJ)
FatSaturated double Fat Saturated
FatTotal double Fat Total
Fibres double Fibres
GTIN varchar2 GTIN
Id int32 ID
ImageLink varchar2 Image Link
Name varchar2 Name
Name_2 varchar2 itgen_horeko_name_2
Proteins double Proteins
PsNumber int32 PS Number
QualityMarkId int32 Quality Mark ID
Quantity double Quantity
Salt double Salt
Sodium double Sodium
Sugars double Sugars
Type_Id int32 Type ID
Type_Name varchar2 Type Name
UnitType_Id int32 Unit Type ID
UnitType_Name varchar2 Unit Type Name

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: