Home > Technical > Table Definitions > DISCOUNT

DISCOUNT

Discounts are now stored in DISCHDR.

This table contains the sale discounts that can be used on DynaPOS. The system will use the total sale value as a basis for calculating discounts. If will then check each record. Any items in the corresponding department/ category/ group will get the specified level of discount.

Column

Type

Description

CTRCODE

INT(4)

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

STRPRICELEVEL

VARCHAR(1)

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.

STRDEPTCODE

VARCHAR(10)

The department the item must belong to in order to get this discount.

DEPT.strDeptCode

STRCATCODE

VARCHAR(10)

The category the item must belong to in order to get this discount.

CATEGORY.strCatCode

STRGROUPCODE

VARCHAR(10)

The group the item must belong to in order to get this discount.

GROUPS.strGroupCode

STRCLASSCODE

VARCHAR(10)

The classification the item must belong to in order to get this discount.

CLASS.strClassCode

STRMEMBERTYPE

VARCHAR(10)

The type of member who can get this discount.

CUSTOMERCATEGORY.strCode (where intType = 1)

CURMINDOLLARS

DECIMAL9(19,4)

The minimum total sale value that this discount applies to. Note that this is the total of all items in the sale.

DBLDISCOUNTPER

DECIMAL9(19,4)

If the item meets the specified criteria above, this will be the discount percentage that will be applied to its sale value.

 

Primary Key: CTRCODE

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