Show/Hide All
This field displays the name of the column, and can only be viewed.
This field displays the data type (Number or String) of the data field, and can only be viewed.
Select the logical operator (And or Or) to be used in conjunction with the prior selection field. This field is not available for the first selection field selected for editing.
Select the type of relation to be used to evaluate the value in the data field for record selection.
The following relation options are available.
Select Equal (=) for the selection field to have a value equal to the value specified.
Select Not Equal (<>) for the selection field to have a value not equal to the value specified.
Select Less Than (<) for the selection field to have a value less than the value specified.
Select Greater Than (>) for the selection field to have a value greater than the value specified.
Select Less Than or Equal (<=) for the selection field to have a value less than or equal to the value specified.
Select Greater Than or Equal (>=) for the selection field to have a value greater than or equal to the value specified.
Select Range for the selection field to have a value within the starting and ending values specified.
Select List for the selection field to be equal to one of the values specified in a list.
The List relation is available only for non-numeric data items (string, phone, zero filled, etc.).
When importing from the Sales Order Detail table, you can exclude Sales Order comment records (ItemType=4) from the import by selecting Not Equal (<>) in this field and then entering 4 at the Selection Value field.
This field determines whether case should be significant when using the equal (=) relation to compare a data item. Clear this check box to ignore case when comparing values. For example, when this check box is cleared and the selection value is CA, data items with CA, ca, Ca, and cA will all be selected. When on, only CA will be selected. This field is available only for Equal (=) relations.
Select this check box to evaluate only a portion of a non-numeric item. You must type the starting character position and the length to evaluate.
Type the starting position of the portion of a non-numeric data item to be evaluated. This field is available only if the Substring check box is selected.
Type the length of the portion of a non-numeric data item to be evaluated. This field is available only if the Substring check box is selected.
This field displays the maximum length of the field, as defined in the data dictionary, and can only be viewed.
Type the value that will be used to compare against the data item. This field appears only if an option other than Range, List, or Mask is selected in the Relation field.
Type the starting value of a range of values to be compared against the data item. This field appears only if Range is selected in the Relation field.
Type the ending value of a range of values to be compared against the data item. This field appears only if Range is selected in the Relation field.
Type the prompt to be displayed to enter the selection value at run time. This field is available only if the User Input check box is selected.
Select this check box to allow the entry of the selection value at the time of exporting. Clear this check box if you do not want to enter a the selection value at the time of exporting.
Enter a list of values to match the records to be exported. A record will be selected for importing if the data item in the record contains a value matching one of the listed values. This field appears only if List is selected in the Relation field.
