The file metadata table contains additional information (metadata) about values from computed columns in the file table. The file metadata table is created together with the default tables. It is also created or refreshed if the calculated fields are checked.

The name of the file metadata table is derived from the name of the file table and the "meta" attachment. For example, if the name of the file table is "deFile", the file metadata table is automatically called "deFileMeta".

An additional column _MetaIdVersion is added to the file table to refer to the metadata version for each file.

The file metadata table has the following columns:

_MetaIdVersion

The version to which the datasets in the file table refer. The current version is always the largest value of this column in the file metadata table.

_ColumnName

The column name in the file table to which this metadata set refers. This column name can be directly used in an SQL statement.

_FieldName

A readable version of the column name that you can display instead of the column name (_ColumnName).

_LogicalName

The name of the logic used to calculate the value of the column in the referenced column in the file table. The value in _LogicalName can be "NULL" (empty) if no logic but rather a simple expression was used for the calculation.

_Expression

The expression that was used to calculate the value in the column of the referring file table.

_Unit

The unit that was added to the logical expression used to calculate the value of the relevant column in the file table.

_Comment1 and _Comment2

Comments that have been added to the logic.