CSV Format
The CSV format used is a standard comma separated format
In PayGate a Payer record and associated payment plan are intrinsically linked. When you import or export a collection of Payers you also import or export their payment plan as part of the data set.
Column Name |
Format |
Optional / Mandatory |
Explanation |
Example |
Sortcode |
6n |
M |
||
Account Number |
8n |
M |
||
Account Holders Name |
30a |
M |
||
Status |
1n |
M |
The status of the payer record. |
0 Where: 0: Operational 1: Suspended 2: Alert 3: Closed |
Status Reason |
2n |
O |
||
Title |
1n |
M |
Payer's title |
1 Where: 0 – Mr 1 - Mrs 2 - Miss 3 - Ms |
Firstname |
30a |
M |
Payer's First Name |
|
Surname |
30a |
M |
Payer's Surname |
|
Reference |
10a |
M |
The Payers unique reference |
|
Address1 |
30a |
M |
Line 1 of the payer's address |
|
Address2 |
30a |
O |
Line 2 of the payer's address |
|
Address3 |
30a |
O |
Line 3 of the payer's address |
|
Address4 |
30a |
O |
Line 4 of the payer's address |
|
Postcode |
30a |
M |
Payer's postcode |
|
254a |
O |
Payer's email address |
||
Tel1 |
30n |
O |
Payer first telephone number |
|
Reserved |
30n |
O |
Reserved for future use |
|
Mobile |
30n |
O |
Payer first telephone number |
|
Reserved |
10a |
O |
||
Custom Field1 |
64a |
O |
User Defined field |
|
Custom Field2 |
64a |
O |
User Defined field |
|
Custom Field3 |
64a |
O |
User Defined field |
|
Custom Field4 |
64a |
O |
User Defined field |
|
Custom Field5 |
64a |
O |
User Defined field |
|
First Amount |
18,2 |
O |
The first debit amount if different from the regular amount. |
123.45 |
Last Amount |
18,2 |
O |
The last debit amount if different from the regular amount. |
Recurrence End Type must be either UntilDate or UntilNumberOfPayments. |
Regular Amount |
18,2 |
M |
The regular debit amount |
3.14 |
Gift Aid |
10a |
M |
TRUE or FALSE |
|
First Payment Date |
10a |
M |
dd/mm/yyyy format |
21/04/2015 |
Ordinal |
3n |
M |
||
Step |
2n |
O |
Defaults to 1 if not present |
|
Recurrence Type |
30a |
M |
Weekly, Monthly, Yearly |
|
Recurrence End Type |
30a |
OneOff, UntilDate, UntilNumberOfPayments,Ongoing |
||
Until Date |
10a |
O |
dd/mm/yyyy format |
If Recurrence End Type is ‘UntilDate’ then this holds the last acceptable payment date |
Total Payments |
3n |
O |
If Recurrence End Type is ‘UntilNumberOfPayments’ then this holds the number of payments |
Key
30a |
30 Alpha numeric characters |
11n |
11 digit number |
18,2 |
A decimal number with up to 18 numbers before the decimal point and 2 numbers after the decimal point (2 places of decimal) |
O |
Optional Field |
M |
Mandatory Field |