Change 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: 0

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
   [timestamp]
   ,[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]
   ,[Changed Record SystemId]
   ,[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 columns in Change Log Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchbigint
3Date and Time Searchdatetime
4Time Searchdatetime
5User ID Searchnvarchar(100)
6Table No_ Searchint
7Field No_ Searchint
8Type of Change Searchint
9Old Value Searchnvarchar(4096)
10New Value Searchnvarchar(4096)
11Primary Key Searchnvarchar(500)
12Primary Key Field 1 No_ Searchint
13Primary Key Field 1 Value Searchnvarchar(100)
14Primary Key Field 2 No_ Searchint
15Primary Key Field 2 Value Searchnvarchar(100)
16Primary Key Field 3 No_ Searchint
17Primary Key Field 3 Value Searchnvarchar(100)
18Record ID Searchvarbinary(448)
19Protected Searchtinyint
20Changed Record SystemId Searchuniqueidentifier
21Notification Status Searchint
22Field Log Entry Feature Searchint
23Notification Message Id Searchuniqueidentifier
24$systemId Searchuniqueidentifier
25$systemCreatedAt Searchdatetime
26$systemCreatedBy Searchuniqueidentifier
27$systemModifiedAt Searchdatetime
28$systemModifiedBy Searchuniqueidentifier

Leave a Reply

Your email address will not be published. Required fields are marked *