Show TOC

Background documentationCustomer Points for Loyalty Table

 

File: [CUSTPTS.ASC]

SQL Table: Customer_Points

Field Number and Name

Field Type or Mask

Possible Values

1 Update Type *

Decimal 2.0

1 - Add

2 - Modify

3 - Delete

99 - Delete existing file and rebuild from transactions.

2 Store

Decimal 6.0

1 – 999999

3 Customer Number

String 14

Customer number

4 Loyalty Program ID

Decimal 8.0

1 – 99999999

5 Available Points

Decimal 8.0

Available points for redemption.

0 means that there is no limit.

6 sDisplayMsg1

String 40

Text message on customer receipt (1st line)

7 sDisplayMsg2

String 40

Text message on customer receipt (2nd line)