Data audit system fields are added to every table in Dynamics 365 Business Central – Update

Hi, Readers.
At the end of September, I once shared a blog about a new feature, Data audit system fields are added to every table in Dynamics 365 Business Central 2020 Release Wave 2. This time I want to update some key point. Hope this will help you.

Contents

Feature Summary
New Update

Feature Summary

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

This is a very useful feature for internal and external audit. Although it can be done with the Change Log feature before, as everyone knows, the Change Log feature will reduce performance and increase the database capacity. Therefore, in the NAV era that Microsoft did not provide this feature, I believe all partners have manually added this function if customers need.
For Example: Customer (18)
The fields has been successfully added to the table(?).

I confirmed the system table (Field 2000000041), and they has been added.

No.	FieldName	Type	Len	Class	Enabled	Type Name	Field Caption	RelationTableNo
2000000001	SystemCreatedAt	DateTime	8	Normal	Yes	DateTime	Created At	0
2000000002	SystemCreatedBy	GUID	16	Normal	Yes	GUID	Created By	2000000120
2000000003	SystemModifiedAt	DateTime	8	Normal	Yes	DateTime	Modified At	0
2000000004	SystemModifiedBy	GUID	16	Normal	Yes	GUID	Modified By	2000000120

New Update

In the previous test, I cannot customize these four fields in AL. Since these fields is stored in the Platform. But now, we can do it.
For example:
New Page:

New Report:

Page Extension:

Note: Although you can add them to the page or report, you cannot modify them because they does not exist in the actual table.

END

Hope this will help.

Thanks for your reading.

ZHU