ITEM INQUIRY

Use this screen to view information on parts, goods, or services in the database. You can enter the item ID and revision (if multiple revisions are allowed) to view both item information and project item information on the screen. You cannot use this inquiry to view information for provisional parts.

Use this screen to information about an item or range of items.

Search Criteria

Item

Enter, or use Lookup to select, an item ID for which information is required. The item description is displayed and cannot be changed.

Rev

Enter, or use Lookup to select, the revision of the item. If you selected the Allow Multiple Revisions For Each Item checkbox in the Product Definition Corporate Settings subtask of the Product Definition Settings screen, you can retrieve multiple revisions of the same item. If you did not select the Allow Multiple Revisions For Each Item checkbox, you can retrieve only the last revision of the item.

U/M

This field displays the unit of measure if an Item ID and Rev is entered.

Make/Buy

Use this drop-down box to select either make or buy items. If this is left blank, both are selected.

Type

Use this drop-down box to select the item type (parts, goods, or services) or leave blank for all.

Status

Use this drop-down box to select active or inactive items. If this field is left blank, both active and inactive items will be retrieved.

Buyer

Use this drop-down box to select a specific buyer ID on which to search.

Commodity

Enter, or use Lookup to select, a specific commodity code for which to search. The description of the commodity code selected will be displayed.

Product Class

Enter, or use Lookup to select, a specific product class. A product classification is a detailed grouping of items within a product type. The product class description will also be displayed.

Planner

Enter, or use Lookup to select, a planner on which to search.

NSN

Enter the national stock number of the selected item, if applicable.

Mil-Sp

Enter the military specification number of the selected item, if applicable.

Item ID/Description Selection Criteria

Exact Match

Select this radio button to find an exact match of the value entered.

Begin With

Select this radio button to find all items that begin with the value entered.

End With

Select this radio button to find all items that end with the value entered.

Contain In

Select this radio button to find all items containing the value entered.

Table Window

Item

This column displays the 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, i.e., whether it is a part, good, or service.

U/M

This column displays the 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 the 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 for this item.

Active

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

NSN

This field displays the national stock number for the selected item.

Mil-Spec

This field displays the military specification number for the selected item.

UPC

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.

Industry Class

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.

Std Text

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

Vendors

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

Item Cost

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

Item Billing

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

Alternate Parts

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

Substitute Parts

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

Projects

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

Project Item Cost

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

ECN Parts

Select this pushbutton to open the ECN Parts subtask for the selected part.

Documents

Select this pushbutton to open the Documents subtask for the selected part.

Table Information

The information that displays in this screen is stored in the following tables: ALT_PART, BUYER, COMM, CUST, ECN, ECN_PART, EMPL, ITEM, ITEM_CST, ITEM_PRODUCT, ITEM_PROJ_CST, ITEM_TEXT, ITEM_VEND, MANUF, PART, PART_PROJ, PRICE_CATLG, PROD_CLASSIF, PROD_CST_SCH, PROD_PRICE_CATLG, PROD_PRICE_SCH, PROD_WARR_CST_SCH, PROJ, PROJ_SUBST_PART, S_WHERE_USED, STD_TEXT, SUBST_PART, TEXT_WHERE_USED, VEND, WARRANTY.