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
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 ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Table ID  | int |
| 3 | Table Name | nvarchar(100) |
| 4 | Total Records | int |
| 5 | Completed Records | int |
| 6 | Progress | decimal(38,38) |
| 7 | Status | int |
| 8 | Task ID | uniqueidentifier |
| 9 | Session ID | int |
| 10 | Change Type 1 | int |
| 11 | Change Type 2 | int |
| 12 | Global Dim_1 Field No_ | int |
| 13 | Global Dim_2 Field No_ | int |
| 14 | Dim_ Set ID Field No_ | int |
| 15 | Primary Key Field No_ | int |
| 16 | Parent Table ID | int |
| 17 | Is Parent Table | tinyint |
| 18 | Earliest Start Date_Time | datetime |
| 19 | Remaining Duration | bigint |
| 20 | Server Instance ID | int |
| 21 | $systemId | uniqueidentifier |
| 22 | $systemCreatedAt | datetime |
| 23 | $systemCreatedBy | uniqueidentifier |
| 24 | $systemModifiedAt | datetime |
| 25 | $systemModifiedBy | uniqueidentifier |