The Transactions Data Source is the primary source for transaction reporting within ACME. Common use cases for Transactions Data Source reporting include sales for an event, sales for a specific customer, refunds over a period of time,revenue and sales data for a period of time, and related use cases. The table below lists the fields available within the Transactions Data Source and their respective definitions.


TABLE OF CONTENTS

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 of the organization's address
OrganizationNameThe name of the organization
OrganizationStateThe state of the organization's address
OrganizationZipThe zip code of the organization's address

Transaction

AcmeCustomerToken

A 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
DiscountedTransactionAmountTotal amount of the transaction after discounts are applied
DiscountedTransactionValueSum of discounts applied to the transaction
ExternalChargeIdThe payment processor's id for this charge
IncidentNumberID generated for a refund
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.

PaymentDueDateThe date that the payment is due
PaymentIdThe id of the payment
PaymentMethod

The method of payment; values are CreditCard, Cash, Check, Voucher

PaymentStatusThe status of the payment, one of Processed, Settled, Failed, Pending or Due
SaleChannel

The channel in which the sale originated; values are Online, Customer Rep, Pos, Reseller, InsideSalesIndividual or Kiosk.

Note: Organization orders are 'reseller'.

WorkstationThe terminal in which the order was placed.
TransactionAmountThe amount of the transaction prior to any discounts
SaleDateThe date that the sale took place
TransactionIdThe unique Id of this transaction
TransactionIncidentReasonCode

The reason for this transaction - used for refunds (e.g. "Canceled Event", "Rebooked Event" or "Misc")

TransactionNotesAny notes that were entered for this transaction
TransactionType

The type of transaction; values are Payment, NoPayment, Refund, Sale, ChargeBack, ChargeBack Reversal, ManualEntry, Rebook, RefundSale, RebookRefundSale,

RebookPaymentSale, RebookRefundAdjustSale, RebookPaymentAdjustSale, RebookRefund, RebookPayment, RebookRefundAdjustment, RebookPaymentAdjustment, PaymentAdjustment or RefundAdjustment.

TransactionUserName

The person signed into the Point of Sale application who completed the order or the customer rep that completed the order in backoffice.


TransactionItem (array of items associated with this transaction)

AddOnType

The type of add-on of this transaction item, one of null, doNotTrack, consumable, resource, donation, fixedDonation or membershipCardReplacement.

Coupon CodeThe line item coupon code used for this transaction
CouponNameThe name of the line item coupon that was used on this transaction item.
CouponResellerName

The name of the Organization associated with the Coupon when the Coupon was created.

ItemIncidentReasonCode

The reason for this transaction - used for refunds (e.g. "Canceled Event", "Rebooked Event" or "Misc")

ItemNameThe name of the item
OrderItemType

The type of this order item; values are: Event, Inventory, Combo, ComboInventory, RebookingFee, MembershipPurchase, MembershipRenewal, MembershipUpgrade, MembershipDowngrade, MembershipCancel, MembershipPostTermRenewal, MembershipRejoin, MembershipRenewalUpgrade, MembershipPostTermRenewalUpgrade, MembershipRejoinUpgrade, MembershipPostTermRenewalDowngrade, MembershipRejoinDowngrade,

MembershipRenewalDowngrade, MembershipPurchaseConversion,

MembershipReplacement or Donation

PricePointNameThe name of the ticket type, e.g. Adult, Child or Senior
SaleTypeIndividual or Group
TransactionItemIdThe unique Id of this transaction item

Event (array of events/tickets associated with this transaction)

AddOnThe name of the AddOn if this is an add-on associated with an event
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
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

DiscountValueThe amount of the discount expressed in dollars
Event GL CodeThe field value of the Identifier Code field on the Event Template
EventIdThe id of the event in which these tickets/add-ons are associated
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
RuleSetNameDeprecated
TicketTypeThe ticket type, e.g. Adult, Child or Senior
UnitPriceThe price of each ticket prior to any discounts

Order

GLCodeDeprecated
GLCodeDeferredDeprecated
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 - generally used for API reference
OrderItemIdThe list of order items associated with this transaction
OrderNumberThe 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



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 of the person paying for this order.
BillingCountryThe country of the person paying for this order.
BillingEmailThe email 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/province of the person paying for this order.
BillingZipCodeThe zip/post 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 of the person placing the order
EmailThe email of the person placing the order
PhoneNumberThe phone number of the person placing the order
StateThe state/province of the person placing the order
ZipCodeThe zip/post code of the person placing the order 



Settlement

NetAmountAmount after the settlement fee is applied
NetTransactionAmountAmount after the settlement fee is applied
PurchaseTypeSingle Venue of Combo Ticket
ServiceFeeAmountThe fee amount that was charged
ServiceFeePercentageThe fee percentage that was charged
SettlementIDUnique ID of the settlement
TenantPaymentStatusThe status of the payment to your venue:
  • Initiated
  • Submitted
  • Approved
  • Error
  • Due
  • PartialError
TransactionServiceFeeThe fee amount that was charged
TransactionServiceFeePercentageThe fee percentage that was charged



Membership

AuxiliaryGroupName
Name of the Auxiliary group the Auxiliary membership to which the membership is associated
AuxiliaryMembership
True/False. Indicates whether the membership is an auxiliary 
ItemAuxiliaryGroupName
Name of the Auxiliary group the Auxiliary membership to which the membership is associated 
ItemAuxiliaryMembership
True/False. Indicates whether the membership is an auxiliary
ItemMembershipLevelName
Name of the membership level  
ItemMembershipNumber
Membership number used for member verification when purchasing the item
ItemMembershipOfferingName
Name of the membership offering  
MembershipAttributeCategory

MembershipExternalId
Membership number used for member verification
MembershipId
Database ID for the membership record
MembershipLevelName
Name of the membership level purchased
MembershipNumber
Membership number used for member verification
MembershipOfferingName
Name of the membership offering purchased
MembershipPrimaryFirstName
First name of the primary cardholder
MembershipPrimaryLastName
Last name of the primary cardholder
MembershipPrimaryOrgName
Name of the Organization (only for Corporate Memberships)



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

A custom field value for an event will inherit from the template. A user can override this value if needed.

EventCustomField1 Custom field assigned to the event instance
EventCustomField2
Custom field assigned to the event instance
EventCustomField3
Custom field assigned to the event instance
EventCustomField4
Custom field assigned to the event instance
EventCustomField5
Custom field assigned to the event instance

Customer

CustomerAddressCity

CustomerAddressCountry

CustomerAddressState

CustomerAddressStreet1

CustomerAddressStreet2

CustomerAddressSuburb

CustomerAddressZip

CustomerEmail

CustomerExternalImportId

CustomerFirstName

CustomerId

CustomerLastName

CustomerPhoneNumber

CustomerSource


Donation

DonationAppealName
DonationCampaignName
DonationFundName