Table Properties in Business Central

Introduction:
In this blog, I will be addressing some of the Table properties in Microsoft Business Central.


Pre-requisites:

  1. VS Code
  2. AL Language Extension
  3. Microsoft Dynamics NAV /  Business Central

Properties:

1. CharAllowed

  1. It sets which characters are allowed in the field.
  2. This property can be applied to Table and Page fields.
  3. Charalowed takes parameters in a combination of two characters as shown below, where characters “1 to 4 “, “7 to 9” and “a to d” are allowed.
  4. An example of this property is given below.
Definition
Error

2. DataPerCompany

  1. It sets whether the table data applies to all companies in the database or only the current company.
  2. The default value for this property is true.
  3. This property can only be applied to Tables.
  4. The User table is an example where Datapercompany is false.
3. DataCaptionFields
  1. Sets fields defined on the Top Left Position of the Card page.
  2. It can be applied in Table.
  3. Syntax: DataCaptionfields= Field1,Field2,Field3;
  4. In below example, I have used No, Name and Type fields for Caption.
Definition
Result

4. Enabled

  1. Sets a value that indicates whether a field is enabled or disabled.
  2. It can be applied to Page fields, Table fields, and Actions.
  3. In the below example, I have set Enabled Property to True on Name field, therefore Name is field is visible to users but it is not editable and it is displayed Gray in color making it less highlighted than other fields.
Enable = False

 

Hope this helps!


Share Story :