Data audit system fields are added to every table

Important

Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned

Enabled for Public preview General availability
Admins, makers, or analysts, automatically - Oct 2020

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.

Feature details

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.