You are here: netFORUM Pro Modules > Reports and Queries > List of Baseline Queries > Open Invoices for Registrants by Event Query

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.