Home > Technical > Table Definitions > CUSTOMERCATEGORY
These records simply serve as a means to categorise customers.
Column | Type | Description |
INTTYPE |
INT(4) |
A customer can be assigned to five different categories. This is a number between 1 and 5 to restrict the use of this code to one of the five customer categories. A value of 1 is reserved for the customer type. |
VARCHAR(10) |
A code to identify the category. It must be unique within intType. |
|
STRDESCRIPTION |
VARCHAR(50) |
A description about the category. |
STRDETAILS |
VARCHAR(20) |
This is a general purpose field whose value will depend on where it is being used. If intType = 1, this is a number from 1 to 5 representing the price level that a customer will be charged for their sale. If left empty, the customer will be charged the current price level. |
YSNMEMBERINVOICE |
VARCHAR(1) |
If intType = 1 and this is 'T' then POS customers of this type can have an invoice printed, rather than a receipt. |
YSNPRINTSIGNATURE |
VARCHAR(1) |
|
INTREQPOINTS |
INT(4) |
|
STRNEXTCATEGORY |
VARCHAR(10) |
|
YSNCALCPOINTS |
VARCHAR(1) |
|
MEMPTSSTATEMENT |
TEXT(16) |
|
Primary Key: STRCODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |