Home > Technical > Table Definitions > OFFER

OFFER

Offers are stored in DISCHDR.

An offer is used to give special discounts on DynaPOS. Examples of offers include:

An offer consists of a single OFFER record, qualifying and reward groups (OFFERGROUP) and depending on the type of offer, items within the groups (OFFERGROUPITEM) or departments within the group (OFFERGROUPDEPT).

Column

Type

Description

CTRCODE

INT(4)

A unique code assigned by the system.

STRTRADECODE

VARCHAR(10)

The location the offer applies to.

TRADUNIT.strTradeCode

DTMEFFECTIVE

DATETIME(8)

The date the offer applies from.

DTMEXPIRY

DATETIME(8)

The date the offer applies to.

INTPRICELEVEL

INT(4)

A sell price can have one of five price levels. This is the price level that the offer applies to.

INTPRIORITY

INT(4)

There can be multiple offers in effect at one time. This is the order in which they should be processed.

STRQUALIFYTYPE

IVARCHAR(10)

 

INTGROUPSQTY

INT(4)

 

INTQUALIFYQTY

INT(4)

 

CURQUALIFYVALUE

DECIMAL(9)19,4

 

YSNALLITEMSTOQUALIFY

VARCHAR(1)

 

STRPRICETYPE

VARCHAR(10)

 

LINTOFFERITEMNUMBER

INT(4)

 

STRREPRICETYPE

VARCHAR(10)

 

CURREPRICEREDUCE

DECIMAL(9)19,4

 

DBLREPRICEREDUCEPER

DECIMAL(9)19,4

 

CURSPLITREMAINPRICE

DECIMAL(9)19,4

 

STRDESCRIPTION

VARCHAR(50)

A description about the offer.

STRCOMMENT

VARCHAR(20)

This comment will be printed on the invoice next to the item.

YSNDISCOUNTPROMOS

VARCHAR(1)

If 'T' then quantity discounts can be applied to items sold on promotion.

INTREPRICELEVEL

INT(4)

If the reward for an offer is to reprice to one of five sell price levels, this is the level to use.

 

Primary Key: CTRCODE

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