Column

Description

The column is not present in these tables

Reseller

name of the reseller who made the sale

Reseller Code

code assigned to a reseller

Reseller Destination

destination to which a reseller is assigned

Reseller Manager

name of the person assigned to a reseller

Reseller Band

name of the reseller band a reseller is assigned to

Reseller Channel

name of the channel a reseller is assigned to

Reseller Billing Account Code

custom code used for ERP integrations like SAP

Reseller Billing Customer Code

custom code used for ERP integrations like SAP

Reseller Billing City

city where the reseller resides, for billing/invoicing

Reseller Billing Address

full address of the reseller, for billing/invoicing

Reseller Invoice Date Field

whether a reseller is invoiced on travel, booking, or redemption date

Reseller Tags

tags assigned to a reseller; used for filtering

Reseller Tax Registered

whether a reseller is tax registered (affects how net tax is calculated)

Reseller FX

conversion rate against the reseller's currency

Reseller Allow Top-ups

whether a reseller is allowed to receive credit top-up

Agent

name of an agent working for the reseller

Reseller Reference

reference identifying the booking on the reseller's side

Reseller Commission

the reseller's cut from the sale

Column

Description

The column is not present in these tables

Shift ID

unique shift identifier

Shift Seller

name of the seller who started the shift on a terminal

Shift Cashier

name of the cashier selling through backoffice or concierge portal

Shift Location

name of the terminal location

Shift Location Tags

tags associated with the location

Seller

name of a seller (may differ from Shift Seller; e.g. a promoter)

Seller Billing Account Code

code assigned to a seller for billing purposes

Seller Tags

tags associated with the seller

User

name of a user who made sales using a password (manager, finance staff, etc.)

Cancelled on ID

ID of the shift when a booking was cancelled

Cancelled By

name of the seller who made the cancellation

Column

Description

This column is not present in these tables

Latitude

the latitude of a virtual location (if set up)

Longitude

the longitude of a virtual location (if set up)

Channel

the source of the sale (Terminal, Web Checkout, Backoffice, Direct API, Concierge, Sales Kiosk, custom)

Order Destination

if destinations are set, the destination in which the sale was made

Checkout

name of the checkout through which the order was made

Portal

name of the sales portal through which the order was made

Connection

name of the connection

Connection Partner

name of the connection partner (reseller)

Checkout Channel

type of channel assigned to the web checkout

Direct Sale

whether the sale was made directly (sellers/website/kiosk) vs. by a reseller

Referrer

URL of a web referrer

Location

name of the location where the sale was made from

Location Channel

name of the channel used to make the sale at the location

Outlet

name of the reseller outlet (chain assignable to a reseller)

Email Receipt

whether an email receipt was sent to the customer

Source

name of the source where the sale was made from

Terminal

name of the terminal where the sale was made from

Delivery Method

delivery method of tickets (email, SMS, QR code, digital wallet, print, do nothing)

Column

Description

This column is not present in these tables

Order Notes

notes entered in the checkout form

Order Reference

8-character alphanumeric string beginning with # on the booking level

ID

unique alphanumeric string identifying the record

Booking Reference

8-character alphanumeric string near the top of the booking level

Booking Barcode

unique string generated for a booking

Booking Alias

unique string generated for a booking made with an operator

Order Date

date the order was made

Order Date Time

time the order was made, with UTC offset

Order Date Weekday

day of the week the order was made

Order Date Week

week of the year the order was made

Order Date Month

month the order was made

Order Date Year

year the order was made

Booking Date

date when the product was purchased

Booking Time

time when the product was purchased

Booking Date Time

time the booking was made, with UTC offset

Booking Date Weekday

day of the week the booking was made

Booking Date Week

week of the year the booking was made

Booking Date Month

month the booking was made

Booking Date Year

year the booking was made

Travel Date

date when the tour takes place

Travel Date Weekday

day of the week the tour takes place

Travel Date Week

week of the year the tour takes place

Travel Date Month

month the tour takes place

Travel Date Year

year the tour takes place

Status

the state of a booking — see the Bookings Table article for status definitions

Label

flag associated with a booking, used to categorise or identify it

Cancellation Reason

reason selected from a drop-down during booking cancellation

Cancellation Notes

additional information about a booking cancellation

Has Duplicates

whether a duplicate booking was made

Checked In

whether the customer checked in (two-stage redemption)

Upsold

whether the booking was changed to a more expensive offering

Upsold From

name of the product the customer initially requested before being upsold

Same Day

whether the travel date is the same as the booking date

Valid From

voucher validity start date

Expires On

voucher validity end date

Redemption Date

date the booking was redeemed

Redemption Time

time the booking was redeemed

Redemption Location

virtual or physical location where tickets were redeemed

Confirmation Date

date of order confirmation

Confirmation Time

time of order confirmation

Cancellation Date

date of order cancellation

Cancellation Time

time of order cancellation

Supplier Booking Date

