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
   [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 an example select of all columns including those from all joined tables

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

Show/hide columns in Change Global Dim. Log Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Table ID Primary Key SearchTable IDNormalInteger4Table IDint
Key to join to the Data Exch. Mapping table.

Show/hide example query

SELECT
       [Change Global Dim. Log Entry].[Table ID]
       ,[Data Exch. Mapping].[Table ID]
FROM
       [CRONUS UK Ltd_$Change Global Dim_ Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Change Global Dim. Log Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Data Exch_ Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Mapping]
              ON
                     [Change Global Dim. Log Entry].[Table ID] = [Data Exch. Mapping].[Table ID]
2Table Name SearchTable NameNormalText50Table Namenvarchar(100)
3Total Records SearchTotal RecordsNormalInteger4Total Recordsint
4Completed Records SearchCompleted RecordsNormalInteger4Completed Recordsint
5Progress SearchProgressNormalDecimal12Progressdecimal(38,38)
6Status SearchStatusNormalOption4Statusint
Available options are:
  • ” “
  • “Scheduled”
  • “In Progress”
  • “Completed”
  • “Incomplete”
7Task ID SearchTask IDNormalGUID16Task IDuniqueidentifier
8Session ID SearchSession IDNormalInteger4Session IDint
9Change Type 1 SearchChange Type 1NormalOption4Change Type 1int
Available options are:
  • “None”
  • “Blank”
  • “Replace”
  • “New”
10Change Type 2 SearchChange Type 2NormalOption4Change Type 2int
Available options are:
  • “None”
  • “Blank”
  • “Replace”
  • “New”
11Global Dim.1 Field No. SearchGlobal Dim.1 Field No.NormalInteger4Global Dim_1 Field No_int
12Global Dim.2 Field No. SearchGlobal Dim.2 Field No.NormalInteger4Global Dim_2 Field No_int
13Dim. Set ID Field No. SearchDim. Set ID Field No.NormalInteger4Dim_ Set ID Field No_int
14Primary Key Field No. SearchPrimary Key Field No.NormalInteger4Primary Key Field No_int
15Parent Table ID SearchParent Table IDNormalInteger4Parent Table IDint
16Is Parent Table SearchIs Parent TableNormalBoolean4Is Parent Tabletinyint
17Earliest Start Date/Time SearchEarliest Start Date/TimeNormalDateTime8Earliest Start Date_Timedatetime
18Remaining Duration SearchRemaining DurationNormalDuration8Remaining Durationbigint
19Server Instance ID SearchServer Instance IDNormalInteger4Server Instance IDint
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Change Global Dim. Log Entry].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Change Global Dim_ Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Change Global Dim. Log Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Change Global Dim. Log Entry].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Change Global Dim. Log Entry].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Change Global Dim_ Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Change Global Dim. Log Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Change Global Dim. Log Entry].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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