Merchandise Purchased by Individuals Query

This query returns a list of merchandise purchased by individuals.

Query Parameters

Parameter Description
Product Name Contains Enter a product name for the query.
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.

Query (Default) Fields

Field Description
Query Header Displays the query name, number of records returned, and the total number of pages for the query.
Add User Lists the user name of the user who added the merchandise purchase transaction.
Add Date Lists the date the merchandise transaction was added to the system.
MepTrx Type Lists the merchandise purchase transaction type.
MepTrx Amount Lists the merchandise purchase transaction amount.
MepTrx Quantity Lists the merchandise purchase transaction quantity.
MepTrx Total Amount Lists the merchandise purchase transaction total amount.
Product Code Lists the merchandise purchase product code.
Product Name Lists the merchandise purchase product name.
Full Name Lists the customer full name.
Organization Name Lists the customer organization name.
ID Lists the customer ID
Order Number Lists the merchandise purchase order number.
E-Mail Address Lists the customer email address.
PriPhone Phone Number, Extension Lists the customer primary phone number and extension.