Home > Technical > Table Definitions > POINTBASIC

POINTBASIC

Points can be assigned to a member for items sold. This table contains the rules for assigning points for items. The POINTEXTRA table contains rules that allow special extra factors to award bonus points.

Column Type Description
CTRCODE INT A unique code assigned by the system.
STRTRADECODE VARCHAR(10) Points are only awarded if the item is sold within this location.
TRADUNIT.strTradeCode
STRTYPE VARCHAR(10) Indicates whether points are for an 'Item' or a 'Basket', that is total sale.
CURFROMAMOUNT DECIMAL(19,4) Points are awarded if the sale value of the items is greater than this amount.
CURTOAMOUNT DECIMAL(19,4) Points are awarded if the sale value of the items is less than this amount.

STRMANUFACTURER

VARCHAR(10)

Points are awarded if the item comes from this manufacturer.

SUPPLIER.strSupplierCode

STRCATEGORY

VARCHAR(10)

The customer category to which this point rule applies.

DBLPOINTSPERDOLLAR

DECIMAL(19,4)

The number of points that will be awarded for each dollar. The sale value is rounded down to the nearest dollar.

DBLPOINTSBONUS

DECIMAL(19,4)

A number of points that will be awarded regardless of the intPointsPerDollar points awarded.

 

Primary Key: CTRCODE

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