Interaction Tmpl. Language – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables IInteraction Tmpl. Language

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

Table Type: Company

Table Name: Interaction Tmpl. Language
Database Table Name: CRONUS UK Ltd_$Interaction Tmpl_ Language$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5103

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 Interaction Tmpl. Language can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Interaction Tmpl_ Language$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Interaction Template Code]
   ,[Language Code]
   ,[Description]
   ,[Attachment No_]
   ,[Custom Layout Code]
   ,[Word Template Code]
   ,[Report Layout Name]
   ,[Report Layout AppID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Interaction Tmpl_ Language$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

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

Show/hide columns in Interaction Tmpl. Language table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Interaction Template Code	Interaction Template Code	Normal	Code	10	Interaction Template Code	nvarchar(20)
	Key to join to the Interaction Template table. Show/hide example query SELECT [Interaction Tmpl. Language].[Interaction Template Code] ,[Interaction Template].[Code] FROM [CRONUS UK Ltd_$Interaction Tmpl_ Language$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Tmpl. Language] LEFT JOIN [CRONUS UK Ltd_$Interaction Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Template] ON [Interaction Tmpl. Language].[Interaction Template Code] = [Interaction Template].[Code]
2	Language Code	Language Code	Normal	Code	10	Language Code	nvarchar(20)
	Key to join to the Language table. Show/hide example query SELECT [Interaction Tmpl. Language].[Language Code] ,[Language].[Code] FROM [CRONUS UK Ltd_$Interaction Tmpl_ Language$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Tmpl. Language] LEFT JOIN [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language] ON [Interaction Tmpl. Language].[Language Code] = [Language].[Code]
3	Description	Description	Normal	Text	100	Description	nvarchar(200)
4	Attachment No.	Attachment No.	Normal	Integer	4	Attachment No_	int
	Key to join to the Attachment table. Show/hide example query SELECT [Interaction Tmpl. Language].[Attachment No_] ,[Attachment].[No_] FROM [CRONUS UK Ltd_$Interaction Tmpl_ Language$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Tmpl. Language] LEFT JOIN [CRONUS UK Ltd_$Attachment$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Attachment] ON [Interaction Tmpl. Language].[Attachment No_] = [Attachment].[No_]
5	Custom Layout Code	Custom Layout Code	Normal	Code	20	Custom Layout Code	nvarchar(40)
6	Custom Layout Description	Custom Layout Description	FlowField	Text	250
7	Word Template Code	Word Template Code	Normal	Code	30	Word Template Code	nvarchar(60)
	Key to join to the Word Template table. Show/hide example query SELECT [Interaction Tmpl. Language].[Word Template Code] ,[Word Template].[Code] FROM [CRONUS UK Ltd_$Interaction Tmpl_ Language$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Tmpl. Language] LEFT JOIN [CRONUS UK Ltd_$Word Template$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Word Template] ON [Interaction Tmpl. Language].[Word Template Code] = [Word Template].[Code]
8	Report Layout Name	Report Layout Name	Normal	Text	250	Report Layout Name	nvarchar(500)
9	Report Layout AppID	Email Body Layout AppID	Normal	GUID	16	Report Layout AppID	uniqueidentifier
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Interaction Tmpl. Language].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Interaction Tmpl_ Language$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Tmpl. Language] LEFT JOIN [User] AS [User] ON [Interaction Tmpl. Language].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Interaction Tmpl. Language table

Language

Dynamics 365 BC Table Reference Tables Company Tables IInteraction Tmpl. Language

Leave a Reply Cancel reply