Note:: When running a transactions report, be sure to filter your results to only look at Sales/RefundSales or Payments/Refunds. Failing to add this filter will result in a duplication of your reported data.
TRANSACTIONS | Detailed list of payments, sales, and refunds. |
Tenant | |
TenantGroup | ACME Internal Use |
Organization | |
OrganizationAddress1 | The street address of the organization |
OrganizationAddress2 | The second line of the street address of the organization |
OrganizationCategoryName | The category name of the organization |
OrganizationCity | The city that the organization is in |
OrganizationID | The ID of the organization that placed the order |
OrganizationName | The name of the organization |
OrganizationState | The state that the organization is in |
OrganizationZipCode | The zip code that the organization is in |
Transaction | |
AcmeCustomerToken | A custom token that attempts to identify this customer; this token is close to 98% accurate in identifying this customer |
CreditCardBrand | The brand of credit card that was used Values:
|
CreditCardLast4Digits | The last four digits of the credit card |
DiscountedTransactionAmount | Returns Discounted value of Order total Amounts |
DiscountedTransactionValue | Returns Discounted value from the Transaction level |
ExternalChargeId | The payment processor's ID for this charge |
IncidentNumber | Returns the Incident Numbers of modified transactions |
ParentTransactionId | The ID of the parent transaction. A payment transaction will generally have a sale transaction as its parent, this ID is used to associate transactions with each other. |
PaymentDueDate | The date that the payment is due |
PaymentEntryType | For in-person card payments. Values include: Contactless, Insert, Swipe |
PaymentId | For a Payment transaction where the Payment Method is Check, Voucher, or Other, then it holds the Payment ID entered during checkout For a ChargeBack or ChargeBackRefund transaction, it holds the TransactionId of the original payment. |
Payment Method | The method of payment; one of CreditCard, Cash, Check, GiftCard, ManualEntry, Voucher, Other, or TravellersCheck |
PaymentStatus | The status of the payment, one of Processed, Settled, Failed, Pending, or Due |
SaleChannel | The original channel in which the sale took place. Values:
|
TerminalId | The terminal that the order was placed on |
TransactionAmount | The amount of the transaction prior to any discounts |
TransactionDate | The date and time that the sale took place in "MM/DD/YY at h:mm a" format |
TransactionId | The unique ID of this transaction |
TransactionIncidentReasonCode | The reason for this transaction; this is venue specific and might be something like "Canceled Event", "Rebooked Event" or "Misc". |
TransactionNotes | Any notes that were entered for this transaction |
TransactionType | The type of transaction. See Transaction Type Definitions for specifics |
TransactionUserLogin | The person signed into the POS taking the order or the customer rep that took the order |
TransactionItem | |
AddOnType | The type of add-on or donation of this transaction item; possible values:
|
CouponCode | The line item coupon code used for this transaction item |
CouponName | The name of the line item coupon that was used on this transaction item |
CouponResellerName | Returns Organization name when the organization is associated with a coupon |
ItemIncidentReasonCode | The reason code for this transaction item. Might be something like "Payment", "Rebook Event", "Canceled Event" or "Misc." |
ItemDetailID | ID of membership version purchased |
ItemName | The name of the item |
OrderItemType | The type of this order item. Values:
|
PricePointName | The name of the ticket type like Adult, Child, or Senior |
SaleType | Individual or Group |
TransactionItemId | The unique ID of this transaction item |
FormTransactionItem | |
FormDescription | Returns the form description field |
FormName | Returns the name of the form |
FormResponseNumber | Returns the unique ID when someone submits a form |
FormSubmissionDate | Returns the date a form was submitted |
Event | |
Add-on | Name of the add-on or donation, as configured |
Amount | The total amount for this item |
DiscountCode | The discount code associated with this event or ticket |
DiscountedAmount | The discounted total amount |
DiscountedUnitPrice | The discounted ticket amount |
DiscountName | The name of the discount list |
DiscountTag | When setting up a discount, you can set a tag for each ticket type. This is the discount tag associated with this ticket type |
DiscountValue | The amount of the discount, something like "20%" or "$2" |
EventGLCode | Returns Event GL Code field data |
EventID | The ID of the event instance that these tickets/add-ons are associated with |
EventName | The name of the event |
EventStartTime | The date and start time of the event |
FlexPay | True if flex pay was used, otherwise false |
PaymentAmount | The amount of payment that's been applied to these tickets |
Quantity | The number of tickets |
RuleSetName | Membership rule set name for templates |
TicketType | The ticket type like Adult, Child or Senior |
UnitPrice | The price of each ticket prior to any discounts |
Order | |
GLCode | Returns the unique GL Code of a Line Item |
GLCodeDeferred | Returns the GL Code defined by the GL Code Mapping tool (deprecated) |
OrderAmount | The total amount of the order |
OrderBalance | The amount of the order that has yet to be paid |
OrderCreationDate | The date that the order was made |
OrderId | The unique ID associated with this order. Use this to verify the accuracy of the report or to answer questions and fine tune your report |
OrderItemId | The list of order items associated with this transaction. Use this to verify the accuracy of the report or to answer questions and fine tune your report. |
OrderNumber | The venue's order number associated with this transaction |
OrderRequestItemExtReferenceId | If this transaction is associated with an order request then this is the venue's unique ID of the order request |
OrderRequestNumber | If this transaction is associated with an order request then this is the order request number associated with this transaction |
Billing Contact | |
BillingAddress1 | The first line of the street address for the person paying for this order |
BillingAddress2 | The second line of the street address for the person paying for this order |
BillingCity | The city that the person paying for this order is in |
BillingCountry | The country that the person paying for this order is in |
BillingEmail | The email address of the person paying for this order |
BillingFirstName | The first name of the person paying for this order |
BillingLastName | The last name of the person paying for this order |
BillingPhoneNumber | The phone number of the person paying for this order |
BillingState | The state that the person paying for this order resides in |
BillingZipCode | The zip code of the person paying for this order |
Order Contact | |
Address1 | First line of the street address |
Address2 | Second line of the street address |
City | The city of the person placing the order |
ContactFirstName | The first name of the person placing the order |
ContactLastName | The last name of the person placing the order |
Country | The country that the person placing the order lives in. Country data entered using the POS Survey will be saved to this field. |
The email address of the person placing the order | |
PhoneNumber | The phone number of the person placing the order |
State | The state of the person placing the order |
ZipCode | The zip code of the person placing the order. Zip code data entered using the POS Survey will be saved to this field. |
Settlement | |
NetAmount | Returns Net value per line item Amounts |
NetTransactionAmount | Returns Net value per Transaction Amounts |
PurchaseType | The purchase type, one of "Single Venue" or "Combo Ticket" |
ServiceFeeAmount | Calculated value of the percent fee charged per item |
ServiceFeePercentage | The percentage fee that ACME charges per payment, like 2.9% |
SettlementId | The unique ID of the settlement |
TenantPaymentStatus | The status of the payment to your venue. One of Initiated, Submitted, Approved, Error, Due or PartialError |
TransactionFixedFee | The fixed fee that ACME charged for this payment |
TransactionPercentFee | Calculated value of the percent fee charged per item |
TransactionServiceFee | The total fee that ACME charged for this payment (fixed + percentage) |
TransactionServiceFeePercentage | The percentage fee that ACME charges per payment, like 2.9% |
Membership | |
AuxiliaryGroupName | Group that auxiliary membership belongs to |
AuxiliaryMembership | True / False flag for memberships to note if the are auxiliary memberships |
BenefitAuxiliaryGroupName | Group that auxiliary membership belongs to |
BenefitAuxiliaryMembership | True / False flag for memberships to note if the are auxiliary memberships |
BenefitMembershipLevelName | Membership Level Name |
BenefitMembershipNumber | Membership ID number |
BenefitMembershipOfferingName | Membership Offering Name |
ItemAuxiliaryGroupName | Group that auxiliary membership belongs to |
ItemAuxiliaryMembership | True / False flag for memberships to note if the are auxiliary memberships |
ItemMembershipLevelName | Membership Level Name |
ItemMembershipNumber | Membership ID number |
ItemMembershipOfferingName | Membership Offering Name |
ItemMembershipPrimaryFirstName | First name of the primary on a membership |
ItemMembershipPrimaryLastName | Last name of the primary on a membership |
MembershipAttributeCategory | Unused |
MembershipExternalId | Membership externally generated ID |
MembershipId | Membership internally generated ID |
MembershipLevelName | Membership Level (Program) Name |
MembershipNumber | Membership ID number |
MembershipOfferingName | Membership Offering Name |
MembershipPrimaryFirstName | First name of the primary on a membership |
MembershipPrimaryLastName | Last name of the primary on a membership |
MembershipPrimaryOrgName | Name of the primary contact for an organization membership |
EventTemplateCustomFields | |
EventTemplateCustomField1 | Custom field assigned to the event template |
EventTemplateCustomField2 | Custom field assigned to the event template |
EventTemplateCustomField3 | Custom field assigned to the event template |
EventTemplateCustomField4 | Custom field assigned to the event template |
EventTemplateCustomField5 | Custom field assigned to the event template |
EventCustomFields | |
EventCustomField1 | Custom field assigned to the event |
EventCustomField2 | Custom field assigned to the event |
EventCustomField3 | Custom field assigned to the event |
EventCustomField4 | Custom field assigned to the event |
EventCustomField5 | Custom field assigned to the event |
Customer | |
CustomerAddressCity | The city that the person placing the order lives in |
CustomerAddressCountry | The country that the person placing the order lives in |
CustomerAddressState | The state that the person placing the order lives in |
CustomerAddressStreet1 | The first line of the street address of the person placing the order |
CustomerAddressStreet2 | The second line of the street address of the person placing the order |
CustomerAddressSuburb | The suburb of the person placing the order |
CustomerAddressZip | The zip code of the person placing the order |
CustomerEmail | The email of the person placing the order |
CustomerExternalImportId | If the customer was imported from something like Raiser's Edge, this will be the Raiser's Edge import id |
CustomerFirstName | The first name of the person placing the order |
CustomerId | The unique ID of the person placing the order |
CustomerImportId | Constituent ID imported from external source |
CustomerLastName | The last name of the person placing the order |
CustomerMiddleName | The middle name of the person placing the order |
CustomerPhoneNumber | The phone number of the person placing the order |
CustomerSource | How the customer was put in ACME's system. Generally "acme" but could be the name of the tool that held the customer prior to ACME. |
CustomerTitle | The title of the person placing the order |
Donation | |
DonationAppealName | If this item is an order then this is the appeal associated with the donation |
DonationCampaignName | If this item is an order then this is the campaign associated with the donation |
DonationFundName | If this item is an order then this is the fund associated with the donation |
ItemDetailID | ID of the donation given |