Home > Technical > Table Definitions > DISCHDR

DISCHDR

This is the header table for discounts and offers in the system.

Column

Type

Description

CTRCODE

INT(4)

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

STRDESCRIPTION

VARCHAR(50)

A description about the discount/qualify.

STRPOSDESCRIPTION

VARCHAR(40)

A description to appear on the POS. Only the first 20 characters are used.

STRCUSTTYPE

VARCHAR(10)

The type of customer that this discount applies to.

CUSTOMERCATEGORY.strCode

STRPRICELEVEL

VARCHAR(5)

The price level that this discount applies to. Will be a number from '1' to '5' depending on the price level. '0' if applies to any price level.

STRTRADECODE

VARCHAR(10)

The location that the discount applies to.

TRADUNIT.strTradeCode

DTMEFFECTIVE

DATETIME(8)

The date the discount can be used from. Leave empty to start immediately.

DTMEXPIRY

DATETIME(8)

The date the discount can be used to. Leave empty to use indefinitely.

DTMEFFECTIVETIME

DATETIME(8)

The time of day that the discount can be used from. This is the time portion only of a TDateTime variable.

DTMEXPIRYTIME

DATETIME(8)

The time of day that the discount can be used to. This is the time portion only of a TDateTime variable.

INTPRIORITY

INT(4)

The priority of the discount in relation to other discounts. The lowest number will be processed first.

YSNDELETED

VARCHAR(1)

'T' if discount has been deleted. 'F' otherwise.

YSNINCLUDEPROMOITEMS

VARCHAR(1)

If 'T' then items currently on promotion can be included in any qualification and rewards checks.  'F' otherwise.

STRDISCOUNTTYPE

VARCHAR(1)

The type of discount:

I = Item Discount
S = Sale Discount
A = Sale Discount Auto
O= Offer
T= Tender

STRREWARDTYPE

VARCHAR(1)

The type of reward to be given.

D = Discount
P = Effective Price
O = Other

INTNUMREWARDITEMS

INT(4)

The number of items to be given as the first reward. Only required if strRewardType is 'O'.

INTNUMREWARD2ITEMS

INT(4)

The number of items to be given as the second reward. Only required if strRewardType is 'O'.

STRREWARDITEMTYPE

VARCHAR(1)

The way in which reward items should be processed. At this stage this can only be 'P' for priority.

CURCOLLECTIVEPRICE

DECIMAL9(19,4)

The effective sell price to be used as the reward for the discount. Only required if strRewardType is 'P'.

STRCOLLECTIVEDISCTYPE

VARCHAR(1)

Indicates the type of discount to be given as a reward. Can be '%' or '$'. Only required if strRewardType is 'D'.

DBLCOLLECTIVEDISCRATE

DECIMAL9(19,4)

The rate of discount to be given as a reward. Used in conjunction with strCollectiveDiscType to give the actual discount. Only required if strRewardType is 'D'.

INTTENDERCODE

INT(4)

If the strDiscountType is 'T' (for tender discount), this field contains the tender for which the discount will be given.

TENDER.intTenderCode

YSNSUNDAY

VARCHAR(1)

'T' if the discount can be used on this day of the week, 'F' otherwise.

YSNMONDAY

VARCHAR(1)

'T' if the discount can be used on this day of the week, 'F' otherwise.

YSNTUESDAY

VARCHAR(1)

'T' if the discount can be used on this day of the week, 'F' otherwise.

YSNWEDNESDAY

VARCHAR(1)

'T' if the discount can be used on this day of the week, 'F' otherwise.

YSNTHURSDAY

VARCHAR(1)

'T' if the discount can be used on this day of the week, 'F' otherwise.

YSNFRIDAY

VARCHAR(1)

'T' if the discount can be used on this day of the week, 'F' otherwise.

YSNSATURDAY

VARCHAR(1)

'T' if the discount can be used on this day of the week, 'F' otherwise.

INTLEVEL

INT(4)

Not used.

YSNREWARDALLOC

VARCHAR(1)

Yes = Allocate the rewarded discount across all items (Qualification + Reward) otherwise the discount is only accounted for against the rewarded item (and hence its Dept/Cat/Group etc).

YSNREWARD2ALLOC

VARCHAR(1)

As above for Reward 2.

INTREWARDPRICELEVEL

INT(4)

The price level to be awarded if the discount qualifies.

YSNINCLUDEEXCHANGEITEM

VARCHAR(1)

Not used.

YSNINCLUDEITEMSWITHITEMDISC

VARCHAR(1)

Indicates if items with item discount count towards other types of discount (Sales/Offers).

INTCHANGEFLAG

INT(4)

Internal flag used to track changes to the DB table.

INTNEWFLAG

INT(4)

Internal flag used to track new records.

STRTENDERLIST

VARCHAR(100)

Comma separated list of tender types (for a Tender Discount). This is the field on the Basic tab that gets populated when you press the white arrow on blue background button to add a Tender type.

INTREWARD1METHOD

INT(4)

Do you award the discount to the highest/lowest first matching reward item?

INTREWARD2METHOD

INT(4)

As above for Reward item 2.

YSNINCLUDEITEMWITHANYDISC

VARCHAR(1)

Not used.

DBLTENDERDISCRATE

DECIMAL9(19,4)

Rate for tender discount.

LINTTENDERVOUCHERCODE

INT(4)

Voucher code for Tender Discount (Basic tab).

LINTREWARDVOUCHERCODE

INT(4)

Voucher code from the Reward 1 tab for the Tender discount.

MEMCOMMENTS

TEXT(16)

Comment field.

YSNASKREASON

VARCHAR(1)

Prompt for reason for Item discount?

INTVOUCHERUSAGECOUNT

INT(4)

Max number of times discount can be given in a transaction.

INTAPPLIEDLEVEL

INT(4)

Discount can be applied any time /when item has no discount/when tender has no discount.

DTMVALIDEARLY

DATETIME(8)

These fields are those on the Location Control tab. The discount can be used this early, if a location chooses. This is an optional date. If a location does not indicate the discount should be used during this period, the discount won't start until the main start date.

DTMVALIDLATE

DATETIME(8)

The discount can be used up until this date, if the location chooses. This is an optional date. If a location does not indicate the discount should be used during this period, the discount will end on the main end date.

YSNLOCALLYMANAGED

VARCHAR(1)

Let store override the default settings so the discount can be applied earlier than the time range specified.

YSNMANDATORYCORE

VARCHAR(1)

If this option is checked on, the discount MUST be used during the main (or core) date range. The location will only be able to control if the discount is used outside of the main date range.

YSNACTIVECORE

VARCHAR(1)

If this option is checked on, it means that by default the discount will be used during the main date range. The store will be able to control the discount usage during the date range but by default it will be on. If the Must Use During Core Date is checked on, it will override this option.

YSNMPOS

VARCHAR(1)

Support for Mobile POS discounts.

 

Primary Key: CTRCODE

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