Home > Technical > Table Definitions > ITEMRECIPE
This table contains the ingredients that make up a recipe.
Column | Type | Description |
LINTITEMNUMBER | INT | The item
this recipe belongs to.![]() |
LINTRECIPEITEMNUMBER | INT | The item
which is an ingredient in this recipe.![]() |
DBLQTY | DECIMAL(19,4) | The quantity of the ingredient in this recipe. |
DBLCONTRIBTOSALES | DECIMAL(19,4) | The percentage contribution, for example 50%, this ingredient will make towards the overall sales value of the recipe item. |
INTSEQUENCE |
INT |
The sequence that the ingredients will be used, for example 0,1,2,... |
INTSALESMETHOD |
INTEGER |
The sales method to which this ingredient belongs. This allows you to set up different recipes for eat-in or take away. A value of -1 indicates the ingredient applies to any sales method. |
Primary Key: LINTITEMNUMBER+ LINTRECIPEITEMNUMBER + INTSALESMETHOD
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |