Members with Open Membership Invoices Query

This query returns a list of individuals with open, non-cancelled, invoices.

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.
Individual Sort Name	Lists the individual sort name.
PriAddr City, State, Post Code	Lists the individual partial primary address.
PriPhone Phone Number, Extension	Lists the individual primary phone number and extension.
PriFax Fax Number, Extension	Lists the individual primary fax number and extension.
PriEMail E-Mail Address	Lists the individual primary email address.
membership Expire Date	Lists the individual membership expire date.
DuesForCst Renewal Date	Lists the individual membership renewal date.
DuesForCst Expire Date	Lists the individual membership expire date.
DuesMemType Start Month	Lists the individual membership start month (numerical).
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.