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