top of page
  • Writer's picturemaique00

4 new fields to All Tables

All Dynamics Business Central community (Business Owners, Project Managers, Solution Architects, Functional Consultants, Business Analysts, CAL/AL Developers, BI Developers and End Users) get used to it!

If for some reason, some of these persons needs to go deep to analyse some data in BC database, they expect to see some System fields table to help to audit them.

Amazing news from MSFT to be released next month (October 2020) in Dynamics 365 2020 Release wave 2.


New feature

Four new system fields are added to all tables:

  • SystemLastModifiedOn

  • SystemLastModifiedBy

  • SystemCreatedBy

  • SystemCreatedOn

The platform will populate the content of the fields when a record is created and modified. It isn't possible for a developer to control the values that are saved to the database.


Business value

This gives developers an easy and performant way to program against historical data, such as writing AL queries that return changed data since some specified point in time.



Let me remind you that you read: All the tables :):)

338 views0 comments
bottom of page