thankQ Help
The Pledge merge fields specific to Pledge Reminder that do not also appear in Pledges. Note that not all of these merge fields will appear in the order specified.
Merge Field Name |
Example Data |
Description |
NEXTPLEDGEID |
|
The fields for the Pledge or Pledge Instalment which is active and due next for this contact. |
NEXTSOURCE |
|
|
NEXTSOURCEDESC |
|
|
NEXTSOURCE2 |
|
|
NEXTSOURCE2DESC |
|
|
NEXTCAMPAIGNYEAR |
|
|
NEXTINSTALMENTID |
|
|
NEXTINSTALMENT |
|
|
NEXTDATEDUE |
|
|
NEXTAMOUNTPAID |
|
|
NEXTOUTSTANDING |
|
|
NEXTEXTERNALREF |
|
|
NEXTCREATED |
|
|
NEXTSTARTDATE |
|
|
NEXTPAYMENTFREQUENCY |
|
|
INSTALSOUTSTANDINGDUE |
148 1/12/2019 $10.00 $0.00 $10.00 |
Lists all outstanding instalments that are due within the date range defined for the mailing in the following format: <InstalmentID> <DueDate> <InstalmentAmount> <PaidAmount> <Outstanding> |
INSTALSOUTSTANDING |
148 1/12/2019 $10.00 $0.00 $10.00 |
Lists all other outstanding instalments (i.e. not listed in INSTALSOUTSTANDINGDUE) that are outstanding in the following format: <InstalmentID> <DueDate> <InstalmentAmount> <PaidAmount> <Outstanding> |
INSTALSPAID |
148 1/12/2019 $10.00 $0.00 $10.00 |
Lists all paid instalments in the following format: <InstalmentID> <DueDate> <InstalmentAmount> <PaidAmount> <Outstanding> |
GRANDTOTAL |
$5000 |
Grand Total Due on a Pledge. |
GRANDTOTALPAID |
$2000 |
Grand Total Paid on a Pledge. |
GRANDTOTALOUTSTANDING |
$3000 |
Grand Total Outstanding on Pledge. |
GRANDTOTALOVERDUE |
$300 |
Grand Total Overdue on a Pledge (calculated based on the End Date of the Date Range applied to the mailing). |
LASTDATEOFPAYMENT |
1/05/2019 |
The Date of Payment of the last transaction associated with a pledge. |
