Menu item stock items

Menu item stock items

tp_MenuItemProductItems - tp_MenuItemProductItems

Object: Menu item

Field

Name

Description

mipi_mitm_ID

Menu item

Menu item. Link to tp_MenuItems (Menu items)

mipi_pitm_ID

Stock item

Stock item. Link to tp_ProductItems (Stock items)

mipi_meit_ID

Unit of measurement for menu item's stock item

Unit of measurement for stock item quantity. Link to tp_MeasureItems (Stock item units of measurement)

mipi_VolumeMenu

Quantity (menu)

Menu item quantity. These numbers (+mipi_VolumeProduct) are required to specify the relationship between the stock item deduction and the menu item.

mipi_VolumeProduct

Quantity (stock item)

Stock item quantity Stored in baseline units of measurement for a given stock item taking into account the ratio in its unit of measurement group. For example, the document might display "Potato" - 200 g The unit of measurement (g) has the ratio 0.001. Therefore, in the base it would be stored as 0.2.

mipi_IsTemporary

Ad hoc recipe

Ad hoc recipe