151 - Pre-Defined Data Capture #151
The Frequent Shopper Transaction Export File: FREQSHOP.DAT
This is achieved by implementing BreakPoint Pre-defined Data Capture #151 in conjunction with the BreakPoint Customer Tracking Facility. This BreakPoint Technical Newsletter should be accompanied with the file PSDC151.TPL which contains the Data Capture programming required to collect the Frequent Shopper transaction data.
To implement the Pre-defined Data Capture #151, first copy the PSDC151.TPL file to your BreakPoint directory. Once you have the PSDC151.TPL file copied over, you must link the Data Capture Function #151 to the sales finalization process one of two ways.
The Frequent Shopper Data Capture can be programmed to be tender-specific using the Tender Setup of the ALT Programming Menu. In this approach, you would assign the Frequent Shopper Data Capture to each of the BreakPoint Tenders that you wish to collect Frequent Shopper Points. This approach would permit the operator to provide Frequent Shopper Points for certain tenders while not providing Frequent Shopper Points for other tenders. This approach may be useful if the operator intends to exclude certain tenders from the Frequent Shopper program.
If the operator intends to include all tenders in the Frequent Shopper Program, the Frequent Shopper Data Capture can be programmed into the Tendering option of the Special Events #1 option of the Data Capture Program menu found in the ALT Programming Menu. This approach would cause the Frequent Shopper information to be collected with all tenders.
Unless altered, this Pre-defined Data Capture Function #151 will create a detailed transaction file of each Frequent Shopper Point assignment that occurs.
This file will have the filename:
Filename: FREQSHOP.DATThe FREQSHOP.DAT file will contain records of the following record format:
Record Format:
CUSTOMER ACCOUNT#, LTH 10, COL 1-10, ALPHANUMERIC, RIGHT JUSTIFIED, ZERO FILLED
TX FREQ SHOPPER POINTS, LTH 10, COL 12-21, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
DATE OF TRANSACTION, LTH 9, COL 23-31, FORMAT DD-MMM-YY
TIME OF TRANSACTION, LTH 4, COL 33-36, FORMAT HHMM
CLERK NUMBER, LTH 3, 38-40, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
TRANSACTION NUMBER, LTH 8, COL 42-49, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
Sample Records:
0000000111,0000002499,19-MAR-95,1018,001,00013252
0000000222,0000004100,19-MAR-95,1022,002,00013287
0000000333,0000000219,19-MAR-95,1032,001,00013314
Each Frequent Shopper transaction will be recorded on its own line and terminated with a carriage return and linefeed character.