Home > Technical > Table Definitions > OFFERGROUPITEM
Offers are stored in DISCHDR.
Within each offer group there is at least one item. These items must be included in the sale in order to use the offer.
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. |
INTPRIORITY |
INT(4) |
The order within the group that this record is processed. |
LINTITEMNUMBER |
INT(4) |
The item number that must exist in the sale |
YSNMANDATORY |
VARCHAR(1) |
'T' if this item must exist. |
INTSPLITQTY |
INT(4) |
Usually zero, unless the offer is a Split offer. In this case, this is the number of units which must be sold to meet the offer. |
CURSELLPRICE |
DECIMAL(9)19,4 |
The sell price to be used if the item is being repriced. |
Primary Key: LINTOFFERCODE + LINTOFFERGROUP + INTPRIORITY + LINTITEMNUMBER + INTSPLITQTY
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |