Home > Technical > Table Definitions > ITEMRECIPE

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.

SALESMETHOD.intCode

 

Primary Key: LINTITEMNUMBER+ LINTRECIPEITEMNUMBER + INTSALESMETHOD

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)