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. 


TRANSACTIONSDetailed list of payments, sales, and refunds.
Tenant
TenantGroupACME Internal Use
Organization
OrganizationAddress1The street address of the organization
OrganizationAddress2The second line of the street address of the organization
OrganizationCategoryNameThe category name of the organization
OrganizationCityThe city that the organization is in
OrganizationNameThe name of the organization
OrganizationStateThe state that the organization is in
OrganizationZipCodeThe zip code that the organization is in.
Transaction
AcmeCustomerTokenA custom token that attempts to identify this customer, this token is close to 98% accurate in identifying this customer
CreditCardBrandThe brand of credit card that was used
CreditCardLast4DigitsThe last four digits of the credit card
DiscountedTransactionAmountReturns Discounted value of Order total Amounts
DiscountedTransactionValueReturns Discount values from the Transaction level
ExternalChargeIdThe payment processor's id for this charge
IncidentNumberReturns the Incident Numbers of modified transactions
ParentTransactionIdThe 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.
PaymentDueDateThe date that the payment is due
PaymentEntryTypeUnused
PaymentIdThe id of the payment
Payment MethodThe method of payment one of CreditCard, Cash, Check, GiftCard, ManualEntry, Voucher or TravellersCheck
PaymentStatusThe status of the payment, one f Processed, Settled, Failed, Pending or Due
SaleChannelThe channel that the sale took place on, one of Online, Customer Rep, Pos, Manual Entry, Reseller, InsideSalesIndividual or Kiosk
TerminalIdThe terminal that the order was placed on
TransactionAmountThe amount of the transaction prior to any discounts
TransactionDateThe date that the sale took place
TransactionIdThe unique Id of this transaction
TransactionIncidentReasonCodeThe reason for this transaction, this is venue specific and might be something like "Canceled Event", "Rebooked Event" or "Misc".
TransactionNotesAny notes that were entered for this transaction
TransactionTypeThe type of transaction.
TransactionUserLoginThe person signed into the PoS taking the order or the customer rep that took the order.
TransactionItem
AddOnTypeThe type of add-on of this transaction item.
CouponCodeThe line item coupon code used for this transaction item.
CouponNameThe name of the line item coupon that was used on this transaction item.
CouponResellerNameReturns Organization name when the organization is associated with a coupon
ItemIncidentReasonCodeThe reason code for this transaction item. Might be something like "Payment", "Rebook Event", "Canceled Event" or "Misc."
ItemNameThe name of the item
OrderItemTypeThe type of this order item.
PricePointNameThe name of the ticket type like Adult, Child or Senior
SaleTypeIndividual or Group
TransactionItemIdThe unique Id of this transaction item
FormTransactionItem
FormDescriptionReturns the form description field
FormNameReturns the name of the form
FormResponseNumberReturns the unique ID when someone submits a form
FormSubmissionDateReturns the date a form was submitted
Event
Add-onName of add-ons
AmountThe total amount for this item
DiscountCodeThe discount code associated with this event or ticket
DiscountedAmountThe discounted total amount
DiscountedUnitPriceThe discounted ticket amount
DiscountNameThe name of the discount
DiscountTagWhen setting up a discount, you can set a tag for each ticket type. This is the discount tag associated with this ticket type
DiscountValueThe amount of the discount, something like "20%" or "$2"
EventGLCodeReturns Event GL Code field data
EventIDThe id of the event that these tickets/add-ons are associated with
EventNameThe name of the event
EventStartTimeThe date of the event
FlexPayTrue if flex pay was used, otherwise false
PaymentAmountThe amount of payment that's been applied to these tickets
QuantityThe number of tickets
RuleSetNameMembership rule set name for templates
TicketTypeThe ticket type like Adult, Child or Senior
UnitPriceThe price of each ticket prior to any discounts
Order
GLCodeReturns the unique GL Code of a Line Item
GLCodeDeferredReturns the GL Code defined by the GL Code Mapping tool
OrderAmountThe total amount of the order
OrderBalanceThe amount of the order that has yet to be paid
OrderCreationDateThe date that the order was made
OrderIdThe unique id associated with this order. Use this to verify the accuracy of the report or to answer questions and fine tune your report
OrderItemIdThe 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.
OrderNumberThe venue's order number associated with this transaction.
OrderRequestItemExtReferenceIdIf this transaction is associated with an order request then this is the venue's unique id of the order request.
OrderRequestNumberIf this transaction is associated with an order request then this is the order request number associated with this transaction.
Visitor
Address1First line of the street address
Address2Second line of the street address
BillingAddress1The first line of the street address for the person paying for this order
BillingAddress2The second line of the street address for the person paying for this order
BillingCityThe city that the person paying for this order is in
BillingCountryThe country that the person paying for this order is in.
BillingEmailThe email address of the person paying for this order
BillingFirstNameThe first name of the person paying for this order
BillingLastNameThe last name of the person paying for this order
BillingPhoneNumberThe phone number of the person paying for this order
BillingStateThe state that the person paying for this order resides in
BillingZipCodeThe zip code of the person paying for this order
CityThe city of the person placing the order
ContactFirstNameThe first name of the person placing the order
ContactLastNameThe last name of the person placing the order
CountryThe country that the person placing the order lives in
EmailThe email address of the person placing the order
PhoneNumberThe phone number of the person placing the order
StateThe state of the person placing the order
ZipCodeThe zip code of the person placing get order
Settlement
NetAmountReturns Net value per line item Amounts
NetTransactionAmountReturns Net value per Transaction Amounts
PurchaseTypeThe purchase type, one of "Single Venue" or "Combo Ticket"
ServiceFeeAmountThe amount that ACME charged
ServiceFeePercentageThe percentage that ACME charged
SettlementIdThe unique id of the settlement
TenantPaymentStatusThe status of the payment to your venue. One of Initiated, Submitted, Approved, Error, Due or PartialError
TransactionServiceFeeThe amount that ACME charged for this transaction
TransactionServiceFeePercentageThe percentage that ACME charged for this transaction
Membership
AuxiliaryGroupNameGroup that auxiliary membership belongs to
AuxiliaryMembershipTrue / False flag for memberships to note if the are auxiliary memberships
BenefitAuxiliaryGroupNameGroup that auxiliary membership belongs to
BenefitAuxiliaryMembershipTrue / False flag for memberships to note if the are auxiliary memberships
BenefitMembershipLevelNameMembership Level (Program) Name
BenefitMembershipNumberMembership ID number
BenefitMembershipOfferingNameMembership Offering Name
ItemAuxiliaryGroupNameGroup that auxiliary membership belongs to
ItemAuxiliaryMembershipTrue / False flag for memberships to note if the are auxiliary memberships
ItemMembershipLevelNameMembership Level (Program) Name
ItemMembershipNumberMembership ID number
ItemMembershipOfferingNameMembership Offering Name
ItemMembershipPrimaryFirstNameFirst name of the primary on a membership
ItemMembershipPrimaryLastNameLast name of the primary on a membership
MembershipAttributeCategoryUnused
MembershipExternalIdMembership externally generated ID 
MembershipIdMembership internally generated ID
MembershipLevelNameMembership Level (Program) Name
MembershipNumberMembership ID number
MembershipOfferingNameMembership Offering Name
MembershipPrimaryFirstNameFirst name of the primary on a membership
MembershipPrimaryLastNameLast name of the primary on a membership
MembershipPrimaryOrgNameName of the primary contact for an organization membership
EventTemplateCustomFields
EventTemplateCustomField1Custom field assigned to the event template.
EventTemplateCustomField2Custom field assigned to the event template.
EventTemplateCustomField3Custom field assigned to the event template.
EventTemplateCustomField4Custom field assigned to the event template.
EventTemplateCustomField5Custom field assigned to the event template.
EventCustomFields
EventCustomField1Custom field assigned to the event.
EventCustomField2Custom field assigned to the event.
EventCustomField3Custom field assigned to the event.
EventCustomField4Custom field assigned to the event.
EventCustomField5Custom field assigned to the event.
Customer
CustomerAddressCityThe city that the person placing the order lives in
CustomerAddressCountryThe country that the person placing the order lives in
CustomerAddressStateThe state that the person placing the order lives in
CustomerAddressStreet1The first line of the street address of the person placing the order
CustomerAddressStreet2The second line of the street address of the person placing the order
CustomerAddressSuburbThe suburb of the person placing the order
CustomerAddressZipThe zip code of the person placing the order
CustomerEmailThe email of the person placing the order
CustomerExternalImportIdIf the customer was imported from something like Raiser's Edge, this will be the Raiser's Edge import id
CustomerFirstNameThe first name of the person placing the order
CustomerIdThe unique id of the person placing the order
CustomerImportIdConstituent ID imported from external source
CustomerLastNameThe last name of the person placing the order
CustomerMiddleNameThe middle name of the person placing the order.
CustomerPhoneNumberThe phone number of the person placing the order
CustomerSourceHow 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.
CustomerTitleThe title of the person placing the order.
Donation
DonationAppealNameIf this item is an order then this is the appeal associated with the donation
DonationCampaignNameIf this item is an order then this is the campaign associated with the donation
DonationFundNameIf this item is an order then this is the fund associated with the donation