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 |