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. |