You are here: netFORUM Pro Modules > Reports and Queries > List of Baseline Queries > Members with Dues Renewal Record by renewal transaction creation date Query

Members with Dues Renewal Record by renewal transaction creation date Query

This query returns a list of individuals with dues renewal records created through the mass renewal process by transaction date.

Query Parameters

Parameter Description
Add Date Greater Than or Equal To Enter a date, or select a date from the drop down calendar, for the query.
Add Date Less Than or Equal To Enter a date, or select a date from the drop down calendar, for the query.
Product Is Equal To Select a product (membership) 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.
Individual Sort Name Lists the individual sort name.
PriAddr Type Lists the individual primary address type.
PriAddr Address Line 1, 2, 3, City, State/Territory, Postal Code Lists the individual primary address.
PriPhone Phone Number Lists the individual primary phone number.
PriEMail E-Mail Address Lists the individual primary email address.
MemPrd Product Name Lists the individual membership product name.
OrderDuesRenewal Order Number Lists the individual membership dues related order number.
DuesRenewalTransaction Add Date Lists the individual membership dues transaction add date.