Home > Technical > Table Definitions > ITEMSETMEALREPLACE

ITEMSETMEALREPLACE

This table is used in conjunction with ITEMSETMEALINGRED. It indicates the replacement items that can be used for each ingredient of a set meal.

Column	Type	Description
LINTITEMNUMBER	INT	The set meal item this replacement items belongs to. ITEM.lintItemNumber
LINTINGREDIENTITEM	INT	The ingredient item that this replacement rule applies to. ITEMSETMEALREPLACE.lintIngredientItem
CTRCODE	INT	A unique number assigned by the system.
INTSEQUENCE	INT	The sequence the replacements will be displayed to the user.
LINTREPLACEITEM	INT	The item that can be used as a replacement item. You can leave this empty and use the codes below to specify a broader range of replacement items. ITEM.lintItemNumber
STRDEPTCODE	VARCHAR(10)	Any item in this department can be used as a replacement item. DEPT.strDeptCode
STRCATCODE	VARCHAR(10)	Any item in this category can be used as a replacement item. CATEGORY.strCatCode
STRGROUPCODE	VARCHAR(10)	Any item in this group can be used as a replacement item. GROUPS.strGroupCode
STRSUBGROUPCODE	VARCHAR(10)	Any item in this subgroup can be used as a replacement item. SUBGROUP.strSubGroupCode
STRCLASSCODE	VARCHAR(10)	Any item in this classification can be used as a replacement item. CLASS.strClassCode
STRFAMILYCODE	VARCHAR(10)	Any item in this family can be used as a replacement item. FAMILY.strFamilyCode
INTPRICETYPE	INT	Indicates how the sell price of the original ingredient will be changed when this replacement item is selected. 0   No price change 1   Use price of replacement item 2   Use different of original and replacement item 3   Use difference but only if its an increase.
YSNEXCLUDE	VARCHAR(1)	If this is 'T' any item NOT in the dept/cat/group/subgroup details above will be allowed to be a replacement item.

Primary Key: LINTITEMNUMBER + LINTINGREDIENTITEM + CTRCODE