Activity Log – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables AActivity Log

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

Table Type: Company

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

Table Number: 710

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 Activity Log can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [ID]
   ,[Record ID]
   ,[Activity Date]
   ,[User ID]
   ,[Status]
   ,[Context]
   ,[Description]
   ,[Activity Message]
   ,[Detailed Info]
   ,[Table No Filter]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

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

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

Show/hide columns in Activity Log table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	ID	ID	Normal	Integer	4	ID	int
2	Record ID	Record ID	Normal	RecordID	448	Record ID	varbinary(448)
3	Activity Date	Activity Date	Normal	DateTime	8	Activity Date	datetime
4	User ID	User ID	Normal	Code	50	User ID	nvarchar(100)
5	Status	Status	Normal	Option	4	Status	int
	Available options are: “Success” “Failed”
6	Context	Context	Normal	Text	30	Context	nvarchar(60)
10	Description	Description	Normal	Text	250	Description	nvarchar(500)
20	Activity Message	Activity Message	Normal	Text	250	Activity Message	nvarchar(500)
21	Detailed Info	Detailed Info	Normal	BLOB	8	Detailed Info	image
22	Table No Filter	Table No Filter	Normal	Integer	4	Table No Filter	int
20100	AMC Bank WebLog Status	Status	Normal	Option	4
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 [Activity Log].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Activity Log$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Activity Log] LEFT JOIN [User] AS [User] ON [Activity Log].[$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 [Activity Log].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Activity Log$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Activity Log] LEFT JOIN [User] AS [User] ON [Activity Log].[$systemModifiedBy] = [User].[User Security ID]