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

VIEW SERVER STATE permission on SQL Server?

Hi all, Sometime While trying to Login into a database we face an error message as shown below. --------------------------- Microsoft Dynamics NAV Classic --------------------------- You cannot start Microsoft Dynamics NAV Classic because you do not have the VIEW SERVER STATE permission on SQL Server. Contact your system administrator. --------------------------- OK    ---------------------------

NAV 2013 R2 - Cumulative update 12 Released.

Hi all, Please find below the details of  Cumulative Update 12 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative Update 12 for Microsoft Dynamics NAV 2013 R2 Build No. - 38053 Release Date - October, 2014 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK, RU Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5.

Error After Restore SQL Backup of NAV 2013 Database

Hi all, we are facing a conman issue during restoring a SQL Database backup restored for NAV 2013. While Trying to run object from Object Designer we get below listed error (even the service is configured properly) - --------------------------- Microsoft Dynamics NAV Development Environment --------------------------- There are no NAV Server instances available for this database. You must ensure that a NAV Server instance is running and is configured to use the database before you perform this activity. --------------------------- OK    ---------------------------