The Aida - New template is used to import Contact and Recurring Payment, or One-Off payment details for your Contacts. You can either use the Vega Contact ID, ScoperID or First name, last name and email address, address 1 or mobile to identify or insert the Contact to add the recurring payment and one-off payment history.
|
Template FieldName |
Field Type (Length) |
Notes |
| SerialNo |
nvarchar(150) |
ID from Aida. Maps to Reference field in Payment and Recurring Payment records |
|
BatchNumber |
nvarchar(150) |
Include - Cancelled and then payment will be set to cancelled |
|
SignupDate |
datetime |
Accepts formats yyyy-mm-dd or dd-mmm-yyyy |
|
AgentName |
nvarchar(150) |
|
|
AgentID |
nvarchar(150) |
|
|
Team Name |
nvarchar(150) |
|
|
ReportDate |
datetime |
Accepts formats yyyy-mm-dd or dd-mmm-yyyy |
|
Organisation |
nvarchar(150) |
|
|
Title |
nvarchar(150) |
|
|
FirstName |
nvarchar(150) |
|
|
Surname |
nvarchar(150) |
|
|
Gender |
nvarchar(150) |
|
|
DateofBirth |
datetime |
Accepts formats yyyy-mm-dd or dd-mmm-yyyy |
|
Occupation |
nvarchar(150) |
|
|
Address1 |
nvarchar(150) |
|
|
Address2 |
nvarchar(150) |
|
|
Address3 |
nvarchar(150) |
|
|
Suburb |
nvarchar(150) |
|
|
City |
nvarchar(150) |
|
|
Postcode |
nvarchar(150) |
|
|
HomePhone |
nvarchar(150) |
|
|
WorkPhone |
nvarchar(150) |
|
|
Mobile |
nvarchar(150) |
|
|
|
nvarchar(150) |
|
|
EmailOK |
nvarchar(150) |
|
|
SupplierLocation |
nvarchar(150) |
|
|
LocationType |
nvarchar(150) |
|
|
PaymentMethod |
nvarchar(150) |
|
|
BankName |
nvarchar(150) |
|
|
BSB |
nvarchar(150) |
|
|
BankAccount |
nvarchar(150) |
|
|
BankAccountName |
nvarchar(150) |
|
|
CCType |
nvarchar(150) |
|
|
CCExpiry |
nvarchar(20) |
Accepts MM/YY |
|
MaskCCNumber |
nvarchar(150) |
|
|
NameOnCard |
nvarchar(150) |
|
|
PledgeAmount |
money |
Remove any leading $ characters |
|
PaymentFrequency |
nvarchar(150) |
|
|
FirstRecurringPaymentDate |
datetime |
Accepts formats yyyy-mm-dd or dd-mmm-yyyy |
|
45DayDate |
datetime |
Accepts formats yyyy-mm-dd or dd-mmm-yyyy |
|
60DayDate |
datetime |
Accepts formats yyyy-mm-dd or dd-mmm-yyyy |
|
100DayDate |
datetime |
Accepts formats yyyy-mm-dd or dd-mmm-yyyy |
|
SMSDate |
datetime |
Accepts formats yyyy-mm-dd or dd-mmm-yyyy |
|
SMSOutcome |
nvarchar(150) |
|
|
EmailDate |
datetime |
Accepts formats yyyy-mm-dd or dd-mmm-yyyy |
|
EmailOutcome |
nvarchar(150) |
|
|
WelcomeCallDate |
datetime |
Accepts formats yyyy-mm-dd or dd-mmm-yyyy |
|
WelcomeCallOutcome |
nvarchar(150) |
|
|
PaymentStatus |
nvarchar(150) |
Accepts Payment Open, Payment Suspended and Payment Closed. Cancelled will set the RP status to Payment Closed |
|
Campaign |
nvarchar(150) |
Required. Must be an active Campaign Action under the Signature Programme Campaign |
|
GLCode |
nvarchar(150) |
Required. Must be an active GL Code |
|
Notes |
nvarchar(500) |
|
|
Token ID |
nvarchar(150) |
|
|
Token Charge ID |
nvarchar(150) |
|
|
1st Instant Payment Amount |
money |
Remove any leading $ characters |
|
1st Instant Payment Date |
datetime |
Accepts formats yyyy-mm-dd or dd-mmm-yyyy |
|
1st Payment Successful(Y/N) |
nvarchar(10) |
Accepts Y or N |
Comments
0 comments
Article is closed for comments.