In Reports, there will be different Fields and Metrics depending on the Report type. Below is a glossary with explanations and examples of each Field and Metric, with a letter signalling which Report type they appear for.
p = Performances Report
o = Transactions Report
i = Inventory Report
a = Availabilities Report
v = Vouchers Report
t = Opt Ins Report
Fields
A-D
Add on Name o
The name of a Basket Discount applied to the Transaction - Basket Discounts are reported as Add Ons
Address City/Country/Postcode/Street/Town po
Customer Location details on the Transaction
Area p
Associated Area on the Venue Plan Hierarchy for the seat
Availability Status Name a
Box Office Holds
Availability Status Type a
Whether it's an Allocation or a Lock
Barcode po
Generated Barcode number for the associated Ticket
Barcode Redeeming Device Name p
The system name of the device that successfully redeemed the Barcode, from the device configuration
Barcode Redeeming Device Nickname p
The friendly name assigned to that device from the device configuration
Barcode Scan Attempts p
Shows the total number of times a Barcode was scanned
Channel Id pov
Identification number for the Channel. Also located within the URL when on a Channel's page in Line-Up, i.e. app.line-up.tickets/channels/8121
Channel Name pov
Website
Customer Name/Email Address povt
Customer details on the Transaction
Customer Phone Number pot
Customer details on the Transaction
Customer Public Id po
Identification number for the Customer. Also located within the URL when on a Customer's page in Line-Up, i.e. app.line-up.tickets/customer/cus_7zc7u8HrBHMXiamRXoYf2J
Delivery Method Name o
E-Ticket
Discount Description/Name p
Industry & Half off for industry workers
Discount Value o
The Discount amount applied to an individual item, calculated as the original price minus the charged price
E-I
Event Id poi
Identification number for the Event. Also located within the URL when on an Event's page in Line-Up, i.e. app.line-up.tickets/event/33543
Event External Id poai
Either your own custom ID used for exports into third-party software, or the ID from an External System for an integrated Event
Event Name poai
Ghostbusters the Musical
Event Organisation Id pav
The identification number of your Organisation
External Barcode p
Third-party barcodes that are uploaded into Line-Up
Form Question/Response/Title po
Customer Form that is associated with the Transaction
Form Response Transaction Item Id o
A unique identifier for each individual Guest. Adding this will organise a specific Guest's Responses within a Transaction, i.e. Guest 1 is 139,622,098 and Guest 2 is 139,622,099
Full Price i
Taken from the Price Table, the maximum price that can be sold for that Price Band
Is Redeemed po
Whether or not the Barcode has been redeemed. true for a redeemed item, and false for an unredeemed item
Item Is Void po
Whether or not a basket item is Active or Voided. true for a Voided Item, and false for an Active Item
Item Voided at Date Time po
When the Refund or Exchange Transaction was completed and the Item was Voided in the Parent Transaction
L-O
Lead Time Days p
Gap of days between a Completed Transaction and the Performance Start Date
Opt In Name/Response/Text t
The details of an Opt In if applicable
Organisation Name po
Line-Up
Organisation Id ti
The identification number of your Organisation
Original Price o
The original pre-Discount price of the item
Override Seat Group [One/Two/Three/Four] Name/Label o
If Performance Seating is used, the assigned seat information. The numerical value is their level within the hierarchy
Override Seat Group [One/Two/Three/Four] Type o
If Performance Seating is used, whether the Seat Group is a Block/Area/Section/Row
P-T
Parent Transaction Public Id/Reference pov
If the Transaction is a Refund or Exchange Transaction and a Parent Transaction is detected, this will show the Transaction Reference Number and the Identification number for it. Also located within the URL when on a Parent Transaction's page in Line-Up, i.e. app.line-up.tickets/order/txn_VhtuN5Y98UukaXqcxGGZEt
Parent Transaction External ID po
The reference provided by an External System when the Parent Transaction was created through an external integration
Parent Transaction External Type po
The name of the External System the Parent Transaction originated from, taken from the external integration configuration
Parent Transaction Source Reference po
The Source Reference (formerly the Prefix) from the external integration configuration, for the Parent Transaction
Payment External Reference o
Third-party payment processor's reference number for their system
Payment Id o
Identification number for the Payment. Also located within the URL when on a Payment's page in Line-Up, i.e. app.line-up.tickets/order/payment/43527
Payment Is Refund o
Displays as true if it is a Refund, and false if it is payment taken in
Payment Issuer Country o
GB
Payment Merchant Reference o
The third party's reference number for Line-Up. Commonly structured as "LU_[Transaction Number]_[Additional Numbers]"
Payment Method Name o
The name given to the Payment Method created in Line-Up
Payment Method Sub Variant o
If the Payment Processor provides this, it would display as amex_googlepay or visacredit
Payment Method Type o
This would either be your Payment Processor Method, e.g. Stripe or Stripe - Terminal. Custom is when you have created your own Payment Method that is not connected to an external payment processor
Payment Method Variant o
The main payment type, which would display as amex/visa/mastercard
Payment Status o
Notes whether a payment is Completed, Pending, or Cancelled
Performance Date Time pai
27/02/2025, 19:00:00
Performance Day of Week pai
Thursday
Performance End Date pa
27-02-2025
Performance End Time pa
08:30 PM
Performance Start Date pa
27-02-2025
Performance Start Time pa
07:00 PM
Performance Start Date Time o
27/02/2025, 19:00:00
Performance Is Cancelled pai
true if cancelled, false if not
Performances Notes po
The Performance's Internal Notes (i.e. Performance-specific Passwords)
Performance Time Zone p
Europe/London
Performance External Id poi
Either your own custom ID used for exports into third-party software, or the ID from an External System for an integrated Performance
Performance Id poi
Identification number for the Performance. Also located within the URL when on a Performance's page in Line-Up, i.e. app.line-up.tickets/event/33543/performance/989219
Price Adjuster Default Rate po
The default set rate
Price Adjuster Description po
Commission
Price Adjuster Name po
Booking Fee
Price Adjuster Outside po
true if it is an Outside Adjuster, and false if it is an Inside Adjuster
Price Adjuster Rate Type po
Whether Percentage or Fixed
Price Band Name poi
Tier A
Price Profile Name p
The Profile currently linked to the associated Performance
Price Variant Name po
Essential Companion
Product Name po
Champagne
Product Type po
Can display as Physical, Digital, Service, Voucher, or Hospitality
Purchase Flow Name pov
The Purchase Flow that was used to complete the Transaction
Purchase Flow Type pov
Box Office or Online Checkout
Redeemed At p
When the Barcode was redeemed
Row p
Associated Row on the Venue Plan Hierarchy for the seat
Seat Group [One/Two/Three/Four] (Type) poi
The name and level within the Venue Plan Hierarchy, i.e. a Plan that follows Area>Section>Row would have these as Seat Group One, Two and Three respectively. A different plan may have Block>Area>Section>Row, which would reflect One, Two, Three and Four
Seat Label poi
The seat number
Seat Type Name pi
If a Seat Type is detected, it'll display the name
Seating Object Area/Row/Seat Label/Sector/Sequential Id a
The order of the object within the Seating Group, i.e. if the Labels are 300, 301 and 302 the Sequential Ids (or Index for Seat Labels) would be 1, 2 and 3 to reflect their positions within the row
Seating Object Seat Group [One/Two/Three/Four] Name/Type a
Similar to the corresponding definitions above, but related to Availability Statuses
Sector p
Associated Section on the Venue Plan Hierarchy for the seat
Tax Rate o
Effective rate for that Row. Calculated from the actual Tax amount charged and the Ticket Price.
NOTE - this may differ from the Rate configured in your Organisation Settings, as that value can be modified independently of existing Transactions
Tax Rate Name o
The name of the Tax Rate
Transaction Completed/Created Date Time po
27/02/2025, 23:59:34
Transaction Day of Week pov
Tuesday
Transaction Expires Date Time po
Displays if a Reservation and an expiry has been set
Transaction External Id po
The reference provided by an External System when the Transaction was created through an external integration
Transaction External Type po
The name of the External System the Transaction originated from, taken from the external integration configuration
Transaction Source Reference po
The Source Reference (formerly the Prefix) from the external integration configuration the Transaction came through
Transaction Includes Products o
true if Products are detected, false if not
Transaction Includes SMB o
true if Secure My Booking is detected, false if not
Transaction Includes Tickets o
true if Tickets are detected, false if not
Transaction Item Id po
The identification number of the specific item in the basket
Transaction Item Kind po
Ticket, Price Adjuster, Product, Delivery, Payment
Transaction Item Name o
Name of the specific item that's been used, i.e. if it's a Price Adjuster, it will be the name of that Adjuster
Transaction Lead Booker pov
Name that has been entered for the Lead Booker field for a Transaction
Transaction Note po
The internal Note that has been entered for a Transaction
Transaction Organisation Id o
The identification number of your Organisation
Transaction Public Id pov
Identification number for the Transaction. Also located within the URL when on a Transaction's page in Line-Up, i.e. app.line-up.tickets/order/txn_VhtuN5Y98UukaXqcxGGZEt
Transaction Reference pov
Auto-generated reference number within Line-Up
Transaction Status pov
Complete, Expired, Reservation or In Basket
Transaction Type po
SALE or RETURN
User First/Last Name pov
The Line-Up User who processed the Transaction. If blank, that may mean it was handled by the Customer on the Website Channel
Value p
The Gross of the individual Transaction Item
Venue Name poi
Line-Up Headquarters
Venue Plan p
Associated Venue Plan for the seat
Venue Plan Admission Type p
General Admission or Reserved Seating
Venue Plan Capacity p
For the Venue Plan as a whole
Venue Plan Name p
Auditorium 4
Voucher Code v
Used to redeem the Voucher
Voucher Expiry Date Time v
19/08/2027, 15:49:50
Voucher Initial Balance v
Original balance at point of sale
Voucher Is Expired v
true if the Voucher is now expired, false if not
Voucher Name v
Product Name
Voucher Organisation Id v
The identification number of your Organisation
Voucher Usage Type v
Full, Partial, or None
Voucher Valid from Date Time v
Original creation date of the Voucher
Metrics
A-E
Average Face Value po
Calculates the average Face Values of the Transaction, not including Returns or Comp Tickets
Average Transaction Value o
The average value of multiple Transactions (not necessarily the Payments taken)
Capacity i
Venue Plan Capacity
Capacity Remaining i
Amount of the Venue Plan Capacity that is available to be sold
Comp Tickets po
Amount of sold Tickets with a £0.00 face value
Credit v
Total value added to the Voucher within the Report's date range. This includes the original sale value and any value later refunded back onto the Voucher, so Credit can be higher than the Voucher Initial Balance.
NOTE - if the date range does not cover the original sale, that value is not counted and Credit will under-report. Use Voucher Initial Balance for the value at point of sale
Debit v
Total value spent from the Voucher within the Report's date range.
NOTE - this does not show the Voucher's current state. A Voucher can show a Debit and still hold its full balance, where value has since been credited back to it. Use Voucher Usage Type to see whether a Voucher is currently unused, partly used or fully used
Discount Total o
Total Discount value across sold Tickets, calculated as sales minus returns. Derived from the difference between original and charged price per Ticket
Expired Value v
Amount on the Voucher that is expired
F-P
Face Value Gross p
The Face Value of the Ticket, excluding Outside Fees
Inside Fee Gross po
The Gross of your Inside Adjusters (Net+Tax)
Inside Fee Net po
The Net portion of your Inside Adjusters, excluding Tax
Inside Fee Tax po
The Tax portion of your Inside Adjusters, excluding Net
Inside Gross p
Sold Gross Value minus Inside Fee Gross
Inside Net po
The Net of the Transaction excluding the Inside Fee Net
Inside Tax po
The Tax of the Transaction excluding the Inside Fee Tax
Item Count po
Count of the Transaction's Tickets, Products, Price Adjusters, Delivery Methods and Payments. Filter out as necessary to see specific items, e.g. Tickets
Net v
The Credit (value added to the Voucher) minus the Debit (value spent from the Voucher), giving the balance remaining on the Voucher. Subject to the same date range behaviour as Credit and Debit, so run the Report without a date range for a true balance
Outside Fee Gross p
The Gross of the Outside Adjuster
Override Seat List o
If Performance Seating is used, the manually set Seat Label
Payment Credit o
Amount received
Payment Debit o
Amount that you've refunded
Payment Net o
Payment Credit (money received) minus Payment Debit (money refunded)
Percentage Remaining ai
Amount that is left for the Availability Status or Price Band
Percentage Sold i
Amount that is sold for the Availability Status or Price Band
Performance Count p
The amount of Performances for that row, i.e. for Event Name, how many Performances are detected
Q-T
Quantity Allocated i
Amount of seats that have an Availability Status
Quantity Banded i
Amount of seats that have a Price Band
Quantity Open i
Amount of seats that are available
Quantity Sold i
Amount of seats that have been sold
Quantity Unbanded i
Amount of seats that do not have a Price Band
Reserved Gross Value po
Only for Reservation Transactions, the potential Sold Gross Value of the Transaction
Reserved Tickets po
Amount of seats that have been reserved
Seat List poi
Associated Seat Labels
Sold Gross Value po
The total Value of all items on the Transaction (Net+Tax)
Sold Net po
The Value minus Tax
Sold Products po
Amount of Products that have been sold
Sold Tickets po
Amount of Tickets that have been sold
Tax po
The tax rate according to the corresponding Price Table
Total Capacity a
Total Venue Plan Capacity
Total Remaining a
Available seats to be purchased
Total Unavailable a
Seats that have been sold or reserved
Transaction Count Completed po
For an Event or a Performance, the amount of completed Transactions
Transaction Count Reserved po
For an Event or a Performance, the amount of Reservations
Transaction Gross o
The Sold Gross Value of the Transaction that cannot be amended through Filters
Transaction Net o
The Net of the Transaction that cannot be amended through Filters
Transaction Product Count o
The amount of Sold Products of the Transaction that are not affected by Filters
Transaction Tax o
The Tax of the Transaction that cannot be amended through Filters
Transaction Ticket Count o
The amount of Sold Tickets of the Transaction that are not affected by Filters