Loyalty Program Records

File: [LOYALPRO.ASC]

POS Filename: LOYALPRO.LTY

SQL Table: LOYALTY_PROGRAM

Field Number and Name	Field Type or Mask	Possible Values
1 Store Number	Decimal 6.0	1 - 999999
2 Parameter Group	Decimal 2.0	1 - 99 (use 99 for now)
3 Region Number	Decimal 2.0	1 - 99
4 Update Type	Decimal 2.0	1 - Add 2 - Modify 3 - Delete
5 Loyalty Program ID	Decimal 8.0	1 - 99999999
6 Description	String 20	Reporting/display description
7 Points Per Threshold	Decimal 5.0	Number of points awarded per threshold (see following two fields).
8 Loyalty Threshold Qty	Decimal 6.3	Enter the qty total for this Loyalty Program. Note Enter this or 8), but not both. End of the note.
9 Loyalty Threshold Amount	Decimal 7.2	Enter the $ total (with the decimal place) for this Loyalty Program. Note Enter this or 7), but not both. End of the note.
10 Maximum Points	Decimal 8.0	Enter the maximum number of points to be earned for this Loyalty Program on one transaction.
11 Transaction Threshold	Decimal 7.2	Amount the customer must purchase before any points are awarded.
12 Track Program ID	Decimal 8.0	Used to track eligible quantity/amount and points under another program
13 Redemption Discount ID	Decimal 5.0	Discount to use when redeeming points. Assumed to be a transaction discount.
14 Print Policy ID	Decimal 3.0	1 - 250
15 Print Document ID	Decimal 2.0	1 - 99
16 Print Line ID	Decimal 3.0	1 - 999
17 Print Eligible	String 1	Y/N
18 Print Points	String 1	Y/N

File: [LOYALELG.ASC]

SQL Table: LOYALTY_PROGRAM_ELIGIBILITY

Field Number and Name	Field Type or Mask	Possible Values
1 Update Type **	Decimal 2.0	1 - Add 3 - Delete
2 Store Number	Decimal 6.0	1 - 999999
3 Loyalty Program ID	Decimal 8.0	1 - 99999999
4 Customer Number *	String 14
5 Customer Type *	Decimal 5.0
6 PLU Number *	String 18
7 Department Number *	Decimal 8.0
8 User Flag Category *	Decimal 2.0
9 Itemizer Category *	Decimal 2.0

Note Note

Fields 4 - 9 are mutually exclusive, only one of these can contain a value per record. Due to the nature of the eligibility table, it is impossible to update a record. To change an existing record, the record must first be deleted, then inserted as new.

End of the note.

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 - Update 3 - Delete
2 Store Number	Decimal 6.0	1 - 999999
3 Customer Number	String 14
4 Loyalty Program ID	Decimal 8.0
5 Points Available	Decimal 8.0
6 Display Message 1	String 4
7 Display Message 2	String 40
8 Previous End Of Week	String 8	YYYY/MM/DD
9 Last Voucher Issued Date	String 8	YYYY/MM/DD
10 Total Points	Decimal 7.2	Default 0