thankQ Help
All Pledge Merge Fields. Note that not all of these merge fields will appear in the order specified.
Merge Field Name |
Example Data |
Description |
ADMITNAME |
M0859 |
Mailing ID. |
MAILINGDETAILSERIALNUMBER |
0000001 |
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 |
General Pledges |
ID of the Group loaded into the Mailing.
|
EXTERNALREFID |
MBR000000002 |
Used to store the record identifier when generating a mailing from another module e.g. generating a membership mailing would cause the Membership ID to be recorded here. |
TITLE |
Ms |
Details of the contact with this pledge.
|
FIRSTNAME |
Jane |
|
KEYNAME |
Smith |
|
OTHERINITIAL |
|
|
POSTNOMINAL |
|
|
PREVIOUSNAMES |
|
|
ENVELOPESALUTATION |
Ms Jane Smith |
Letter Salutations of the Contact with this Pledge.
|
LETTERSALUTATION |
Jane |
|
JOINTSALUTATION |
Ms Jane Smith & Mr Josh Lucas |
|
JOINTLETTERSALUTATION |
Jane & Josh |
|
CONTACTPOSITION |
Executive Director |
|
USESERIALNUMBER |
|
|
TOTITLE |
Ms |
|
TOFIRSTNAME |
Jane |
|
TOKEYNAME |
Smith |
|
TOOTHERINITIAL |
|
|
TOPOSTNOMINAL |
|
|
TOENVELOPESALUTATION |
Ms Jane Smith |
|
TOLETTERSALUTATION |
Jane |
|
TOCONTACTPOSITION |
|
|
CAREOFPREFIX |
|
Care Of fields come from View Address Detail in the Addressing tab:
|
CAREOFTITLE |
|
|
CAREOFFIRSTNAME |
|
|
CAREOFKEYNAME |
|
|
CAREOFOTHERINITIAL |
|
|
CAREOFPOSTNOMINAL |
|
|
CAREOFENVELOPESALUTATION |
|
|
CAREOFLETTERSALUTATION |
|
|
CAREOFCONTACTPOSITION |
|
|
ORGANISATIONNAME |
|
|
MAILSORT |
|
|
MAILINGDETAILSUBADDRESS |
|
This is in Mailing Preferences.
|
CAREOFPREFIX |
|
|
CAREOF |
|
|
ADDRESSLINE1 |
11 Balfour Street |
|
ADDRESSLINE2 |
|
|
ADDRESSLINE3 |
DULWICH HILL |
|
ADDRESSLINE4 |
NSW |
|
ADDRESSLINE5 |
|
|
ADDRESSLINE6 |
|
|
POSTCODE |
2203 |
|
COUNTRY |
|
|
DAYTELEPHONE |
02 9119 9009 |
|
EVENINGTELEPHONE |
02 82275 2801 |
|
FAXNUMBER |
02 9115 5113 |
|
MOBILENUMBER |
0414 931 6549 |
|
EMAILADDRESS |
janesmith@gmail.com |
|
|
|
|
ADDRESSCODE1 |
00000000 |
|
ADDRESSCODE2 |
00000000000000 |
|
ADDRESSCODE3 |
|
|
PREFERREDMETHOD |
Letter |
|
|
|
|
SALESREGION |
GRAYNDLER |
|
CCEMAIL |
|
|
CCTO |
|
|
DONOTMAIL |
0 |
|
DONOTMAILREASON |
|
|
DONOTPUBLISH |
|
|
DONOTCALL |
0 |
|
|
|
|
NARRATIVE |
(PLEDGEHEADER.PLEDGEID Like '000000000444%' Or PLEDGEHEADER.DESCRIPTION Like '000000000444%' Or PLEDGEHEADER.SERIALNUMBER Like '000000000444%' Or PLEDGEHEADER.PLEDGETYPE Like '000000000444%' Or PLEDGEHEADER.SERIALNUMBER IN (SELECT CONTACT.SERIALNUMBER FROM CONTACT WHERE KEYNAME Like '000000000444%' )) |
|
MAILSENT |
0 |
|
INCLUDETEXTREF |
|
Used with Include Text Rules
|
INCLUDETEXTNTHRULE |
|
|
INCLUDETEXTFILE |
|
|
BLANKFIELD |
|
|
BSPNUMBER |
|
|
HOUSEHOLDCODE |
|
|
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 |
|
Mailing Manager Address Details
|
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 |
|
|
SEGMENT |
|
Segment in mailing |
WEBSITE |
|
|
CHARITYNUMBER |
|
|
OCCUPATION |
Accountant |
|
DATEOFBIRTH |
20/09/1972 |
|
GENDER |
Female |
|
MARITALSTATUS |
Married |
|
CONTACTPOSITION |
Executive Director |
|
|
|
|
TAXSTATUS |
|
|
SOURCE |
|
|
ADDITIONALID1 |
000000000444 |
|
ADMITNAME1 |
M0859 |
|
SERIALNUMBER |
0000001 |
|
ADDITIONALID11 |
000000000444 |
|
PARAMETERVALUE1 |
|
|
PARAMETERVALUE2 |
|
Credit Card Type or Pledge ID (Batch Receipt Letters Only) |
PARAMETERVALUE3 |
|
|
PARAMETERVALUE4 |
|
Credit Card Expiry |
PARAMETERVALUE5 |
|
Credit Card Holder |
PARAMETERVALUE6 |
|
Group Role / Description |
PARAMETERVALUE7 |
|
In Memory Name |
PARAMETERVALUE8 |
|
In Memory Next of Kin |
PARAMETERVALUE9 |
|
In Memory Next of Kin Relationship |
PARAMETERVALUE10 |
Corporate |
Membership Type |
PARAMETERVALUE11 |
Key |
Membership Sub-Type |
PARAMETERVALUE12 |
Normal |
Membership Grade |
PARAMETERVALUE13 |
|
IC Number - Masked |
PARAMETERVALUE14 |
94848484848484 |
Encrypt Serial Number |
PARAMETERVALUE15 |
|
|
PARAMETERVALUE16 |
|
|
PARAMETERVALUE17 |
|
|
PARAMETERVALUE18 |
|
|
PARAMETERVALUE19 |
|
Group Manager Evening Phone |
PARAMETERVALUE20 |
|
Group Manager Day Phone |
PARAMETERVALUE21 |
|
Group Manager Name |
PARAMETERVALUE22 |
|
Group Title |
PARAMETERVALUE23 |
13 May 2019 |
Last Donation Date |
PARAMETERVALUE24 |
300.00000 |
Last Donation Amount |
PARAMETERVALUE25 |
REGGIVING |
Last Donation Source Code |
PARAMETERVALUE26 |
REGGIVING |
Last Donation Destination Code |
PARAMETERVALUE27 |
Kosher |
Profile Dietary Requirements |
PARAMETERVALUE28 |
|
Last Donation Amount plus 20% |
PARAMETERVALUE29 |
|
|
PARAMETERVALUE30 |
|
|
PARAMETERVALUE31 |
|
|
PARAMETERVALUE32 |
|
|
PARAMETERVALUE33 |
|
|
PARAMETERVALUE34 |
|
|
PARAMETERVALUE35 |
|
|
PARAMETERVALUE36 |
|
|
PARAMETERVALUE37 |
|
|
PARAMETERVALUE38 |
|
|
PARAMETERVALUE39 |
|
Raffle Ticket Purchased Under Group Organisation |
PARAMETERVALUE40 |
|
Raffle Ticket Number Range |
PARAMETERVALUE41 |
|
|
PARAMETERVALUE42 |
|
|
PARAMETERVALUE43 |
|
|
PARAMETERVALUE44 |
|
|
PARAMETERVALUE45 |
|
|
PARAMETERVALUE46 |
|
|
PARAMETERVALUE47 |
|
|
PARAMETERVALUE48 |
0 |
Contact Ownercode |
PARAMETERVALUE49 |
Supporter |
Contact Primary Category |
PARAMETERVALUE50 |
Individual |
Contact Type |
PARAMETERVALUE51 |
09/20 |
Date of Birth (mm/dd) |
PARAMETERVALUE52 |
Josh |
Wife/Husband/Spouse/Life Partner Letter Salutation |
PARAMETERVALUE53 |
esittraining1@gmail.com |
Wife/Husband/Spouse/Life Partner Email |
PARAMETERVALUE54 |
0411 999 9999 |
Wife/Husband/Spouse/Life Partner Mobile Number |
PARAMETERVALUE55 |
250.00 |
Largest DONATION (Average 1st & 2nd) in date range (ex SOFT) |
PARAMETERVALUE56 |
250.00 |
Largest DONATION (2nd) in date range (ex SOFT) |
PARAMETERVALUE57 |
250.00 |
Largest DONATION in date range (ex SOFT) |
PARAMETERVALUE58 |
REGGIVING |
Destination Code (Pledges) or Destination Code (Pledge Reminders) |
PARAMETERVALUE59 |
|
Destination Code 2 (Pledges) or Destination Code 2 (Pledge Reminders) |
PARAMETERVALUE60 |
|
|
PARAMETERVALUE61 |
13 May 2019 |
Last Payment Date |
PARAMETERVALUE62 |
250.00 |
Last Payment Amount |
PARAMETERVALUE63 |
|
Total Paid to Source Code x |
PARAMETERVALUE64 |
30 |
Number of Previous Mailings |
PARAMETERVALUE65 |
GEN_FUND |
First Donation Destination |
PARAMETERVALUE66 |
|
Cheque Number (Batch Receipts) |
PARAMETERVALUE67 |
|
Receipt ID (Singapore) |
PARAMETERVALUE68 |
2750.00 |
Total Donated Last 12 Months or Total Donated Last Financial Year or Total Donated Last Financial Year (Tax-Deductable Only) |
PARAMETERVALUE69 |
9 |
Total Number of Donations Last 12 Months |
PARAMETERVALUE70 |
0000001 |
Head of Household Serial Number |
PARAMETERVALUE71 |
|
|
PARAMETERVALUE72 |
MARRICKVILLE |
Local Government Area |
PARAMETERVALUE73 |
375.00 |
Next Ask (Last Donation + 50% Rounded to nearest $5) |
PARAMETERVALUE74 |
300.00 |
Next Ask (Last Donation + 20% Rounded to nearest $5) |
PARAMETERVALUE75 |
275.00 |
Next Ask (Last Donation + 10% Rounded to nearest $5) |
PARAMETERVALUE76 |
|
Member Country |
PARAMETERVALUE77 |
|
Member Postcode |
PARAMETERVALUE78 |
|
Member Town / City / State |
PARAMETERVALUE79 |
|
Member Suburb |
PARAMETERVALUE80 |
|
Member Address Line 2 |
PARAMETERVALUE81 |
|
Member Address Line 1 |
PARAMETERVALUE82 |
|
Member Household Salutation |
PARAMETERVALUE83 |
|
Member Email Address |
PARAMETERVALUE84 |
|
Member Mobile Phone |
PARAMETERVALUE85 |
|
Member Evening Telephone or Credit Card Number |
PARAMETERVALUE86 |
|
Member Day Telephone or Credit Card Number (Masked) |
PARAMETERVALUE87 |
13 Jun 2019 |
Next Active Instalment Date Due |
PARAMETERVALUE88 |
250.00 |
Next Active Instalment Value |
PARAMETERVALUE89 |
|
Membership Type (Batch Receipts) |
PARAMETERVALUE90 |
|
Membership Sub-Type (Batch Receipts) |
PARAMETERVALUE91 |
|
Membership Grade (Batch Receipts) |
PARAMETERVALUE92 |
$250.00 |
Last Pledge Instalment Value |
PARAMETERVALUE93 |
|
Membership ID (Batch Receipts) |
PARAMETERVALUE94 |
|
Membership Current End Date (Batch Receipts) |
PARAMETERVALUE95 |
19 Oct 2004 |
Contact Record Created Date |
PARAMETERVALUE96 |
10.00 |
First Donation Amount |
PARAMETERVALUE97 |
01 Jan 2003 |
First Donation Date |
PARAMETERVALUE98 |
APPEAL2009 |
First Donation Source |
PARAMETERVALUE99 |
REGGIVING |
Second Last Donation Source |
PARAMETERVALUE100 |
|
Receipt ID in Event Confirmation Letter |
COUNTAMOUNT |
114 |
|
SUMAMOUNT |
35263.34 |
|
MAXAMOUNT |
5000 |
|
AVGAMOUNT |
309.3275 |
|
MAXDATE |
13/05/2019 |
|
MINDATE |
1/01/2003 |
|
LEADCONTACT |
-1 |
|
DEFAULTTITLE |
|
If using a related contact’s mailing address |
DEFAULTFIRSTNAME |
|
|
DEFAULTKEYNAME |
|
|
DEFAULTADDRESSLINE1 |
|
|
DEFAULTADDRESSLINE2 |
|
|
DEFAULTADDRESSLINE3 |
|
|
DEFAULTADDRESSLINE4 |
|
|
DEFAULTPOSTCODE |
|
|
DEFAULTCOUNTRY |
|
|
DEFAULTADDRESSCODE1 |
|
|
DEFAULTADDRESSCODE2 |
|
|
EXTERNALREFDATE |
23/10/2012 1:01:35 PM |
Audit Tab |
PLAINTEXTEMAIL |
|
|
PICTUREFILE2 |
|
|
SECONDCONTACT |
|
|
CANVASSEE |
|
|
VOLUNTEER |
-1 |
|
VOLSOURCE |
|
|
VOLSPECIALREQ |
|
|
EMERGENCYNAME |
|
|
EMERGENCYNUMBER |
|
|
PLEDGEID |
000000000444 |
|
PLEDGESTATUS |
Active |
|
DESCRIPTION |
Regular Giving |
|
PLEDGEPLAN |
Continuous |
|
PLEDGETYPE |
Regular Payment |
|
CURRENCY |
$ (AUD) |
|
SOURCECODE |
REGGIVING |
|
SOURCETYPE |
Pledge |
|
SOURCEDESCRIPTION |
Regular Giving |
|
CAMPAIGNYEAR |
2020 |
|
PAYMENTTYPE |
Credit Card |
|
|
|
|
SOURCENOTES |
|
|
SOURCECODE2 |
|
|
SOURCE_2_CATEGORY |
|
|
SOURCE_2_TYPE |
|
|
SOURCE_2_DESCRIPTION |
|
|
SOURCE_2_NOTES |
|
|
RECEIPTFREQUENCY |
|
|
NEXTRECEIPTDATE |
|
|
STARTDATE |
13/09/2010 |
|
ENDDATE |
13/07/2022 |
|
TOTALVALUE |
35750.00 |
|
INSTALMENTVALUE |
250.00 |
|
PAYMENTFREQUENCY |
Monthly |
|
MAXPAYMENTS |
143 |
|
TOTALPAID |
26250.00 |
|
OUTSTANDING |
9500.00 |
|
ORIGINALTOTALVALUE |
9000.00 |
|
ONEOFF |
No |
|
|
|
|
ACCOUNTNAME |
|
|
SORTCODE |
|
|
ACCOUNTNUMBER |
|
|
ROLLNUMBER |
|
|
TEXT1 |
|
|
TEXT2 |
|
|
BANKNAME |
|
|
BANKADDRESS |
|
|
BANKPOSTCODE |
|
|
CREDITCARDTYPE |
Visa |
|
CREDITCARDNUMBER |
450E13BAB1EF77798289FBF4633194D2+yfqIYa/WoIhcYQ2x |
|
CREDITCARDHOLDER |
J Smith |
|
CREDITCARDEXPIRY |
10/21 |
|
CREDITCARDISSUENUMBER |
|
|
CREDITCARDMASKED |
411111...111 |
|
PLEDGERECRUITEDBY |
|
|
PLEDGERECRUITEDBYEVENT |
|
|
RECORDOWNER |
|
|
CREATED |
13/09/2010 1:43:12 PM |
|
CREATEDBY |
training2 |
|
MODIFIED |
27/04/2018 5:45:01 AM |
|
MODIFIEDBY |
Instalment Maintenance |
|
TAXCLAIMABLE |
Yes |
|
EXTERNALREF |
|
|
EXTERNALREFTYPE |
|
|
ESCALATIONLETTER |
0 |
|
LASTESCALATIONDATE |
|
|
MEMBERSHIP |
|
|
MEMBERSHIPID |
|
|
SUBSCRIPTION |
|
|
SUBSCRIPTIONID |
|
|
NEW |
-1 |
|
EXISTING |
0 |
|
RECOVERED |
0 |
|
ACKNOWLEDGE |
Yes |
|
ACKNOWLEDGEDATE |
|
|
ACKNOWLEDGELETTER |
:MailingID: |
|
RECEIPTREQUIRED |
No |
|
RECEIPTSUMMARY |
Yes |
|
|
|
|
DESTINATIONCODE |
REGGIVING |
|
DESTINATIONCODE2 |
|
|
PAYMENTRATIO |
|
|
PLEDGENOTES |
|
|
INSTALMENTID |
106 |
|
INSTALMENT |
250.00 |
|
DATEDUE |
13/06/2019 |
|
AMOUNTPAID |
0.00 |
|
NUMBERPAID |
105 |
|
BPAYBILLERCODE |
|
Used to generate BPay Information |
BPAYREF |
|
|
BPAYCHECKSUM |
|
|
POSTBILLPAYCODE |
|
Used to generate Post Bill Pay |
POSTBILLPAYREF |
|
|
POSTBILLPAYCHECKSUM |
|
|
BARCODEPURPOSEID |
|
Used for barcodes in mailing |
PARCELZONE |
|
|
CATEGORY |
|
|
COMMENT |
|
|
BSPNAME |
|
|
POSTBILLPAYKEYINGLINE |
|
|
POSTBILLPAYBCODESTR |
|
|
POSTBILLPAYBCODE |
|
|
SOURCEDESCRIPTION1 |
Regular Giving |
|
SERIALNUMBER1 |
0000001 |
|
