Show/Hide All
This field displays the column name, 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 in the Selection Value field.
Select this check box if case is significant when using the equal (=) relation to compare a data item. Clear this check box to ignore case when comparing values. This field is available only for Equal (=) relations.
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 the check box is selected, only CA will be selected.
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 in the Start Pos and Length fields.
Type the starting position of the portion of a non-numeric data item to evaluate. 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 evaluate. 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 compare against the data item. This field is available only if Range is selected in the Relation field.
Type the ending value of a range of values to compare against the data item. This field appears only if Range is selected in the Relation field.
Type the prompt to display 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 importing. Clear this check box if you do not want to allow the entry of the selection value.
Enter a list of values to match the records to import. A record is selected for importing if the data item in the record contains a value matching one of the listed values.
