Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5104
Table Type: Company
Table Name: Segment Interaction Language
Database Table Name: CRONUS UK Ltd_$Segment Interaction 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 Segment Interaction Language can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Segment Interaction Language$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[Segment No_]
,[Segment Line No_]
,[Language Code]
,[Description]
,[Attachment No_]
,[Subject]
,[Word Template Code]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Segment Interaction 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_$Segment Interaction Language$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Interaction Language]
LEFT JOIN
[CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
ON
[Segment Interaction Language].[Language Code] = [Language].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Word Template$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Word Template]
ON
[Segment Interaction Language].[Word Template Code] = [Word Template].[Code]
LEFT JOIN
[User] AS [User]
ON
[Segment Interaction Language].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Segment Interaction Language].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Segment Interaction Language table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Segment No.   | Segment No. | Normal | Code | 20 | Segment No_ | nvarchar(40) |
Key to join to the Segment Header table.Show/hide example querySELECT
[Segment Interaction Language].[Segment No_]
,[Segment Header].[No_]
FROM
[CRONUS UK Ltd_$Segment Interaction Language$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Interaction Language]
LEFT JOIN
[CRONUS UK Ltd_$Segment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Header]
ON
[Segment Interaction Language].[Segment No_] = [Segment Header].[No_] | |||||||
| 2 | Segment Line No. | Segment Line No. | Normal | Integer | 4 | Segment Line No_ | int |
| 3 | Language Code | Language Code | Normal | Code | 10 | Language Code | nvarchar(20) |
Key to join to the Language table.Show/hide example querySELECT
[Segment Interaction Language].[Language Code]
,[Language].[Code]
FROM
[CRONUS UK Ltd_$Segment Interaction Language$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Interaction Language]
LEFT JOIN
[CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
ON
[Segment Interaction Language].[Language Code] = [Language].[Code] | |||||||
| 4 | Description | Description | Normal | Text | 100 | Description | nvarchar(200) |
| 5 | Attachment No. | Attachment No. | Normal | Integer | 4 | Attachment No_ | int |
Key to join to the Attachment table.Show/hide example querySELECT
[Segment Interaction Language].[Attachment No_]
,[Attachment].[No_]
FROM
[CRONUS UK Ltd_$Segment Interaction Language$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Interaction Language]
LEFT JOIN
[CRONUS UK Ltd_$Attachment$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Attachment]
ON
[Segment Interaction Language].[Attachment No_] = [Attachment].[No_] | |||||||
| 6 | Subject | Subject | Normal | Text | 100 | Subject | nvarchar(200) |
| 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
[Segment Interaction Language].[Word Template Code]
,[Word Template].[Code]
FROM
[CRONUS UK Ltd_$Segment Interaction Language$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Interaction Language]
LEFT JOIN
[CRONUS UK Ltd_$Word Template$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Word Template]
ON
[Segment Interaction Language].[Word Template Code] = [Word Template].[Code] | |||||||
| 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
[Segment Interaction Language].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Segment Interaction Language$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Interaction Language]
LEFT JOIN
[User] AS [User]
ON
[Segment Interaction 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
[Segment Interaction Language].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Segment Interaction Language$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Interaction Language]
LEFT JOIN
[User] AS [User]
ON
[Segment Interaction Language].[$systemModifiedBy] = [User].[User Security ID] | |||||||