Recurring - SPW Format Specifications

Created by Richard Moore, Modified on Wed, 19 Apr 2023 at 10:14 AM by Richard Moore

Record Count



The first line in the file is simply the number of transaction records contained in the file. It should NOT contain any spaces, commas or other characters.


File Body

After the Record Count, every line is a transaction record. The format is outlined below.


Field IndexField NameField FormatRequired
1BatchIDnumericNo
2Not used, but delimiter requiredN/ANo
3Batch Description100 characters maxNo
4Not used, but delimiter requiredN/ANo
5Not used, but delimiter requiredN/ANo
6Not used, but delimiter requiredN/ANo
7Not used, but delimiter requiredN/ANo
8FirstDateMM/DD/YYYYNo
9Not used, but delimiter requiredN/ANo
10Frequency

Indicates the number of transactions to process per year. Accepted Values: 0, 1, 2, 4, 6, 12, 24, 26, 52, 365


No
11Last DateMM/DD/YYYYNo
12Not used, but delimiter requiredN/ANo
13Not used, but delimiter requiredN/ANo
14AmountNumeric 0.00 formatYes
15Debit/Credit"True" for debit, "False" for creditYes
16Not used, but delimiter requiredN/ANo
17Not used, but delimiter requiredN/ANo
18Cardholder Reference19 characters maxNo
19Cardholder Name30 characters maxYes
20Card Number19 characters maxYes
21Not used, but delimiter requiredN/ANo
22Expiry DateMM/YYYes
23Not used, but delimiter requiredN/ANo
24Transaction CodeMVAUTH (pre-authorization), MVSETL (pre-authorization completion), MVATHSTL (purchase/authorize and capture)Yes
25Recurring PaymentTrue/FalseYes
26Not used, but delimiter requiredN/ANo
27Authorization Number6 characters maximumRequired if Transaction Code is MVSETL
28Not used, but delimiter requiredN/ANo
29Not used, but delimiter requiredN/ANo
30Not used, but delimiter requiredN/ANo



Sample SPW File:


2

87,,,"RENT A WOND CAR",,,,04/11/2006,,52,06/27/2006,,, 200.00,"True",,,"123456","Jabba","5454545454545454",,"08/08",,"MVATHSTL","True",,,,,

87,,,"RENT A WOND CAR",,,,06/13/2006,,52,06/27/2006,,, 10.00,"True",,,"654321","Zorba","5454545454545454",,"08/08",,"MVSETL","False",,,,,

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article