Home > Technical > Table Definitions > 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.![]() |
||||||||
LINTINGREDIENTITEM | INT | The ingredient item that this replacement rule applies to. | ||||||||
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. | ||||||||
STRDEPTCODE | VARCHAR(10) | Any item in
this department can be used as a replacement item.![]() |
||||||||
STRCATCODE | VARCHAR(10) | Any item in
this category can be used as a replacement item.![]() |
||||||||
STRGROUPCODE | VARCHAR(10) | Any item in
this group can be used as a replacement item.![]() |
||||||||
STRSUBGROUPCODE | VARCHAR(10) | Any item in
this subgroup can be used as a replacement item.![]() |
||||||||
STRCLASSCODE | VARCHAR(10) | Any item in
this classification can be used as a replacement item.![]() |
||||||||
STRFAMILYCODE | VARCHAR(10) | Any item in
this family can be used as a replacement item.![]() |
||||||||
INTPRICETYPE | INT | Indicates
how the sell price of the original ingredient will be changed when
this replacement item is selected.
|
||||||||
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) |