date the booking was made by the supplier

Supplier Booking Time

time the booking was made by the supplier

Supplier Redemption Date

date the booking was redeemed by the supplier

Supplier Redemption Time

time the booking was redeemed by the supplier

Supplier Confirmation Date

date the booking was confirmed by the supplier

Supplier Confirmation Time

time the booking was confirmed by the supplier

Supplier Cancellation Date

date the booking was cancelled by the supplier

Supplier Cancellation Time

time the booking was cancelled by the supplier

Confirmed

whether the booking/order was successfully processed

Booking Type

the type of product purchased — see the Bookings Table article for definitions

Private Notes

backend notes on a booking, not viewable by concierge or customer

Public Notes

notes on a booking viewable by everyone

Open Dated

whether a booking can be used anytime within the product's validity period

Skip Feedback Email

whether the option to skip the feedback email was selected

Question

displays the answers to questions associated with the booking

Weight

weight data for bookings with weight limits

Sequence Value

the ticket's order number in the database

Supplier Reference

reference identifying the booking on the supplier's side

Column

Description

This column is not present in these tables

Product

name of the product

Product Destination

destination associated with the product

Product Operator

name of the product operator

Product Code

custom code of the product

Product Billing Account Code

custom code for reporting purposes

Product Tags

custom tags assigned to a product, used for filtering

Promotion

discount assigned to the sale of a booking

Promotion Code

custom code assigned to a promotion

Promotion Tags

custom tags assigned to a promotion, used for filtering

Combination

starting product that led to a combination discount sale

Has Combination

whether the order contains combinations (cross-sell products)

Combination Booking

the reference number of the starting product

Package Product

a product consisting of more than one include (product)

Package Product Code

custom code assigned to a package

Package Option

name of an option in a package

Package Option Code

custom code assigned to a package option

Package Travel Date

the nearest travel date of one of the includes in the package

Package Travel Date Difference

days between the earliest and latest travel dates in a package

Membership Product

the name of the membership product associated with the booking

Membership Option

the option variant of the membership product purchased

Membership Unit

the specific membership unit associated with the booking

Membership Benefit

the specific benefit of the membership applied to the booking, such as free entry or an automatic discount

Membership Customer

the customer the membership belongs to

Membership Customer Code

custom code assigned to the membership customer, e.g. for ERP integrations

Membership Reference

reference identifying the membership

Membership Reseller Reference

reference identifying the membership on the reseller's side

Option

variant of the product (e.g. 24-hour tour, 48-hour tour)

Option Code

custom code assigned to an option

Hotel

name of the hotel selected during booking

Tour Time

time when the tour starts

Tour Group

name of the tour group the booking is assigned to

Duration

length of the tour, in hours

Has Allocations

whether the product contains allocations

Has Resource Allocations

whether the booking has a resource assigned to it

Column

Description

This column is not present in these tables

Order Balance

the amount due or overpayment of an order

PAX

the number of passengers regardless of ticket type (tier)

Total

the total amount paid

Notice Days

the number of days between booking date and travel date

Adult

the number of tickets by ticket type (tier)

Youth

the number of tickets by ticket type (tier)

Child

the number of tickets by ticket type (tier)

Infant

the number of tickets by ticket type (tier)

Family

the number of tickets by ticket type (tier)

Senior

the number of tickets by ticket type (tier)

Student

the number of tickets by ticket type (tier)

Military

the number of tickets by ticket type (tier)

Other

the number of tickets by ticket type (tier)

Net PAX

the number of customers on the ticket

Noshow PAX

the number of tickets where a customer did not show up for the tour

Upgraded PAX

the number of tickets upgraded to a comparison (up-sell) product

Active PAX

the number of customers that attended the tour; no-shows are always 0

Points

the number of points earned by a seller or reseller for selling products

Adjustment

the amount by which an order's total was changed (custom discount or custom price)

Cost

the amount of costs associated with a booking (e.g. purchase of 3rd party products)

Base Cost

the cost of a product in the product's base currency

Discount

if a promotion was applied, the value of the promotion

Wholesale

the set price a reseller buys the product at, fixed for a contracted period

Seller Commission

the seller's cut from the sale

Commission

the reseller's cut from the sale

Receivable

amount you make or owe from the sale; positive = reseller owes you, negative = you owe reseller

Margin

clean earnings: total − cost − commission − payment fees − net tax

Surcharge

the amount added to the total, like a booking fee

Paid

the amount paid by the customer

Refunded

the amount given back to the customer

Card Total

the total amount paid by card

Cash Total

the total amount paid by cash

Other Total

the total amount paid by other means

Gift Total

the total amount paid by a gift card

Voucher Total

the total amount paid by a reseller voucher

Tax

the tax amount out of the total paid by the customer

Net Tax

tax applied to product price (direct sale) or after commission is deducted (reseller sale)

Total No Tax

the total value of the booking excluding tax

Revenue

earnings from the sale of a single ticket

Gross Revenue

earnings before any deductions or taxes

Balance

the difference between an amount due and an amount paid

Product FX

conversion rate for the product, if using different currencies

Extras Total

the value of extra upgrades

Reconciled

whether payments in the transaction are matching

Supplier FX

conversion rate against the supplier's currency

Settlement

settlement method: Direct, Voucher, Deposit, Wholesale, or Deferred

Currency

currency used to sell a product

Transferred

whether funds have arrived in the operation's account

Ticket Price

price for an individual ticket (Tickets-specific)

Exchange Rate

conversion rate, if using different currencies (Resource Allocations-specific)

Price

the price of the item or extra

Quantity

the number of purchased items of the same type (Item Purchases-specific)

Tax Rate

the tax rate applied to the price of the item

Payment Disputed

whether the booking payment is disputed

Payment Disputed Reason

the reason provided when the dispute was submitted

📒 NOTE

Disputed payments automatically sync with associated memberships. While a dispute is active, membership benefits cannot be redeemed unless the membership was redeemed before the dispute was raised.

Column

Description

This column is not present in these tables

Has Waivers

whether the booking includes any waivers

Waiver

name of the waiver included in the booking

Waivers Complete

whether all attached waivers have been signed by the customer

Column

Description

This column is not present in these tables

Pickup Requested

whether the customer requested to be picked up for the tour

Pickup Dispatch Driver

name of the driver assigned to the pickup

Pickup Zone

name of the zone where the pickup point is located

Pickup Time

exact time pickup is available for the tour

Pickup Point

name of the pickup point

Pickup Route

path the pickup takes

Pickup Notes

additional information about a pickup

Pickup Address

address of the pickup point

Pickup Telephone

phone number of a contact managing/guiding the pickup

Custom Pickup

name of a pickup not assigned to the booking route but listed in the pickup list

Dropoff Requested

whether the customer requested to be dropped off after the tour

Dropoff Zone

name of the zone where the dropoff point is located

Dropoff Time

exact time dropoff is available for the tour

Dropoff Point

name of the dropoff point

Dropoff Route

path the dropoff takes

Dropoff Address

address of the dropoff point

Dropoff Telephone

phone number of a contact managing/guiding the dropoff

Dropoff Time

time the customer is dropped off

Dropoff Date

date the customer is dropped off

Dropoff Instructions

information pertaining to the dropoff point

Column

Description

This column is not present in these tables

Voucher

name of the reseller voucher

Voucher Code

code of reseller voucher used during the sale

Voucher Bill Gap

YES/NO; whether a skipped voucher number was auto-filled to keep invoicing continuous

Has Voucher File

whether an image of the voucher is attached to the booking

Allow Voucher

whether a group ticket is allowed

Allow Tickets

whether individual tickets are allowed

Gift Time

time of gift card purchase

First Used Date

date when the gift card was first used

First Used Time

time when the gift card was first used

Expiry Date

date of gift card expiry; if no date is selected, the gift card is valid for a year

Expiry Date Week

week of the year the gift card expires

Expiry Date Weekday

day of the week the gift card expires

Expiry Date Month

month the gift card expires

Expiry Date Year

year the gift card expires

Expiry Date Time

time of gift card expiry, with UTC offset

Expiry Time

time of gift card expiry; if no date is selected, the gift card is valid for a year to the minute

Message

message from the customer who purchased the gift card, for the recipient

Tags

tags associated with a gift card

Ledger Code

code automatically assigned to the order for fulfilling a defined ledger code rule

Ledger Code Description

brief description of the ledger code rule

Column

Description

This column is not present in these tables

Invoice ID

reseller invoice ID

Invoice

reseller invoice reference (reseller code/name + invoice number)

Invoice Status

state of reseller invoice (void, draft, confirmed, overdue, paid)

Operator Invoice ID

operator invoice identifier

Operator Invoice

operator invoice reference

Has Operator Invoice

whether an operator invoice was issued

Column

Description

This column is not present in these tables

Has Purchases

whether an item was purchased with the booking

Has Extra Upgrades

whether the booking contains extras

Purchases

name of item purchased

Purchase Date

date when the item was purchased

Purchase Time

time the item was purchased

Purchase Date Time

time the item was purchased, with UTC offset

Purchase Date Year

year the item was purchased

Purchase Date Month

month the item was purchased

Purchase Date Week

week of the year the item was purchased

Purchase Date Weekday

day of the week the item was purchased

Column

Description

This column is not present in these tables

Imported

whether a booking/order was imported

Test

whether a booking/order is a test booking

IP Address

customer's IP address, if ordered via web checkout

User Agent

browser information if the sale came through web checkout

Backend Connected

whether the booking is API connected

Backend Error

whether there was an API connection failure

Backend Error Message

description of API connection failure

3rd Party Products

whether the product is a 3rd party product

OCTO UUID

unique reseller identifier used as an API authentication token