Report Columns for TeamRaiser TeamRaiser eCommerce Purchases Report
The following tables contain the available columns you can add to the TeamRaiser eCommerce Purchases report.
Donor Information
| Donor Biographical Information | |
|---|---|
| Donor Active Detail | One of the following:
|
| Donor Active Status | Active if the person is a registered user of your site and can log in Inactive if the person is no longer a registered user of your site. |
| Donor Constituent ID | System-generated identifier that is unique to this person (also called ConsID) |
| Donor Created By | Name of the administrator who created the contact record |
| Donor Creation Time | Month, day, year, and time when the contact record was created |
| Donor Date of Birth | Month, day, year entered as the date of birth for this person |
| Donor Donor Status | Indication of when this person last made a gift of money to the site:
|
| Donor Exchange ID | System-generated identification number used for importing data about this person into the BlackBaud Raiser's Edge offline donor database |
| Donor First Name | The constituent's first name |
| Donor Gender | Male or Female |
| Donor Last Modified By | Name of the administrator who last modified the contact record |
| Donor Last Name | The constituent's last name |
| Donor Marital Status | |
| Donor Matched Donor | Indicates whether any gifts made by this person are matched by an employer |
| Donor Member ID | Member identification number typically uploaded from an offline database if organization uses member numbers |
| Donor Middle Name | Extra name information entered for this person. Can be a middle name, maiden name, nickname, and so on |
| Donor Modification Time | Month, day, year, and time when the contact record was modified |
| Donor Nickname | |
| Donor Origin Application Reference ID | System-generated string that identifies the feature through which the person became a registered user of the site |
| Donor Origin Application Type | |
| Donor Origin Source Code | A string defined by an administrator identifying a page or campaign that generated the user's registration |
| Donor Origin Subsource Code | A string defined by an administrator qualifying the Origin Source Code |
| Donor Password Type | Indicates the method used to generate the password:
|
| Donor Prefer Gift Aid | |
| Donor Preferred Locale | |
| Donor Professional Suffix | Abbreviated respect/education label selected to follow the last name of the person (for example, MD or Esq) |
| Donor Salutation (Casual) | |
| Donor Salutation (Formal) | |
| Donor Suffix | Abbreviated label selected to follow the last name of the person (for example, Jr) |
| Donor Title | Introductory title that appears before the first name of the person (for example, Mr. or Mrs.) |
| Donor User Name | String of letters and numbers that this person enters to log in to the site. Can be entered by the person when registering as a user on this site or generated by the system. |
| Donor Email | |
|---|---|
| Donor Accept Email | Yes or No- Typically enabled by default, for whether the email recipient will accept other email from the site |
| Donor Email | The constituent's email address |
| Donor Hard-Bounce Count | Number of coaching emails that were sent back as undeliverable because of an invalid email address |
| Donor Opt-Out Date | Month, day, year, and time that the Opt-out option was disabled by or for this person so they do not receive site email messages by default |
| Donor Opt-Out Method | Indicates who or how the Opt-Out option was disabled:
|
| Donor Opt-Out Reference ID | System-generated identifier that tracks the opt-in/opt-out status change of this person |
| Donor Preferred Format | HTML if the person can receive email messages with formatting in them Plain Text if the person can only receive emails without formatting in them |
| Participant Biographical Information | |
|---|---|
| Participant Active Detail | One of the following:
|
| Participant Active Status | Active if the person is a registered user of your site and can log in Inactive if the person is no longer a registered user of your site. |
| Participant Constituent ID | System-generated identifier that is unique to this person (also called ConsID) |
| Participant Created By | Name of the administrator who created the contact record |
| Participant Creation Time | Month, day, year, and time when the contact record was created |
| Participant Date of Birth | Month, day, year entered as the date of birth for this person |
| Participant Donor Status | Indication of when this person last made a gift of money to the site:
|
| Participant Exchange ID | System-generated identification number used for importing data about this person into the BlackBaud Raiser's Edge offline donor database |
| Participant First Name | The constituent's first name |
| Participant Gender | Male or Female |
| Participant Last Modified By | Name of the administrator who last modified the contact record |
| Participant Last Name | The constituent's last name |
| Participant Matched Donor | Indicates whether any gifts made by this person are matched by an employer |
| Participant Member ID | Member identification number typically uploaded from an offline database if organization uses member numbers |
| Participant Middle Name | Extra name information entered for this person. Can be a middle name, maiden name, nickname, and so on |
| Participant Modification Time | Month, day, year, and time when the contact record was modified |
| Participant Origin Application Reference ID | System-generated string that identifies the feature through which the person became a registered user of the site |
| Participant Origin Application Type | |
| Participant Origin Source Code | A string defined by an administrator identifying a page or campaign that generated the user's registration |
| Participant Origin Subsource Code | A string defined by an administrator qualifying the Origin Source Code |
| Participant Password Type | Indicates the method used to generate the password:
|
| Participant Professional Suffix | Abbreviated respect/education label selected to follow the last name of the person (for example, MD or Esq) |
| Participant Suffix | Abbreviated label selected to follow the last name of the person (for example, Jr) |
| Participant Title | Introductory title that appears before the first name of the person (for example, Mr. or Mrs.) |
| Participant User Name | String of letters and numbers that this person enters to log in to the site. Can be entered by the person when registering as a user on this site or generated by the system. |
| Participant Email | |
|---|---|
| Participant Accept Email | Yes or No- Typically enabled by default, for whether the email recipient will accept other email from the site |
| Participant Email | The constituent's email address |
| Participant Hard-Bounce Count | Number of coaching emails that were sent back as undeliverable because of an invalid email address |
| Participant Opt-Out Date | Month, day, year, and time that the Opt-out option was disabled by or for this person so they do not receive site email messages by default |
| Participant Opt-Out Method | Indicates who or how the Opt-Out option was disabled:
|
| Participant Opt-Out Reference ID | System-generated identifier that tracks the opt-in/opt-out status change of this person |
| Participant Preferred Format | HTML if the person can receive email messages with formatting in them Plain Text if the person can only receive emails without formatting in them |
| Valued Transaction | |
|---|---|
| Account Number | The bank account, entered during the payment stage of the transaction, on which a gift payment should be drawn |
| Account Type | |
| AVS Decode Value | |
| AVS Response | One character code:
|
| Billing Address | The donor's billing address |
| Bank Name | Name on the credit card used to make an online transaction or the name entered by the administrator when recording or processing a transaction offline |
| Billing Email | The donor's email address |
| Billing Name | Name on the credit card used to make an online transaction or the name entered by the administrator when recording or processing a transaction offline |
| Billing Phone | The donor's phone number |
| Campaign Title | Name of the donation campaign with which the donation form used to collect money is associated |
| Card Expiration Date | Date when the credit card used to make a gift payment will expire |
| Card Number | Number of the credit card used to make a gift payment |
| Check Number | Number on the check received for a gift payment |
| Confirmation Code | The letter/number code combination the system assigned to the transaction system |
| Creation Method |
|
| Discount Value | Dollar figure of a discount applied to the transaction |
| Employer | Company for which the donor works |
| Gift Aid Status | True or False if government will make partial match (UK only) |
| INV Number | Invoice number returned by ecommerce gateway |
| Occupation | Employment as indicated by person who will be billed for this transaction |
| Original Value Transacted | The donation or registration fee paid online or recorded |
| Payment Installment | A number that indicates which payment transaction this is in a sequence of payments |
| Processor Transaction ID | Unique number and letter identifier assigned to the donation when it was processed in the system |
| Proxy ID | Team ID, Event ID, or Constituent depending on for which of these the transaction was completed |
| Proxy Name | One of the following:
|
| Proxy Type | Team, Event, or Participant for which the transaction was completed |
| Real Reference Number | Internal number to track original payment in a sustaining gift series (for Clear Commerce) |
| Receipt ID | Generated by system to track PDF receipt |
| Reference Number | Order number generated by Clear Commerce |
| Routing Number | Specially encoded number that identifies the bank for an account withdrawal |
| Settlement Batch | The settlement batch ID associated with this transaction |
| Settlement Date | The date the transaction was settled as provided by the payment processor. If the payment processor does not return a date, the system will determine the date of the settlement. |
| Settlement Status | Settled, Unsettled, or Submitted ACH only |
| Transaction Amount | Monetary sum of all gift payments made in support of the participant (whether marked as confirmed or if they appear on the unconfirmed gift list) plus the monetary amount of registration fees that the participant paid |
| Transaction Date | The date that the donation was processed in the system |
| Transaction ID | Unique number and letter identifier assigned to the donation when it was processed in the system |
| User Confirmation Code | The letter/number code combination the system assigned to the user |