Skip to main content

Table Objects - #albacktobasics.

Hi Readers,

This year I am starting to talk about basics again.

We all understand that basics are important while working on solution for our customers.

In this article we will talk about one of the key object type in Business Central i.e. Tables.

Tables are the core objects used to store data in Dynamics 365 Business Central. 

As of today, each object in business central need to have a unique number.

Snippet support
Typing the shortcut ttable will create the basic layout for a table object when using the AL Language extension in Visual Studio Code.

The structure of a table has four sections:

Section 1 - The first block contains metadata for the overall table, such as the table type and other table properties.

Section 2 - The fields section describes the data elements that make up the table, such as their name and the type of data they can store.

Section 3 - The keys section contains the definitions of the keys that the table needs to support.

Section 4 - The final section details the triggers and code that can run on the table.


Additionally, each table in business central have System fields -

The Dynamics 365 Business Central platform will automatically add several system fields to tables. As of today Microsoft will add following system fields in every table - 
  • 2000000000 - SystemId
  • 2000000001 - SystemCreatedAt
  • 2000000002 - SystemCreatedBy
  • 2000000003 - SystemModifiedAt
  • 2000000004 - SystemModifiedBy

In the next article of #albacktobasics we will talk about Section 1, table metadata. 

If you have any other basic stuff that you would like to discuss please let me know and I will try to write an article on this.

Let me know your views as comment to this article.

Regards,
Saurav Dhyani

sauravdhyani.com
#albacktobasics

Comments

Popular posts from this blog

Send Mail with Attachment From Navision.

Hi all, We have seen how to save a report into PDF and how to send mail to a customer. Let's link these two post in one i.e. Mailing statement to a customer into PDF Format. This article is part of the Series. Please Refer  Table of Content here . If you have the old objects set let me brief you what I will be changing - 

Microsoft Dynamics NAV 2016 - How to Configure Phone Client.

Hi All, In this article we will discuss how we can connect Microsoft Dynamics NAV 2016 with New Client Launched i.e. Phone Client. This Article Contain Steps for a Android Phone as I have Only Android Phone. I am doing it having all tiers on my windows 8 machine, steps remain same for multiple servers but issues might be different. What we Need (Other what we discuss in this article) -  The Service Tier should be on Public IP . Some of the Data-card does not Provide you Public IP. check it for sure.

Download Microsoft Dynamics Business Central on Premises 2020 Wave 2 Release.

 Hi Readers, As Expected Microsoft have released #msdyn365bc 2020 wave 2 is available.  This article provides details of the new release. The 2020 release wave 2 for Business Central delivers a wealth of new features. Read What's new in 2020 Release Wave 2 here .  Dynamics NAV Customers upgrading to Business Central on Prem will be able to run business central on premises, move to cloud or choose a hybrid approach.