Home > Technical > Table Definitions > OFFERGROUPITEM

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.

OFFER.ctrCode

LINTOFFERGROUP

INT(4)

A unique number assigned by the system.

OFFERGROUP.ctrOfferGroup

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

ITEM.lintItemNumber

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)