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_dateDimension
The date when the booking was created or made.
booking_stateDimension
Current status of the booking, such as Confirmed, Cancelled, InError, or GeneralFailure.
booking_system_referenceDimension
A unique reference ID assigned to the booking by the booking system.
booking_typeDimension
Classification of the booking, such as Direct or OnAccount.
customer_address_line1Dimension
First line of the customer's street address.
customer_address_line2Dimension
Second line of the customer's street address, if applicable.
customer_cityDimension
City of the customer's address.
customer_countryDimension
Country of the customer's address.
customer_emailDimension
Customer's primary email address.
customer_first_nameDimension
Customer's given name.
customer_last_nameDimension
Customer's family name.
customer_postcodeDimension
Postcode or ZIP code of the customer's address.
customer_stateDimension
State, province, or region of the customer's address.
customer_telephone_homeDimension
Customer's home telephone number.
customer_telephone_mobileDimension
Customer's mobile telephone number.
customer_telephone_workDimension
Customer's work telephone number.
distributor_address_line1Dimension
First line of the distributor's street address.
distributor_address_line2Dimension
Second line of the distributor's street address, if applicable.
distributor_cityDimension
City of the distributor's address.
distributor_countryDimension
Country of the distributor's address.
distributor_emailDimension
Distributor's primary email address.
distributor_full_nameDimension
Full legal name of the distributor.
distributor_idDimension
Unique identifier for the distributor.
distributor_postcodeDimension
Postcode or ZIP code of the distributor's address.
distributor_short_nameDimension
Abbreviated or common name of the distributor.
distributor_stateDimension
State, province, or region of the distributor's address.
distributor_tax_idDimension
Tax identification number for the distributor.
distributor_telephoneDimension
Distributor's primary telephone number.
industry_categoryDimension
The category of the tourism product or service, such as Accommodation or Attraction.
merchant_address_line1Dimension
First line of the merchant's street address.
merchant_address_line2Dimension
Second line of the merchant's street address, if applicable.
merchant_cityDimension
City of the merchant's address.
merchant_countryDimension
Country of the merchant's address.
merchant_emailDimension
Merchant's primary email address.
merchant_full_nameDimension
Full legal name of the merchant.
merchant_idDimension
Unique identifier for the merchant.
merchant_postcodeDimension
Postcode or ZIP code of the merchant's address.
merchant_short_nameDimension
Abbreviated or common name of the merchant.
merchant_stateDimension
State, province, or region of the merchant's address.
merchant_tax_idDimension
Tax identification number for the merchant.
merchant_telephoneDimension
Merchant's primary telephone number.
num_adultsMetric
The number of adult participants included in the booking.
num_childrenMetric
The number of child participants included in the booking.
num_concessionsMetric
The number of concession-eligible participants included in the booking.
payment_methodDimension
The method used to pay for the booking (e.g., credit card, bank transfer).
product_cancelledDimension
Boolean indicator showing if the booked product or service was cancelled.
product_commencing_dateDimension
The start date for the booked product or service.
product_concluding_dateDimension
The end date for the booked product or service.
product_idDimension
Unique identifier for the booked product or service.
product_nameDimension
Name of the booked product or service.
product_quantityMetric
The number of units of the product or service booked.
product_refundedDimension
Boolean indicator showing if the booked product or service was refunded.
provider_address_line1Dimension
First line of the provider's street address.
provider_address_line2Dimension
Second line of the provider's street address, if applicable.
provider_cityDimension
City of the provider's address.
provider_countryDimension
Country of the provider's address.
provider_emailDimension
Provider's primary email address.
provider_full_nameDimension
Full legal name of the provider.
provider_idDimension
Unique identifier for the provider.
provider_postcodeDimension
Postcode or ZIP code of the provider's address.
provider_short_nameDimension
Abbreviated or common name of the provider.
provider_stateDimension
State, province, or region of the provider's address.
provider_tax_idDimension
Tax identification number for the provider.
provider_telephoneDimension
Provider's primary telephone number.
reservation_idDimension
A unique identifier for the specific reservation.
total_priceMetric
The total price of the booking, including all extras and taxes.
total_price_excluding_extrasMetric
The total price of the booking, excluding any additional services or items.
transaction_dateDimension
The date when the financial transaction for the booking occurred.