You are here: netFORUM Pro Modules > Reports and Queries > List of Baseline Queries > Individual Primary Contacts of Member Orgs by the Orgs Dues Invoice Closed Date Query
Individual Primary Contacts of Member Orgs by the Orgs Dues Invoice Closed Date Query
This query returns a list of non-cancelled invoices for all primary contacts of a member organization.
Query Parameters
Parameter | Description |
---|---|
Close Date Greater Than or Equal To | Enter a date, or select a date from the drop down calendar, for the query. |
Close 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 Member Flag | Indicates whether or not the individual is a member (1) or non-member (0). |
Individual Sort Name | Lists the individual sort name. |
Individual Organization Name | Lists the individual organization name. |
PriAddress 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. |
membership Join Date | Lists the individual membership join date. |
membership Effective Date | Lists the individual membership effective date. |
membership Expire Date | Lists the individual membership expire date. |