Members with Open Membership Orders by Member Type (single/multi-select) Query

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

Query Parameters

Parameter	Description
Member Type Is Equal To	Select up to five (5) member types from the drop down lists.

Query (Default) Fields

Field	Description
Query Header	Displays the query name, number of records returned, and the total number of pages for the query.
Individual Sort Name	Lists the individual sort name.
PriAddr City, State, Post Code	Lists the individual partial primary address.
DuesForCst Renewal Date	Lists the individual membership renewal date.
DuesForCst Expire Date	Lists the individual membership expire date.
DuesMemType Life Time Membership?	Indicates whether or not the individual membership type is a lifetime membership.
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.