Change Log Entry – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CChange Log Entry

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/405

Table Type: Company

Table Name: Change Log Entry
Database Table Name: CRONUS UK Ltd_$Change Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 405

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Change Log Entry can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Change Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Entry No_]
   ,[Date and Time]
   ,[Time]
   ,[User ID]
   ,[Table No_]
   ,[Field No_]
   ,[Type of Change]
   ,[Old Value]
   ,[New Value]
   ,[Primary Key]
   ,[Primary Key Field 1 No_]
   ,[Primary Key Field 1 Value]
   ,[Primary Key Field 2 No_]
   ,[Primary Key Field 2 Value]
   ,[Primary Key Field 3 No_]
   ,[Primary Key Field 3 Value]
   ,[Record ID]
   ,[Protected]
   ,[Notification Status]
   ,[Field Log Entry Feature]
   ,[Notification Message Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Change Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Change Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Change Log Entry]
LEFT JOIN
   [User] AS [User]
      ON
         [Change Log Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Change Log Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Change Log Entry table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Entry No.	Entry No.	Normal	BigInteger	8	Entry No_	bigint
2	Date and Time	Date and Time	Normal	DateTime	8	Date and Time	datetime
3	Time	Time	Normal	Time	4	Time	datetime
4	User ID	User ID	Normal	Code	50	User ID	nvarchar(100)
5	Table No.	Table No.	Normal	Integer	4	Table No_	int
6	Table Caption	Table Caption	FlowField	Text	250
7	Field No.	Field No.	Normal	Integer	4	Field No_	int
8	Field Caption	Field Caption	FlowField	Text	80
9	Type of Change	Type of Change	Normal	Option	4	Type of Change	int
	Available options are: “Insertion” “Modification” “Deletion”
10	Old Value	Old Value	Normal	Text	2048	Old Value	nvarchar(4096)
11	New Value	New Value	Normal	Text	2048	New Value	nvarchar(4096)
12	Primary Key	Primary Key	Normal	Text	250	Primary Key	nvarchar(500)
13	Primary Key Field 1 No.	Primary Key Field 1 No.	Normal	Integer	4	Primary Key Field 1 No_	int
14	Primary Key Field 1 Caption	Primary Key Field 1 Caption	FlowField	Text	80
15	Primary Key Field 1 Value	Primary Key Field 1 Value	Normal	Text	50	Primary Key Field 1 Value	nvarchar(100)
16	Primary Key Field 2 No.	Primary Key Field 2 No.	Normal	Integer	4	Primary Key Field 2 No_	int
17	Primary Key Field 2 Caption	Primary Key Field 2 Caption	FlowField	Text	80
18	Primary Key Field 2 Value	Primary Key Field 2 Value	Normal	Text	50	Primary Key Field 2 Value	nvarchar(100)
19	Primary Key Field 3 No.	Primary Key Field 3 No.	Normal	Integer	4	Primary Key Field 3 No_	int
20	Primary Key Field 3 Caption	Primary Key Field 3 Caption	FlowField	Text	80
21	Primary Key Field 3 Value	Primary Key Field 3 Value	Normal	Text	50	Primary Key Field 3 Value	nvarchar(100)
22	Record ID	Record ID	Normal	RecordID	448	Record ID	varbinary(448)
25	Protected	Protected	Normal	Boolean	4	Protected	tinyint
26	Changed Record SystemId	Changed Record SystemId	Normal	GUID	16
27	Notification Status	Notification status	Normal	Option	4	Notification Status	int
	Available options are: “Turned Off” “Email Sent” “Sending Email Failed” “Email Enqueued”
28	Field Log Entry Feature	Field Log Entry Feature	Normal	Option	4	Field Log Entry Feature	int
	Available options are: “Change Log” “Monitor Sensitive Fields” “All”
29	Notification Message Id	Notification Message Id	Normal	GUID	16	Notification Message Id	uniqueidentifier
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Change Log Entry].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Change Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Change Log Entry] LEFT JOIN [User] AS [User] ON [Change Log Entry].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Change Log Entry].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Change Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Change Log Entry] LEFT JOIN [User] AS [User] ON [Change Log Entry].[$systemModifiedBy] = [User].[User Security ID]