Home > Technical > Table Definitions > POINTEXTRA
Points can be assigned to a member for items sold. The POINTBASIC table contains rules for assigning basic points while this table contains the rules for multiplying the basic points for special events.
Column 
Type 
Description 

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(15) 
Indicates the type of event these extra points are given for:


STRDEPTCODE  VARCHAR(10)  Only items in this department are considered for bonus points. If this is empty then all items qualify.  
STRCATCODE  VARCHAR(10)  Only items in this category are considered for bonus points. If this is empty then all items qualify.  
STRGROUPCODE  VARCHAR(10)  Only items in this group are considered for bonus points. If this is empty then all items qualify.  
LINTITEMNUMBER  INT  The item
for which bonus points will be given. If this is empty then all
items qualify. ITEM.lintItemNumber 

DTMFROMTRADE  DATETIME  The item must be sold after this date to qualify (inclusive).  
DTMTOTRADE  DATETIME  The item must be sold before this date to qualify (inclusive).  
DTMFROMTIME  DATETIME  The item must be sold after this time on any of the dates specified in dtmFromTrade and dtmToTrade.  
DTMTOTIME  DATETIME  The item must be sold before this time on any of the dates specified in dtmFromTrade and dtmToTrade.  
YSNSUNDAY  VARCHAR(1)  If 'T' then the extra points can be given on a Sunday, 'F' otherwise.  
YSNMONDAY  VARCHAR(1)  If 'T' then the extra points can be given on a Monday, 'F' otherwise.  
YSNTUESDAY  VARCHAR(1)  If 'T' then the extra points can be given on a Tuesday, 'F' otherwise.  
YSNWEDNESDAY  VARCHAR(1)  If 'T' then the extra points can be given on a Wednesday, 'F' otherwise.  
YSNTHURSDAY  VARCHAR(1)  If 'T' then the extra points can be given on a Thursday, 'F' otherwise.  
YSNFRIDAY  VARCHAR(1)  If 'T' then the extra points can be given on a Friday, 'F' otherwise.  
YSNSATURDAY  VARCHAR(1)  If 'T' then the extra points can be given on a Saturday, 'F' otherwise.  
STRMANUFACTURER  VARCHAR(10)  Points are awarded if the item comes from this manufacturer.  
INTDAYSBEFORE  INT  Used for date related points. The points can be assigned if this transaction is no more than this number of days before the special date, for example 3 days before the customer's birthday.  
INTDAYSAFTER  INT  Used for date related points. The points can be assigned if this transaction is no more than this number of days after the special date, for example 3 days after the customer's birthday.  
STRSUBGROUPCODE  VARCHAR(10)  Only items in this subgroup are considered for bonus points. If this is empty then all items qualify.  
STRCLASSCODE 
VARCHAR(10) 
Only items in this classification are considered for bonus points. If this is empty then all items qualify. 

STRCATEGORY 
VARCHAR(10) 
The customer category to which this point rule applies. 

DBLFACTOR 
DECIMAL(19,4) 
If the item qualifies for extra points, the basic points already awarded will be multiplied by this number. 

DBLPOINTSBONUS 
DECIMAL(19,4) 
If the item qualifies for extra points, this number of bonus points will be added after the intFactor has been used. 

YSNRESTRICTTOFIRSTTRAN 
VARCHAR(1) 
'T' indicates that new member bonus points for a loyalty member will only be applied to the first visit. Default behavior is false ('F'). 

YSNBONUSPOINTSIFNOBASICPOINTS 
VARCHAR(1) 
'T' indicates that item bonus points will be awarded even if no basic points are awarded. Default behavior is false ('F') 
Primary Key: CTRCODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) 