Date fields

Booking date

Start date

End date

Date

Row created date

Row effective start date

Row effective end date

Metric fields

Total price

Total VAT amount

Already paid

Hotel latitude

Hotel longitude

Quantity

Unit price

VAT amount

Total VAT

From price

Min occupancy

Max occupancy

Rank

Number of participants

Basket level discount amount

Basket level discount VAT amount

Original unit price

Original total price

Original VAT amount

Original total VAT

Row quantity

Row nights

Row unit amount

Row total amount

Dimension fields

Booking code

Booking GUID

Booking status

Channel ID

Organization ID

Currency code

Customer ID

Customer first name

Customer last name

Customer email

Customer phone

Customer country code

Customer city

Customer postal code

Customer street address

Hotel name

Hotel email

Can be edited online

Can be cancelled online

Is conference booking

Is standalone booking

Is vacation rental booking

Rooms JSON

Room descriptions JSON

Guests JSON

Optional add-ons JSON

Payment history JSON

VAT breakdown JSON

Cancellation data JSON

Optional addon packages JSON

Package descriptions JSON

Row type

Row status

Product kind

Product ID

Room ID

Package ID

Add-on ID

Add-on package ID

Guest ID

Price included in room rate

Charge unit

Add-on type

Cancellation policy ID

Source internal booking ID

Source internal add-on booking ID

Rate plan ID

Inventory ID

Discount ID

Combined ID

Category ID

Category name

Product name

Short description

Description

Additional info

Primary image URL

Images JSON

Type code

From price type

Base prices JSON

Room size

Accommodation type

External info URL

Is dynamic

Sale start

Sale end

Conference room ID

Conference rate plan ID

Occasion ID

Base inventory ID

Room type

Seating type

Seating type name

Payment policy ID

Related add-on internal booking ID

Related add-on package internal booking ID

Taxes and fees JSON

Gift card payments JSON

Basket level discount info JSON

Booking data JSON

Raw booking JSON

PSP type

Payment method

Transaction type

Transaction status

Paid on site

Row metadata JSON

Row family

Include in revenue