| Column Name | Filter Name | Description |
Document Acknowledgement Created Date | Document Acknowledgement Created Date Range | The date a document acknowledgment in a Trip was created. Each acknowledgment will display as a separate row. |
Document Acknowledgement Status | Document Acknowledgement Status | The date a document acknowledgment in a Trip will expire. Each acknowledgment will display as a separate row. |
Payment Authorization Created Date | Payment Authorization Created Date Range | The date a payment authorization in a Trip was created. Each authorization will display as a separate row. |
| Payment Authorization Expiration Date | Payment Authorization Created Date Range | The date a payment authorization in a Trip will expire. Each authorization will display as a separate row. |
| Payment Authorization Status | Payment Authorization Status | The status of a payment authorization. Each authorization will display as a separate row. |
| Reservation Advisor | Reservation Advisor | The Advisor listed in the Advisors tab of a Reservation. |
| Reservation Advisor Commission Amount | The Commission Amount listed in the Advisors tab of a Reservation. | |
| Reservation Advisor Commission Rate | The Commission % listed in the Advisors tab of a Reservation. | |
| Reservation Advisor Date Payable | Reservation Advisor Date Payable From/To | The date an Advisor should expect commission to be received on a Reservation. This is calculated from the rules set up in Agency Settings. |
| Reservation Advisor Date Reconciled | Reservation Advisor Date Reconciled From/To | The Date of Reconciliation listed in the Advisors tab of a Reservation. |
| Reservation Advisor Default Commission Amount | Calculated from the Reservation Commission and the Default Commission % listed in the Advisors profile for the specific travel category. | |
| Reservation Advisor Default Commission Rate | The Default Commission % listed in the Advisors profile for the specific travel category. | |
| Reservation Advisor Record Number | Data in the program that allows the merging of of the record number into a hyperlink linking to an Advisor profile. | |
| Reservation Air Ticket Type | The Ticket Type of Air Reservations. | |
| Reservation ARC Number | Reservation ARC Number | The ARC Number selected in a Reservation. |
| Reservation Balances Settled Date Range | The date the reservation was settled: when both client and supplier balances went to $0. | |
| Reservation Booking Date | Reservation Booking Date Range | The Booking Date entered in a Reservation. |
| Reservation Booking Source | Reservation Booking Source | The Booking Source entered in a Reservation. |
| Reservation Client Balance | Reservation Client Balance | The remaining balance owed by the Client on a Reservation. |
| Reservation Commission Amount | Reservation Commission Amount | The Commission Amount of a Reservation. |
| Reservation Commission Date Receivable Range | The date commission is expected to be received from the supplier. This is calculated from the supplier payment rules entered in the supplier profile. | |
| Reservation Commission Rate | The Commission % of a Reservation. | |
| Reservation Confirmation Number | Reservation Confirmation Number | The Confirmation No entered in a Reservation. |
| Reservation Confirmed Date | Reservation Confirmed Date Range | The date a Reservation was saved with a status of Confirmed. |
| Reservation Date Created | Reservation Created Date Range | The date a Reservation was created. |
| Reservation Date Modified | Reservation Modified Date Range | The date a Reservation was most recently modified. |
| Reservation Deposit Due Date | Reservation Deposit Due Date Range | The Deposit Date entered in a Reservation. |
| Reservation End Date | Reservation End Date Range | The End Date of a Reservation. |
| Reservation Final Pay Due Date | Reservation Final Pay Due Date Range | The Final Pay Date entered in a Reservation. |
| Reservation GST/HST Amount | Reservation GST/HST Amount | The GST/HST amount entered in a Reservation. Canadian databases only. |
| Reservation GST on Commission Amount | Reservation GST on Commission Amount | The GST/HST on commission amount entered in a Reservation. Canadian databases only. |
| Reservation Itin Remarks | Reservation Itin Remarks | The Itinerary Remarks entered in a Reservation. |
| Reservation Mark-up/Discount | The Mark-up/Discount of a Reservation. | |
| Reservation Number | Reservation Number | Data in the program that allows the merging of of the record number into a hyperlink linking to a Reservation. |
| Reservation Original Ticket Number | Data from the original ticket number field in an air reservation. | |
| Reservation Primary Traveler | Reservation Traveler | The name of the Traveler toggled as Primary Traveler in the Travelers tab of a Reservation. |
| Reservation Primary Traveler Record Number | Data in the program that allows the merging of of the record number into a hyperlink linking to a Traveler profile. | |
| Reservation Promo Id | Reservation P | The Promo ID entered in a Reservation. |
| Reservation Provider | Reservation Provider | The Provider selected in a Reservation. |
| Reservation Provider - Imported Data Name | Reservation Provider - Imported Data Name | The Name listed in the Imported Provider Data of a Reservation. |
| Reservation Record Locator | Reservation Record Locator | The Record Locator entered in a Reservation. |
| Reservation Start Date | Reservation Start Date Range | The Start Date of a Reservation. |
| Reservation Status | Reservation Status | The Status selected in a Reservation. |
| Reservation Supplier | Reservation Supplier | The Supplier selected in a Reservation. |
| Reservation Supplier - Imported Data Name | Reservation Supplier - Imported Data Name | The Name listed in the Imported Supplier Data of a Reservation. |
| Reservation Supplier Balance | Reservation Supplier Balance | The remaining balance owed by or to the Supplier on a Reservation. |
| Reservation Supplier Profile Record Number | Data in the program that allows the merging of of the record number into a hyperlink linking to a Supplier Profile. | |
| Reservation Tag | Reservation Tag | A tag added to a Reservation. |
| Reservation Tags - All | All tags added to a Reservation. | |
| Reservation Tax Amount | The tax amount entered in a Reservation. | |
| Reservation Ticket No | Reservation Ticket No | The Ticket No. entered in a Reservation. |
| Reservation Total Fare | Reservation Total Fare | The Total Fare of a Reservation. |
| Reservation Track Client Payment | Reservation Track Client Payment | The toggled option (Yes or No) of Track Client Payment in a Reservation. |
| Reservation Travel Category | Reservation Travel Category | The Travel Category selected in a Reservation. |
| Reservation Travel Category Record Number | Not applicable at this time. | |
| Reservation Travel Category Sub-Category | Reservation Travel Category Sub-Category | The Travel Sub-Category selected in a Reservation. |
| Reservation Traveler Name | Reservation Traveler Name | All Travelers (linked and freeflow) in a Reservation. |
| Reservation Traveler Record Number | Data in the program that allows the merging of of the record number into a hyperlink linking to a Traveler profile. | |
| Summary Count | Represents the count of child rows for a given row. Used when you want to see both the child row details and the count of child rows as a column. | |
| Trip Action Assigned To | Trip Action Assigned To | The User selected in the Assigned To field of an Action. |
| Trip Action Item Completed | Trip Action Item Completed | The Completed status (Yes or No) of an Action. |
| Trip Action Item Date | Trip Action Item Date Range | The Target Date of an Action. |
| Trip Advisor | Trip Advisor | The Advisor selected in a Trip. |
| Trip Advisor Profile RecNo | Data in the program that allows the merging of of the record number into a hyperlink linking to an Advisor profile. | |
| Trip Branch | Trip Branch | The Branch selected in a Trip. |
| Trip Cancelled | Trip Cancelled | The Cancelled status (Yes or No) of a Trip. |
| Trip Client | Trip Client | The Client associated with a Trip. |
| Trip Client Profile RecNo | Data in the program that allows the merging of of the record number into a hyperlink linking to a Client profile. | |
| Trip Date Created | Trip Created Date Range | The date a Trip was created. |
| Trip Date Modified | Trip Modified Date Range | The date a Trip was most recently modified. |
| Trip Destination | Trip Destination | All Destinations entered in a Trip. |
| Trip End Date | Trip End Date Range | The End Date of a Trip. |
| Trip Name | Trip Name | The Trip Name of a Trip. |
| Trip Number | Trip Number | Data in the program that allows the merging of of the record number into a hyperlink linking to a Trip. |
| Trip Record Locator | Data in the program that allows the merging of of the record number into a hyperlink linking to a Trip profile. | |
| Trip Start Date | Trip Start Date Range | The Start Date of a Trip. |
| Trip Tag | Trip Tag | A tag added to a Trip. |
| Trip Tags - All | All tags added to a Trip. | |
| Trip Target Travel Date | Trip Target Travel Date Range | The Target Travel Date of a Trip. |
| Trip Total Commission | The total commission of all confirmed and cancelled Reservations in a Trip. Pending Reservations are not included in this calculation. | |
| Trip Total Fare | The Total Fare of all Reservations in a Trip. |