The Payments template is used to import Payment History 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 payment history to.
| 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. |
| BatchCode | nvarchar(150) | The Batch the payment was processed in. This is to provide traceability back to your legacy system. |
| PaymentDate | datetime | The date the payment was processed in the date format dd-mmm-yyyy, for example, 10-OCT-2016. |
| Amount | money | The amount of the payment. |
| Campaign | nvarchar(150) | The name of the Campaign that the 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. |
| Category | nvarchar(150) | The name of the Category that the 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. |
| PaymentType | nvarchar(50) | The type of payment. This must be one of the valid Pay Types configured in Vega. |
| Bank | nvarchar(50) | For cheque and bank deposits optionally enter the Bank code for the payment. |
| Branch | nvarchar(50) | For cheque and bank deposits optionally enter the Branch code for the payment. |
| Account | nvarchar(50) | For cheque and bank deposits optionally enter the Account code for the payment. |
| AccountName | nvarchar(50) | Optionally enter the payee details. |
| GiftFromFirstName | nvarchar(150) | For Membership payments, optionally enter the first name of the Contact who gifted the membership. |
| GiftFromLastName | nvarchar(150) | For Membership payments, optionally enter the last name of the Contact who gifted the membership. |
| GiftFromEmailAddress | nvarchar(150) | For Membership payments, optionally enter the email address of the Contact who gifted the membership. |
Comments
0 comments
Please sign in to leave a comment.