invantive documentation
Invantive Support ForumsLog In / Sign Up

IngredientHistoryByIngredientID: Horeko Ingredient History by Ingredient ID

read only REST

  • Catalog: Horeko
  • Schema: Ingredient
  • Label: Ingredient History by Ingredient ID

Returns history for one ingredient

Can only retrieve data.

API Source

  • Endpoint: /v4/ingredients/{id}/history
  • Operation: get /v4/ingredients/{id}/history

Parameters

Name Data Type Required Default Documentation
from `` 01/01/2020 00:00:00 take ingredient history after this date (format yyyy-mm-dd hh:mm:ss)
id ``
to `` 12/31/2999 00:00:00 take ingredient history before this date (format yyyy-mm-dd hh:mm:ss)

Table Columns

The columns of the table IngredientHistoryByIngredientID 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
IngredeintId int32 Ingredient ID
IngredientHistoryId int32 Ingredient History ID
Price double Price
ProductPackage int32 Product Package
PurchasePrice double Purchase Price
Summary_PurchasePrice double itgen_horeko_summary_purchaseprice
Summary_PurchasePricePercentage double itgen_horeko_summary_purchasepricepercentage
Summary_UnitPrice double itgen_horeko_summary_unitprice
Summary_UnitPricePercentage double itgen_horeko_summary_unitpricepercentage
UnitType_Id int32 Unit Type ID
UnitType_Name varchar2 Unit Type Name
UpdateDate datetime Update date
UsableAmountPerProduct int32 Usable Amount per Product

Release Notes

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