thankQ Help
All Batch Merge Fields. Note that not all of these merge fields will appear in the order specified.
Merge Field Name |
Example Data |
Description |
ADMITNAME |
M1011
|
The mailing id given on creation of a mailing.
|
REF1 |
|
|
REF2 |
|
|
MAILINGDETAILSERIALNUMBER |
0000068 |
Can be used as the serial number of the contact but it is used when there are more than one Barcode Purpose IDs in a mailing.
|
GROUPID |
B02731
|
The Batch Id – example of receipt mailing.
|
USESERIALNUMBER |
|
Fields from the contact form merged into the Mailing under View Address Detail – Detail tab:
|
TOTTILE |
Ms |
|
TOFIRSTNAME |
Jenna |
|
TOKEYNAME |
Boyd |
|
TOOTHERINITIAL |
Bianca |
|
TOPOSTNOMINAL |
AM |
|
TOENVELOPESALUTATION |
Ms Jenna Boyd |
|
TOLETTERSALUTATION |
Jenna |
|
TOCONTACTPOSITION |
Accountant |
|
CAREOFPREFIX |
|
Under View Address Detail – Addressing tab:
|
CAREOF |
|
|
CAREOFENVELOPESALUTATION |
|
|
CAREOFCONTACTPOSITION |
|
|
ORGANISATIONNAME |
|
|
POSTCODE |
2065 |
|
MAILSORT |
|
|
MAILINGDETAILSUBADDRESS |
|
|
ADDESSLINE1 |
119 Enmore Lane |
|
ADDRESSLINE2 |
|
|
ADDRESSLINE3 |
Crows Nest |
|
ADDRESSLINE4 |
NSW |
|
ADDRESSCODE1 |
70330701 |
|
ADDRESSCODE2 |
1301012100101000210001301322030310013 |
|
ADDRESSCODE3 |
No full match (K0) |
|
SALESREGION |
|
|
COUNTRY |
Australia |
|
DAYTELEPHONE |
02 8987 7654 |
|
EVENINGTELEPHONE |
02 6371 5332 |
|
FAXNUMBER |
|
|
MOBILENUMBER |
0402 345 323 |
|
EMAILADDRESS |
esittraining5@gmail.com |
|
CCEMAIL |
|
|
CCTO |
|
|
DOTNOTMAIL |
0 |
Fields in the Mailing under View Address Detail – Detail tab:
|
DONOTMAILREASON |
|
|
NARRATIVE |
B02731 |
Fields in the Mailing under View Address Detail – Other Information tab:
|
INFORMATION |
|
|
PREFERREDMETHOD |
|
Field under Detail tab:
|
MAILSENT |
0 |
|
INCLUDETEXTREF |
|
Fields in the Mailing under View Address Detail – Include Text tab. Created when applying text rules in the mailing:
|
INCLUDETEXTNTHRULE |
|
|
INCLUDETEXTFILE |
|
|
BSPNUMBER |
|
Fields in the Mailing under View Address Detail – Detail tab:
|
BSPNAME |
|
|
MAILINGQUANTITY |
|
|
PARCELZONE |
|
Fields in the Mailing under View Address Detail – Sort Plan tab:
|
PRESORTINDICATOR |
|
|
CATEGORY |
|
|
COMMENT |
|
|
BPAYBILLERCODE |
|
Fields in the Mailing under View Address Detail – BPay Postbillpay tab:
|
BPAYREF |
|
|
BPAYCHECKSUM |
|
|
POSTBILLPAYCODE |
|
|
POSTBILLPAYREF |
|
|
POSTBILLPAYCHECKSUM |
|
|
POSTBILLPAYKEYINGLINE |
|
|
POSTBILLPAYBCPDESTR |
|
|
POSTBILLPAYBCODE |
|
|
BARCODEPURPOSEID |
|
On the Mail Manager form – enter when creating the mailing – for barcode scanning.
|
NEXTASK |
|
Setup under Canvassing & Prospecting, Next Ask can have between 1 to 5 different percentages asking for donors to increase their giving
|
NEXTASK2 |
|
|
NEXTASK3 |
|
|
NEXTASK4 |
|
|
NEXTASK5 |
|
|
LASTDONATION |
|
|
AVERAGEDONATION |
|
|
DONORTYPE |
|
|
RANKR |
|
Recently, Frequently and Monetary (RFM) module under Canvassing & Prospecting.
|
RANKF |
|
|
RANKM |
|
|
RFMSCORE |
|
|
CHARITYNUMBER |
|
|
VOLUNTEER |
-1 |
|
NOTABLEALUMNI |
0 |
|
DONOTVOLUNTEER |
0 |
|
OCCUPATION |
Teacher |
|
DATEOFBIRTH |
2/11/1987 |
|
GENDER |
Female |
|
MARITALSTATUS |
Single |
|
WEBSITE |
www.thankq.net.au |
|
PREVIOUSNAMES |
Raquel |
|
TAXSTATUS |
|
|
SERIALNUMBER |
0000068 |
Serial Number of the primary contact with this payment. |
HTMLNOTES |
|
|
COUNTAMOUNT |
5 |
Payment Summary tab
|
SUMAMOUNT |
1230 |
|
AVGAMOUNT |
246 |
|
MAXDATE |
2/05/2010 |
|
MAXAMOUNT |
450 |
|
MINDATE |
19/09/2004 |
|
LEADCONTACT |
0 |
|
JOINTSALUTATION |
Ms Jenna Boyd |
The household salutations associated directly with the contact being mailed e.g. if contact is a household sub-ordinate then these fields will be blank since only populated on head of household. |
JOINTLETTERSALUTATION |
Jenna |
|
DEFAULTTITLE |
|
Default Address of this contact, if applicable.
|
DEFAULTFIRSTNAME |
|
|
DEFAULTKEYNAME |
|
|
DEFAULTADDRESSLINE1 |
|
|
DEFAULTADDRESSLINE2 |
|
|
DEFAULTADDRESSLINE3 |
|
|
DEFAULTADDRESSLINE4 |
|
|
DEFAULTPOSTCODE |
|
|
DEFAULTCOUNTRY |
|
|
DEFAULTADDRESSCODE1 |
|
|
DEFAULTADDRESSCODE2 |
|
|
EXTERNALREF |
IMP90135 |
Audit Information if imported.
|
EXTERNALREFTYPE |
Data Import |
|
EXTERNALREFDATE |
18/04/2010 |
|
SUBADDRESS |
|
Mailing Preference field for this contact:
|
PLAINTEXTEMAIL |
-1 |
|
PICTUREFILE2 |
|
File used for the contact's secondary picture (used in Media group). |
DONOTCALL |
-1 |
|
DONOTPUBLISH |
-1 |
|
DONOTEMAIL |
-1 |
|
DONOTSMS |
-1 |
|
SECONDCONTACT |
|
Serial Number of the Second Organisation Contact if this is an organisational contact. |
CANVASSEE |
|
|
VOLSOURCE |
Internet |
|
VOLSPECIALREQ |
Chair Access |
|
EMERGENCYNAME |
Sam Smithers |
|
EMERGENCYNUMBER |
02 8897 4322 |
|
VOLUNTEERMANAGER |
Dr Elizabeth Weber - (0000010) |
|
CRMPRIMARYMANAGER |
training13 |
|
CRMSECONDARYMANAGER |
training12 |
|
CRMPLAN |
Bi-Monthly |
|
CRMREFERMANAGER |
-1 |
|
CRMNOTE |
CRM Note |
|
CCEMAILADDRESS |
|
|
CCNAME |
|
|
SOURCE |
Mailing |
This is the Contact Source or Source 2 NOT the Payment Source Code or Payment Source Code 2.
|
SOURCEDATE |
3/10/2017 |
|
SOURCE2 |
|
|
MEDICALREF1 |
|
|
MEDICALREF2 |
|
|
MEDICALREF2DATE |
|
|
DEFAULTRECEIPTREQUIRED |
Yes |
Default Receipts for this contact as well as the default payment Source Code 2.
|
DEFAULTRECEIPTSUMMARY |
No |
|
DEFAULTSOURCE2 |
09031CA |
|
TEMPMAINTITLE |
|
|
TEMPMAINFIRSTNAME |
|
|
TEMPMAINKEYNAME |
|
|
TEMPSECONARYTITLE |
|
|
TEMPSECONDARYFIRSTNAME |
|
|
TEMPSECONDARYKEYNAME |
|
|
DEFAULTRODUCTLEVEL |
|
|
CONFIGTEXT1 |
|
|
CONFIGTEXT2 |
|
|
CONFIGTEXT3 |
|
|
CONFIGTEXT4 |
|
|
CONFIGTEXT5 |
|
|
IC |
|
|
ICTYPE |
|
|
ALTTITLE |
|
|
ALTFIRSTNAME |
|
|
ALTKEYNAME |
|
|
ALTADDRESS |
|
|
SUMAMOUNTSOFT |
|
|
COUNTAMOUNTSOFT |
|
|
SUMAOUNTHARDNSOFT |
1230 |
|
COUNTAMOUNTHARDNSFOT |
5 |
|
REFERRALSOURCE |
|
|
QLDHEALTHREGION |
|
|
QLDREGION |
|
|
ISLANDER |
-1 |
Whether this contact is a Pacific Islander |
WRITTENPRIVACYCONSENTHELD |
|
|
VERBALPRIVACYCONSENTGIVEN |
|
|
NOTES |
|
|
BATCHID |
B02731 |
Payment Form
|
MAILINGBATCHPAYMENTSAUTOID_1 |
000000005898 |
|
DATEOFPAYMENT_1 |
3/10/2017 |
|
MAILINGBATCHPAYMENTSPAYMENTTYPE_1 |
Cash |
|
PAYMENTAMOUNT_1 |
100.00 |
|
TREATASANON_1 |
-1 |
|
CAMPAIGNYEAR_1 |
2018 |
|
NARRATIVE_1 |
Payment Notes (Narrative) |
Payment Form
|
BANKINGREFERENCE_1 |
|
|
MAILINGBATCHPAYMENTSAUTOID_2 |
|
|
DATEOFPAYMENT_2 |
|
|
MAILINGBATCHPAYMENTSPAYMENTTYPE_2 |
|
|
PAYMENTAMOUNT_2 |
|
|
TREATASANON_2 |
|
|
CAMPAIGNYEAR_2 |
|
|
NARRATIVE_2 |
|
|
BANKINGREFERENCE_2 |
|
|
MAILINGBATCHPAYMENTSAUTOID_3 |
|
|
DATEOFPAYMENT_3 |
|
|
MAILINGBATCHPAYMENTSPAYMENTTYPE_3 |
|
|
PAYMENTAMOUNT_3 |
|
|
TREATASANON_3 |
|
|
CAMPAIGNYEAR_3 |
|
|
NARRATIVE_3 |
|
|
BANKINGREFERENCE_3 |
|
|
MAILINGBATCHPAYMENTSAUTOID_4 |
|
|
DATEOFPAYMENT_4 |
|
|
MAILINGBATCHPAYMENTSPAYMENTTYPE_4 |
|
|
PAYMENTAMOUNT_4 |
|
|
TREATASANON_4 |
|
|
CAMPAIGNYEAR_4 |
|
|
NARRATIVE_4 |
|
|
BANKINGREFERENCE_4 |
|
|
MAILINGBATCHPAYMENTSAUTOID_5 |
|
|
DATEOFPAYMENT_5 |
|
|
MAILINGBATCHPAYMENTSPAYMENTTYPE_5 |
|
|
PAYMENTAMOUNT_5 |
|
|
TREATASANON_5 |
|
|
CAMPAIGNYEAR_5 |
|
|
NARRATIVE_5 |
|
|
BANKINGREFERENCE_5 |
|
|
RECEIPT |
Yes |
|
TOTALOFALLPAYMENTS |
100.00 |
|
TOTALOFALLTAX |
|
|
RECEIPTID_1 |
000000005898 |
|
MANUALRECEIPTID_1 |
Manual Receipt No |
|
PAYMENTTYPE_1 |
Cash |
|
RECEIPTAMOUNT_1 |
100.00 |
|
RECEIPTEXTAX_1 |
100.00 |
|
RECEIPTTAX_1 |
0.00 |
|
ORDERSUMMARY_1 |
|
|
RECEIPTID_2 |
|
|
MANUALRECEIPTID_2 |
|
|
PAYMENTTYPE_2 |
|
|
RECEIPTAMOUNT_2 |
|
|
RECEIPTEXTAX_2 |
|
|
RECEIPTTAX_2 |
0.00 |
|
ORDERSUMMARY_2 |
|
|
RECEIPTID_3 |
|
|
MANUALRECEIPTID_3 |
|
|
PAYMENTTYPE_3 |
|
|
RECEIPTAMOUNT_3 |
|
|
RECEIPTEXTAX_3 |
|
|
RECEIPTTAX_3 |
0.00 |
|
ORDERSUMMARY_3 |
|
|
RECEIPTID_4 |
|
|
MANUALRECEIPTID_4 |
|
|
PAYMENTTYPE_4 |
|
|
RECEIPTAMOUNT_4 |
|
|
RECEIPTEXTAX_4 |
|
|
RECEIPTTAX_4 |
0.00 |
|
ORDERSUMMARY_4 |
|
|
RECEIPTID_5 |
|
|
MANUALRECEIPTID_5 |
|
|
PAYMENTTYPE_5 |
|
|
RECEIPTAMOUNT_5 |
|
|
RECEIPTEXTAX_5 |
|
|
RECEIPTTAX_5 |
0.00 |
|
ORDERSUMMARY_5 |
|
|
AUTOID_1 |
000000005898 |
|
TRANSACTIONTYPE_1 |
Donation |
|
SPLITAMOUNT_1 |
$100.00 |
|
DESTINATIONCODE_1 |
07Appeal |
|
DESTINATIONDESC_1 |
All Direct Mail Campaigns for 2007 |
|
DESTINATIONCODE2_1 |
|
|
DESTINATION2DESC_1 |
|
|
SOURECODE_1 |
DONATE |
|
SOURCEDESC_1 |
Donate |
|
SOURCECODE2_1 |
09031CA |
|
SOURCE2DESC_1 |
Christmas 2009 Segment 31 Copy A |
|
GOODSTAX_1 |
$0.00 |
|
TAXCLAIMABLE_1 |
|
|
LINKEDMEMBERSUMMARY_1 |
|
|
AUTOID_2 |
|
|
TRANSACTIONTYPE_2 |
|
|
SPLITAMOUNT_2 |
|
|
DESTINATIONCODE_2 |
|
|
DESTINATIONDESC_2 |
|
|
DESTINATIONCODE2_2 |
|
|
DESTINATION2DESC_2 |
|
|
SOURECODE_2 |
|
|
SOURCEDESC_2 |
|
|
SOURCECODE2_2 |
|
|
SOURCE2DESC_2 |
|
|
GOODSTAX_2 |
|
|
TAXCLAIMABLE_2 |
|
|
LINKEDMEMBERSUMMARY_2 |
|
|
AUTOID_3 |
|
|
TRANSACTIONTYPE_3 |
|
|
SPLITAMOUNT_3 |
|
|
DESTINATIONCODE_3 |
|
|
DESTINATIONDESC_3 |
|
|
DESTINATIONCODE2_3 |
|
|
DESTINATION2DESC_3 |
|
|
SOURECODE_3 |
|
|
SOURCEDESC_3 |
|
|
SOURCECODE2_3 |
|
|
SOURCE2DESC_3 |
|
|
GOODSTAX_3 |
|
|
TAXCLAIMABLE_3 |
|
|
LINKEDMEMBERSUMMARY_3 |
|
|
AUTOID_4 |
|
|
TRANSACTIONTYPE_4 |
|
|
SPLITAMOUNT_4 |
|
|
DESTINATIONCODE_4 |
|
|
DESTINATIONDESC_4 |
|
|
DESTINATIONCODE2_4 |
|
|
DESTINATION2DESC_4 |
|
|
SOURECODE_4 |
|
|
SOURCEDESC_4 |
|
|
SOURCECODE2_4 |
|
|
SOURCE2DESC_4 |
|
|
GOODSTAX_4 |
|
|
TAXCLAIMABLE_4 |
|
|
LINKEDMEMBERSUMMARY_4 |
|
|
AUTOID_5 |
|
|
TRANSACTIONTYPE_5 |
|
|
SPLITAMOUNT_5 |
|
|
DESTINATIONCODE_5 |
|
|
DESTINATIONDESC_5 |
|
|
DESTINATIONCODE2_5 |
|
|
DESTINATION2DESC_5 |
|
|
SOURECODE_5 |
|
|
SOURCEDESC_5 |
|
|
SOURCECODE2_5 |
|
|
SOURCE2DESC_5 |
|
|
GOODSTAX_5 |
|
|
TAXCLAIMABLE_5 |
|
|
LINKEDMEMBERSUMMARY_5 |
|
|
AUTOID_6 |
|
|
TRANSACTIONTYPE_6 |
|
|
SPLITAMOUNT_6 |
|
|
DESTINATIONCODE_6 |
|
|
DESTINATIONDESC_6 |
|
|
DESTINATIONCODE2_6 |
|
|
DESTINATION2DESC_6 |
|
|
SOURECODE_6 |
|
|
SOURCEDESC_6 |
|
|
SOURCECODE2_6 |
|
|
SOURCE2DESC_6 |
|
|
GOODSTAX_6 |
|
|
TAXCLAIMABLE_6 |
|
|
LINKEDMEMBERSUMMARY_6 |
|
|
AUTOID_7 |
|
|
TRANSACTIONTYPE_7 |
|
|
SPLITAMOUNT7 |
|
|
DESTINATIONCODE7 |
|
|
DESTINATIONDESC7 |
|
|
DESTINATIONCODE27 |
|
|
DESTINATION2DESC7 |
|
|
SOURECODE_7 |
|
|
SOURCEDESC_7 |
|
|
SOURCECODE2_7 |
|
|
SOURCE2DESC_7 |
|
|
GOODSTAX_7 |
|
|
TAXCLAIMABLE_7 |
|
|
LINKEDMEMBERSUMMARY_7 |
|
|
AUTOID_8 |
|
|
TRANSACTIONTYPE_8 |
|
|
SPLITAMOUNT_8 |
|
|
DESTINATIONCODE_8 |
|
|
DESTINATIONDESC_8 |
|
|
DESTINATIONCODE2_8 |
|
|
DESTINATION2DESC_8 |
|
|
SOURECODE_8 |
|
|
SOURCEDESC_8 |
|
|
SOURCECODE2_8 |
|
|
SOURCE2DESC_8 |
|
|
GOODSTAX_8 |
|
|
TAXCLAIMABLE_8 |
|
|
LINKEDMEMBERSUMMARY_8 |
|
|
AUTOID_9 |
|
|
TRANSACTIONTYPE_9 |
|
|
SPLITAMOUNT_9 |
|
|
DESTINATIONCODE_9 |
|
|
DESTINATIONDESC_9 |
|
|
DESTINATIONCODE2_9 |
|
|
DESTINATION2DESC_9 |
|
|
SOURECODE_9 |
|
|
SOURCEDESC_9 |
|
|
SOURCECODE2_9 |
|
|
SOURCE2DESC_9 |
|
|
GOODSTAX_9 |
|
|
TAXCLAIMABLE_9 |
|
|
LINKEDMEMBERSUMMARY_9 |
|
|
AUTOID_10 |
|
|
TRANSACTIONTYPE_10 |
|
|
SPLITAMOUNT_10 |
|
|
DESTINATIONCODE_10 |
|
|
DESTINATIONDESC_10 |
|
|
DESTINATIONCODE2_10 |
|
|
DESTINATION2DESC_10 |
|
|
SOURECODE_10 |
|
|
SOURCEDESC_10 |
|
|
SOURCECODE2_10 |
|
|
SOURCE2DESC_10 |
|
|
GOODSTAX_10 |
|
|
TAXCLAIMABLE_10 |
|
|
LINKEDMEMBERSUMMARY_10 |
|
|
ADMITNAME1 |
M1011 |
|
SERIALNUMBER1 |
0000068 |
|
ADDITIONALID1 |
None_000000005898 |
|
PARAMETERVALUE1 to 100 |
(Varies) |
See Field Rules for more information. |
