Report Builder - Order Line Field Explanations

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

Updated at October 16th, 2026

+ More

Table of Contents

Data Types Field Explanations

These are the fields you can add to a Report Builder report of type Order lines. 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 lines

Field	Description	Data type
Line ID	ID of the order line.	Number
Line price	Selling price of one unit on the line, without VAT.	Currency
Line price range	Price type of the line as a code: 0 Stock, 1 Exchange, 2 Warranty, 4 Add-on, 9 Stock zero margin, 19 Exchange zero margin, 20 Custom.	Number
Line price range name	Price type of the line as a name: Stock, Exchange or Warranty. Other price types show Unknown.	Text
Line product code	Product code on the line.	Text
Line product name	Product name on the line.	Text
Line notes	Text in the line's Notes field.	Text
Line type	Product type of the line as a code: 0 Service, 1 Product, 2 Replacement, 3 Module, 4 Other, 5 Transport, 6 Loaner, 7 Excess.	Number
Line type name	Product type of the line as a name: Service, Product, Replacement or Module. Other types show Unknown.	Text
Line issue	The issue saved on the line.	Text
Line KBB	KBB serial on the line (serial of the part removed).	Text
Line KGB	KGB serial on the line (serial of the part installed).	Text
Line IMEI	IMEI on the line.	Text
Line is reported	The line is marked as Reported.	Yes / No
Line is DOA	The line is marked as DOA (dead on arrival).	Yes / No
Line is GPR	The line is marked as GPR.	Yes / No
Line is accidental damage	The line is marked as accidental damage.	Yes / No
Line is core return	The line is marked as a core return.	Yes / No
Stock ID	ID of the stock the line takes its part from.	Number
Stock name	Name of the stock the line takes its part from.	Text
Line is dispatched	The line has been dispatched.	Yes / No
Line dispatched quantity	Quantity dispatched from the line.	Number
Line status	Status of the line as a code. Empty for lines that do not use line statuses, such as service lines.	Number
Line status name	Status of the line as a name, as shown in the order view.	Text
Line CompTIA code	CompTIA code on the line.	Text
Line VAT	VAT rate (%) of the line.	Number
Line quantity	Quantity on the line.	Number
Line price total	Price x quantity, without VAT.	Currency
Line price total (incl. VAT)	Price x quantity, including VAT.	Currency
Line purchase price	Purchase price (cost) of one unit on the line.	Currency
Line revenue	Price x quantity, without VAT. Same value as Line price total.	Currency
Line revenue (incl. VAT)	Price x quantity, including VAT.	Currency
Line purchase price total	Purchase price x quantity for the line.	Currency
Line sales margin	Line price total minus line purchase price total.	Currency
Line difference	Line price total minus line purchase price total. Same value as Line sales margin.	Currency
Line part coverage	Coverage GSX gave for the part on the line.	Text
Line part number	Part number of the line's product.	Text
Line product manufacturer	Manufacturer of the line's product.	Text
Line product category	ID of the line's product category (your own categories, from the product card).	Number
Product purchase stock price	Stock purchase price on the product card (the current price, not the price on the line).	Currency
Product purchase exchange price	Exchange purchase price on the product card (the current price).	Currency
Product stock price	Stock selling price on the product card (the current price, not the price on the line).	Currency
Product exchange price	Exchange selling price on the product card (the current price).	Currency
Product tags	Tags on the line's product.	Text
Product labour tier	Labour tier on the line's product.	Text
Product category name	Name of the line's product category.	Text
Revenue	Total of price x quantity for all of the order's lines, without VAT. Only lines marked Reported are counted.	Currency
Revenue (incl. VAT)	Total of price x quantity for all of the order's lines, including VAT. Only lines marked Reported are counted.	Currency

Order

Field	Description	Data type
Order reference	The text in the order's Reference field.	Text
Order ID	The order number.	Number
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
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
Order tags	Tags added to the order.	Text
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
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
Status	Name of the order's current status.	Text
Order dispatch ID	ID of the order's dispatch.	Number
Order dispatched (date & time)	Date and time the order was dispatched.	Date & time
Order dispatched (date)	Date the order was dispatched.	Date
Order dispatched (year)	Year the order was dispatched.	Number
Order dispatched (month)	Month number the order was dispatched.	Number
Order dispatched (month name)	Month name the order was dispatched.	Text
Order dispatched (week)	Week number the order was dispatched.	Number
Shipping ID	ID of the shipping method on the order.	Number
Shipping method	Name of the shipping method on the order.	Text

Received by

Field	Description	Data type
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

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

Handler

Field	Description	Data type
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
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

Owner

Field	Description	Data type
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

Customer

Field	Description	Data type
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 phone	Phone number of the order's customer.	Text

Queue

Field	Description	Data type
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 configuration	Configuration of the device on the order.	Text
Device description	Description of the device on the order.	Text
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

Repair

Field	Description	Data type	Integration
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

Invoice

Field	Description	Data type
Invoice paid date	Date the invoice containing this line was paid.	Date
Invoice name	Customer name on the invoice containing this line.	Text
Invoicer name	Name of the person who created the invoice containing this line.	Text

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 line custom fields your environment has.
Do Not Report reason and Do Not Report reason code: shown in the Order lines group when Do Not Report reasons are turned on.

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