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 |
|---|---|---|---|---|---|
Containment |
int32 |
itgen_horeko_containmentlevel_id | |||
Containment |
varchar2 |
itgen_horeko_containmentlevel_name | |||
Id |
int32 |
ID | |||
Ingredient |
varchar2 |
Article Code | |||
Ingredient |
varchar2 |
Brand | |||
Ingredient |
int32 |
itgen_horeko_category_id | |||
Ingredient |
varchar2 |
itgen_horeko_category_name | |||
Ingredient |
varchar2 |
Comment | |||
Ingredient |
datetime |
Created on | |||
Ingredient |
int32 |
itgen_horeko_eol | |||
Ingredient |
varchar2 |
itgen_horeko_eolcomment | |||
Ingredient |
varchar2 |
GTIN | |||
Ingredient |
int32 |
ID | |||
Ingredient |
datetime |
Last Modified on | |||
Ingredient |
varchar2 |
Name | |||
Ingredient |
double |
Price | |||
Ingredient |
int32 |
Product Package | |||
Ingredient |
double |
Purchase Price | |||
Ingredient |
varchar2 |
Storage Location | |||
Ingredient |
int32 |
itgen_horeko_supplier_id | |||
Ingredient |
varchar2 |
itgen_horeko_supplier_name | |||
Ingredient |
varchar2 |
Supplier Article Number | |||
Ingredient |
int32 |
Unit Type ID | |||
Ingredient |
varchar2 |
Unit Type Name | |||
Ingredient |
int32 |
Usable Amount per Product | |||
Name |
varchar2 |
Name |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: