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.
link.gif (858 bytes) DEPT.strDeptCode
STRCATCODE VARCHAR(10) Any item in this category can be used as a replacement item.
link.gif (858 bytes) CATEGORY.strCatCode
STRGROUPCODE VARCHAR(10) Any item in this group can be used as a replacement item.
link.gif (858 bytes) GROUPS.strGroupCode
STRSUBGROUPCODE VARCHAR(10) Any item in this subgroup can be used as a replacement item.
link.gif (858 bytes) SUBGROUP.strSubGroupCode
STRCLASSCODE VARCHAR(10) Any item in this classification can be used as a replacement item.
link.gif (858 bytes) CLASS.strClassCode
STRFAMILYCODE VARCHAR(10) Any item in this family can be used as a replacement item.
link.gif (858 bytes) 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

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