The Recurring template is used to import Recurring Payment details for your Contacts. You can either use the Vega Contact ID, ScoperID or First name, last name and email address to identify the Contact to add the recurring payment history.
| Template FieldName | Field Type (Length) | Notes |
| ID | nvarchar(15) | This is used where provided to match to the correct Contact record in Vega using the Vega Contact ID. |
| ScoperID | nvarchar(20) | This is used where provided to match to the correct Contact record in Vega using your legacy unique ID. |
| First Name | nvarchar(150) | This is used where provided to match to the correct Contact record in Vega using the Contacts First Name, Last Name and Email Address. |
| Last Name | nvarchar(150) | This is used where provided to match to the correct Contact record in Vega using the Contacts First Name, Last Name and Email Address. |
| Email Address | nvarchar(150) | This is used where provided to match to the correct Contact record in Vega using the Contacts First Name, Last Name and Email Address. |
| PayType | nvarchar(50) | The Recurring payment type. This must be a valid Pay Type in Vega. Recurring Payments can be set up for payment types other than Credit/Debit Card but no 'processing' of these payment types will occur automatically in Vega. |
| DonationAmt | money | The amount of the recurring payment. |
| CardName | nvarchar(250) | Optionally enter the Card Name |
| CardNumber | nvarchar(150) | Optionally enter the masked Card Number if provided from your payment gateway. |
| Campaign | nvarchar(50) | The name of the Campaign that the recurring payment related to. This can be set to a default value, for example, Initial Data Migration where there is no equivalent in your legacy system. |
| Distribution | nvarchar(50) | The GL Account the payment is to be applied to. |
| Frequency | nvarchar(50) | The frequency that the payment is to be applied. This must be one of the valid frequency set up in Vega. |
| StartDate | datetime | The date that the recurring payment started. |
| Token | nvarchar(150) | The payment gateway token or identifier for the Card to be charged. |
Comments
0 comments
Please sign in to leave a comment.