IngredientByIDAlt: Horeko Ingredient by ID (alt.)
read only REST
- Catalog:
Horeko - Schema:
Ingredient - Label: Ingredient by ID (alt.)
Returns details for one ingredient
Can only retrieve data.
API Source
- Endpoint:
/v4/ingredients/get/{id} - Operation:
get /v4/ingredients/get/{id}
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
id |
`` |
Table Columns
The columns of the table IngredientByIDAlt 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 |
|---|---|---|---|---|---|
Article |
varchar2 |
Article Code | |||
Brand |
varchar2 |
Brand | |||
Category_ |
int32 |
itgen_horeko_category_id | |||
Category_ |
varchar2 |
itgen_horeko_category_name | |||
Comment |
varchar2 |
Comment | |||
Created |
datetime |
Created on | |||
Eol |
int32 |
itgen_horeko_eol | |||
Eol |
varchar2 |
itgen_horeko_eolcomment | |||
GTIN |
varchar2 |
GTIN | |||
Id |
int32 |
ID | |||
Last |
datetime |
Last Modified on | |||
Name |
varchar2 |
Name | |||
Price |
double |
Price | |||
Product |
int32 |
Product Package | |||
Purchase |
double |
Purchase Price | |||
Storage |
varchar2 |
Storage Location | |||
Supplier_ |
int32 |
itgen_horeko_supplier_id | |||
Supplier_ |
varchar2 |
itgen_horeko_supplier_name | |||
Supplier |
varchar2 |
Supplier Article Number | |||
Unit |
int32 |
Unit Type ID | |||
Unit |
varchar2 |
Unit Type Name | |||
Usable |
int32 |
Usable Amount per Product |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: