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 |