Payment details report

This customizable report provides detailed information about payments made on a marketplace. The column headings that it includes are based on the fields you apply when you create the report.

note

This report is available to Marketplace Managers, Developers, Network Managers, and Resellers. This feature must be enabled by AppDirect for your marketplace and for your role. Contact your AppDirect technical representative for information. Additionally, some of the fields described in the table may not be included for your role. To see all of the available fields, click the Choose Fields tab in the Customize reports section on the Create Reports page. See Create reports for more information.

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?
Invoice ID	Unique identifier for the invoice line.	N
Payment ID	Identifier recorded for the payment.	Y
Transaction ID	Identifier recorded for the transaction.	Y
Subscription ID	Unique identifier of subscription being paid.	N
Order Item ID	Unique identifier for the item in the product order.	Y
Reference Code	Purchase order reference code. This field is enabled by default for resellers and developers. Users with other roles can add it when they create a report.	Y/N
Invoice Line ID	Unique identifier of the invoice line.	N
Date	Date the payment was recorded.	Y
First Name	The first name of the user who completed the payment.	Y
Last Name	The last name of the user who completed the payment.	Y
User ID	Unique identifier of the user who purchased the product.	N
Email	Email of the user who completed the payment.	Y
User External ID	External ID of the user who purchased the product	N
Company	Company of the user who completed the payment.	Y
Company ID	Unique identifier of the company.	Y
Channel	Name of the marketplace.	Y
Vendor	Name of the application developer	Y
Vendor ID	Identifier of the application developer on the marketplace.	Y
Provider	Name of the application provider (the name entered in the Company Name field on the Listing Info page)	N
Receiving Partner	Name of the receiving partner.	N
Reconciliation Line ID	Unique identifier of the payment reconciliation. This field is enabled by default for marketplace managers. Network managers can add it when they create a report.	Y/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
Reconciliation Creation Date	Date on which the reconciliation was created.	N
Reconciliation Last Modified Date	Last date on which the reconciliation was modified.	N
Payment Method	Method used to make the payment.	Y
Application	Name of the application or product that was purchased.	Y
Application ID	Unique identifier of the application or product that was purchased.	Y
Application UUID	Unique identifier of the application on the marketplace.	N
Edition	Edition code of the application or product that was purchased.	Y
Edition ID	Unique identifier of the application or product that was purchased.	Y
Edition UUID	Unique identifier on the marketplace for this edition of the product.	N
Add-on Parent Product ID	Parent product list for add-on product.	N
Add-on Parent Product and Edition ID	Parent product and edition list for add-on product.	N
Description	Description of the product configured by the application developer. This field is enabled by default for resellers and developers. Users with other roles can add it when they create a report.	Y/N
Quantity	Number of items charged.	Y
Line Type	Determines if the payment processed is for the product or tax.	Y
Unit Type	The type of unit purchased (for example, gigabyte)	Y
Price Per Unit	Price paid for each unit purchased	Y
Application Origin	Indicates whether the application was part of the AppDirect Master Catalog and syndicated to the marketplace or if the application originated on the marketplace. This field is enabled by default for resellers and developers. Users with other roles can add it when they create a report.	Y/N
Currency	Currency in which the payment is processed.	Y
Total	Total payment value.	Y
AppDirect Share	Revenue share for AppDirect.	Y
AppDirect % Share	Percentage value of the revenue share for AppDirect.	Y
Channel Share	Revenue share for the marketplace.	Y
Channel % Share	Percentage value of the revenue share for the marketplace.	Y
Channel Payout ID	Unique identifier of the marketplace payout.	N
Vendor Share	Value of the revenue share for the application developer.	Y
Vendor % Share	Percentage value of the revenue share for the application developer.	Y
Reseller Share	Value of the revenue share for the reseller reported to have assisted the sale.	Y
Reseller % Share	Percentage value of the revenue share for the reseller.	Y
Payout Status	Indicates whether the payment has been reconciled with the application developer. This field is enabled by default for resellers and developers. Users with other roles can enable it when they create a report.	Y/N
Payout ID	Identifier to use when looking at the payout the payment belongs to. This field is enabled by default for resellers and developers. Users with other roles can enable it when they create a report.	Y/N
Result	End result of the payment. Possible values: Successful, failed, manual.	Y
Auth Code	Authorization code.	Y
Reseller Email	Email address of the reseller that assisted in the sale.	Y
Pay Period Start	Start date of the pay period the payment was recorded.	Y
Pay Period End	End date of the pay period the payment was recorded.	Y
Vendor Company UUID	Application developer's unique identifier on the marketplace.	N
Vendor Company External ID	Application developer's external identifier on the marketplace.	N
Vendor Company Street 1	Application developer's street address .	N
Vendor Company Street 2	Application developer's additional address information .	N
Vendor Company State	Application developer's state.	N
Vendor Company Zip	Application developer's ZIP code.	N
Vendor Company Country	Application developer's country.	N
Vendor Company Phone	Application developer's phone number.	N
Vendor Company Phone Extension	Application developer's phone number extension.	N
Vendor Company Fax	Application developer's fax number.	N
Vendor Company Fax Extension	Application developer's fax number extension.	N
Reseller Company UUID	Reseller's unique identifier on the marketplace .	N
Reseller User External ID	Reseller's external identifier on the marketplace.	N
Reseller Company Phone Extension	Reseller's telephone extension.	N
Reseller Company Street 1	Reseller street address.	N
Reseller Company Street 2	Reseller's additional address information.	N
Reseller Company State	Reseller's state.	N
Reseller Company Zip	Reseller's ZIP code.	N
Channel SKU	The marketplace SKU associated with the pricing item.	Y
Company Country	The company’s country. This field is enabled by default for resellers and developers. Users with other roles can enable it when they create a report.	Y/N
Discount Code	Discount code. This field is enabled by default for resellers and developers. Users with other roles can enable it when they create a report.	Y/N
Discount Type	Discount type. This field is enabled by default for resellers and developers. Users with other roles can enable it when they create a report.	Y/N
Percentage Discount	Discount percentage. This field is enabled by default for resellers and developers. Users with other roles can enable it when they create a report.	Y/N
Fixed Price Discount	Amount of the fixed discount that is applied to the price. This field is enabled by default for resellers and developers. Users with other roles can enable it when they create a report.	Y/N
Order ID	The purchase order ID.	Y
Revenue Model Type	The revenue model associated with the purchased product. This field is enabled by default for resellers and developers. Users with other roles can enable it when they create a report.	Y/N
External Vendor Identifier	Unique identifier used by the application vendor associated with a subscription.	N
Microsoft Order ID	Unique identifier for a specific Microsoft order.	N
Microsoft Subscription ID	Unique identifier for a Microsoft subscription.	N
Edition Code	Edition identifier specified by the application Developer. This field is enabled by default for resellers and developers. Users with other roles can enable it when they create a report.	Y/N
Subscription Status	Status of the subscription. Possible values include: active, canceled, failed, free trial, free trial expired, initialized, suspended. This field is enabled by default for resellers and developers. Users with other roles can enable it when they create a report.	Y/N
Subscription Start Date	Date on which the subscription is created.	N
Subscription End Date	Date on which the subscription is canceled.	N
Product Custom Integration	Indicates if the product has custom integration. Possible values include: null (no custom integration), Autodesk, doc center (documentation center ), Docusign, domain registration (Melbourne IT Domain Registration), Google Apps, McAfee (McAfee California), McAfee Denver, MOSI (Microsoft Online Services), Mozy, New Relic, Norton, Samsung License, ScaleXtreme, SendGrid, Symantec.cloud, Symantec.ev.cloud, WebEx.	N
Is Sub Canceled Before Pay Period Ends	Indicates if a subscription was cancelled prior to the Pay Period End. Possible values: Y, N.	N
Product Type	Indicates the type of the application or product. Possible values: web app stacked, domain reseller, cloud services, physical product, and so on.	N
Billing Frequency	Billing frequency of the product edition purchased. Possible values: daily, monthly, one time, quarterly, yearly, and so on	N
Invoice Number	Invoice number associated with the payment	Y
Response Message	Displays information about transactions that are included in the report. The value varies depending on the marketplace and payment method. It can include any information that was added as a note about the payment. Sample values can include: the transaction has been approved, declined, refused by issuer.	N
Reseller Agent ID	ID of the Reseller Agent associated with the payment	N
Reseller Agent Name	Name of the Reseller Agent associated with the payment	N
Billing Address City	Billing address city that is associated with the user's default payment method	N
Billing Address Country	Billing address country that is associated with the user's default payment method	N
Billing Address Postal Code	Billing address postal/zip code that is associated with the user's default payment method	N
Billing Address State	Billing address state that is associated with the user's default payment method	N
Billing Address Street 1	First line of billing address that is associated with the user's default payment method	N
Billing Address Street 2	Second line of billing address that is associated with the user's default payment method	N
Billing Phone Number	Phone number linked to billing information that is associated with the user's default payment method	N
Company External ID	Purchasing company's external identifier on the marketplace	N
Company Fax	Purchasing company's fax number	N
Company Fax Extension	Purchasing company's fax number extension	N
Company Phone	Purchasing company's phone number	N
Company Phone Extension	Purchasing company's phone number extension	N
Company State	Purchasing company's state	N
Company Street 1	Street address of the company that purchased the product	N
Company Street 2	Additional address information for the company that purchased the product	N
Company UUID	Unique identifier for the company on the marketplace	N
Company Zip	Purchasing company’s ZIP code	N
Reseller Company Country	The reseller company’s country	N
Reseller Company External ID	External ID of the reseller company on the marketplace	N
Reseller Company Fax	The fax number of the reseller company	N
Reseller Company Fax Extension	The fax number extension of the reseller company	N
Reseller Company ID	ID of the reseller company who purchased the product	N
Reseller Company Name	Name of the reseller company that purchased the product	N
Reseller Company Phone	The phone number of the reseller company	N
Marketplace Name	Name of the marketplace	Y
Company Name	Name of the purchasing company	Y
Purchase Order ID	Unique identifier of the purchase order	Y