invantive documentation
Invantive Support ForumsLog In / Sign Up

StockLevel1ItemsByStockID: Horeko Stock Level 1 Items by Stock ID

read only REST

  • Catalog: Horeko
  • Schema: Stock
  • Label: Stock Level 1 Items by Stock ID

Returns details for one stocklist ItemType: 0=Category, 1=Subrecipe, 2=Ingredient. ItemUnit: 0=Kilo, 1=Liter, 2=Piece

Can only retrieve data.

API Source

  • Endpoint: /v4/stocks/{id}
  • Operation: get /v4/stocks/{id}

Parameters

Name Data Type Required Default Documentation
id ``

Table Columns

The columns of the table StockLevel1ItemsByStockID 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
CountDate datetime Count Date
CountedAmountByContent double itgen_horeko_countedamountbycontent
CountedAmountByItem double itgen_horeko_countedamountbyitem
CountedAmountByPackage double itgen_horeko_countedamountbypackage
CountedBy int32 Counted by
CountedValue double Counted (value)
Description varchar2 Description
ItemId int32 Item ID
ItemName varchar2 Item Name
ItemType int32 Item Type
ItemUnit int32 Item Unit
LocationId int32 Location ID
Name varchar2 Name
TotalKilo double Total (kilo)
TotalLiter double Total (liter)
TotalPiece double Total (piece)
TotalValue double Total (value)

Release Notes

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