Table Field
Virtual table that provides metadata information about all fields in all tables within the database. This table enables introspection of field definitions, properties, and characteristics across the entire data model.
Remarks
The Field table is a critical metadata source for data model analysis, field discovery, and schema inspection. It contains detailed information about field types, relationships, data classification, and various field properties. This table is extensively used by development tools, data migration utilities, configuration management, and customization frameworks that need to understand the structure and constraints of table fields. The information includes both base application fields and those added by extensions.
Properties
| Name | Value |
|---|---|
| Scope | Cloud |
| InherentPermissions | rX |
Fields
| Name | Type | Description |
|---|---|---|
| TableNo | Integer | The table number that contains this field. |
| "No." | Integer | The unique field number within the table. |
| TableName | Text[30] | The name of the table that contains this field. |
| FieldName | Text[30] | The name of the field as defined in the AL source code. |
| Type | Option | The data type of the field (Text, Integer, Boolean, etc.). |
| Len | Integer | The length or size constraint for text and code fields. |
| Class | Option | The field class indicating whether it's a normal field, FlowField, or FlowFilter. |
| Enabled | Boolean | Indicates whether the field is currently enabled and accessible. |
| "Type Name" | Text[30] | The type name for complex field types such as enums or custom types. |
| ExternalName | Text[100] | The external name used when the field is exposed to external systems or APIs. |
| "Field Caption" | Text[80] | The caption text displayed for this field in the user interface. |
| RelationTableNo | Integer | The table number of the related table when this field has a table relation. |
| RelationFieldNo | Integer | The field number in the related table when this field has a table relation. |
| SQLDataType | Option | The SQL data type used for this field in the underlying database. |
| OptionString | Text[2047] | The option string containing all possible values for option fields. |
| ObsoleteState | Option | The obsolete state indicating whether the field is obsolete, pending removal, or removed. |
| ObsoleteReason | Text[248] | The reason provided when the field was marked as obsolete. |
| DataClassification | Option | The data classification category for privacy and compliance purposes. |
| IsPartOfPrimaryKey | Boolean | Indicates whether this field is part of the table's primary key. |
| "App Package ID" | Guid | The package identifier of the application that contains this field. |
| "App Runtime Package ID" | Guid | The runtime package identifier used by the platform for application management. |
| OptimizeForTextSearch | Boolean | Indicates whether the field is optimized for text search operations. |
| Access | Option | The access level of the field (Public, Internal, Protected, or Local). |
| IsAllowedInCustomizations | Boolean | Indicates whether the field can be modified through customization features. |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemRowVersion | BigInteger |