Dimension Translation

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

Table Type: Company

Table Name: Dimension Translation
Database Table Name: CRONUS UK Ltd_$Dimension Translation$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 388

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Dimension Translation$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [Code]
   ,[Language ID]
   ,[Name]
   ,[Code Caption]
   ,[Filter Caption]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Dimension Translation$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Dimension Translation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Translation]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Dimension Translation].[Language ID] = [Language].[Windows Language ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Dimension Translation].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Dimension Translation].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Dimension Translation table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code Primary Key SearchCodeNormalCode20Codenvarchar(40)
2Language ID Primary Key SearchLanguage IDNormalInteger4Language IDint
Key to join to the Language table.

Show/hide example query

SELECT
       [Dimension Translation].[Language ID]
       ,[Language].[Windows Language ID]
FROM
       [CRONUS UK Ltd_$Dimension Translation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Translation]
LEFT JOIN
       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
              ON
                     [Dimension Translation].[Language ID] = [Language].[Windows Language ID]
3Name SearchNameNormalText30Namenvarchar(60)
4Code Caption SearchCode CaptionNormalText80Code Captionnvarchar(160)
5Filter Caption SearchFilter CaptionNormalText80Filter Captionnvarchar(160)
6Language Name SearchLanguage NameFlowFieldText80
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
       [Dimension Translation].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Dimension Translation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Translation]
LEFT JOIN
       [User] AS [User]
              ON
                     [Dimension Translation].[$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
       [Dimension Translation].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Dimension Translation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Translation]
LEFT JOIN
       [User] AS [User]
              ON
                     [Dimension Translation].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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