Home > Technical > Table Definitions > GROUPMODIFIER

GROUPMODIFIER

These records store the modifier sets that are available for a dept/cat/group. It is used by DynaPOS to select group modifiers instead of setting up individual item modifiers with ITEMMODIFER.

Column Type Description
STRDEPTCODE VARCHAR(10) Department code the modifier is for.
DEPT.strDeptCode
STRCATCODE VARCHAR(10) Category code the modifier is for.
CATEGORY.strCatCode
STRGROUPCODE VARCHAR(10) Group code the modifier is for.
GROUPS.strGroupCode
STRSUBGROUPCODE VARCHAR(10) SubGroup code the modifier is for.
SUBGROUP.strSubGroupCode
CURFROMVALUE DECIMAL(19,4) The sell price of the item must be greater than or equal to this amount before the modfier can be used.
CURTOVALUE DECIMAL(19,4) The sell price of the item must be less than or equal to this amount before the modfier can be used.
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
CTRCODE INT A unique number generated by the system to identify the record.
 

Primary Key: STRDEPTCODE + STRCATCODE + STRGROUPCODE + STRSUBGROUPCODE + CURFROMVALUE + CURTOVALUE + CTRCODE

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