Home > Technical > Table Definitions > 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. |
|
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) |
