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) |
