invantive documentation
Invantive Support ForumsLog In / Sign Up

IngredientAllergans: Horeko Ingredient Allergans

read only

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

Can only retrieve data.

Table Columns

The columns of the table IngredientAllergans 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
ContainmentLevel_Id int32 itgen_horeko_containmentlevel_id
ContainmentLevel_Name varchar2 itgen_horeko_containmentlevel_name
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

Release Notes

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