Home > Technical > Table Definitions > OFFERGROUPDEPT
Offers are stored in DISCHDR.
Some types of offers allow any items sold from a specific department/category/group to count towards qualification. Rather than specify all individual items, a single OFFERGROUPDEPT record can be set up.
|
Column |
Type |
Description |
|
LINTOFFERCODE |
INT(4) |
The code of the offer this group belongs to. |
|
LINTOFFERGROUP |
INT(4) |
A unique number assigned by the system. |
|
CTRCODE |
INT(4) |
A unique number assigned by the system. |
|
STRDEPTCODE |
VARCHAR(10) |
Department code items can belong to. |
|
STRCATCODE |
VARCHAR(10) |
Category code items can belong to. |
|
STRGROUPCODE |
VARCHAR(10) |
Group code items can belong to. |
Primary Key: LINTOFFERCODE + LINTOFFERGROUP + CTRCODE
| Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |
