Skip to main content
Version: 1.20.1

Columns in Data Structure

A column corresponds to a specific attribute of an information object. Each column has its own strictly determined data type that is supported and controlled by the platform.

Column Attributes and Properties​

The column attributes determine their type, the table that the columns belong to, and others:

  • Table – determines the table to which the column belongs.
  • Column type – determines the type of stored data and functional purpose of a column.
  • Title – determines the name of a column displayed in forms and lists.
  • Name – determines the system name of a column used in the business logic. The column name is set according to the following rules.
  • Comments – provides a column description or other information that could be useful to system administrators or solution developers.

The column properties determine their behavior and limitations that are applied to them:

  • Active – determines whether a column can be used.
  • Read only – protects column values from modification by users with limited access.
  • Mandatory – denotes columns that must be filled in to save a record.
  • Full text search – denotes the columns whose values are available for the global search.
  • Display by ref – determines a column whose values are used as the display values in the Reference fields.
  • Unique – ensures that each column value in a table is unique.

Dot-walking in Scripts​

Learn about using the dot-walking functionality in scripts and context processing.

Change Column Settings​

Find out when you can change the type or system name of a column and how to do it without breaking the system processes.