© Tillypad, 2008-2015
- tp_StoreExperimentItems
Object: Development record
Field |
Name |
Description |
---|---|---|
sexi_ID |
ID for: Development record specifications | |
sexi_sexi_ID_Parent |
Parent |
Parent If the field's value equals NULL, this is a composed dish. If the field's value is not NULL, this is an ingredient of the recipe. |
sexi_stex_ID |
Document |
Document. Link to tp_StoreExperiments (Development records) |
sexi_pitm_ID |
Stock item |
Stock item - experiment ingredient. Link to tp_ProductItems (Stock items) |
sexi_meit_ID |
Unit of measurement for development record specification |
Unit of measurement for stock item quantity. Link to tp_MeasureItems (Stock item units of measurement) |
sexi_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) | |
sexi_IsDeleted |
When the user deletes a stock item from the specification, the stock item is not immediately deleted from the document. Instead, it is just marked to be deleted. Deletion will take place after the document will have been processed by the storekeeping system if there are no reasons, which prevent this operation (closed period, this item has been deducted, etc.) | |
sexi_Order |
Index |
Index. This is an info field. It is used to sort out items in the list |