Change Global Dim_ Log Entry

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

Table Type: Company

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

Table Number: 483

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 Global Dim_ Log Entry can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Change Global Dim_ Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Table ID]
   ,[Table Name]
   ,[Total Records]
   ,[Completed Records]
   ,[Progress]
   ,[Status]
   ,[Task ID]
   ,[Session ID]
   ,[Change Type 1]
   ,[Change Type 2]
   ,[Global Dim_1 Field No_]
   ,[Global Dim_2 Field No_]
   ,[Dim_ Set ID Field No_]
   ,[Primary Key Field No_]
   ,[Parent Table ID]
   ,[Is Parent Table]
   ,[Earliest Start Date_Time]
   ,[Remaining Duration]
   ,[Server Instance ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Change Global Dim_ Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Change Global Dim_ Log Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Table ID Primary Key Searchint
3Table Name Searchnvarchar(100)
4Total Records Searchint
5Completed Records Searchint
6Progress Searchdecimal(38,38)
7Status Searchint
8Task ID Searchuniqueidentifier
9Session ID Searchint
10Change Type 1 Searchint
11Change Type 2 Searchint
12Global Dim_1 Field No_ Searchint
13Global Dim_2 Field No_ Searchint
14Dim_ Set ID Field No_ Searchint
15Primary Key Field No_ Searchint
16Parent Table ID Searchint
17Is Parent Table Searchtinyint
18Earliest Start Date_Time Searchdatetime
19Remaining Duration Searchbigint
20Server Instance ID Searchint
21$systemId Searchuniqueidentifier
22$systemCreatedAt Searchdatetime
23$systemCreatedBy Searchuniqueidentifier
24$systemModifiedAt Searchdatetime
25$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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