Extended Output Formats
The following table explains the items contained in the formatted mail acknowledgement output - extended and email acknowledgement output - extended output formats.
The double asterisk (**) fields in the Output column indicate fields that are exported multiple times. With extended output formats, you can export the following fields multiple times:
-
5 benefits per transaction
-
5 tributes per transaction
-
3 matching gift applications per transaction
-
5 applications per transaction
-
10 campaigns per application
-
10 recognition credits per application
The following table explains the items contained in the pledge acknowledgement output - extended format.
|
Output |
Example |
|
Business process output PKID |
1 |
|
Revenue ID |
24ffdc3a-31fc-47a8-a2ce-00ca801248eb |
|
Constituent name |
John J. Smith (individual) or ABC, Inc. (organization) |
|
Constituent ID |
Constit 123 |
|
Primary addressee |
Mr. John J. Smith, Jr. |
|
Primary salutation |
Mr. Smith |
|
Primary contact |
Mr. Smith |
|
Address block |
100 Main Street, Apartment D |
|
City |
Charleston |
|
State |
SC |
|
Zip code |
29492 |
|
Country |
USA |
|
Email address |
jjsmith@somewhere.com |
|
Total pledge amount |
$1,200.00 |
|
Pledge date |
05/12/2009 |
|
Frequency |
Monthly |
|
Start date |
05/10/2009 |
|
Number of installments |
12 |
|
First installment due date |
05/10/2009 |
|
First installment amount |
$120.00 |
|
Send pledge reminders |
Yes |
|
Anonymous |
No |
|
First gift |
Yes |
|
Appeal name |
Spring Appeal 2008 |
|
Application type** |
Donation |
|
Designation name** (exports from the Public name field on the designation. If Public name is blank or does not exist, the designation Name exports) |
President’s Scholarship Fund |
|
Designation public name** |
President Walter B. Murray Scholarship Fund |
|
Designation amount** |
$1,200.00 |
|
Designation administrator** |
Mark Adamson (the administrator on the associated fundraising purpose) |
|
Designation ID** |
President Walter B. Murray Scholarship Fund |
|
Campaign** |
Playground Campaign |
|
Position |
Sales Manager |
|
Revenue letter ID |
A5693F6D-2F1F-4E55-A622-423E13D32DAF (the record ID of the revenue letter row) |
|
Donor addressee |
Ms. Mary M. Smith |
|
Donor address block |
200 Main Street, Apartment G |
|
Donor city |
Charleston |
|
Donor state |
SC |
|
Donor Zip code* |
29492 |
|
Donor country |
USA |
|
DDI account holder address block |
100 Main Street, Apartment D |
|
DDI account holder postcode |
M11 |
|
DDI account number |
123456789123 |
|
DDI account branch |
Manchester |
|
Amount with Gift Aid |
£101.85 (total transaction amount with Gift Aid) |
|
Other payment method |
Wire transfer |
|
Transaction reference |
Additional information existing in the Reference field on a payment record |
|
Tribute type** |
In honor of |
|
Tributee** |
Michelle and Mark Walker |
|
Tribute text** |
Thank you for all your hard work |
|
Tribute default designation** |
Playground Site |
|
Tribute amount** |
£100 |
|
Matching gift organization* |
Carolina Bank |
|
Matching gift condition type** |
Employee |
|
Matching gift claim amount** |
£25 |
|
Benefit name** |
Free Admission |
|
Benefit quantity** |
1 |
|
Benefit unit value** |
£15 |
|
Benefit total value** |
£15 |
|
Membership program |
Adopt a Sea Turtle (if applicable) |
|
Membership level |
Individual (if applicable) |
|
Membership expiration date |
08/08/2011 (if applicable) |
|
Constituent on pledge |
Adam Johnson (if applicable) |
|
Pledge amount |
£2000 (if applicable) |
|
Pledge date |
05/05/2009 (if applicable) |
|
Pledge balance |
£2000 (if applicable) |
|
Recognition credit recipient** |
Amy Smith |
|
Recognition credit amount** |
£40 |
|
Recognition type** |
Spouse |
|
Recognition credit date** |
05/05/2009 |
|
Recognition program (Last added) |
President’s Club |
|
Recognition level (Last added) |
Gold |
|
Process date |
05/10/2009 |
|
Letter code name |
Pledge Thank You |