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
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 querySELECT
[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 querySELECT
[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 querySELECT
[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 querySELECT
[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 querySELECT
[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 |
Key to join to the User table.Show/hide example querySELECT
[Interaction Tmpl. Language].[$systemModifiedBy]
,[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].[$systemModifiedBy] = [User].[User Security ID] | |||||||