Navigation:  Engineering > Part Number Search >

Additional Criteria

Training Manuals Alphabetical Function List Back Print this Topic Previous topicOne level upNext topic
Show/Hide Hidden Text

On this tab the following fields can be viewed:

 

hmtoggle_plus1Approved Item Name

It is populated with distinct approved item names from the Standard Item Master table.

 

The number of characters to be entered before the list is shown is governed by the value of "populate length" (optional).

 

Standard item numbers will be displayed from the Standard Item Master table using the "Approved Item Name" selected.

 

If "Beginning With" is checked, standard item numbers will be selected from the Standard Item Master table where the approved item name begins with the selected approved item name.

hmtoggle_plus1Beginning With

In addition to the existing search options on the Part Master Criteria tab this option can be selected to search for part numbers on the part master table that begins with the specified characters.

 

When the 'Search' button is applied the part numbers beginning with the specified characters and the selected options on the Part Master Criteria, Additional Criteria and Search Results tabs will be displayed in the 'Parts' list box on the Search Results tab.

hmtoggle_plus1Clear All

When the "Clear All" button is clicked, all the Characteristics/Characteristic Value fields will be cleared.

hmtoggle_plus1Characteristic Value Line 4

The value entered in this field will be used together with the chosen "Comparison Operator" to select standard item numbers or part numbers from the Characteristic Link table.

 

If "Equal To", "Greater Than", "Greater Than or Equal To", "Less Than", "Less Than or Equal To", "Like", "Not Equal To", or "Not Like" is selected, a characteristic value can be entered (enabled).

 

If "Exists" or "Not Exists" is selected, a characteristic value cannot be entered (disabled).

 

If the Characteristic selected in line 4 has a field type of:

 

Integer, a value of only 7 integer digits can be entered,Decimal, a value of 7 digits before and 5 digits after the Decimal point can be entered,Text, a maximum of 255 characters can be entered, or Date, only a date may be selected from the Calendar.

 

All values entered must comply with the limitations (field types and values) set on the "Characteristics" function.

hmtoggle_plus1Characteristic Value Line 3

The value entered in this field will be used together with the chosen "Comparison Operator" to select standard item numbers or part numbers from the Characteristic Link table.

 

If "Equal To", "Greater Than", "Greater Than or Equal To", "Less Than", "Less Than or Equal To", "Like", "Not Equal To", or "Not Like" is selected, a characteristic value can be entered (enabled).

 

If "Exists" or "Not Exists" is selected, a characteristic value cannot be entered (disabled).

 

If the Characteristic selected in line 3 has a field type of:

 

Integer, a value of only 7 integer digits can be entered, Decimal, a value of 7 digits before and 5 digits after the Decimal point can be entered, Text, a maximum of 255 characters can be entered, or Date, only a date may be selected from the Calendar.

 

All values entered must comply with the limitations (field types and values) set on the "Characteristics" function.

hmtoggle_plus1Characteristic Value Line 2

The value entered in this field will be used together with the chosen "Comparison Operator" to select standard item numbers or part numbers from the Characteristic Link table.

 

If "Equal To", "Greater Than", "Greater Than or Equal To", "Less Than", "Less Than or Equal To", "Like", "Not Equal To", or "Not Like" is selected, a characteristic value can be entered (enabled).

 

If "Exists" or "Not Exists" is selected, a characteristic value cannot be entered (disabled).

 

If the Characteristic selected in line 2 has a field type of:

 

Integer, a value of only 7 integer digits can be entered, Decimal, a value of 7 digits before and 5 digits after the Decimal point can be entered, Text, a maximum of 255 characters can be entered, or Date, only a date may be selected from the Calendar.

 

All values entered must comply with the limitations (field types and values) set on the "Characteristics" function.

hmtoggle_plus1Characteristic Value Line 1

It is populated with the column description field and the column values field from the Column Values table where the column name is equal to "Part Number Search Logical".

 

The number of characters to be entered before the list is shown is governed by the value of "populate length" (optional).

 

It can have a value of either "And" or "Or".  If selected, the characteristic and comparison operator combo boxes, on line 2 can be entered (enabled).

hmtoggle_plus1Characteristic Line 4

It is populated with the description from the Characteristics table and the characteristic from the Characteristic Link table.

 

The number of characters to be entered before the list is shown is governed by the value of "populate length" (optional).

 

Standard item numbers or part numbers will be selected from the Characteristic Link table for the characteristic selected.

 

It can only be selected (enabled) if a "Logical Operator" is selected at the end of line 3.

hmtoggle_plus1Characteristic Line 3

It is populated with the description from the Characteristics table and the characteristic from the Characteristic Link table.

 

The number of characters to be entered before the list is shown is governed by the value of "populate length" (optional).

 

Standard item numbers or part numbers will be selected from the Characteristic Link table for the characteristic selected.

 

It can only be selected (enabled) if a "Logical Operator" is selected at the end of line 2.

hmtoggle_plus1Characteristic Line 2

It is populated with the description from the Characteristics table and the characteristic from the Characteristic Link table.

 

The number of characters to be entered before the list is shown is governed by the value of "populate length" (optional).

 

Standard item numbers or part numbers will be selected from the Characteristic Link table for the characteristic selected.

 

It can only be selected (enabled) if a "Logical Operator" is selected at the end of line 1.

