Home > Technical > Table Definitions > OFFERGROUP

OFFERGROUP

Offers are stored in DISCHDR.

Within an offer there are two types of groups - qualifying and rewards. The structure of these groups will depend on the type of offer being set up. For example, a Set offer (buy any 2 of five different items for a special price) will have a two qualifying groups.

Column

Type

Description

LINTOFFERCODE

INT(4)

The code of the offer this group belongs to.

OFFER.ctrCode

CTROFFERGROUP

INT(4)

A unique number assigned by the system.

STRGROUPNAME

VARCHAR(50)

A description about the group.

STRGROUPTYPE

VARCHAR(1)

'Q' indicates a qualifying group.

'R' indicates a reward group.

INTQUALIFYQTY

INT(4)

 

 

Primary Key: LINTOFFERCODE + CTROFFERGROUP

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