Open Invoices for Registrants by Event Query

This query returns a list of event registrants with open invoices.

Query Parameters

Parameter	Description
Event Is Equal To	Select an event from the drop down list.

Query (Default) Fields

Field	Description
Query Header	Displays the query name, number of records returned, and the total number of pages for the query.
Badge First, Last, Name	Lists the customer badge first, last, and full name.
Cancel Date	Lists the registration cancel date.
Registrant Type Code	Lists the registrant type code.
trx Amount	Lists the transaction amount.
Invoice Code	Lists the associated invoice code.
Event Product Name	Lists the event product name.
Order Number	Lists the associated order number.
Order Status	Lists the order status.
Confirmation Number	Lists the order confirmation number.