Transactions report

The customizable Transactions report provides details about all transactions that were generated on a marketplace during a defined period.

note

This report is available to Marketplace Managers.

Recommended fields appear by default in the report. However, when you create a report, you can remove default fields or add different fields. If Marketplace Managers create custom attributes (see Create custom attributes), you can also include those fields when you create the report. Only custom attributes that were created in your marketplace (not child marketplaces) are displayed.

In the following table, the last column indicates whether or not the column is included by default.

Heading	Description	Included by default?
Order ID	Unique identifier for the order of the product in the marketplace.	Y
Next Order ID	Unique identifier of the subsequent purchase order related to the current order.	Y
Order Creation Date	Date on which the purchase order was generated.	Y
Order Type	Type of order. Possible values include: prepaid and postpaid.	Y
Order Status	Status of the order. Possible values include: active, canceled, failed, finished, free trial, free trial canceled, free trial expired, initialized, one time, pending asynchronous creation, pending manual recovery, pending remote creation, pending user approval, suspended and upcoming.	Y
Trial Expiration Date	If the order status is free trial or free trial expired, the free trial expiration date is listed.	Y
Subscription Type	Type of subscription. Possible values include: new, migration, adoption, free trial activation, metered usage, end of contract migration, refund, termination, credit, one time fee, additional fee, end of discount migration.	Y
Subscription Status	The status of the subscription. Possible values include: initialized, failed, free trial, free trial expired, active, suspended, and canceled.	Y
Transaction ID	Identifier recorded for the transaction.	Y
Transaction Date	Date of the transaction.	Y
Payment ID	Unique identifier recorded for the payment.	Y
Invoice ID	Identifier recorder for the invoice.	N
User ID	Unique identifier of the customer who purchased the product.	Y
First Name	First name of the customer.	Y
Last Name	Last name of the customer.	Y
Email Address	Customer’s email address.	Y
Company ID	ID of the company who purchased the product.	Y
Company Name	Name of the company that purchased the product.	Y
Company Street	Street address of the company that purchased the product.	Y
Company City	City of the company that purchased the product.	Y
Company State	State of the company that purchased the product.	Y
Company Zip Code	ZIP Code of the company that purchased the product.	Y
Billing Address Street 1	Street address associated with the customer's payment method.	Y
Billing Address City	City associated with the customer's payment method.	Y
Billing Address State	State associated with the customer's payment method.	Y
Billing Address Zip Code	Zip code associated to the customer's payment method.	Y
Vendor ID	Unique identifier of the application Developer on the marketplace.	Y
Vendor Name	Name of the application Developer.	Y
Product Name	Application name of the product that was purchased.	Y
Product type	The product type for the purchased application or product. Sample values include: web app stacked, domain reseller, cloud services, physical product	N
Edition Name	Edition name of the product that was purchased.	Y
Edition Code	Edition identifier specified and exchanged between the application Developer and Marketplace.	Y
Revenue Model Type	Revenue model type. Possible values are: recurring, tiered, free.	Y
Billing Frequency	Subscription period. Possible values include: monthly, one time, yearly, six months, three years, two years, quarterly, daily.	Y
Pay Period Start	The start date of the pay period.	Y
Pay Period End	The end date of the pay period.	Y
Is Refund	Indicates whether the transaction is a refund. Possible values are: true, false.	Y
Is Chargeback	Indicates whether the transaction is a chargeback. Possible values are: true, false.	Y
Discount Code	Discount code, if applicable, that is applied to the invoice.	Y
Discount Type	Type of discount. Possible values are: fixed price and percentage.	Y
Discount Percentage	Discount percentage if discount type is percentage.	Y
Discount Price	Amount of dollars discounted if the discount type is fixed price.	Y
Currency	The currency in which the payment is processed.	Y
Total Revenue	Total revenue. Equivalent to total cash flow minus taxes.	Y
Taxes	Tax amount.	Y
Tax Summary ID	Unique identifier that can be used to retrieve additional information on the calculated tax amount.	Y
Channel Share	The marketplace's revenue share.	Y
Vendor Share	The revenue share for the application Developer.	Y
Appdirect Share	AppDirect's revenue share.	Y
Reseller Share	The revenue share for the Reseller.	Y
Total Payment	Total payment value.	Y
Channel % Share	The percentage value of the marketplace's revenue share.	Y
Vendor % Share	The percentage value of the Developer's revenue share.	Y
Appdirect % Share	The percentage value of the revenue share for AppDirect.	Y
Reseller % Share	The percentage value of the Reseller’s revenue share.	Y
Line Total	Invoice line total.	Y
Line Type	Determines if the payment processed is for the product purchase, discount or taxes.	Y
Payment Recurring Status	Indicates whether the transaction is for a new purchase or an existing one. Possible values are: new and recurring.	Y
Invoice Number	Invoice number associated with the transaction	Y
Product ID	Unique identifier of the application or product in the marketplace.	N
Edition ID	Identifier of the product edition in the marketplace.	N
Company UUID	Unique universal ID of the company that purchased the product .	N
Company External ID	External ID of the company on the marketplace.	N
Reseller ID	Reseller’s identifier on the marketplace.	N
Reseller UUID	Reseller agent’s unique universal identifier on the marketplace.	N
Reseller External ID	Reseller's external identifier on the marketplace.	N
Reseller Email Address	Email address of the Reseller that assisted in the sale.	N
Reseller Company ID	Reseller company’s identifier on the marketplace.	N
Reseller Company Name	Reseller’s company’s name on the marketplace.	N
Reseller Company UUID	Reseller company’s unique universal id on the marketplace.	N
Reseller Company External ID	Reseller company’s external identifier on the marketplace.	N
Subscription ID	Unique identifier of the subscription on the marketplace.	N
Item Wholesale Price	The wholesale price of the product that the Reseller paid when they purchased the product from the marketplace	N
Item Markup Price by Reseller	The marked up price for the product as set by the reseller during an assisted sales	N
Subscription Start Date	Date on which the customer's subscription to the product is created.	N
Subscription End Date	Date on which the customer's subscription to the product ends.	N
Billing Address Street 2	Second line associated to the customer's payment method.	N
Billing Phone Number	Phone number linked to billing information.	N