Table, Table Fields, and Table extension properties

This article lists properties that apply to the table object, table fields, and table extension object.

Object properties

The following properties all apply to the Table object, only some of these properties can be set for a Table extension object as specified below. This list is sorted alphabetically by property name. For Table properties sorted by method on a Table, see Properties.

Property name Extensible Applies to
Access property -Codeunit
-Query
-Table
-Table field
-Enum Type
-Interface
-Permission Set
AccessByPermission property -Table field
-Page Field
-Page Part
-Page System Part
-Page Chart Part
-Page Action
-Page Custom Action
-Page File Upload Action
-Page
-Report
AllowInCustomizations property -Table field
AutoFormatExpression property -Table field
-Page Field
-Report Column
AutoFormatType property -Table field
-Page Field
-Report Column
AutoIncrement property -Table field
AutoReplace property -Xml Port Table Element
AutoSave property -Xml Port Table Element
AutoUpdate property -Xml Port Table Element
BlankNumbers property -Table field
-Page Field
BlankZero property True -Table field
-Page Field
CalcFields property -Xml Port Table Element
-Report Data Item
CalcFormula property -Table field
Caption property True -Table
-Table field
-Page Field
-Field Group
-Page
-Request Page
-Page Label
-Page Group
-Page Part
-Page System Part
-Page Action
-Page Action Separator
-Page Action Group
-Xml Port
-Report
-Query
-Query Column
-Query Filter
-Report Column
-Enum Value
-Page Custom Action
-Page System Action
-Page File Upload Action
-Page View
-Report Layout
-Profile
-Enum Type
-Permission Set
CaptionClass property True -Table field
-Page Label
-Page Field
CaptionML property True -Table
-Table field
-Page Field
-Field Group
-Page
-Request Page
-Page Label
-Page Group
-Page Part
-Page System Part
-Page Action
-Page Action Separator
-Page Action Group
-Xml Port
-Report
-Query
-Query Column
-Query Filter
-Report Column
-Enum Value
-Page Custom Action
-Page System Action
-Page File Upload Action
-Page View
-Report Layout
-Profile
-Enum Type
-Permission Set
CharAllowed property -Table field
-Page Field
ClosingDates property True -Table field
-Page Field
Clustered property -Table key
ColumnStoreIndex property -Table
Compressed property -Table field
CompressionType property -Table
DataCaptionFields property True -Table
-Page
-Request Page
DataPerCompany property -Table
DateFormula property -Table field
-Page Field
DecimalPlaces property -Table field
-Page Field
-Report Column
Description property True -Codeunit
-Table field
-Table key
-Page
-Page Action
-Page Action Area
-Page Action Group
-Page Area
-Page Field
-Page Group
-Page Label
-Page Part
-Page System Part
-Page Chart Part
-Query
-Query Column
-Query Data Item
-Query Filter
-Report
-Report Data Item
-Report Column
-Request Page
-Table
-Xml Port
-Xml Port Text Element
-Xml Port Field Element
-Xml Port Table Element
-Xml Port Field Attribute
-Xml Port Text Attribute
-Profile
DrillDownPageId property True -Table
-Page Field
Editable property -Table field
-Page
-Request Page
-Page Label
-Page Field
-Page Group
-Page System Part
-Page Chart Part
-Page Part
Enabled property -Table field
-Table key
-Page Label
-Page Field
-Page Group
-Page Part
-Page System Part
-Page Chart Part
-Page Action
-Page Action Group
-Page Custom Action
-Page System Action
-Page File Upload Action
-Profile
ExtendedDatatype property -Table field
-Page Field
Extensible property -Report
-Enum Type
-Table
-Page
ExternalAccess property -Table field
ExternalName property -Table
-Table field
ExternalSchema property -Table
ExternalType property -Table field
FieldClass property -Table field
IncludedFields property -Table key
InherentEntitlements property -Query
-Report
-Xml Port
-Table
-Codeunit
-Page
InherentPermissions property -Query
-Report
-Xml Port
-Table
-Codeunit
-Page
InitValue property -Table field
LinkedInTransaction property -Table
LinkedObject property -Table
LinkFields property -Xml Port Table Element
LinkTable property -Xml Port Table Element
LinkTableForceInsert property -Xml Port Table Element
LookupPageId property True -Table
-Page Field
MaintainSiftIndex property -Table key
MaintainSqlIndex property -Table key
MaxOccurs property -Xml Port Text Element
-Xml Port Table Element
-Xml Port Field Element
MaxValue property -Table field
-Page Field
MinOccurs property -Xml Port Text Element
-Xml Port Field Element
-Xml Port Table Element
MinValue property -Table field
-Page Field
MovedFrom property -Table
-Table field
MovedTo property -Table
-Table field
NamespacePrefix property -Xml Port Text Element
-Xml Port Field Element
-Xml Port Table Element
-Xml Port Field Attribute
-Xml Port Text Attribute
NotBlank property -Table field
-Page Field
Numeric property -Table field
-Page Field
ObsoleteReason property -Page Action Ref
-Page Custom Action
-Page File Upload Action
-Table
-Table field
-Table key
-Codeunit
-Enum Type
-Enum Value
-Page Action
-Page Action Group
-Page Action Separator
-Page Part
-Page System Part
-Page Chart Part
-Page Group
-Page Label
-Query
-Query Column
-Query Filter
-Report
-Report Data Item
-Report Column
-Request Page
-Xml Port
-Page Field
-Page Action Area
-Page Area
-Page
-Page View
-Profile
-Interface
-Control Add In
-Permission Set
-Field Group
ObsoleteState property -Page Action Ref
-Page Custom Action
-Page File Upload Action
-Table
-Table field
-Table key
-Codeunit
-Enum Type
-Enum Value
-Page Action
-Page Action Group
-Page Action Separator
-Page Part
-Page System Part
-Page Chart Part
-Page Group
-Page Label
-Query
-Query Column
-Query Filter
-Report
-Report Data Item
-Report Column
-Request Page
-Xml Port
-Page Field
-Page Action Area
-Page Area
-Page
-Page View
-Profile
-Interface
-Control Add In
-Permission Set
-Field Group
ObsoleteTag property -Page Action Ref
-Page Custom Action
-Page File Upload Action
-Table
-Table field
-Table key
-Codeunit
-Enum Type
-Enum Value
-Page Action
-Page Action Group
-Page Action Separator
-Page Part
-Page System Part
-Page Chart Part
-Page Group
-Page Label
-Query
-Query Column
-Query Filter
-Report
-Report Data Item
-Report Column
-Request Page
-Xml Port
-Page Field
-Page Action Area
-Page Area
-Page
-Page View
-Profile
-Interface
-Control Add In
-Permission Set
-Field Group
OptimizeForTextSearch property -Table field
OptionCaption property True -Table field
-Page Field
-Report Column
OptionCaptionML property True -Table field
-Page Field
-Report Column
OptionOrdinalValues property -Table field
PasteIsValid property -Table
Permissions property -Codeunit
-Table
-Request Page
-Page
-Xml Port
-Report
-Query
-Permission Set
-Permission Set Extension
ReplicateData property -Table
RequestFilterFields property -Xml Port Table Element
-Report Data Item
RequestFilterHeading property -Xml Port Table Element
-Report Data Item
RequestFilterHeadingML property -Xml Port Table Element
-Report Data Item
SignDisplacement property -Table field
-Page Field
SqlDataType property -Table field
SqlIndex property -Table key
SqlTimestamp property -Table field
SumIndexFields property -Table key
TableRelation property True -Table field
-Page Field
TableType property -Table
TestTableRelation property -Table field
ToolTip property True -Page Label
-Page Field
-Page Part
-Page System Part
-Page Chart Part
-Page Action Area
-Page Action
-Page Action Group
-Page Custom Action
-Page System Action
-Page File Upload Action
-Query Column
-Table field
ToolTipML property True -Page Label
-Page Field
-Page Part
-Page System Part
-Page Chart Part
-Page Action Area
-Page Action
-Page Action Group
-Page Custom Action
-Page System Action
-Page File Upload Action
-Query Column
-Table field
Unbound property -Xml Port Text Element
-Xml Port Field Element
-Xml Port Table Element
-Xml Port Field Attribute
-Xml Port Text Attribute
Unique property -Table key
ValidateTableRelation property -Table field
ValuesAllowed property -Table field
-Page Field
XmlName property -Xml Port Text Element
-Xml Port Field Element
-Xml Port Table Element
-Xml Port Field Attribute
-Xml Port Text Attribute

Getting started with AL
Developing extensions