Home > Technical > Table Definitions > ITEMSETMEALINGRED

ITEMSETMEALINGRED

This tables contains the items that make up a Set Meal, for example a burger, fries and drink.

Column Type Description
LINTITEMNUMBER INT The set meal item this ingredient belongs to.
ITEM.lintItemNumber
CTRCODE INT A unique code assigned by the system.
INTSEQUENCE INT The sequence that the ingredients will be displayed to the user (used for Set Meals where the user is able to change the ingredient item, for example 0,1,2,...
LINTINGREDIENTITEM INT The item which is an ingredient in this set meal.
ITEM.lintItemNumber
DBLCONTRIBTOSALES DECIMAL(19,4) The percentage contribution, for example 50%, this ingredient will make towards the overall sales value of the set meal item.
DBLQTY DECIMAL(19,4) he quantity of the ingredient in the set meal.
 

Primary Key: LINTITEMNUMBER + CTRCODE

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