The Donations data set contains data pertaining to donations processed in ACME.
Customer | |
CustomerAddressCity | City value for customer record |
CustomerAddressCountry | Country value for customer record |
CustomerAddressState | State value for customer record |
CustomerAddressStreet1 | Street Address Line 1 value for customer record |
CustomerAddressStreet2 | Street Address Line 2 value for customer record |
CustomerAddressSuburb | Suburb or region value for customer record |
CustomerAddressZip | Zip code value for customer record |
CustomerEmail | City value for customer record |
CustomerFirstName | Email Address value for customer record |
CustomerId | The unique id of the customer that made the donation |
CustomerImportId | The Id for an imported customer record |
CustomerLastName | Last name on file for customer record |
CustomerPhoneNumber | Phone number value for customer record |
CustomerSource | The channel in which the customer record was added into ACME |
MembershipNumber | The membership number of the person making the donation |
AddOn | |
AddOnName | The name of the donation (values are defined in the Donations Amounts configuration) |
AddOnType | The type of donation Values
|
Transaction | |
Amount | The amount that was donated |
PaymentMethod | The method of payment collected for the donation. Values:
|
SalesChannel | The sale channel in which the donation was processed. Values:
|
TransactionDate | The date in which the transaction occurred |
Order | |
OrderId | The unique id of the order associated with the donation |
OrderNumber | The order number associated with the donation |
Donor | |
DonorRecognitionCorpName | The name of the corporation associated with the donation |
DonorRecognitionNote | An optional recognition note that the donor may have left |
DonorRecognitionType | The type of recognition associated with the donation Values:
|
Donation This data can be collected if Extended Form is toggled ON in Donations>Config Form Settings tab | |
DonationAppealName | The name of the appeal associated with the donation. Values are defined in the Donations Config area. |
DonationCampaignName | The name of the campaign associated with the donation. Values are defined in the Donations Config area. |
DonationFundName | The name of the fund associated with the donation. Values are defined in the Donations Config area. |
DonationID | ID of the donation given |
GiftImportId | An Import number generated when a donation is imported from an outside source |
Dedication This data can be collected if Extended Form is toggled ON in Donations>Config Form Settings tab | |
DedicationFirstName | The first name of the person that the donation is being dedicated to |
DedicationLastName | The last name of the person that the donation is being dedicated to |
Beneficiary This data can be collected if Extended Form is toggled ON in Donations>Config Form Settings tab | |
DedicationNotes | Donor provided notes for the dedication |
DonorDedication | The type of dedication Values:
|
NotificationCity | The city of the person to be notified about the donation |
NotificationCountry | The country of the person to be notified about the donation |
NotificationEmail | The email of the person to be notified about the donation |
NotificationFirstName | The first name of the person to be notified about the donation |
NotificationLastName | The last name of the person to be notified about the donation |
NotificationPhone | The phone number of the person to be notified about the donation |
NotificationState | The state of the person to be notified about the donation |
NotificationStreetAddress1 | The first line of the street address of the person to be notified about the donation |
NotificationStreetAddress2 | The second line of the street address of the person to be notified about the donation |
NotificationZip | The ZIP code of the person to be notified about the donation |
DonationCustomFields for POS transactions only | |
DonationCustomField1 | Predefined custom field |
DonationCustomField2 | Predefined custom field |
DonationCustomField3 | Predefined custom field |
DonationCustomField4 | Predefined custom field |
DonationCustomField5 | Predefined custom field |
DonationCustomField6 | Predefined custom field |
DonationCustomField7 | Predefined custom field |
DonationCustomField8 | Predefined custom field |
DonationCustomField9 | Predefined custom field |
DonationCustomField10 | Predefined custom field |