Use this screen to create a selective list of parts that can be easily imported into other modules to facilitate inquiries. When you select the Copy function on the toolbar or click anywhere on a selected row, the part ID is copied to the clipboard. You can use the Edit-Paste function (if available for that module) or the Control V command to paste the part into an application. This Part Query screen can be minimized and imported into the present module (using the Alt-Tab keys), allowing you to select a new part or criteria if required.
Use this drop-down box to select the field you want 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. This value is used with the Field and Relation fields to define the rows to be selected from the database.
Select this checkbox if you want your query to be case sensitive.
After you have filled in the Field, Relation, and Value fields, select this pushbutton. Your value statement will display 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 radio buttons in 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 value statement in the Current field can 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 you select the Replace pushbutton, or removed if you select the Delete pushbutton.
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 this drop-down box to select a field by which to sort.
Select this radio button to sort in ascending order.
Select this radio button to sort in descending order.
Select the Count pushbutton to view how many database rows satisfy the current selection criteria.
This column displays the item ID of the selected part(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 in Costpoint Product Definition, this column displays the item revision levels of the selected part(s).
This column displays the description of the selected part(s).
This column displays the unit of measure of the selected part(s).
The commodity code associated with the selected part(s) is displayed in this column.
The product class associated with the selected part(s) is displayed in this column.
This column displays the product type associated with the selected part(s).
The buyer ID associated with the selected part(s) is displayed in this column.
The name associated with the buyer ID is displayed in this column.
This column displays "Y" (Yes) or "N" (No) to indicate if QC acceptance/inspection is required.
This column displays "Y" (Yes) or "N" (No) to indicate if a certificate of conformance is required.
This column displays "Y" (Yes) or "N" (No) to indicate if source inspection is required.
This column displays "Y" (Yes) or "N" (No) to indicate if the part is designated as, or contains, hazardous material.
This column displays the inspection type associated with the selected part(s).
This column displays the lead time days associated with the selected part(s).
The national stock number assigned to the selected part(s) is displayed in this column.
The military specification identification assigned to the selected part(s) is displayed in this column.
This column displays the planner associated with the selected part(s).
This column displays the planning type assigned to the selected part(s).
This column displays the order policy type associated with the selected part(s).
The ABC code assigned to the selected part(s) is displayed in this column.
This column displays the status type assigned to the selected part(s) in the Basic Part Data screen in Costpoint Product Definition.
This column displays the part type assigned to the selected part(s) in the Basic Part Data screen in Costpoint Product Definition.
This field displays the "M" (Make)/"B" (Buy) status of the selected part(s).
This column displays "Y" (Yes) or "N" (No) to indicate if a bill of material exists for the selected part(s).
This column displays the BOM status of the selected part(s).
This field displays the Uniform Product Code (UPC) for the item. This is an optional field whose value is assigned to the item in the Additional Item Codes subtask in the screen in which the item was established.
This field displays the industry classification code along with its description for the part, good or service. Industry classification codes are originally set up in the Industry Classifications screen, and assigned to the item in the Additional Item Codes subtask in the screen in which the item was established.
The information that displays in this screen is stored in the following tables: BUYER, EMPL, ITEM, PART, PROD_CLASSIF, S_ORD_POLICY_TYPE, S_PART_TYPE, S and STATUS_TYPE.