Common Elements Used in This Topic

Field or Control	Description
Condition	This field is available for entry if you have two or more rows of criteria. Values are: AND: Select if you want the system to consider each of the selected criteria when narrowing the scope of the item data update. For example, suppose that you select account 212020 and alternate account 111000. The system updates only item data that has been assigned to account 212020 and alternate account 111000. OR: Select if you want the system to narrow the scope of the item data update by using any one of the selection criteria that you have selected. For example, suppose that you select account 212020 or alternate account 111000. The system updates item data that has been assigned to either account 212020 or alternate account 111000. Use a combination of AND and OR conditions to specify more complex selection criteria. For example, suppose that you select account 212020 or alternate account 111000 and primary buyer Atamian, Wes. The system updates item data that has been assigned to either account 212020 or alternate account 111000 and that has also been assigned to the primary buyer Atamian, Wes.
Field Name	The technical name of the field that is used as criteria. The fields that are available for selection depend on the record that is selected. The system provides any prompts that are associated with the field that you select.
Operator	Select to define the quantifier for the value that you enter in the Value field. Values are: <=: Less than or equal to the criteria. >=: Greater than or equal to the criteria. Equal: Equal to the criteria. Greater: Greater than the criteria. Less: Less than the criteria. Not Equal: Does not match the criteria. Like: Enables the use of wild cards in the Value field. The target item data must contain the criteria that are defined here. Valid wild cards depend on the database system. Not Like: Enables the use of wild cards in the Value field. The target item data must not contain the criteria that are defined here. Valid wild cards depend on the database system.
Value	The system narrows the update to item data based on this value, combined with the operator value and the field that is selected.
<View Values>	Click to access the Select Valid Value page, where you can view and select values for the selected field.