thankQ Help
Merge Field Name |
Example Data |
Description |
ADMITNAME |
MS00293 |
The mailing id given on creation of a mailing |
MAILINGDETAILSERIALNUMBER |
0000001 |
Can be used as the serial number of the contact but it is used when there are more than one barcode purpose id’s in a mailing
|
GROUPID |
Letter |
|
EXTERNALREFID |
BKG000078 |
Used to store the record identifier when generating a mailing from another module e.g. generating a booking mailing would cause the booking ID to be recorded here. |
USESERIALNUMBER |
|
Serial number or address ID of the address record associated with that contact for that mailing |
TOTITLE |
Ms |
|
TOFIRSTNAME |
Jane |
|
TOKEYNAME |
Smith |
|
TOOTHERINITIAL |
|
|
TOPOSTNOMINAL |
|
|
PREVIOUSNAMES |
|
|
NICKNAME |
|
|
|
|
|
TOLETTERSALUTATION |
|
|
TOENVELOPESALUTATION |
Ms Jane Smith |
|
JOINTSALUTATION |
Ms Jane Smith & Mr Josh Lucas |
|
JOINTLETTERSALUTATION |
Jane & Josh |
|
|
|
|
CAREOF |
|
|
ORGANISATIONNAME |
|
|
POSTCODE |
2203 |
|
ADDRESSLINE1 |
11 Balfour Street |
|
ADDRESSLINE2 |
|
|
ADDRESSLINE3 |
DULWICH HILL |
|
ADDRESSLINE4 |
NSW |
|
COUNTRY |
|
|
DAYTELEPHONE |
02 9119 9009 |
|
EVENINGTELEPHONE |
02 82275 2801 |
|
FAXNUMBER |
02 9115 5113 |
|
MOBILENUMBER |
0414 931 6549 |
|
EMAILADDRESS |
janesmith@gmail.com |
|
CAREOFENVELOPESALUTATION |
|
|
CAREOFLETTERSALUTATION |
|
|
CAREOFCONTACTPOSITION |
|
|
|
|
|
CCEMAIL |
|
|
CCTO |
|
|
ADDRESSCODE1 |
00000000 |
|
ADDRESSCODE2 |
00000000000000 |
|
ADDRESSCODE3 |
|
|
PREFERREDMETHOD |
Letter |
|
SALESREGION |
GRAYNDLER |
|
MAILINGDETAILSUBADDRESS |
|
Under Mailing Preferences |
|
|
|
DONOTMAIL |
0 |
|
DONOTMAILREASON |
|
|
DONOTCALL |
0 |
|
DONOTEMAIL |
|
|
|
|
|
MAILSENT |
0 |
This would only be populated once a mailing had been completed. |
|
|
|
INCLUDETEXTREF |
|
Used with Include Text Rules
|
INCLUDETEXTNTHRULE |
|
|
INCLUDETEXTFILE |
|
|
MAILSORT |
|
Used with Mailsort
|
BSPNUMBER |
|
|
BSPNAME |
|
|
PARCELZONE |
|
|
PRESORTINDICATOR |
|
|
CATEGORY |
|
|
COMMENT |
|
|
MAILINGQUANTITY |
|
This can be set under Mailing Preferences and can be used to specify how many letters/brochures etc to insert into an envelope as some customers may request extra copies. |
INFORMATION |
|
|
NARRATIVE |
|
|
|
|
|
BPAYBILLERCODE |
|
Used to generate BPay information |
BPAYREF |
|
|
BPAYCHECKSUM |
|
|
POSTBILLPAYCODE |
|
Used to generate Post Bill Pay |
POSTBILLPAYREF |
|
|
POSTBILLPAYCHECKSUM |
|
|
BARCODEPURPOSEID |
|
|
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 module under Canvassing & Prospecting
|
RANKF |
|
|
RANKM |
|
|
RFMSCORE |
|
|
CAREOFPREFIX |
|
|
CHARITYNUMBER |
|
|
OCCUPATION |
Accountant |
|
DATEOFBIRTH |
20/09/1972 |
|
GENDER |
Female |
|
MARITALSTATUS |
Married |
|
WEBSITE |
|
|
TOCONTACTPOSITION |
Executive Director |
|
|
|
|
TAXSTATUS |
|
|
SOURCE |
|
|
SOURCE2 |
|
|
SOURCEDATE |
|
|
|
|
|
RECORDOWNER |
|
|
CREATED |
2004-10-19 11:31:09.0000000 |
|
CREATEDBY |
ADMiT |
|
MODIFIED |
2017-02-01 11:08:03.4000000 |
|
MODIFIEDBY |
training13 |
|
SEGMENT |
|
Mailing segment |
SERIALNUMBER |
0000001 |
|
HTMLNOTES |
<p>Membership MBR000000001 archived by training13 on 28/02/2012 11:54:54 AM </p> |
Information under the Notes tab |
COUNTAMOUNT |
114 |
|
SUMAMOUNT |
35263.34 |
|
MAXAMOUNT |
5000 |
|
AVGAMOUNT |
309.3275 |
|
MAXDATE |
13/05/2019 |
|
MINDATE |
1/01/2003 |
|
LEADCONTACT |
-1 |
|
DEFAULTTITLE |
|
|
DEFAULTFIRSTNAME |
|
|
DEFAULTKEYNAME |
|
|
DEFAULTADDRESSLINE1 |
|
|
DEFAULTADDRESSLINE2 |
|
|
DEFAULTADDRESSLINE3 |
|
|
DEFAULTADDRESSLINE4 |
|
|
DEFAULTPOSTCODE |
|
|
DEFAULTCOUNTRY |
|
|
DEFAULTADDRESSCODE2 |
|
|
EXTERNALREF |
IMP90154 |
|
EXTERNALREFTYPE |
Data Import |
|
EXTERNALREFDATE |
23/10/2012 1:01:35 PM |
|
SUBADDRESS |
|
|
PLAINTEXTEMAIL |
|
|
PICTUREFILE2 |
|
|
SECONDCONTACT |
|
|
CANVASSEE |
|
|
VOLUNTEER |
|
|
DONOTPUBLISH |
|
|
VOLSOURCE |
|
|
VOLSPECIALREQ |
|
|
EMERGENCYNAME |
|
|
EMERGENCYNUMBER |
|
|
VOLUNTEERMANAGER |
|
|
DONOTVOLUNTEER |
0 |
|
NOTABLEALUMNI |
|
|
|
|
|
CRMPRIMARYMANAGER |
training13 |
|
CRMSECONDARYMANAGER |
manager1 |
|
CRMPLAN |
|
|
CRMREFERMANAGER |
0 |
|
CRMNOTE |
|
|
CCEMAILADDRESS |
|
|
CCNAME |
|
|
MEDICALREF1 |
|
|
MEDICALREF2 |
|
|
MEDICALREF2DATE |
|
|
DEFAULTRECEIPTREQUIRED |
|
|
DEFAULTRECEIPTSUMMARY |
|
|
DEFAULTSOURCE2 |
|
|
|
|
|
TEMPMAINTITLE |
|
|
TEMPMAINFIRSTNAME |
|
|
TEMPMAINKEYNAME |
|
|
TEMPSECONDARYTITLE |
|
|
TEMPSECONDARYFIRSTNAME |
|
|
TEMPSECONDARYKEYNAME |
|
|
DEFAULTPRODUCTLEVEL |
|
|
CONFIGTEXT1 |
|
|
CONFIGTEXT2 |
|
|
CONFIGTEXT3 |
|
|
CONFIGTEXT4 |
|
|
CONFIGTEXT5 |
|
|
IC |
|
|
ICTYPE |
|
|
ALTTITLE |
|
|
ALTADDRESS |
|
|
SUMAMOUNTSOFT |
2962 |
|
COUNTAMOUNTSOFT |
26 |
|
SUMAMOUNTHARDNSOFT |
38225.34 |
|
COUNTAMOUNTHARDNSOFT |
140 |
|
REFERRALSOURCE |
|
|
QLDHEALTHREGION |
|
|
QLDREGION |
|
|
ISLANDER |
|
|
WRITTENPRIVACYCONSENTHELD |
|
|
VERBALPRIVACYCONSENTGIVEN |
|
|
NOTES |
|
|
PLEDGESTATUS |
Active |
|
DESCRIPTION |
|
|
PLEDGEPLAN |
Fixed |
|
PLEDGETYPE |
Single Payment |
|
CURRENCY |
$ (AUD) |
|
SOURCECODE |
19_BO_TICK |
|
SOURCECODE2 |
|
|
RECEIPTREQUIRED |
Yes |
|
RECEIPTSUMMARY |
No |
|
RECEIPTFREQUENCY |
|
|
NEXTRECEIPTDATE |
|
|
STARTDATE |
3/11/2010 |
|
ENDDATE |
3/11/2010 |
|
TOTALVALUE |
150.00 |
|
INSTALMENTVALUE |
150.00 |
|
PAYMENTFREQUENCY |
One Off |
|
MAXPAYMENTS |
1 |
|
CAMPAIGNYEAR |
|
|
PAYMENTTYPE |
Credit Card |
|
ONEOFF |
|
|
|
|
|
ACCOUNTNAME |
|
|
SORTCODE |
|
|
ACCOUNTNUMBER |
|
|
ROLLNUMBER |
|
|
TEXT2 |
|
|
BANKNAME |
|
|
BANKADDRESS |
|
|
BANKPOSTCODE |
|
|
CREDITCARDTYPE |
Visa |
|
CREDITCARDNUMBER |
|
|
CREDITCARDHOLDER |
Jane Smith |
|
CREDITCARDEXPIRY |
10/21 |
|
CREDITCARDISSUENUMBER |
|
|
CREDITCARDMETHOD |
|
|
PLEDGERECRUITEDBY |
|
|
PLEDGERECRUITEDBYEVENT |
|
|
PLEDGECREATED |
3/11/2010 12:37:03 PM |
|
PLEDGECREATEDBY |
training13 |
|
PLEDGEMODIFIED |
16/09/2019 9:59:26 AM |
|
PLEDGEMODIFIEDBY |
ADMiT |
|
PLEDGEEXTERNALREF |
DINESI002 |
|
PLEDGEEXTERNALREFTYPE |
Booking |
|
ESCALATIONLETTER |
0 |
|
LASTESCALATIONDATE |
|
|
TAXCLAIMABLE |
|
|
MEMBERSHIP |
|
|
MEMBERSHIPID |
|
|
SUBSCRIPTION |
|
|
SUBSCRIPTIONID |
|
|
NEW |
|
|
EXISTING |
|
|
RECOVERED |
|
|
ACKNOWLEDGE |
|
|
ACKNOWLEDGEDATE |
|
|
ACKNOWLEDGELETTER |
|
|
TOTALPAID |
0.00 |
|
OUTSTANDING |
150.00 |
|
ORIGINALTOTALVALUE |
150.00 |
|
TITLE |
Ms |
|
FIRSTNAME |
Jane |
|
KEYNAME |
Smith |
|
SERIALNUMBER1 |
0000001 |
|
ADDITIONALID1 |
BKG000078 |
|
|
|
|
WRITTENDOWNREASON |
|
|
WRITTENDOWN |
|
|
WRITTENDOWNBY |
|
|
ONHOLDREASON |
|
|
ONHOLDDATETIME |
|
|
ONHOLDBY |
|
|
PLEDGENOTES |
|
|
|
|
|
REMINDER |
Yes |
|
SOURCEDESCRIPTION |
2019 Annual Bake Off |
|
INVOICEID |
BKG000078/3 |
|
INVOICESTATUS |
Pending |
|
DATEINVOICED |
16/09/19 |
|
DATEPAID |
|
|
AMOUNTINVOICED |
$150.00 |
|
MAILINGID |
MS00293 |
|
INVOICECREATED |
16/09/2019 10:11:53 AM |
|
INVOICECREATEDBY |
ADMiT |
|
INVOICEMODIFIED |
16/09/2019 10:11:53 AM |
|
INVOICEMODIFIEDBY |
ADMiT |
|
DATECANCELLED |
|
|
AMOUNTADJUSTED |
$0.00 |
|
AMOUNTPAID |
$0.00 |
|
INVOICESUMMARY |
Booking for ESIT Winter Dinner 1 $150.00 $0.00 $150.00 $13.64 |
|
AMOUNTGST |
$13.64 |
|
AMOUNTNETT |
$136.36 |
|
AMOUNTDUE |
$150.00 |
|
ADMITNAME1 |
MS00293 |
|
View the Finance Merge fields for Parrmatervalues |
|
|
ORDERID |
|
|
ORDERID |
|
|
SENDON |
|
|
SPECIALINSTRUCTIONS |
|
|
SUPERSEDESORDERID |
|
|
ORDERDATE |
|
|
WEIGHT |
|
|
INVOICETITLE |
|
|
INVOICEFIRSTNAME |
|
|
INVOICEKEYNAME |
|
|
INVOICEENVELOPESALUTATION |
|
|
INVOICELETTERSALUTATION |
|
|
INVOICECOUNTRY |
|
|
INVOICEPOSTCODE |
|
|
INVOICEADDRESSLINE1 |
|
|
INVOICEADDRESSLINE2 |
|
|
INVOICEADDRESSLINE3 |
|
|
INVOICEADDRESSLINE4 |
|
|
INVOICEDONOTMAIL |
|
|
DELIVERYTITLE |
|
|
DELIVERYFIRSTNAME |
|
|
DELIVERYKEYNAME |
|
|
DELIVERYENVELOPESALUTATION |
|
|
DELIVERYLETTERSALUTATION |
|
|
DELIVERYCOUNTRY |
|
|
DELIVERYPOSTCODE |
|
|
DELIVERYADDRESSLINE1 |
|
|
DELIVERYADDRESSLINE2 |
|
|
DELIVERYADDRESSLINE3 |
|
|
DELIVERYADDRESSLINE4 |
|
|
DELIVERYDONOTMAIL |
|
|
