150 - Pre-Defined Data Capture #150
Customer Charge and R/A Transaction Export: CUSTOMER.DAT
This is achieved by implementing BreakPoint Pre-defined Data Capture #150 in conjunction with the BreakPoint Customer Tracking Facility. This BreakPoint Technical Newsletter should be accompanied with the file PSDC150.TPL which contains the Data Capture programming required to collect the Charge and Received on Account transaction data.
To implement the Pre-defined Data Capture #150, first copy the PSDC150.TPL file to your BreakPoint directory. Once you have the PSDC150.TPL file copied over, you must link the Data Capture Function #150 to both the BreakPoint Tender which you have designated for Customer Charge and the Received on Account function. The Customer Charge Data Capture can be programmed using the Tender Setup of the ALT Programming Menu. The Received on Account Data Capture must be programmed using the Special Events #1 option of the Data Capture Program option of the ALT Programming Menu.
Unless altered, this Pre-defined Data Capture Function #150 will create a detailed transaction file of each Customer Charge and each Received on Account that occurs. This file will have the filename:
Filename: CUSTOMER.DATThe CUSTOMER.DAT file will contain records of the following record format:
Record Format:
RECORD TYPE, LTH 25, COL 1-25, hardcoded to CHARGE or RECEIVED ON ACCOUNT
CUSTOMER ACCOUNT#, LTH 10, COL 27-36, ALPHANUMERIC, RIGHT JUSTIFIED, ZERO FILLED
CUSTOMER NAME, LTH 40, COL 38-77, ALPHANUMERIC, LEFT JUSTIFIED, BLANK FILLED
CREDIT LIMIT, LTH 10, COL 79-88, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
NEW BALANCE, LTH 10, COL 90-99, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
SALE AMOUNT, LTH 10, COL 101-110, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
DATE OF TRANSACTION, LTH 9, COL 112-120, FORMAT DD-MMM-YY
TIME OF TRANSACTION, LTH 5, COL 122-126, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
CLERK NUMBER, LTH 3, 128-130, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
TRANSACTION NUMBER, LTH 8, COL 132-139, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
Sample Records:
CHARGE ,0000000111,JOHN DOE ,0000100000,0000027840,0000002499, (cont.) 9-MAR-95 ,10:18,001,00013252
RECEIVED ON ACCOUNT ,0000000111,JOHN DOE ,0000100000,0000027840,0000002499, (cont.) 9-MAR-95 ,10:18,001,00013252
Each Charge or Received on Account transaction will be recorded on its own line and terminated with a carriage return and linefeed character. Negative amounts will appear such that the minus sign (-) replaces the leftmost digit of the field.