The following list outlines the data points and types you can use to create custom Product line reports.
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 |
Change Log
2022-06-27 - New Article