Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA Enterprise SCADA

Table field types

  • Last UpdatedApr 24, 2025
  • 1 minute read

There are several types of fields (columns) in a Table Edit dialog box. You can select criteria or edit the field according to the field type.

The field types are:

  • Primary key: This field contains an alphanumeric string and is marked by a primary key.

  • Foreign key: The field contains an alphanumeric string and is marked by a foreign key.

  • Alphanumeric string

  • Numeric

  • Checkbox

The table below summarizes the different ways of selecting or editing fields types.

Note: Matching criteria are used to filter, find and replace data. The data is displayed in the Data grid.

Field Type

Select Matching Criteria or Edit the Field

Foreign Key Field with Alphanumeric String

  • Open the Select dialog box, select a name and select Accept.

  • Type alphanumeric string - it is a whole string match.

  • Use Regular Expression - it is a partial string match.

Alphanumeric String

  • Type alphanumeric string - it is a whole string match.

  • Use Regular Expression - it is a partial string match.

Numeric Field

  • Type the number - it is a whole number match.

    Note: There is no partial number match.

Checkbox

  • Select the checkbox.

  • Clear the checkbox.