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 name | Description | Example |
|---|---|---|
itinerary_number | The itinerary number or point of sale order reference number. | 12345678910111 |
transaction_type | The type of transaction recorded. | Possible values: purchase award modification cancel |
book_date | The date a booking was initially made, represented in ISO 8601 date format (YYYY-MM-DD). | 2023-02-05 |
transaction_date | The 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_date | The date the traveler earned the loyalty currency being used. | 2023-01-14 |
point_definition | Indicator of a campaign or promotion that changes your program’s base earning model. | base |
pending_points | Number of points earned but not yet awarded. | Broken down as: total: –100.11 base: –90.01 bonus: –10.1 |
award_points | Number of points awarded for the transaction. | Broken down as: total: 100.11 base: 90.01 bonus: 10.1 |
loyalty_id | Unique identifier of the member record. | 12345678 |
product_line_name | The type of business the booking item falls under. | Possible values: Air Car Cruise Destination services Insurance Lodging Package unknown |
currency_code | Currency in which the booking was paid, represented in standard International Bank Account Number (IBAN) currency code format. | USD |
gbv_local | The gross booking value (GBV), or total booking amount including taxes and fees, in the currency used to pay. | 694.89 |