Home > Technical > Table Definitions > 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.![]() |
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. |
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) |