Data audit system fields are added to every table

Enabled for Public preview General availability
Admins, makers, marketers, or analysts, automatically - Oct 1, 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.

See also

Data Audit Fields (docs)