Home > Technical > Table Definitions > OFFERGROUPDEPT

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.

OFFER.ctrCode

LINTOFFERGROUP

INT(4)

A unique number assigned by the system.

OFFERGROUP.ctrOfferGroup

CTRCODE

INT(4)

A unique number assigned by the system.

STRDEPTCODE

VARCHAR(10)

Department code items can belong to.

DEPT.strDeptCode

STRCATCODE

VARCHAR(10)

Category code items can belong to.

CATEGORY.strCatCode

STRGROUPCODE

VARCHAR(10)

Group code items can belong to.

GROUPS.strGroupCode

 

Primary Key: LINTOFFERCODE + LINTOFFERGROUP + CTRCODE

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