Invoice Query Examples

Query that does not show voids (lists only non-tracking invoices and refunds)	Query to select domestic flights
Query to include ARC and Invoice Items (excludes Tracking and Direct items)	Query of invoices by payment status
Query of non-paid customer service fees	Query for e-tickets only
Query of corporate accounts without car and hotel bookings	Query for ARC service fees
Query for non-paid cash or check tickets	Query for tickets not paid in full
Query for invoices paid with a United UATP card	Query by the invoice number located on the interface log
Query with a wild card in the sort fields	Query with a specific market code
Query plastic items with partially paid commission	Query Revenue Types T and S

For queries to find Apollo manual hotels, missing comment lines, or missing Apollo MIR sequence numbers, see "Comment Line Subtotal Examples" in the Printing a Query in the Invoice File section.