Use this screen to create a selective list of items that can be easily imported into the modules to facilitate inquiries. The part ID is copied to the clipboard when you select copy, or click anywhere on a selected row. Using the Edit-Paste function (if available for that module) or the Control V command, you can paste the part can into an application. You can minimize this Item Query function and run it within the module (using the Alt-Tab keys), allowing you to select a new item or criteria.
Use this drop-down box to select the field you wish to use as a selection criterion.
Use this drop-down box to define a relationship between the selected Field and the Value.
Enter the value to which you want to limit your search. The Value field is used with the Field and Relation fields to define the rows to be selected from the database.
Select this checkbox if you want the search to be case sensitive.
After you have filled in the Field, Relation, and Value fields, select this pushbutton. Your value statement will appear in the Current field. You can add another value statement by changing the Field, Relation, and Value fields and selecting this pushbutton again. Use the Combine Method group box to determine how statements are handled by the query.
Select this radio button when both value statements in the Current field must be true for selection to take place.
Select this radio button when either statement in the Current field may be true for a record to be selected.
This field displays the statements as you create them. The highlighted row shows the statement that will be modified if the Replace pushbutton is selected, or removed if the Delete pushbutton is selected.
Select this pushbutton to add a new statement to the Current field.
Select this pushbutton to modify the highlighted statement in the Current field.
Select this pushbutton to delete the highlighted statement in the Current field.
Use the drop-down box to choose a field by which to sort.
Select this radio button to sort the rows in ascending order.
Select this radio button to sort the rows in descending order.
Select the Count pushbutton to view how many database rows satisfy the current selection criteria.
Select the OK pushbutton to accept the selection criteria. The Subquery screen will close and the Part Query screen will appear, populated with the data from the Subquery selection.
Select this pushbutton to cancel the Subquery screen and return to the Part Query screen.
This column displays the item ID of the selected item(s).
If you selected the Allow Multiple Revisions for Each Item checkbox in the Product Definition Corporate Settings subtask of the Product Definition Settings screen, this column displays the item revision levels of the selected item(s).
This column displays the description of the selected item(s).
This column displays the item type of the selected item(s): Part, Goods, or Services.
This column displays the unit of measure of the selected item(s).
This column displays the commodity code associated with the selected item(s).
This column displays the product class associated with the selected item(s).
This column displays the product type associated with the selected item(s).
This column displays the buyer ID associated with the selected item(s).
This column displays the name associated with the buyer ID.
This column displays the lead time days associated with the selected item(s).
This optional field displays the Uniform Product Code (UPC) for the item. You can assign this value to the item in the Additional Item Codes subtask of the screen in which the item was established.
This optional field displays the industry classification code along with its description for the part, good, or service. You set up industry classification codes in the Industry Classifications screen, and assign them to the item in the Additional Item Codes subtask of the screen in which the item was established.
The information that displays in this screen is stored in the following tables: BUYER, EMPL, ITEM, PROD_CLASSIF.