Home > Technical > Table Definitions > ITEMMODIFIER
These records store the modifier sets that are available for an item, for example for an item called STEAK there could be modifier sets for cooking instructions, sauces, and so on.
| Column | Type | Description |
| LINTITEMNUMBER | INT | The item
this modifier belongs to. ITEM.lintItemNumber
|
| INTORDER | INT | The order in which the modifier sets will be displayed to the user, for example 0,1,2... |
| LINTMODIFIERCODE | INT | The code of
the modifier set to be displayed. MODIFIERHDR.ctrCode
|
| DTMSTART | DATETIME | The date the modifier can be used from. If not entered, modifier can be used immediately. |
| DTMEND | DATETIME | The date the modifier can be used up to. If not entered, modifier can be used forever. |
| STRTRADECODE | VARCHAR(10) | The
location where the modifier can be used. This can be a location
group. TRADUNIT.strTradeCode
|
Primary Key: LINTITEMNUMBER + INTORDER + LINTMODIFIERCODE
| Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |