Report Builder - Order Field Explanations
The following list outlines the data points and types you can use to create custom Order reports.
Written by Annukka Matilainen
Updated at October 16th, 2026
Table of Contents
These are the fields you can add to a Report Builder report of type Orders. They are listed in the same groups and order as the field list in the Report Builder.
Some fields only show when the matching integration is turned on. The Integration column shows which one.
Data types
Each field has one of these data types:
| Data type | What it holds |
|---|---|
| Text | Letters, numbers and spaces. |
| Number | A whole number or a decimal number. |
| Currency | An amount of money. |
| Date | A date. |
| Date & time | A date with a time. |
| Yes / No | One of two values: Yes or No. |
Many dates come in a set of six fields: date & time, date, year, month, month name and week. Use the year, month or week fields to group a report by time period.
Field explanations
Order
| Field | Description | Data type | Integration |
|---|---|---|---|
| Order ID | The order number. | Number | |
| Order reference | The text in the order's Reference field. | Text | |
| Another reference | The order's second reference field, if your environment uses it. | Text | |
| Internal reference | The order's internal reference. | Text | |
| Is cancelled | The order is cancelled. | Yes / No | |
| Is closed | The order is closed. | Yes / No | |
| Is draft | The order is a draft. | Yes / No | |
| Is inside | The order is currently in service. | Yes / No | |
| Created (date & time) | Date and time the order was created. | Date & time | |
| Created (date) | Date the order was created. | Date | |
| Created (year) | Year the order was created. | Number | |
| Created (month) | Month number the order was created. | Number | |
| Created (month name) | Month name the order was created. | Text | |
| Created (week) | Week number the order was created. | Number | |
| Created (year-month) | Year and month the order was created, for example 2026-10. | Text | |
| Closed (date & time) | Date and time the order was closed. | Date & time | |
| Closed (date) | Date the order was closed. | Date | |
| Closed (year) | Year the order was closed. | Number | |
| Closed (month) | Month number the order was closed. | Number | |
| Closed (month name) | Month name the order was closed. | Text | |
| Closed (week) | Week number the order was closed. | Number | |
| Order tags | Tags added to the order. | Text | |
| Contact name | Name in the order's contact fields. | Text | |
| Contact email | Email in the order's contact fields. | Text | |
| Contact company | Company in the order's contact fields. | Text | |
| Inside time (days) | Total time the order has spent in service, in days (rounded up). Includes the current stretch if the order is in service now. | Number | |
| Inside time (hours) | Total time the order has spent in service, in hours. Includes the current stretch if the order is in service now. | Number | |
| Has inside time | The order has finished at least one stretch in service. | Yes / No | |
| Inside since | Date and time the order's current stretch in service started. Empty when the order is not in service. | Date & time | |
| Last activity | Date and time the order's status last changed. | Date & time | |
| Lead time (days) | Days between the date the order was created and the date it was closed. Empty for open orders. | Number | |
| Last issue | The most recent Issue note on the order. | Text | |
| Last diagnosis | The most recent Diagnosis note on the order. | Text | |
| Diagnosed by ID | Employee ID (from Users > Employees) of the person who added the most recent Diagnosis note. | Number | |
| Diagnosed by name | Name of the person who added the most recent Diagnosis note. | Text | |
| Last resolution | The most recent Resolution note on the order. | Text | |
| Resolution by ID | Employee ID (from Users > Employees) of the person who added the most recent Resolution note. | Number | |
| Resolution by name | Name of the person who added the most recent Resolution note. | Text | |
| Note count | Number of notes on the order. | Number | |
| Event count | Number of events in the order's timeline. | Number | |
| Shipping ID | ID of the shipping method on the order. | Number | |
| Shipping method | Name of the shipping method on the order. | Text | |
| Dispatch ID | ID of the order's dispatch. | Number | |
| Dispatched (date & time) | Date and time the order was dispatched. | Date & time | |
| Dispatched (date) | Date the order was dispatched. | Date | |
| Dispatched (year) | Year the order was dispatched. | Number | |
| Dispatched (month) | Month number the order was dispatched. | Number | |
| Dispatched (month name) | Month name the order was dispatched. | Text | |
| Dispatched (week) | Week number the order was dispatched. | Number | |
| Status | Name of the order's current status. | Text | |
| Order provider | The external system the order came from, for example a customer portal or an integration. | Text | |
| Order provider account | The account of the order provider the order came from. | Text | |
| External ID | The order's ID in the external system it came from (order provider). | Text |
Location
| Field | Description | Data type | Integration |
|---|---|---|---|
| Location ID | ID of the order's location (from System Settings > Stores and Locations). | Number | |
| Location name | Name of the order's location. | Text |
Store
| Field | Description | Data type | Integration |
|---|---|---|---|
| Store ID | ID of the order's store (from System Settings > Stores and Locations). | Number | |
| Store name | Name of the order's store. | Text | |
| Store address | Street address of the order's store. | Text | |
| Store ZIP | ZIP or postal code of the order's store. | Text | |
| Store city | City of the order's store. | Text | |
| Store country | Country of the order's store. | Text |
Handler
| Field | Description | Data type | Integration |
|---|---|---|---|
| Handler ID | Employee ID (from Users > Employees) of the person assigned to the order. | Number | |
| Handler name | Name of the person assigned to the order. | Text | |
| Handler roles | Permission roles given to the handler, separated by commas. | Text | |
| Handler role (legacy) | Role set in the handler's User Settings (for example Technician). | Text | |
| Last event handler ID | User ID of the person who triggered the order's most recent event. | Number | |
| Last event handler name | Name of the person who triggered the order's most recent event. | Text | |
| Last event handler roles | Permission roles of the person who triggered the most recent event, separated by commas. | Text | |
| Last event handler role (legacy) | Role set in the User Settings of the person who triggered the most recent event. | Text |
Customer
| Field | Description | Data type | Integration |
|---|---|---|---|
| Customer ID | Customer ID (from Users > Customers) of the order's customer. | Number | |
| Customer name | Name of the order's customer. Shows the company name when there is one. | Text | |
| Customer email | Email of the order's customer. | Text | |
| Customer additional email | Extra email addresses saved for the order's customer. | Text | |
| Customer phone | Phone number of the order's customer. | Text | |
| Customer department | Department of the order's customer. | Text | |
| Customer business ID | Business ID of the order's customer. | Text | |
| Customer address | Street address of the order's customer. | Text | |
| Customer city | City of the order's customer. | Text | |
| Customer state | State of the order's customer. | Text | |
| Customer ZIP | ZIP or postal code of the order's customer. | Text | |
| Customer country | Country of the order's customer. | Text |
Parent customer
| Field | Description | Data type | Integration |
|---|---|---|---|
| Parent customer ID | Customer ID of the parent customer (the business the customer belongs to). | Number | |
| Parent customer name | Name of the parent customer. | Text | |
| Parent customer email | Email of the parent customer. | Text | |
| Parent customer phone | Phone number of the parent customer. | Text | |
| Parent customer department | Department of the parent customer. | Text |
Owner
| Field | Description | Data type | Integration |
|---|---|---|---|
| Owner ID | Customer ID of the order's owner. The owner is the customer by default, but can be a different user, for example the portal user who created the order. | Number | |
| Owner name | Name of the order's owner. | Text | |
| Owner email | Email of the order's owner. | Text | |
| Owner phone | Phone number of the order's owner. | Text | |
| Owner department | Department of the order's owner. | Text |
Created by
| Field | Description | Data type | Integration |
|---|---|---|---|
| Created by ID | User ID of the person who created the order. This can be an employee or a customer using the portal. | Number | |
| Created by name | Name of the person who created the order. | Text | |
| Created by email | Email of the person who created the order. | Text | |
| Created by phone | Phone number of the person who created the order. | Text | |
| Created by department | Department of the person who created the order. | Text | |
| Created by status | User level of the person who created the order: 1 Customer, 2 User, 3 Manager, 4 Admin (0 Not verified). | Text |
Received by
| Field | Description | Data type | Integration |
|---|---|---|---|
| Received by ID | User ID of the person who received the order into service. | Number | |
| Received by name | Name of the person who received the order into service. | Text | |
| Received by email | Email of the person who received the order into service. | Text | |
| Received by phone | Phone number of the person who received the order into service. | Text | |
| Received by department | Department of the person who received the order into service. | Text | |
| Received by status | User level of the person who received the order: 1 Customer, 2 User, 3 Manager, 4 Admin (0 Not verified). | Text | |
| Received (date & time) | Date and time the order was received into service. | Date & time | |
| Received (date) | Date the order was received into service. | Date | |
| Received (year) | Year the order was received into service. | Number | |
| Received (month) | Month number the order was received into service. | Number | |
| Received (month name) | Month name the order was received into service. | Text | |
| Received (week) | Week number the order was received into service. | Number |
Service partner
| Field | Description | Data type | Integration |
|---|---|---|---|
| Service partner ID | ID of the order's service partner, if your environment uses service partners. | Number | |
| Service partner name | Name of the order's service partner. | Text |
Queue
| Field | Description | Data type | Integration |
|---|---|---|---|
| Queue ID | ID of the order's queue (from System Settings > Queues). | Number | |
| Queue name | Name of the order's queue. | Text | |
| Queue group | Name of the parent queue (for example Mac or iOS). Shows the queue itself when it has no parent. | Text |
Device
| Field | Description | Data type | Integration |
|---|---|---|---|
| Device ID | ID of the device on the order. | Number | |
| Device brand | Brand of the device on the order. | Text | |
| Is Apple or Beats device | The device on the order is an Apple or Beats device. | Yes / No | |
| Device serial number | Serial number of the device on the order. | Text | |
| Device IMEI | IMEI of the device on the order. | Text | |
| Device model | Model of the device on the order. | Text | |
| Device code | Product code of the device on the order. | Text | |
| Device configuration | Configuration of the device on the order. | Text | |
| Device description | Description of the device on the order. | Text | |
| Is warranty device | The device has warranty or extended warranty coverage. Empty when the order has no device. | Yes / No | |
| Device purchase country | Country where the device was bought. | Text | |
| Device warranty name | Name of the device's warranty coverage. | Text | |
| Device sold-to (GSX) | Sold-to name GSX has for the device. | Text | GSX |
| Device warranty end date | Date the device's warranty ends. | Date | |
| Device estimated purchase date | Estimated purchase date of the device. | Date | |
| GSPN local service product | GSPN local service product of the device. | Text | GSPN |
| GSPN product category | GSPN product category of the device. | Text | GSPN |
Order lines
| Field | Description | Data type | Integration |
|---|---|---|---|
| Total line count | Number of lines on the order. Only lines marked Reported are counted. | Number | |
| Has lines | The order has at least one line marked Reported. | Yes / No | |
| Non-warranty line count | Number of lines without the Warranty price type. Only lines marked Reported are counted. | Number | |
| Has non-warranty lines | The order has at least one Reported line without the Warranty price type. | Yes / No | |
| Warranty line count | Number of lines with the Warranty price type. Only lines marked Reported are counted. | Number | |
| Has warranty lines | The order has at least one Reported line with the Warranty price type. | Yes / No | |
| Charged line count | Number of charged lines (price x quantity above 0). Only lines marked Reported are counted. | Number | |
| Has charged lines | The order has at least one charged Reported line (price x quantity above 0). | Yes / No | |
| Apple part count | Number of lines whose product manufacturer is Apple. Only lines marked Reported are counted. | Number | |
| Has Apple parts | The order has at least one Reported line whose product manufacturer is Apple. | Yes / No | |
| Warranty Apple part count | Number of Apple lines with the Warranty price type. Only lines marked Reported are counted. | Number | |
| Has warranty Apple parts | The order has at least one Reported Apple line with the Warranty price type. | Yes / No | |
| Charged Apple part count | Number of charged Apple lines (price x quantity above 0). Only lines marked Reported are counted. | Number | |
| Has charged Apple parts | The order has at least one charged Reported Apple line. | Yes / No | |
| Has pickup product | The order has a Reported line with the pickup product (product code NOUTO). | Yes / No | |
| Revenue | Total of price x quantity for the order's lines, without VAT. Only lines marked Reported are counted. | Currency | |
| Purchase price | Total of purchase price x quantity for the order's lines. Only lines marked Reported are counted. | Currency | |
| Revenue (incl. VAT) | Total of price x quantity for the order's lines, including VAT. Only lines marked Reported are counted. | Currency | |
| Used products | Product codes on the order's Reported lines, separated by commas. | Text | |
| Product tags | Tags of the product on one of the order's Reported lines. With several lines, which line is used is not fixed. Use an Order line report for per-product data. | Text | |
| Product code | Product code of one of the order's Reported lines. With several lines, which line is used is not fixed. Use an Order line report for per-product data. | Text | |
| Has whole unit repair | The order has a Reported line whose product is marked as a whole-unit replacement. | Yes / No | |
| Has display replacement | The order has a Reported repair line whose KBB serial is different from the device serial. | Yes / No | |
| Whole unit repair price type | Price type (Stock, Exchange, Warranty) of the whole-unit replacement line. | Text | |
| Display replacement price type | Price type (Stock, Exchange, Warranty) of the display replacement line. | Text |
Repair
| Field | Description | Data type | Integration |
|---|---|---|---|
| Repair count | Number of OEM repairs (for example GSX or GSPN) on the order. | Number | |
| Has repairs | The order has at least one OEM repair. | Yes / No | |
| Turnaround time (days) | Days between the date the order was received and the date it was closed. Empty for open orders. | Number | |
| Last repair ID | Internal ID of the order's latest repair. | Number | |
| Last repair identifier | Which system the latest repair belongs to, for example GSX. | Text | |
| Last repair number | Repair number of the order's latest repair. | Text | |
| Last repair strategy | Repair strategy of the order's latest repair. | Text | |
| Repair sold-to (GSX) | Sold-to account of the order's latest GSX repair. | Text | GSX |
| Repair ship-to (GSX) | Ship-to account of the order's latest GSX repair. | Text | GSX |
| Is last repair closed | The order's latest repair is closed. | Yes / No | |
| Last repair received (date & time) | Date and time the order's latest repair was marked received. | Date & time | |
| Last repair received (date) | Date the order's latest repair was marked received. | Date | |
| Last repair received (year) | Year the order's latest repair was marked received. | Number | |
| Last repair received (month) | Month number the order's latest repair was marked received. | Number | |
| Last repair received (month name) | Month name the order's latest repair was marked received. | Text | |
| Last repair received (week) | Week number the order's latest repair was marked received. | Number | |
| Last repair created (date & time) | Date and time the order's latest repair was created. | Date & time | |
| Last repair created (date) | Date the order's latest repair was created. | Date | |
| Last repair created (year) | Year the order's latest repair was created. | Number | |
| Last repair created (month) | Month number the order's latest repair was created. | Number | |
| Last repair created (month name) | Month name the order's latest repair was created. | Text | |
| Last repair created (week) | Week number the order's latest repair was created. | Number | |
| Last repair closed (date & time) | Date and time the order's latest repair was closed. | Date & time | |
| Last repair closed (date) | Date the order's latest repair was closed. | Date | |
| Last repair closed (year) | Year the order's latest repair was closed. | Number | |
| Last repair closed (month) | Month number the order's latest repair was closed. | Number | |
| Last repair closed (month name) | Month name the order's latest repair was closed. | Text | |
| Last repair closed (week) | Week number the order's latest repair was closed. | Number |
Invoice
| Field | Description | Data type | Integration |
|---|---|---|---|
| Invoiced amount | Total of all invoices on the order, without VAT. | Currency | |
| Invoiced amount (incl. VAT) | Total of all invoices on the order, including VAT. | Currency | |
| Is fully invoiced | Every Reported line on the order with a price has been invoiced. | Yes / No |
Shipment
| Field | Description | Data type | Integration |
|---|---|---|---|
| Shipment tracking number | Tracking numbers of the shipments the order is in, separated by commas. | Text | |
| Package tracking number | Tracking numbers of the packages the order is in, separated by commas. | Text |
Measures
| Field | Description | Data type | Integration |
|---|---|---|---|
| Order count | Number of orders. Use it in grouped reports, for example orders per location. | Number | |
| Closed orders | Number of closed orders. | Number | |
| Repeat repair orders | Number of orders marked as a repeat repair. | Number | |
| Orders in warranty | Number of orders with at least one Reported line with the Warranty price type. | Number | |
| Orders out of warranty | Number of orders with no Reported line with the Warranty price type. | Number | |
| Orders with warranty device | Number of orders whose device has warranty coverage. | Number | |
| Warranty share % | Share of orders in warranty, as a percentage. | Number | |
| Closed share % | Share of orders that are closed, as a percentage. | Number |
Fields that depend on your setup
These fields are added at the end of the field list, based on how your environment is set up:
- Custom fields: any order custom fields your environment has.
- Tasks: any tasks your environment has.