Members with Open Membership Orders Query

This query returns a list of individuals with open, non-cancelled, dues orders by date range.

Query Parameters

Parameter	Description
Date Greater Than or Equal To	Enter a date, or select a date from the drop down calendar, for the query.
Date Less Than or Equal To	Enter a date, or select a date from the drop down calendar, for the query.

Query (Default) Fields

Field	Description
Query Header	Displays the query name, number of records returned, and the total number of pages for the query.
First, Last Name, Suffix	Lists the individual first and last name with any suffix.
PriAddress Address Line 1, 2, 3, City, State/Territory, Postal Code	Lists the individual primary address.
PriPhone Phone Number, Extension	Lists the individual primary phone number and extension.
PriEMail E-Mail Address	Lists the individual primary email address.
membership Expire Date	Lists the individual membership expire date.
PrdMem Product Name	Lists the individual membership product name.
trx_mbd Total Amount	Lists the individual membership total invoice amount.
mbd_ord Date	Lists the individual membership order date.
mbd_ord Order Number	Lists the individual membership related order number.