Change Global Dim. Header

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

Table Type: Company

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

Table Number: 484

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [Primary Key]
   ,[Old Global Dimension 1 Code]
   ,[Old Global Dimension 2 Code]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Parallel Processing]
   ,[Change Type 1]
   ,[Change Type 2]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Change Global Dim_ Header$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_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Change Global Dim. Header]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Change Global Dim. Header].[Old Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Change Global Dim. Header].[Old Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Change Global Dim. Header].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Change Global Dim. Header].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Change Global Dim. Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Change Global Dim. Header].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Change Global Dim. Header table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary Key Primary Key SearchPrimary KeyNormalCode10Primary Keynvarchar(20)
2Old Global Dimension 1 Code SearchOld Global Dimension 1 CodeNormalCode20Old Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Change Global Dim. Header].[Old Global Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Change Global Dim_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Change Global Dim. Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Change Global Dim. Header].[Old Global Dimension 1 Code] = [Dimension].[Code]
3Old Global Dimension 2 Code SearchOld Global Dimension 2 CodeNormalCode20Old Global Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Change Global Dim. Header].[Old Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Change Global Dim_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Change Global Dim. Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Change Global Dim. Header].[Old Global Dimension 2 Code] = [Dimension].[Code]
4Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Change Global Dim. Header].[Global Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Change Global Dim_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Change Global Dim. Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Change Global Dim. Header].[Global Dimension 1 Code] = [Dimension].[Code]
5Global Dimension 2 Code SearchGlobal Dimension 2 CodeNormalCode20Global Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Change Global Dim. Header].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Change Global Dim_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Change Global Dim. Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Change Global Dim. Header].[Global Dimension 2 Code] = [Dimension].[Code]
6Parallel Processing SearchParallel ProcessingNormalBoolean4Parallel Processingtinyint
7Change Type 1 SearchChange Type 1NormalOption4Change Type 1int
Available options are:
  • “None”
  • “Blank”
  • “Replace”
  • “New”
8Change Type 2 SearchChange Type 2NormalOption4Change Type 2int
Available options are:
  • “None”
  • “Blank”
  • “Replace”
  • “New”
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. Header].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Change Global Dim_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Change Global Dim. Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Change Global Dim. Header].[$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. Header].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Change Global Dim_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Change Global Dim. Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Change Global Dim. Header].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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