Please note: File-based delivery is only available to White Label Template partners.

File-based delivery for Loyalty Earn

The standard earn report, also known as an accrual file, provides basic booking information along with the loyalty rewards earned. Using the standard reports in the Portal means that you can get your data quickly, without additional development time.

The earn report includes a curated list of more than 30 fields to choose from, including:

  • Basic booking information such as dates, itineraries, and trip amounts
  • Loyalty member information
  • Rewards information like earn date and program details

When you download your file via the Portal, you can configure the file name however you like. We recommend that you include the date of generation and type of report in the file name, for easy reference.

Learn more about file delivery setup
Best practices for file ingestion

Standard report default fields

There are many fields to choose from when customizing your reports. These are included by default in standard reports.

Field nameDescriptionExample
itinerary_numberThe itinerary number or point of sale order reference number.12345678910111
transaction_typeThe type of transaction recorded.Possible values:
purchase
award
modification
cancel
book_dateThe date a booking was initially made, represented in ISO 8601 date format (YYYY-MM-DD).2023-02-05
transaction_dateThe date a booking was last modified. This is the same as book_date if the booking is never updated. Represented in ISO 8601 date format (YYYY-MM-DD).2023-02-05
earn_dateThe date the traveler earned the loyalty currency being used.2023-01-14
point_definitionIndicator of a campaign or promotion that changes your program’s base earning model.base
pending_pointsNumber of points earned but not yet awarded.Broken down as:
total: –100.11
base: –90.01
bonus: –10.1
award_pointsNumber of points awarded for the transaction.Broken down as:
total: 100.11
base: 90.01
bonus: 10.1
loyalty_idUnique identifier of the member record.12345678
product_line_nameThe type of business the booking item falls under.Possible values:
Air
Car
Cruise
Destination services
Insurance
Lodging
Package
unknown
currency_codeCurrency in which the booking was paid, represented in standard International Bank Account Number (IBAN) currency code format.USD
gbv_localThe gross booking value (GBV), or total booking amount including taxes and fees, in the currency used to pay.694.89
Did you find this page helpful?
How can we improve this content?
Thank you for helping us improve!