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.
ITEM.lintItemNumber
|
| LINTRECIPEITEMNUMBER | INT | The item
which is an ingredient in this recipe.
ITEM.lintItemNumber
|
| 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) |