Item Attr. Value Translation

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

Table Type: Company

Table Name: Item Attr. Value Translation
Database Table Name: CRONUS UK Ltd_$Item Attr_ Value Translation$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 7503

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 Item Attr. Value Translation can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

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

Show/hide columns in Item Attr. Value Translation table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Attribute ID Primary Key SearchAttribute IDNormalInteger4Attribute IDint
Key to join to the Item Attribute table.

Show/hide example query

SELECT
       [Item Attr. Value Translation].[Attribute ID]
       ,[Item Attribute].[ID]
FROM
       [CRONUS UK Ltd_$Item Attr_ Value Translation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Attr. Value Translation]
LEFT JOIN
       [CRONUS UK Ltd_$Item Attribute$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Attribute]
              ON
                     [Item Attr. Value Translation].[Attribute ID] = [Item Attribute].[ID]
2ID Primary Key SearchIDNormalInteger4IDint
4Language Code Primary Key SearchLanguage CodeNormalCode10Language Codenvarchar(20)
Key to join to the Language table.

Show/hide example query

SELECT
       [Item Attr. Value Translation].[Language Code]
       ,[Language].[Code]
FROM
       [CRONUS UK Ltd_$Item Attr_ Value Translation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Attr. Value Translation]
LEFT JOIN
       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
              ON
                     [Item Attr. Value Translation].[Language Code] = [Language].[Code]
5Name SearchNameNormalText250Namenvarchar(500)
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
       [Item Attr. Value Translation].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Item Attr_ Value Translation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Attr. Value Translation]
LEFT JOIN
       [User] AS [User]
              ON
                     [Item Attr. Value 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
       [Item Attr. Value Translation].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Item Attr_ Value Translation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Attr. Value Translation]
LEFT JOIN
       [User] AS [User]
              ON
                     [Item Attr. Value Translation].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Item Attr. Value Translation table

Leave a Reply

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