Txgb: Most-used fields#
The table below gives information about most-used fields that you can import from Txgb. Other fields might also be available in Adverity.
The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.
booking_date Dimension
The date when the booking was created or made.
booking_state Dimension
Current status of the booking, such as Confirmed, Cancelled, InError, or GeneralFailure.
booking_system_reference Dimension
A unique reference ID assigned to the booking by the booking system.
booking_type Dimension
Classification of the booking, such as Direct or OnAccount.
customer_address_line1 Dimension
First line of the customer's street address.
customer_address_line2 Dimension
Second line of the customer's street address, if applicable.
customer_city Dimension
City of the customer's address.
customer_country Dimension
Country of the customer's address.
customer_email Dimension
Customer's primary email address.
customer_first_name Dimension
Customer's given name.
customer_last_name Dimension
Customer's family name.
customer_postcode Dimension
Postcode or ZIP code of the customer's address.
customer_state Dimension
State, province, or region of the customer's address.
customer_telephone_home Dimension
Customer's home telephone number.
customer_telephone_mobile Dimension
Customer's mobile telephone number.
customer_telephone_work Dimension
Customer's work telephone number.
distributor_address_line1 Dimension
First line of the distributor's street address.
distributor_address_line2 Dimension
Second line of the distributor's street address, if applicable.
distributor_city Dimension
City of the distributor's address.
distributor_country Dimension
Country of the distributor's address.
distributor_email Dimension
Distributor's primary email address.
distributor_full_name Dimension
Full legal name of the distributor.
distributor_id Dimension
Unique identifier for the distributor.
distributor_postcode Dimension
Postcode or ZIP code of the distributor's address.
distributor_short_name Dimension
Abbreviated or common name of the distributor.
distributor_state Dimension
State, province, or region of the distributor's address.
distributor_tax_id Dimension
Tax identification number for the distributor.
distributor_telephone Dimension
Distributor's primary telephone number.
industry_category Dimension
The category of the tourism product or service, such as Accommodation or Attraction.
merchant_address_line1 Dimension
First line of the merchant's street address.
merchant_address_line2 Dimension
Second line of the merchant's street address, if applicable.
merchant_city Dimension
City of the merchant's address.
merchant_country Dimension
Country of the merchant's address.
merchant_email Dimension
Merchant's primary email address.
merchant_full_name Dimension
Full legal name of the merchant.
merchant_id Dimension
Unique identifier for the merchant.
merchant_postcode Dimension
Postcode or ZIP code of the merchant's address.
merchant_short_name Dimension
Abbreviated or common name of the merchant.
merchant_state Dimension
State, province, or region of the merchant's address.
merchant_tax_id Dimension
Tax identification number for the merchant.
merchant_telephone Dimension
Merchant's primary telephone number.
num_adults Metric
The number of adult participants included in the booking.
num_children Metric
The number of child participants included in the booking.
num_concessions Metric
The number of concession-eligible participants included in the booking.
payment_method Dimension
The method used to pay for the booking (e.g., credit card, bank transfer).
product_cancelled Dimension
Boolean indicator showing if the booked product or service was cancelled.
product_commencing_date Dimension
The start date for the booked product or service.
product_concluding_date Dimension
The end date for the booked product or service.
product_id Dimension
Unique identifier for the booked product or service.
product_name Dimension
Name of the booked product or service.
product_quantity Metric
The number of units of the product or service booked.
product_refunded Dimension
Boolean indicator showing if the booked product or service was refunded.
provider_address_line1 Dimension
First line of the provider's street address.
provider_address_line2 Dimension
Second line of the provider's street address, if applicable.
provider_city Dimension
City of the provider's address.
provider_country Dimension
Country of the provider's address.
provider_email Dimension
Provider's primary email address.
provider_full_name Dimension
Full legal name of the provider.
provider_id Dimension
Unique identifier for the provider.
provider_postcode Dimension
Postcode or ZIP code of the provider's address.
provider_short_name Dimension
Abbreviated or common name of the provider.
provider_state Dimension
State, province, or region of the provider's address.
provider_tax_id Dimension
Tax identification number for the provider.
provider_telephone Dimension
Provider's primary telephone number.
reservation_id Dimension
A unique identifier for the specific reservation.
total_price Metric
The total price of the booking, including all extras and taxes.
total_price_excluding_extras Metric
The total price of the booking, excluding any additional services or items.
transaction_date Dimension
The date when the financial transaction for the booking occurred.