ITEM INQUIRY

Use this inquiry to view information on parts, goods, or services in the database. Enter the item ID and revision (if multiple revisions are allowed) to view both item information and project item information on the screen. 

Search Criteria

Use this group box to enter the search criteria for the item.

Item

Enter, or use Lookup to select, an item ID and description for which information is required. 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, you can retrieve multiple revisions of the same item. If you did not select the checkbox, you can retrieve only the last revision of the item.

Rev

Enter, or use Lookup to select, the revision of the item.

U/M

This field displays the unit of measure associated with the item.

Make/Buy

This field displays whether the item is "M" (Make) or "B" (Buy).

Type

This field displays the item type: part, good, or service.

Commodity

This field displays the commodity code associated with this item.

Status

This field displays the status of the item, "Active" or "Inactive."

Product Class

This field displays the product class associated with this item.

Buyer

This field displays the buyer ID for this item.

Planner

This field displays the planner assigned to this item.

NSN

This field displays the national stock number, if applicable.

Mil-Sp

This field displays the military specification number, if applicable.

Item ID/Description Selection Criteria

Use the selections in this group box to choose items in the inquiry:

Exact Match

Select this radio button to find an exact match of the item and revision entered.

Begin With

Select this radio button to find all items and revisions that begin with the data entered.

End With

Select this radio button to find all items and revisions that end with the data entered.

Contain In

Select this radio button to find all items and revisions that contain the data entered.

Table Window

Item

This column displays item ID for the selected items from the search.

Item Rev

This column displays the revision of the item.

Item Description

This column displays the description of the item.

Item Type

This column displays the item type: part, good, or service.

U/M

This column displays unit of measure of this item.

Make/Buy

This column displays whether the item is an "M" (Make) or "B" (Buy) item.

Commodity

This column displays commodity code associated with the item.

Product Class

This column displays the product class associated with the item.

Buyer

This column displays the buyer ID associated with the item.

Planner

This column displays the planner assigned to the default commodity or overridden in the Planning Part Data screen in Costpoint Product Definition for this item.

Active

This column displays "Y" (Yes) or "N" (No) to indicate whether the item is active.

NSN

This field displays the national stock number, if applicable.

Mil-Spec

This field displays the military specification number, if applicable.

UPC

This field displays the item's uniform product code, if applicable.

Industry Class

This column displays the item's industry class code, if applicable.

Std Text

Select this pushbutton to access the Item Standard Text subtask for the item selected.

Vendors

Select this pushbutton to access the Vendors subtask for the item selected.

Item Cost

Select this pushbutton to access the Item Cost subtask for the item selected.

Item Billing

Select this pushbutton to access the Item Billing subtask for the item selected.

Alternate Parts

Select this pushbutton to access the Alternate Parts subtask for the item selected.

Substitute Parts

Select this pushbutton to access the Substitute Parts subtask for the item selected.

Projects

Select this pushbutton to access the Projects subtask for the item selected.

Project Item Cost

Select this pushbutton to access the Project Item Cost subtask for the item selected.

ECN Parts

Select this pushbutton to open the ECN Parts subtask.

Documents

Select this pushbutton to open the Documents subtask.