Home > Technical > Table Definitions > DISCQUALIFYGROUP

DISCQUALIFYGROUP

The qualifying group contains details about what items are required on a sale before a discount can be given. The actual items themselves are stored in DISCQUALIFYITEM.

Column

Type

Description

LINTDISCOUNTCODE

INT(4)

The code which identifies the DISCHDR this record belongs to.

DISCHDR.ctrCode

CTRCODE

INT(4)

A unique number assigned by the system to identify the qualification group.

STRDESCRIPTION

VARCHAR(50)

A description about the qualifying group.

STRQUALIFYTYPE

VARCHAR(1)

'Q' if a quantity of items must be in the sale.

'V' if a certain value of items is required.

INTQUALIFYFROMQTY

INT(4)

The quantity of items required. Only required if strQualifyType is 'Q'.

INTQUALIFYTOQTY

INT(4)

Not used.

CURQUALIFYVALUE

DECIMAL9(19,4)

The value of items required. Only required if strQualifyType is 'V'.

YSNEXCLUDEITEMS

VARCHAR(1)

If this option is checked on, all items in the qualification group are NOT allowed to be in the transaction. Note, you should still have a qualifying group to allow the item to be selected. For example, if you wanted all categories in the FOOD department except VEGE, then would have one qualifying group for the FOOD department then one qualifying group excluding VEGE.

 

DBLQUALIFYMEASURE

DECIMAL(19,4)

 

 

Primary Key: LINTDISCOUNTCODE + CTRCODE

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