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.
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. |
|
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) |