Dynamics 365 Business Central: System tables, Virtual tables and Virtual tables (entities) in Dataverse

Dynamics 365 Business Central

The article discusses system tables, virtual tables in Business Central, and virtual tables in Dataverse, focusing on the differences between them.
System tables are created in the ID range of 2.000.000.000 and above, and virtual tables contain system information that cannot be changed but only read.
Virtual tables in Microsoft Dataverse, also known as virtual entities, integrate data from external systems without replication and custom coding.
Virtual tables in Microsoft Dataverse enable Create, Read, Update, and Delete operations from Dataverse against Dynamics 365 Business Central.
Virtual tables in Dataverse allow data to be sourced from an external database, such as Azure SQL Database, without residing in Dataverse.
There are a total of 175 tables in Business Central, with 117 being system tables and 58 being virtual tables in the W1 24.3 version.
The article also mentions the availability of virtual tables in Power Apps and provides a list of 78 virtual tables in Microsoft Dataverse.
The post aims to clarify the distinction between system tables and virtual tables and highlights the importance of understanding these concepts for efficient data management in Business Central and Dataverse.

Registered users can view the full text for FREE!