thankQ Help
Merge Field Name |
Example Data |
Description |
ADMITNAME |
M0857 |
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 |
Loaded Group ID in Mailing |
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 |
|
|
|
|
|
TOENVELOPESALUTATION |
Ms Jane Smith |
|
TOLETTERSALUTATION |
Jane |
|
JOINTSALUTATION |
Ms Jane Smith & Mr Josh Lucas |
|
JOINTLETTERSALUTATION |
Jane & Josh |
|
CAREOFENVELOPESALUTATION |
|
|
CAREOFLETTERSALUTATION |
|
|
CAREOFCONTACTPOSITION |
|
|
MAILINGDETAILSUBADDRESS |
|
|
DAYTELEPHONE |
02 9119 9009 |
|
EVENINGTELEPHONE |
02 82275 2801 |
|
FAXNUMBER |
02 9115 5113 |
|
MOBILENUMBER |
0414 931 6549 |
|
EMAILADDRESS |
Janesmith@gmail.com |
|
CAREOFPREFIX |
|
|
CAREOF |
|
|
ORGANISATIONNAME |
|
|
POSTCODE |
2203 |
|
ADDRESSLINE1 |
11 Balfour Street |
|
ADDRESSLINE2 |
|
|
ADDRESSLINE3 |
DULWICH HILL |
|
ADDRESSLINE4 |
NSW |
|
COUNTRY |
|
|
PREFERREDMETHOD |
Letter |
|
ADDRESSCODE1 |
00000000 |
|
ADDRESSCODE2 |
00000000000000 |
|
ADDRESSCODE3 |
|
|
SALESREGION |
GRAYNDLER |
|
CCEMAIL |
|
|
CCTO |
|
|
DONOTVOLUNTEER |
0 |
|
DONOTCALL |
0 |
|
DONOTPUBLISH |
|
|
DONOTMAIL |
0 |
|
DONOTMAILREASON |
|
|
NARRATIVE |
((MEMBERSHIP.MEMBERID LIKE '%jane%smith%' OR MEMBERSHIP.SERIALNUMBER LIKE '%jane%smith%' OR (MEMBERSHIP.PURCHASERFIRSTNAME LIKE '%jane%' AND MEMBERSHIP.PURCHASERKEYNAME LIKE '%smith%') OR MEMBERSHIP.FORSERIALNUMBER LIKE '%jane%smith%' OR (MEMBERSHIP.FORFIRSTNAME LIKE '%jane%' AND MEMBERSHIP.FORKEYNAME LIKE '%smith%') )) |
|
INFORMATION |
|
|
|
|
|
INCLUDETEXTREF |
|
Used with Include Text Rules
|
INCLUDETEXTNTHRULE |
|
|
INCLUDETEXTFILE |
|
|
BPAYBILLERCODE |
|
Used to generate BPay information |
BPAYREF |
|
|
BPAYCHECKSUM |
|
|
POSTBILLPAYCODE |
|
Used to generate Post Bill Pay |
POSTBILLPAYREF |
|
|
POSTBILLPAYCHECKSUM |
|
|
POSTBILLPAYKEYINGLINE |
|
|
POSTBILLPAYBCODESTR |
|
|
POSTBILLPAYBCODE |
|
|
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 |
|
|
BLANKFIELD |
|
|
MEMBERID |
MBR000000034 |
|
NTHPERIOD |
6.6 |
|
STATUS |
Lapsed |
|
PHASE |
Awaiting Rejoining |
|
SERIALNUMBER |
0000001 |
|
PURCHASERTITLE |
Ms |
|
PURCHASERFIRSTNAME |
Jane |
|
PURCHASERKEYNAME |
Smith |
|
PURCHASEREASON |
|
|
RENEWALTOPURCHASER |
-1 |
|
|
|
|
FORSERIALNUMBER |
0000001 |
|
FORTITLE |
Ms |
|
FORFIRSTNAME |
Jane |
|
FORKEYNAME |
Smith |
|
MEMBERTYPE |
Corporate |
|
MEMBERSUBTYPE |
Key |
|
MEMBERGRADE |
Normal |
|
FIRSTSTARTDATE |
3/11/2010 |
|
PERIODTYPE |
Period Rolling |
|
DURATIONMONTHS |
12 |
|
ACTUALMONTHS |
12 |
|
CURRENTSTARTDATE |
1/01/2018 |
|
CURRENTENDDATE |
31/12/2018 |
|
NEXTRENEWALDATE |
1/01/2019 |
|
SOURCECODE |
MEMBER |
|
DESTINATIONCODE |
MEMBERFUND |
|
MEMBERSHIPAMOUNT |
2500.00 |
|
AMOUNTCALCINFO |
Period Rolling membership calculated at full amount. Membership amount of 2500.00. |
|
DISCOUNT |
0.00 |
|
DISCOUNTCOMMENT |
|
|
CONTRA |
0 |
|
DUEAMOUNT |
2500.00 |
|
LASTINVOICEID |
|
|
COMMENT |
|
|
TERMINATIONREASON |
|
|
EXTERNALREF |
000000001252 |
|
EXTERNALREFTYPE |
Pledge |
|
PRIORITY |
|
|
INVOICESERIALNUMBER |
0000001 |
|
INVOICETITLE |
Ms |
|
INVOICEFIRSTNAME |
Jane |
|
INVOICEKEYNAME |
Smith |
|
AUTORENEWAL |
0 |
|
FREQUENCY |
One Off |
|
COST |
2500.00 |
|
REJOININGFEE |
0.00 |
|
MAILSORT |
|
Used with Mailsort
|
BSPNUMBER |
|
|
BSPNAME |
|
|
PARCELZONE |
|
|
PRESORTINDICATOR |
|
|
CATEGORY |
|
|
Expr1 |
|
|
SEGMENT |
|
Mailing segment |
CHARITYNUMBER |
|
|
MAILINGQUANTITY |
|
Mailing preference |
TOCONTACTPOSITION |
Executive Director |
|
WEBSITE |
|
|
OCCUPATION |
Accountant |
|
DATEOFBIRTH |
20/09/1972 |
|
GENDER |
Female |
|
MARITALSTATUS |
Married |
|
TAXSTATUS |
|
|
Expr2 |
|
|
Expr3 |
|
|
SOURCE |
|
|
SOURCE2 |
|
|
DEFAULTSOURCE2 |
|
|
|
|
|
RECORDOWNER |
|
|
CREATED |
2004-10-19 11:31:09.0000000 |
|
CREATEDBY |
ADMiT |
|
MODIFIED |
2019-09-16 15:06:29.0536597 |
|
MODIFIEDBY |
ADMiT |
|
Expr4 |
|
|
NOTES |
|
|
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 |
|
|
DEFAULTADDRESSCODE1 |
|
|
DEFAULTADDRESSCODE2 |
|
|
Expr5 |
|
|
Expr6 |
|
|
EXTERNALREFDATE |
23/10/2012 1:01:35 PM |
|
SUBADDRESS |
|
|
PLAINTEXTEMAIL |
|
|
PICTUREFILE2 |
|
|
SECONDCONTACT |
|
|
CANVASSEE |
|
|
VOLUNTEER |
-1 |
|
VOLSOURCE |
|
|
VOLSPECIALREQ |
|
|
EMERGENCYNAME |
|
|
EMERGENCYNUMBER |
|
|
VOLUNTEERMANAGER |
|
|
CRMPRIMARYMANAGER |
training13 |
|
CRMSECONDARYMANAGER |
manager1 |
|
CRMPLAN |
|
|
CRMREFERMANAGER |
0 |
|
CRMNOTE |
|
|
CCEMAILADDRESS |
|
|
CCNAME |
|
|
MEDICALREF1 |
|
|
MEDICALREF2 |
|
|
MEDICALREF2DATE |
|
|
DEFAULTRECEIPTREQUIRED |
|
|
DEFAULTRECEIPTSUMMARY |
|
|
ADMITNAME1 |
M0857 |
|
SERIALNUMBER1 |
0000001 |
|
ADDITIONALID1 |
MBR000000034 |
|
Paramatervalues – view Pledges |
|
|
INVOICEID |
|
|
DATEDUE |
|
|
DATEINVOICED |
|
|
DATEPAID |
|
|
AMOUNTINVOICED |
|
|
AMOUNTADJUSTED |
|
|
AMOUNTPAID |
|
|
AMOUNTGST |
|
|
INVOICEMAILINGID |
|
|
INVOICESUMMARY |
|
|
COMMENTS |
|
|
PLEDGEID |
000000001252 |
|
PLEDGESTATUS |
Active |
|
PLEDGEDESCRIPTION |
Member MBR000000034 - REJOINED |
|
PLEDGETYPE |
Single Payment |
|
STARTDATE |
1/01/2018 |
|
SUM_PAID |
|
|
ESCALATIONLETTER |
0 |
|
LASTESCALATIONDATE |
|
|
OUTSTANDING |
2500.00 |
|
PLEDGEPLAN |
Fixed |
|
RECEIPTREQUIRED |
Yes |
|
PAYMENTTYPE |
Cheque |
|
RECEIPTSUMMARY |
No |
|
ENDDATE |
31/12/2018 |
|
TOTALVALUE |
2500.00 |
|
MAXPAYMENTS |
1 |
|
PLEDGERECRUITEDBYEVENT |
|
|
PLEDGERECRUITEDBY |
|
|
CREDITCARDMETHOD |
|
|
CREDITCARDEXPIRY |
|
|
CREDITCARDHOLDER |
|
|
CREDITCARDNUMBER |
|
|
CREDITCARDTYPE |
|
|
BANKPOSTCODE |
|
|
BANKADDRESS |
|
|
BANKNAME |
|
|
TEXT2 |
|
|
TEXT1 |
|
|
ROLLNUMBER |
|
|
ACCOUNTNUMBER |
|
|
SORTCODE |
|
|
ACCOUNTNAME |
|
|
ACKNOWLEDGELETTER |
|
|
ACKNOWLEDGEDATE |
|
|
ACKNOWLEDGE |
|
|
ORIGINALTOTALVALUE |
2500.00 |
|
REMINDER |
Yes |
|
ONHOLDBY |
|
|
ONHOLDDATETIME |
|
|
ONHOLDREASON |
|
|
WRITTENDOWNBY |
|
|
WRITTENDOWN |
|
|
WRITTENDOWNREASON |
|
|
ONEOFF |
No |
|
INSTALMENTID |
1 |
|
INSTALMENT |
2500.00 |
|
INSTALMENTDATEDUE |
1/01/2018 |
|
INSTALMENTAMOUNTPAID |
0.00 |
