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 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.