A column corresponds to a specific attribute of an information object. Each column has its own strictly determined data type, which is supported and controlled by the platform.
Column attributes and properties
The column attributes determine their type, the table they 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 – the name of a column displayed in forms and lists.
- Name – the system name of a column used in the business logic. Column names follow set rules.
- Comments – 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 apply to them:
- Active – determines whether a column can be used.
- Read only – protects column values from accidental modification by users.
- Mandatory – denotes columns that must be filled to save a record.
- Full text search – denotes the columns the values of which are available for the global search.
- Display by ref – determines a column that represents the table records 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 mechanism in scripts and context processing.
Change Column Settings
In some exceptional cases you may need to change the type or the name of a column. Read this article to learn when it is possible and how to do it without disrupting the system.