PowerObjects Blog 

for Microsoft Business Applications


Table Properties in Business Central

Post Author: Vinita Kumari Mishra |

In this blog post, we will be addressing some of the Table properties in Microsoft Business Central. Prerequisites for this post are VS Code, AL Language Extension, and Business Central.

Properties:

CharAllowed

  1. It sets which characters are allowed in the field.
  2. This property can be applied to Table and Page fields.
  3. CharAllowed 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

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.

DataCaptionFields

  1. Sets fields defined on the top-left position of the Card page.
  2. It can be applied in Tables.
  3. Syntax: DataCaptionFields = Field1, Field2, Field3;
  4. In below example, we used No, Name and Type fields for Caption.
Definition
Result

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, we 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!

Joe CRM
By Joe D365
Joe D365 is a Microsoft Dynamics 365 superhero who runs on pure Dynamics adrenaline. As the face of PowerObjects, Joe D365’s mission is to reveal innovative ways to use Dynamics 365 and bring the application to more businesses and organizations around the world.

Leave a Reply

Your email address will not be published. Required fields are marked *

PowerObjects Recommends