Use this inquiry function to create a selective list of parts that can be easily imported into the modules to facilitate inquiries.
When you click the Copy pushbutton or click your mouse on a selected row, the part ID is copied to the clipboard. Use the Edit-Paste menu function or the Control V command to paste the part into an application. This Part Query function can be minimized and imported into the module currently active (using the Alt-Tab keys), allowing you to select a new part or criteria if required.
When you first call up the Part Query screen, a Subquery screen displays. In this Subquery screen you can select the criteria required to view part information.
Use this drop-down box to select the field that you would like to use as a selection criterion, such as "Item," "Product Class," or "Planning Type."
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. Costpoint uses the entry in the Value field with those for 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.
Use the options in this 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 your selection criteria statements as you create them. You can add statements by clicking the Add pushbutton. The highlighted row displays the statement that will be modified if you click the Replace pushbutton, or removed if you click the Delete pushbutton.
Click this pushbutton to add a new statement to the Current field.
Click this pushbutton to modify the highlighted statement in the Current field.
Click this pushbutton to delete the highlighted statement in the Current field.
Use the options in this group box to select the method for sorting the rows of data. In the drop-down box, choose a field on which to sort, either by Item or Item Description.
Click this radio button to sort the rows in ascending order.
Click this radio button to sort the rows in descending order.
Click the Count pushbutton to view how many database rows satisfy the current selection criteria.
Click 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.
Click this pushbutton to cancel the Subquery screen and return to the Part Query screen.
This field 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 field displays the item revision levels of the selected part(s).
This field displays the description of the selected part(s).
This field displays the unit of measure of the selected part(s).
This field displays the commodity code associated with the selected part(s).
This field displays the product class associated with the selected part(s).
This field displays the product type associated with the selected part(s).
This field displays the ID of the buyer associated with the selected part(s).
This field displays the name associated with the buyer ID.
This field displays "Y" (Yes) or "N" (No) depending on whether or not QC acceptance/inspection is required.
This field displays "Y" (Yes) or "N" (No) depending on whether or not a certificate of conformance is required.
This field displays "Y" (Yes) or "N" (No) depending on whether or not a source inspection is required.
This field displays "Y" (Yes) or "N" (No) depending on whether or not the part is designated as, or contains, hazardous material.
This field displays the inspection type associated with the selected part(s).
This field displays the lead time days associated with the selected part(s).
This field displays the national stock number assigned to the selected part(s).
This field displays the military specification identification assigned to the selected part(s).
This field displays the name of the planner associated with the selected part(s).
This field displays the planning type assigned to the selected part(s).
This field displays the order policy type associated with the selected part(s).
This field displays the ABC code assigned to the selected part(s).
This field displays the status type assigned to the selected part(s) from the Basic Part Data screen in Costpoint Product Definition.
This field displays the part type assigned to the selected part(s) from the Basic Part Data screen in Costpoint Product Definition.
This field displays the "M" (Make)/"B" (Buy) status of the selected part(s).
This field displays "Y" (Yes) or "N" (No) depending on whether or not a bill of material exists for the selected part(s).
This field displays the BOM status of the selected part(s).
This optional field displays the Uniform Product Code (UPC) for the part. You can assign this value to the part in the Additional Item Codes subtask of the Maintain Parts and Basic Part Data screens in Costpoint Product Definition.
This optional field displays the industry classification code along with its description for the part. You set up industry classification codes in the Industry Classifications screen in Costpoint Product Definition, and assign them to the part in the Additional Item Codes subtask of the Maintain Parts and Basic Part Data screens, also in Costpoint Product Definition.