thankQ Help
Merge Field Name |
Example Data |
Description |
|
ADMITNAME |
M0854 |
The mailing id given on creation of a mailing
|
|
REF1 |
|
||
REF2 |
|
||
MAILINGDETAILSERIALNUMBER |
0000970 |
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 |
|
0000970 The id of a contact, search or group loaded into the mailing
|
|
USESERIALNUMBER |
|
Serial number or address ID of the address record associated with that contact for that mailing |
|
TOTTILE |
Mr |
If the resolved address is that associated with an Organisation then the name of the Organisation will be set under ORGANISATIONNAME.
|
|
TOFIRSTNAME |
Craig |
||
TOKEYNAME |
Nelson |
||
TOOTHERINITIAL |
|
||
NICKNAME |
|
||
ORGANISATIONNAME |
|
||
TOENVELOPESALUTATION |
Mr Craig Nelson |
|
|
TOLETTERSALUTATION
If Apply Households and/or Joint Salutations is applied in a mailing the H/H Envelope and Letter salutations will be used |
Craig |
||
CAREOFPREFIX |
c/o |
|
|
CAREOF |
|
||
ADDESSLINE1 |
GROUND FLOOR |
||
ADDRESSLINE2 |
35 PHILLIP STREET |
||
ADDRESSLINE3 |
SYDNEY |
||
ADDRESSLINE4 |
NSW |
||
POSTCODE |
2000 |
||
COUNTRY |
|
||
MAILINGDETAILSUBADDRESS |
|
||
PREFERREDMETHOD |
|
|
|
ADDRESSCODE1 |
54042813 |
||
ADDRESSCODE2 |
1301011211001102220110312001203100213 |
||
ADDRESSCODE3 |
|
||
|
|
||
CAREOFENVELOPESALUTATION |
No Longer used |
|
|
CAREOFCONTACTPOSITION |
|
||
SALESREGION |
|
||
DAYTELEPHONE |
|
|
|
EVENINGTELEPHONE |
|
||
FAXNUMBER |
|
||
MOBILENUMBER |
|
||
EMAILADDRESS |
esittraining5@gmail.com |
||
CCEMAIL |
|
||
CCTO |
|
||
DOTNOTMAIL |
0 |
|
|
DONOTMAILREASON |
|
||
MAILSENT |
|
This is only populated once a mailing had been completed. |
|
Include Text Rules merge fields ONLY |
|||
INCLUDETEXTREF |
|
Used with Include Text Rules
|
|
INCLUDETEXTNTHRULE |
|
||
INCLUDETEXTFILE |
|
||
Mailsort merge fields ONLY |
|||
MAILSORT |
|
|
|
BSPNUMBER |
|
||
BSPNAME |
|
||
PARCELZONE |
|
||
PRESORTINDICATOR |
|
||
CATEGORY |
|
||
COMMENT |
|
Not Used |
|
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. |
|
NARRATIVE |
17C2S |
Narrative is used to store search criteria relevant to the mailing in question e.g. the search applied when generating a mailing from the membership form.
|
|
INFORMATION |
|
||
BPay merge fields ONLY |
|||
BPAYBILLERCODE |
|
Used to generate BPay information |
|
BPAYREF |
|
||
BPAYCHECKSUM |
|
||
Post Bill Pay merge fields ONLY |
|
||
POSTBILLPAYCODE |
|
Used to generate Post Bill Pay |
|
POSTBILLPAYREF |
|
||
POSTBILLPAYCHECKSUM |
|
||
POSTBILLPAYKEYINGLINE |
|
||
POSTBILLPAYBCPDESTR |
|
||
POSTBILLPAYBCODE |
|
||
BARCODEPURPOSEID |
|
||
Next Ask merge fields ONLY |
|||
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 |
|
||
RFM merge fields ONLY |
|||
RANKR |
|
Recently Frequently and Monetary module under Canvassing & Prospecting
|
|
RANKF |
|
||
RANKM |
|
||
RFMSCORE |
|
||
TOCONTACTPOSITION |
|
|
|
WEBSITE |
|
Not Used |
|
CHARITYNUMBER |
|
Not Used |
|
OCCUPATION |
|
Not Used |
|
DATEOFBIRTH |
|
Not Used |
|
GENDER |
|
Not Used |
|
PREVIOUSNAMES |
|
Not Used |
|
MARITALSTATUS |
|
Not Used |
|
TAXSTATUS |
|
Not Used |
|
Sessions on an Event |
|
||
SESSION1 |
End of Day Get Together |
|
|
SESSIONSTARTDATE1 |
28/10/2017 |
||
SESSIONSTARTIME1 |
17:00 |
||
SESSIONENDDATE1 |
28/10/2017 |
||
SESSIONENTTIME1 |
|
||
SESSION2 |
|
||
SESSIONSTARTDATE2 |
|
||
SESSIONSTARTIME2 |
|
||
SESSIONENDDATE2 |
|
||
SESSIONENTTIME2 |
|
||
SESSION3 |
|
||
SESSIONSTARTDATE3 |
|
||
SESSIONSTARTIME3 |
|
||
SESSIONENDDATE3 |
|
||
SESSIONENTTIME3 |
|
||
SESSION4 |
|
||
SESSIONSTARTDATE4 |
|
||
SESSIONSTARTIME4 |
|
||
SESSIONENDDATE4 |
|
||
SESSIONENTTIME4 |
|
||
SESSION5 |
|
||
SESSIONSTARTDATE5 |
|
||
SESSIONSTARTIME5 |
|
||
SESSIONENDDATE5 |
|
||
SESSIONENTTIME5 |
|
||
SESSION6 |
|
||
SESSIONSTARTDATE6 |
|
||
SESSIONSTARTIME6 |
|
||
SESSIONENDDATE6 |
|
||
SESSIONENTTIME6 |
|
||
SESSION7 |
|
||
SESSIONSTARTDATE7 |
|
||
SESSIONSTARTIME7 |
|
||
SESSIONENDDATE7 |
|
||
SESSIONENTTIME7 |
|
||
SESSION8 |
|
||
SESSIONSTARTDATE8 |
|
||
SESSIONSTARTIME8 |
|
||
SESSIONENDDATE8 |
|
||
SESSIONENTTIME8 |
|
||
SESSION9 |
|
||
SESSIONSTARTDATE9 |
|
||
SESSIONSTARTIME9 |
|
||
SESSIONENDDATE9 |
|
||
SESSIONENTTIME9 |
|
||
SESSION10 |
|
||
SESSIONSTARTDATE10 |
|
||
SESSIONSTARTIME10 |
|
||
SESSIONENDDATE10 |
|
||
SESSIONENTTIME10 |
|
||
Structures on an Event |
|||
STRUCTURETYPE1 |
Row |
|
|
STRUCTUREDESC1 |
Which Row |
||
STRUCTURETYPE2 |
|
||
STRUCTUREDESC2 |
|
||
STRUCTURETYPE3 |
|
||
STRUCTUREDESC3 |
|
||
STRUCTURETYPE4 |
|
||
STRUCTUREDESC4 |
|
||
STRUCTURETYPE5 |
|
||
STRUCTUREDESC5 |
|
||
STRUCTURETYPE6 |
|
||
STRUCTUREDESC6 |
|
||
STRUCTURETYPE7 |
|
||
STRUCTUREDESC7 |
|
||
STRUCTURETYPE8 |
|
||
STRUCTUREDESC8 |
|
||
STRUCTURETYPE9 |
|
||
STRUCTUREDESC9 |
|
||
STRUCTURETYPE10 |
|
||
STRUCTUREDESC10 |
|
||
Booking Information |
|||
BOOKINGID1 |
BKG000191 |
|
|
DATEBOOKED1 |
24/10/2017 |
|
|
PLACESBOOKED1 |
2 |
|
|
TOTALCOST1 |
100.00 |
|
|
DISCOUNT1 |
0.00 |
|
|
TOTALPAID1 |
100.00 |
|
|
TOTALOUTSTANDING1 |
0.00 |
|
|
BOOKINGID2 |
|
||
DATEBOOKED2 |
|
||
PLACESBOOKED2 |
|
||
TOTALCOST2 |
|
||
DISCOUNT2 |
|
||
TOTALPAID2 |
|
||
TOTALOUTSTANDING2 |
|
||
BOOKINGID3 |
|
||
DATEBOOKED3 |
|
||
PLACESBOOKED3 |
|
||
TOTALCOST3 |
|
||
DISCOUNT3 |
|
||
TOTALPAID3 |
|
||
TOTALOUTSTANDING3 |
|
||
BOOKINGID4 |
|
||
DATEBOOKED4 |
|
||
PLACESBOOKED4 |
|
||
TOTALCOST4 |
|
||
DISCOUNT4 |
|
||
TOTALPAID4 |
|
||
TOTALOUTSTANDING4 |
|
||
BOOKINGID5 |
|
||
DATEBOOKED5 |
|
||
PLACESBOOKED5 |
|
||
TOTALCOST5 |
|
||
DISCOUNT5 |
|
||
TOTALPAID5 |
|
||
TOTALOUTSTANDING5 |
|
||
TOTALPLACESNUMBER |
2 |
|
|
TOTALPACESCOST |
100.00 |
|
|
TOTALPLACESDISCOUNTEDCOST |
100.00 |
|
|
TOTALSESSIONSNUMBER |
1 |
|
|
TOTALSESSIONSCOST |
|||
TOTALSESSIONSDISCOUNTEDCOST |
0.00 |
|
|
TOTALSTRUCTURESNUMBER |
1 |
|
|
TOTALSTRUCTURESCOST |
0.00 |
|
|
TOTALSTRUCTURESDISCOUNTEDCOST |
0.00 |
|
|
DETAILTEXT1 |
|
||
Batch / Payment Information |
|||
DETAILTEXT2 |
B01211 Pre-Banked 000000005877 24/10/2017 $100.00 |
|
|
Attendee Type |
|||
DETAILTEXT3 |
Registration |
|
|
DETAILTEXT4 |
|
||
DETAILTEXT5 |
|
||
SEGMENT |
|
The Segment name in Mailing
|
|
Event Information |
|||
EVENTYPE |
Meeting |
|
|
DISCRIPTION |
City to Surf |
|
|
STARTDATE |
28/10/2017 |
|
|
STARTTIME |
07:00 |
|
|
ENDDATE |
28/10/2017 |
|
|
ENDTIME |
17:00 |
|
|
HOST1 |
|
||
HOST1TITLE |
|
||
HOST1FIRSTNAME |
|
||
HOST1SURNAME |
|
||
HOST2 |
|
||
HOST2TITLE |
|
||
HOST2FIRSTNAME |
|
||
HOST2SURNAME |
|
||
SERIALNUMBER |
0000137 |
|
|
HTMLNOTES |
|
|
|
COUNTAMOUNT |
2 |
|
|
SUMAMOUNT |
160 |
||
AVGAMOUNT |
80 |
||
MAXDATE |
19/04/2004 |
||
MAXAMOUNT |
150 |
||
MINDATE |
2/03/2004 |
||
LEADCONTACT |
|
No longer used |
|
JOINTSALUTATION |
Mr Craig Nelson |
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 |
Craig |
||
DEFAULTTITLE |
|
|
|
DEFAULTFIRSTNAME |
|
||
DEFAULTKEYNAME |
|
||
DEFAULTADDRESSLINE1 |
|
||
DEFAULTADDRESSLINE2 |
|
||
DEFAULTADDRESSLINE3 |
|
||
DEFAULTADDRESSLINE4 |
|
||
DEFAULTPOSTCODE |
|
||
DEFAULTCOUNTRY |
|
||
DEFAULTADDRESSCODE1 |
|
||
DEFAULTADDRESSCODE2 |
|
||
Audit Fields |
|||
EXTERNALREF |
|
IMP90128 |
|
EXTERNALREFTYPE |
|
Data Import |
|
EXTERNALREFDATE |
|
27/03/2010 10:12:15 PM |
|
SUBADDRESS |
|
Mailing Preference
|
|
CCNAME |
|
|
|
PLAINTEXTEMAIL |
|
||
PICTUREFILE2 |
|
|
|
SECONDCONTACT |
|
|
|
CANVASSEE |
|
|
|
DONOTEMAIL |
|
|
|
DONOTCALL |
|
||
DONOTPUBLISH |
|
||
VOLUNTEER |
|
||
DONOTVOLUNTEER |
|
||
Volunteer Information |
|||
VOLSOURCE |
|
|
|
VOLSPECIALREQ |
|
||
EMERGENCYNAME |
|
||
EMERGENCYNUMBER |
|
||
VOLUNTEERMANAGER |
|
||
Client Relationship Management Information |
|||
CRMPRIMARYMANAGER |
|
|
|
CRMSECONDARYMANAGER |
|
||
CRMPLAN |
|
||
CRMREFERMANAGER |
|
||
CRMNOTE |
|
||
CCEMAILADDRESS |
|
|
|
SOURCE |
Not Used |
|
|
SOURCE2 |
|
||
SOURCEDATE |
|
||
MEDICALREF1 |
|
Support Services Fields |
|
MEDICALREF2 |
|
||
MEDICALREF2DATE |
|
||
Payment History Tab |
|||
DEFAULTRECEIPTREQUIRED |
|
|
|
DEFAULTRECEIPTSUMMARY |
|
||
DEFAULTSOURCE2 |
|
||
TEMPMAINTITLE |
|
Do Not Use as they are used to construct organisations |
|
TEMPMAINFIRSTNAME |
|
||
TEMPMAINKEYNAME |
|
||
TEMPSECONARYTITLE |
|
||
TEMPSECONDARYFIRSTNAME |
|
||
TEMPSECONDARYKEYNAME |
|
||
DEFAULTRODUCTLEVEL |
|
Used to detail the default price level to be applied when orders are created for that contact |
|
CONFIGTEXT1 |
|
|
|
CONFIGTEXT2 |
|
|
|
CONFIGTEXT3 |
|
|
|
CONFIGTEXT4 |
|
|
|
CONFIGTEXT5 |
|
|
|
Identity Card Information (Singapore) |
|||
IC |
|
|
|
ICTYPE |
|
|
|
Alternate Names |
|||
ALTTITLE |
|
This panel can be activated via Lookup Values. Other keyboard characters can be copied and pasted into fields.
|
|
ALTFIRSTNAME |
|
||
ALTKEYNAME |
|
||
ALTADDRESS |
|
||
SUMAMOUNTSOFT |
|
|
|
COUNTAMOUNTSOFT |
|
||
SUMAOUNTHARDNSOFT |
|
||
COUNTAMOUNTHARDNSFOT |
|
||
Support Services |
|||
REFERRALSOURCE |
|
|
|
QLDHEALTHREGION |
|
||
QLDREGION |
|
||
ISLANDER |
|
||
WRITTENPRIVACYCONSENTHELD |
|
||
VERBALPRIVACYCONSENTGIVEN |
|
||
Invoice Fields |
|||
NOTES |
|
|
|
INVOICEID |
|
|
|
DATEDUE |
|
|
|
DATEINVOICED |
|
|
|
DATEPAID |
|
|
|
AMOUNTINVOICED |
|
|
|
AMOUNTADJUSTED |
|
|
|
AMOUNTPAID |
|
|
|
AMOUNTGST |
|
|
|
INVOICEMAILINGID |
|
|
|
INVOICESUMMARY |
|
|
|
COMMENTS |
|
|
|
Order Fields |
|||
ORDERID |
OR0000122 |
|
|
ORDERTYPE |
Customer |
|
|
SENDON |
25/10/2017 |
|
|
SPECIALINSTRUCTIONS |
|
|
|
SOURCECODE |
SHOPSALES |
|
|
SUPERSEDESORDERID |
|
|
|
ORDERDATE |
25/10/2017 |
|
|
PRIORITY |
Normal |
|
|
VALUE |
5.00 |
|
|
VALUENETT |
4.55 |
|
|
VALUEGST |
0.45 |
|
|
WEGHT |
0 |
|
|
PAID |
0.00 |
|
|
INVOICETITLE |
Mr |
|
|
INVOICEFIRSTNAME |
James |
|
|
INVOICEKEYNAME |
Smith |
|
|
INVOICEENVELOPESALUTATION |
Mr James Smith |
|
|
INVOICELETTERSALUTATION |
James |
|
|
INVOICECOUNTRY |
|
|
|
INVOICEPOSTCODE |
2029 |
|
|
INVOICEADDRESSLINE1 |
6 Kingswood Park |
|
|
INVOICEADDRESSLINE2 |
|
|
|
INVOICEADDRESSLINE3 |
ROSE BAY |
|
|
INVOICEADDRESSLINE4 |
NSW |
|
|
INVOICEDONOTMAIL |
0 |
|
|
DELIVERYTITLE |
Mr |
|
|
DELIVERYFIRSTNAME |
James |
|
|
DELIVERYKEYNAME |
Smith |
|
|
DELIVERYENVELOPESALUTATION |
Mr James Smith |
|
|
DELIVERYLETTERSALUTATION |
James |
|
|
DELIVERYCOUNTRY |
|
|
|
DELIVERYPOSTCODE |
2029 |
|
|
DELIVERYADDRESSLINE1 |
6 Kingswood Park |
|
|
DELVIERYADDRESSLINE2 |
|
|
|
DELIVERYADDRESSLINE3 |
ROSE BAY |
|
|
DELIVERYADDRESSLINE4 |
NSW |
|
|
DELIVERYDONOTMAIL |
0 |
|
|
ORDERDETAILS |
PR000012 Navy Blue Logo Badge 1 5.00 5.00 |
|
|
PACKINGDETAILS |
WH000004 PR000012 Navy Blue Logo Badge 1 For James |
|
|
POSTAGE |
|
|
|
DEPOSITSLIPREF |
|
|
|
TEAMNAME |
Not Used |
|
|
ADMITNAME1 |
M1015 |
|
|
SERIALNUMBER1 |
182671 |
|
|
ADDITIONALID1 |
|
|
|
