Segment Interaction Language

Dynamics 365 BC Table ReferenceTablesCompany TablesSSegment Interaction Language

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

Table Number: 5104

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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Segment No. SearchSegment No.NormalCode20Segment No_nvarchar(40)
Key to join to the Segment Header table.

Show/hide example query

SELECT
	       [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_]
2Segment Line No. Primary Key SearchSegment Line No.NormalInteger4Segment Line No_int
3Language Code Primary Key SearchLanguage CodeNormalCode10Language Codenvarchar(20)
Key to join to the Language table.

Show/hide example query

SELECT
	       [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]
4Description Primary Key SearchDescriptionNormalText100Descriptionnvarchar(200)
5Attachment No. SearchAttachment No.NormalInteger4Attachment No_int
Key to join to the Attachment table.

Show/hide example query

SELECT
	       [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_]
6Subject SearchSubjectNormalText100Subjectnvarchar(200)
7Word Template Code SearchWord Template CodeNormalCode30Word Template Codenvarchar(60)
Key to join to the Word Template table.

Show/hide example query

SELECT
	       [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 SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
	       [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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Segment Interaction Language table

Language
Dynamics 365 BC Table ReferenceTablesCompany TablesSSegment Interaction Language

Leave a Reply

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