hmtoggle_plus1Characteristic Line 1

It is populated with the description from the Characteristics table and the characteristic from the Characteristic Link table.

 

The number of characters to be entered before the list is shown is governed by the value of "populate length" (optional).

 

Standard item numbers or part numbers will be selected from the Characteristic Link table for the characteristic selected.

hmtoggle_plus1Comparison Operator Line 4

It is populated with the column description field and the column values field from the Column Values table where the column name field has a value of "Part Number Search Comparison".

 

The number of characters to be entered before the list is shown is governed by the value of "populate length" (optional).

 

If "Equal To", "Greater Than", "Greater Than or Equal To", "Less Than", "Less Than or Equal To", "Like", "Not Equal To", or "Not Like" is selected, a characteristic value can be entered (enabled).

 

If "Exists" or "Not Exists" is selected, a characteristic value cannot be entered (disabled).

hmtoggle_plus1Comparison Operator Line 3

is populated with the column description field and the column values field from the Column Values table where the column name field has a value of "Part Number Search Comparison".

 

The number of characters to be entered before the list is shown is governed by the value of "populate length" (optional).

 

If "Equal To", "Greater Than", "Greater Than or Equal To", "Less Than", "Less Than or Equal To", "Like", "Not Equal To", or "Not Like" is selected, a characteristic value can be entered (enabled).

 

If "Exists" or "Not Exists" is selected, a characteristic value cannot be entered (disabled).

hmtoggle_plus1Comparison Operator Line 2

It is populated with the column description field and the column values field from the Column Values table where the column name field has a value of "Part Number Search Comparison".

 

The number of characters to be entered before the list is shown is governed by the value of "populate length" (optional).

 

If "Equal To", "Greater Than", "Greater Than or Equal To", "Less Than", "Less Than or Equal To", "Like", "Not Equal To", or "Not Like" is selected, a characteristic value can be entered (enabled).

 

If "Exists" or "Not Exists" is selected, a characteristic value cannot be entered (disabled).

hmtoggle_plus1Comparison Operator Line 1

It is populated with the column description field and the column values field from the Column Values table where the column name field has a value of "Part Number Search Comparison".

 

The number of characters to be entered before the list is shown is governed by the value of "populate length" (optional).

 

If "Equal To", "Greater Than", "Greater Than or Equal To", "Less Than", "Less Than or Equal To", "Like", "Not Equal To", or "Not Like" is selected, a characteristic value can be entered (enabled).

 

If "Exists" or "Not Exists" is selected, a characteristic value cannot be entered (disabled).

hmtoggle_plus1Equal To

When this combo box is opened then Part Numbers with there descriptions will be populated from the Part Master table.

 

This option is only used in conjunction with the Catalogue Part Numbers, Stock and or the Allocation frames. When selected all the options on the Part Master Criteria and Additional Criteria tabs will be disabled.

 

When the 'Search' button is applied the part will be displayed in the 'Parts' list box on the Search Results tab according to the options selected in the Catalogue Part Numbers and or the Stockframes.

 

Business Rules:

If this option is selected then an existing part number on the part master table have to be selected meaning that a Part Number equal to spaces will not be allowed to search on.

hmtoggle_plus1Item Name Code

It is populated with distinct item name codes from the Standard Item Master table.

 

The number of characters to be entered before the list is shown is governed by the value of "populate length" (optional).

 

Standard item numbers will be displayed from the Standard Item Master table using the item name Code selected.

 

If "Beginning With" is checked standard item numbers will be selected from the Standard Item Master table where the item name code begins with the selected Item Name Code.

hmtoggle_plus1Logical Operator Line 3

It is populated with the column description field and the column values field from the Column Values table where the column name is equal to "Part Number Search Logical".

 

The number of characters to be entered before the list is shown is governed by the value of "populate length" (optional).

 

It can have a value of either "And" or "Or".  If selected, the characteristic and comparison operator combo boxes, on line 4 can be entered (enabled).

hmtoggle_plus1Logical Operator Line 2

It is populated with the column description field and the column values field from the Column Values table where the column name is equal to "Part Number Search Logical".

 

The number of characters to be entered before the list is shown is governed by the value of "populate length" (optional).

 

It can have a value of either "And" or "Or".  If selected, the characteristic and comparison operator combo boxes, on line 3 can be entered (enabled).

hmtoggle_plus1Logical Operator Line 1

It is populated with the column description field and the column values field from the Column Values table where the column name is equal to "Part Number Search Logical".

 

The number of characters to be entered before the list is shown is governed by the value of "populate length" (optional).

 

It can have a value of either "And" or "Or".  If selected, the characteristic and comparison operator combo boxes, on line 2 can be entered (enabled).

hmtoggle_plus1Spec Code

It is populated with distinct spec codes from the Standard Item Master table where the code matches the code the user entered.

 

The number of characters to be entered before the list is shown is governed by the value of "populate length" (optional).

 

Standard item numbers will be displayed from the Standard Item Master table using the selected spec code.

 

If "Beginning With" is checked, standard item numbers will be selected from the Standard Item Master table where the spec code begins with the selected spec code.

hmtoggle_plus1With Part Number Like

These options enable the user to either search for a part number by specifying a limited amount of characters or the complete Part Number.