What Product Line data points are available to use in Advanced Reports?

The following list outlines the data points and types you can use to create custom Product line reports.

Written by Annukka Matilainen

Updated at September 25th, 2024

+ More

Table of Contents

Order Reports Data Types Name of Data Point Description Data Type

Order Reports

Data Types

Number - a data type that can contain both integer and floating-point numbers.

String - a data type comprised of a set of characters that can contain text, spaces and numbers.

Boolean (Yes / No) - a data type with two possible values: true or false.

Name of Data Point	Description	Data Type
Order ID	Order Number	Number
Closed Date	Date Order was Closed	String
Closed Date Time	Date and Time Order was Closed	String
Closed Month	Month Number Order was Closed	Number
Closed Month Name	Month Name Order was Closed	String
Closed Week	Week Order was Closed	Number
Closed Year	Year Order was Closed	Number
Contact Email	Email listed under Cash Customer in an Order	String
Contact Name	Name listed under Cash Customer in an Order	String
Created Date	Date that the Order was initially created	String
Created Date Time	Date and Time that the Order was initially created	String
Created Month	Month Number that the Order was initially created	Number
Created Month Name	Month Name that the Order was initially created	String
Created Week	Week Number that the Order was initially created	Number
Created Year	The year that the Order was initially created	Number
Customer Email	Email of the customer listed on the Order	String
Customer Id	Customer ID number (from Users > Customers) of the customer listed on the Order	Number
Customer Name	Name of the customer listed on the Order	String
Customer Phone	Phone of the customer listed on the Order	String
Device Brand	Brand of the Device listed on the Order	String
Device Configuration	Configuration of the Device listed on the Order	String
Device Description	Description of the Device listed on an Order	String
Device Id	Identifier for each Device that has been added to your Fixably environment	Number
Device Imei	IMEI number of the Device listed on the Order	Number
Device Model	Model of the Device listed on the Order	String
Device Serial	Serial number of the Device listed on the Order	String
Device Warranty End Date	Warranty end date of the Device listed on the Order	String
Dispatch Date	Date Order was Dispatched	String
Dispatch Date Time	Date and time Order was Dispatched	String
Dispatch Id	Dispatch ID number associated with the Order	Number
Dispatch Month	Month Number Order was Dispatched	Number
Dispatch Month Name	Month Name Order was Dispatched	String
Dispatch Week	Week Order was Dispatched	Number
Dispatch Year	Year Order was Dispatched	Number
Handler Id	The ID of the Employee (from Users > Employees) assigned to the Order	Number
Handler Name	Name of the Employee assigned to the Order	String
Imei	IMEI number of the Product line	String
Invoice Name	Customer name listed on the Invoice	String
Invoice Paid Date	Date Invoice was paid	String
Invoicer Name	Name of the Employee that created the Invoice	String
Is Apple or Beats Device	Device attached to the Order is an Apple or Beats device	Yes / No
Is Closed	Order is Closed	Yes / No
Is Draft	Order is in Draft status	Yes / No
Is Reported	Product line is marked as Reported	Yes / No
Issue	Combination of all Issue notes on an Order	String
KBB	KBB Serial of the Product line	String
KGB	KGB Serial of the Product line	String
Last Event Handler Id	The ID of the Technician (from Users > Employees) that performed the most recent event to the Order.	Number
Last Event Handler Name	Name of the Technician (from Users > Employees) that performed the most recent event to the Order.	String
Line Id	ID Number of the Product line	Number
Line Revenue	Total revenue of the Product line	Number
Line Revenue Vat	Total revenue (including tax) of the Product line	Number
Line Type	Type of Product (1 - Service, 2 - Product, 3 - Replacement, 4 - Module, 5 - Transport, 6 - Excess, 7 - Other	Number
Location Id	Location ID (From System Settings > Stores and Locations) associated with the Order	Number
Location Name	Location Name associated with the Order	String
Notes	Shows data entered in the Notes field of the Product line	String
Order Received Date	Date the Order was received into the Service Location	String
Order Received Date Time	Date and Time the Order was received into the Service Location	String
Order Received Month	Month number the Order was received into the Service Location	Number
Order Received Name	Month Name the Order was received into the Service Location	String
Order Received Week	Week Number the Order was received into the Service Location	Number
Order Received Year	Year the Order was received into the Service Location	Number
Order Revenue	Total revenue (without taxes) of all Products currently listed on the Order	Number
Order Revenue Vat	Total revenue (including taxes) of all Products currently listed on the Order	Number
Owner Email	Email of the customer listed on the Order	String
Owner Id	Customer ID number (from Users > Customers) of the customer listed on the Order	Number
Owner Name	Name of the customer listed on the Order	String
Owners Phone	Customer's phone number	String
Parent Customer Email	Email of the Parent Customer (From Users > Customers) associated with the Order	String
Parent Customer Id	ID Number of the Parent Customer (From Users > Customers) associated with the Order.	Number
Parent Customer Name	Name of the Parent Customer (From Users > Customers) associated with the Order	String
Parent Customer Phone	Phone number of the Parent Customer (From Users > Customers) associated with the Order	String
Part Number	Part Number	String
Price	Selling price of the Product line	Number
Price Range	Price Type (0 - Stock, 1 - Exchange, 2 - Warranty) associated the Product Line	Number
Price Range Name	Price Type (Warranty, Stock, Exchange) associated the Product Line	String
Price Total	Total Selling price of the Product line	Number
Price Total Vat	Total Selling Price (including tax) of the Product Line	Number
Product Category	0 - General, 1 - Visual, 2 - Display, 3 - Storage, 4 - Input, 5 - Board, 6 - Power, 7 - Printer, 8 - Multifunction, 9 - Communication, 10 - Share, 11 - Flate Rate, 12 - Bundle, 13 - iPhone, 14 - iPod, 15 - iPad	Number
Product Category Name	Product Category of the Product line	String
Product Code	Product Code	String
Product Exchange Price	Exchange selling price of the Product line	Number
Product Manufacturer	Manufacturer of the Product	String
Product Name	Name of the Product	String
Product Purchase Exchange Price	Exchange purchase price of the Product line	Number
Product Purchase Stock Price	Stock purchase price of the Product line	Number
Product Stock Price	Stock selling price of the Product line	Number
Product Tags	Shows any Tags associated with the Product line	String
Purchase Price	Total purchase price (cost) of the Products listed on the Order	Number
Purchase Price Total	Total purchase price (cost) of the Products listed on the Order	Number
Quantity	Quantity of items listed on the Product line	Number
Queue Group	Parent Queue (Mac, iOS, etc.) from System Settings > Queues	String
Queue ID	ID Number of the Queue (from System Settings > Queues)	Number
Queue Name	Name of the Queue (from System Settings > Queues)	String
Sales Margin	Margin of the Product line	Number
Status Name	Name of the status currently set on the Order	String
Type Name	Type of the product added to order line (Service, Product, Replacement, Module or Unknown (Unknown will be assigned for freight, Other and loaner type products)	String
Vat	Tax amount of the Product line	Number

product line data points reports advanced available advanced reporting advanced reports products product export reports data custom reports create report

What Product Line data points are available to use in Advanced Reports?

Contact Us

Order Reports

Data Types

Name of Data Point

Description

Data Type

Related Articles