Data audit system fields are added to every table


This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

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)