Home > Technical > Table Definitions > DISCREWARDITEM

DISCREWARDITEM

This table contains details about specific items which are rewarded for a discount/offer. Basic discount and effective sell price rewards are stored in DISCHDR.

Column

Type

Description

LINTDISCOUNTCODE

INT(4)

The code which identifies the DISCHDR this record belongs to.

DISCHDR.ctrCode

INTREWARDNUM

INT(4)

A discount can have two rewards given. This field will contain 1 or 2 to indicate which reward the item belongs to.

CTRCODE

INT(4)

A unique number assigned by the system to identify the discount.

STRDEPTCODE

VARCHAR(10)

Only items in this department code can be rewarded. If not set then items from any department can be rewarded.

DEPT.strDeptCode

STRCATCODE

VARCHAR(10)

Only items in this category code can be rewarded. If not set then items from any category can be rewarded.

CATEGORY.strCatCode

STRGROUPCODE

VARCHAR(10)

Only items in this group code can be rewarded. If not set then items from any group can be rewarded.

GROUPS.strGroupCode

STRSUBGROUPCODE

VARCHAR(10)

Only items in this subgroup code can be rewarded. If not set then items from any subgroup can be rewarded.

SUBGROUP.strSubGroupCode

STRCLASSCODE

VARCHAR(10)

Only items in this classification code can be rewarded. If not set then items from any classification can be rewarded.

CLASS.strClassCode

STRFAMILYCODE

VARCHAR(10)

Only items in this family code can be rewarded. If not set then items from any family can be rewarded.

FAMILY.strFamilyCode

LINTITEMNUMBER

INT(4)

Only items with this item number can be rewarded. If not set then items with any item number can be rewarded.

ITEM.lintItemNumber

STRREWARDTYPE

VARCHAR(1)

The type of reward to be given for the rewarded item.

D= Discount
S=Sell Price

STRDISCTYPE

VARCHAR(1)

The type of discount to be applied. Can be % or $. Only required if strRewardType = 'D'.

DBLDISCRATE

DECIMAL 9(19,4)

The rate of discount to be applied. eg 0.50 is either 0.5% or £0.50 off.

INTPRIORITY

INT(4)

The priority of this item in relation to other reward items for this discount. Lowest numbers will be processed first.

CURSELLPRICE

DECIMAL 9(19,4)

The sell price to set the rewarded item to. Only required if strRewardType = 'S'.

STRPRODUCTBRANDNAME

VARCHAR(30)

Items in this brand can be given as a reward.

STRSEASONCODE

VARCHAR(10)

Items in this season can be given as a reward.

STRYEARCODE

VARCHAR(4)

Items in this year can be given as a reward.

 

Primary Key: LINTDISCOUNTCODE + LINTGROUPCODE + CTRCODE

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