© Tillypad 2008-2014
- tp_CompoundItems
Object: Stock item
Field |
Name |
Description |
---|---|---|
cmit_ID |
Recipe specifications ID | |
cmit_cmpd_pitm_ID |
Stock item recipe |
Recipe. Link to tp_ProductItems (Stock items) |
cmit_pitm_ID |
Stock item |
Stock item. Link to tp_ProductItems (Stock items) |
cmit_meit_ID |
Unit of measurement for recipe specification |
Unit of measurement for stock item quantity. Link to tp_MeasureItems (Stock item units of measurement) |
cmit_cmmd_ID |
Recipe mode. The Recipe mode field determines whether the recipe will be unfolded when the stock item is added to the store document specification or when it is recalculated. The recipe mode is specified for stock item recipe ingredients and for store document specification items (except for Stock-in and Butchering records). There are three recipe modes: 1. By stock item concurrence – the stock item concurrence determines whether the recipe needs to be unfolded 2. Always without recipe – the stock item is always added without recipe 3. Always with recipe – the recipe of the stock item is always unfolded irrespective of the concurrence. Link to tp_CompoundModes (Recipe modes) | |
cmit_Volume |
Gross |
Gross. 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. |
cmit_Netto |
Net |
Net. 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. |
cmit_VolumeOut |
Yield |
Yield of the stock item (preparation wastages are taken into account) 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. |
cmit_EditIndex |
Reference field It is used in the interface of editor windows for automatic recalculation of prices, amounts, etc. | |
cmit_Comment |
Comment |
Comment |
cmit_GroupOrder |
Order of weights |
Stock item tab order when preparing dishes |
cmit_Order |
Index |
Stock item tab order when preparing dishes |