Country_Region Translation

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

Table Type: Company

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

Table Number: 11

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Country_Region Code]
   ,[Language Code]
   ,[Name]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Country_Region 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_$Country_Region Translation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region Translation]
LEFT JOIN
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Country_Region Translation].[Country_Region Code] = [Country_Region].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Country_Region Translation].[Language Code] = [Language].[Code]

Show/hide columns in Country_Region Translation table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Country_Region Code Primary Key Searchnvarchar(20)
Key to join to the Country_Region table.

Show/hide example query

SELECT
       [Country_Region Translation].[Country_Region Code]
       ,[Country_Region].[Code]
FROM
       [CRONUS UK Ltd_$Country_Region Translation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region Translation]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
              ON
                     [Country_Region Translation].[Country_Region Code] = [Country_Region].[Code]
3Language Code Primary Key Searchnvarchar(20)
Key to join to the Language table.

Show/hide example query

SELECT
       [Country_Region Translation].[Language Code]
       ,[Language].[Code]
FROM
       [CRONUS UK Ltd_$Country_Region Translation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region Translation]
LEFT JOIN
       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
              ON
                     [Country_Region Translation].[Language Code] = [Language].[Code]
4Name Searchnvarchar(100)
5$systemId Searchuniqueidentifier
6$systemCreatedAt Searchdatetime
7$systemCreatedBy Searchuniqueidentifier
8$systemModifiedAt Searchdatetime
9$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Country_Region Translation table

Leave a Reply

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