Open topic with navigation

netFORUM Pro Modules > Reports and Queries > List of Baseline Queries > Subscription Queries > Outstanding Subscription Orders by Subscription Query
More information

Running a Query

Saving a Favorite Query

Available Data Elements Page

Working with Query Results

Outstanding Subscription Orders by Subscription Query

This query returns a list of subscribers with an outstanding or open subscription order.

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.
Product Code Contains Enter a product code 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.
Product Code Lists the subscriber subscription product code.
Product Name Lists the subscriber subscription product name.
SubTrx Total Amount Lists the subscriber subscription total amount.
SubCst Customer Type Lists the subscriber customer type.
SubCst Full Name Lists the subscriber full name.
SubCst Organization Name Lists the subscriber organization name.
SubOrd Order Number Lists the subscriber subscription associated order number.
SubOrd Order Status Lists the subscriber subscription associated order status.
SubOrd Billing Address Line 1, 2, 3, City, State, Postal Code, Country, Province Lists the subscriber invoice billing address.
CstPrimEml E-Mail Address Lists the subscriber primary email address.
Subscriber Expire Date Lists the subscriber subscription expire date.
Subscriber Renew Date Lists the subscriber subscription renew date.