invantive documentation
Invantive Support ForumsLog In / Sign Up

IngredientNutrients: Horeko Ingredient Nutrients

read only

  • Catalog: Horeko
  • Schema: Views
  • Label: Ingredient Nutrients

Can only retrieve data.

Table Columns

The columns of the table IngredientNutrients 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
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
IngredientArticleCode varchar2 Article Code
IngredientBrand varchar2 Brand
IngredientCategory_Id int32 itgen_horeko_category_id
IngredientCategory_Name varchar2 itgen_horeko_category_name
IngredientComment varchar2 Comment
IngredientCreatedOn datetime Created on
IngredientEol int32 itgen_horeko_eol
IngredientEolComment varchar2 itgen_horeko_eolcomment
IngredientGTIN varchar2 GTIN
IngredientId int32 ID
IngredientLastModifiedOn datetime Last Modified on
IngredientName varchar2 Name
IngredientPrice double Price
IngredientProductPackage int32 Product Package
IngredientPurchasePrice double Purchase Price
IngredientStorageLocation varchar2 Storage Location
IngredientSupplier_Id int32 itgen_horeko_supplier_id
IngredientSupplier_Name varchar2 itgen_horeko_supplier_name
IngredientSupplierArticleNo varchar2 Supplier Article Number
IngredientUnitType_Id int32 Unit Type ID
IngredientUnitType_Name varchar2 Unit Type Name
IngredientUsableAmountPerProduct int32 Usable Amount per Product
Name varchar2 Name
Proteins double Proteins
Quantity double Quantity
QuantityUnit_Id int32 itgen_horeko_quantityunit_id
QuantityUnit_Name varchar2 itgen_horeko_quantityunit_name
Salt double Salt
Sodium double Sodium
Sugars double Sugars

Release Notes

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