Home > Technical > Table Definitions > CUSTOMERCATEGORY

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.

STRCODE

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)