Home > Technical > Table Definitions > ITEMMODIFIER

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.
link.gif (858 bytes) 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.
link.gif (858 bytes) 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.
link.gif (858 bytes) TRADUNIT.strTradeCode
 

Primary Key: LINTITEMNUMBER + INTORDER + LINTMODIFIERCODE

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