Orders report

This report provides detailed information about the orders that have been created on your marketplace. An order represents an item or items in a purchase. For more information about orders, see Orders topics in the AppDirect documentation center.

note

This report is available to Marketplace Managers

The column headings included in this report are based on the fields that you apply when you create the report. Following is a list of all columns that appear in your report, if you select every field. Note that, if custom order fields have been configured for your marketplace, your report includes additional columns. See Create custom attributes to learn more.

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 on the marketplace.	Y
Application Name	Name of the application or product.	Y
Application ID	Unique identifier of the application or product on the marketplace.	Y
Application UUID	Unique universal ID of the application	N
Edition Name	Name of the edition associated with the application or product.	Y
Edition ID	Identifier of the edition of the product on the marketplace.	Y
Edition UUID	Universal ID of the edition	N
Product Category	List of product categories associated with purchased application	N
Product Sub Category	List of product sub categories associated with purchased application	N
Product Category & Sub Category	List of product categories and subcategories associated with purchased application, separated by an ampersand. For example: "New Category App"=,"Services"="Audit & Consulting","Services"="Engineering”& Integration","Services"="Design","Web Development"=	N
Product type	The product type for the purchased application or product. Sample values include: web app stacked, domain reseller, cloud services, physical product	N
Microsoft Domain Name	Microsoft domain name associated with the purchasing company. Listed only when the purchased application is integrated with Microsoft.	N
Microsoft Tenant ID	Microsoft tenant ID associated with the purchasing company. Listed only when the purchased application is integrated with Microsoft.	N
Company	Name of the company that purchased the edition of the product.	Y
Company ID	ID of the company that purchased the edition of the product.	Y
Company UUID	Unique universal ID for the customer on the marketplace	N
Company External ID	Company's external ID on the marketplace	N
Company Street 1	Street address of the purchasing company	N
Company Street 2	Additional address information for the purchasing company	N
Company State	Sate where the company is located	N
Company Country	Company's country	N
Company Phone	Purchasing company's phone number	N
Company Phone Extension	Purchasing company's phone number extension	N
Company Fax	Purchasing company's fax number	N
Company Fax Extension	Purchasing company's fax number extension	N
User	Customer who purchased the edition of the product to which the order applies.	Y
User ID	Unique identifier for the customer who purchased the edition of the product to which the order applies.	Y
User External ID	User's external ID on the marketplace	N
User UUID	ID of the customer who purchased the edition of the product to which the order applies. This identifier is used when making API calls.	Y
Email	User email.	Y
Vendor	Name of the application developer.	Y
Vendor ID	Unique identifier for the application developer.	Y
Company Entitlement UUID	Identifier that defines the company’s subscription to the product. This remains unique even if the subscription ownership changes within a company.	Y
Creation date	Date on which the order was generated.	Y
Start date	Date on which the customer's subscription to the product was created.	Y
Suspension Date	Date on which the order or subscription was suspended	N
Subscription ID	Unique identifier of the subscription on the marketplace	N
Status	Order status. Some of the possible values include: Active, canceled, deleted, failed, finished, free trial canceled, free trial expired, initialized, one time, pending remote creation, pending user approval, suspended and upcoming. For the full list and a description of each status, see Order and subscription statuses.	Y
Frequency	How often the order will be charged for. Possible values: one time, daily, monthly, yearly, and so on.	Y
Total fee	Total fee is the cumulative amount due after adding up unit fees and flat fees. This value does not include tax.	Y
Sales Agent ID	Name of the sales agent associated with this order.	Y
Sales Agent Name	Identifier for the sales agent associated with this order.	Y
Sales Agent Email	Email of the sales agent associated with this order.	Y
Sales Agent Company Name	Company of the sales agent associated with this order.	Y
Sales Agent Company ID	Identifier for the company of the sales agent associated with this order.	Y
Sales Agent User External ID	Sales agent user's external ID on the marketplace.	N
External Vendor Identifier	Unique identifier used by the application vendor associated to a subscription.	N
Microsoft Order ID	Unique identifier for a specific Microsoft order.	N
Microsoft Subscription ID	Unique identifier for a specific Microsoft subscription.	N
Edition Code	Edition identifier specified by the application Developer.	N
Product Settings—End User Details	This column contains additional information about the end user that can be entered during the checkout flow. The requested information is defined during the product integration configuration. See Add required information for more details.	N
External Reference Code	Purchase order reference code	N
Company Zip	ZIP code of the company that purchased the product.	N
Sales Agent Company Country	Country code of the company whose agent sold the product	N
Sales Agent Company External ID	External identifier for the company whose agent sold the product	N
Sales Agent Company Fax	Fax of the company whose agent sold the product	N
Sales Agent Company Fax Extension	Fax extension of the company whose agent sold the product	N
Sales Agent Company Phone	Phone of the company whose agent sold the product	N
Sales Agent Company Phone Extension	Phone extension of the company whose agent sold the product	N
Sales Agent Company State	State of the company whose agent sold the product	N
Sales Agent Company Street 1	Street address of the company whose agent sold the product—part 1	N
Sales Agent Company Street 2	Street address of the company whose agent sold the product—part 2	N
Sales Agent Company UUID	Unique universal identifier the company whose agent sold the product	N
Sales Agent Company Zip	ZIP code of the company whose agent sold the product	N
Vendor Company Country	Country code of the product developer	N
Vendor Company External ID	External identifier of the product developer	N
Vendor Company Fax	Fax number of the product developer	N
Vendor Company Fax Extension	Fax extension of the product developer	N
Vendor Company Phone	Phone number of the product developer	N
Vendor Company Phone Extension	Phone extension of the product developer	N
Vendor Company State	State of the product developer	N
Vendor Company Street 1	Street address of the product developer—part 1	N
Vendor Company Phone Extension	Phone extension of the product developer.	N
Vendor Company State	State of the product developer	N
Vendor Company Street 1	Street address of the product developer—part 1	N
Vendor Company Street 2	Street address of the product developer—part 2	N
Vendor Company UUID	Universally unique identifier of the product developer	N
Vendor Company Zip	Zip code of the product developer	N