Segment Header

Dynamics 365 BC Table ReferenceTablesCompany TablesSSegment Header

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

Table Type: Company

Table Name: Segment Header
Database Table Name: CRONUS UK Ltd_$Segment Header$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5076

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 Header can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Segment Header$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [No_]
   ,[Description]
   ,[Campaign No_]
   ,[Salesperson Code]
   ,[Correspondence Type (Default)]
   ,[Interaction Template Code]
   ,[Unit Cost (LCY)]
   ,[Unit Duration (Min_)]
   ,[Date]
   ,[Campaign Target]
   ,[Information Flow]
   ,[Initiated By]
   ,[No_ Series]
   ,[Campaign Response]
   ,[Language Code (Default)]
   ,[Interaction Group Code]
   ,[Send Word Docs_ as Attmt_]
   ,[Ignore Contact Corres_ Type]
   ,[Subject (Default)]
   ,[Word Template Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Segment Header$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 Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Header]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Segment Header].[Salesperson Code] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Interaction Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Template]
      ON
         [Segment Header].[Interaction Template Code] = [Interaction Template].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Segment Header].[Language Code (Default)] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Interaction Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Group]
      ON
         [Segment Header].[Interaction Group Code] = [Interaction Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Word Template$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Word Template]
      ON
         [Segment Header].[Word Template Code] = [Word Template].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Segment Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Segment Header].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Segment Header table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. SearchNo.NormalCode20No_nvarchar(40)
2Description Primary Key SearchDescriptionNormalText100Descriptionnvarchar(200)
3Campaign No. SearchCampaign No.NormalCode20Campaign No_nvarchar(40)
Key to join to the Campaign table.

Show/hide example query

SELECT
	       [Segment Header].[Campaign No_]
	       ,[Campaign].[No_]
	FROM
	       [CRONUS UK Ltd_$Segment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Campaign$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign]
	              ON
	                     [Segment Header].[Campaign No_] = [Campaign].[No_]
4Salesperson Code SearchSalesperson CodeNormalCode20Salesperson Codenvarchar(40)
Key to join to the Salesperson/Purchaser table.

Show/hide example query

SELECT
	       [Segment Header].[Salesperson Code]
	       ,[Salesperson/Purchaser].[Code]
	FROM
	       [CRONUS UK Ltd_$Segment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
	              ON
	                     [Segment Header].[Salesperson Code] = [Salesperson/Purchaser].[Code]
5Correspondence Type (Default) SearchCorrespondence Type (Default)NormalOption4Correspondence Type (Default)int
Available options are:
  • ” “
  • “Hard Copy”
  • “Email”
  • “Fax”
6Interaction Template Code SearchInteraction Template CodeNormalCode10Interaction Template Codenvarchar(20)
Key to join to the Interaction Template table.

Show/hide example query

SELECT
	       [Segment Header].[Interaction Template Code]
	       ,[Interaction Template].[Code]
	FROM
	       [CRONUS UK Ltd_$Segment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Interaction Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Template]
	              ON
	                     [Segment Header].[Interaction Template Code] = [Interaction Template].[Code]
7Unit Cost (LCY) SearchUnit Cost ($)NormalDecimal12Unit Cost (LCY)decimal(38,38)
8Unit Duration (Min.) SearchUnit Duration (Min.)NormalDecimal12Unit Duration (Min_)decimal(38,38)
9Attachment No. SearchAttachment No.FlowFieldInteger4
Key to join to the Attachment table.

Show/hide example query

SELECT
	       [Segment Header].[]
	       ,[Attachment].[No_]
	FROM
	       [CRONUS UK Ltd_$Segment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Attachment$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Attachment]
	              ON
	                     [Segment Header].[] = [Attachment].[No_]
10Date SearchDateNormalDate4Datedatetime
11Campaign Target SearchCampaign TargetNormalBoolean4Campaign Targettinyint
12Information Flow SearchInformation FlowNormalOption4Information Flowint
Available options are:
  • ” “
  • “Outbound”
  • “Inbound”
13Initiated By SearchInitiated ByNormalOption4Initiated Byint
Available options are:
  • ” “
  • “Us”
  • “Them”
14No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
	       [Segment Header].[No_ Series]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$Segment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [Segment Header].[No_ Series] = [No. Series].[Code]
15Campaign Response SearchCampaign ResponseNormalBoolean4Campaign Responsetinyint
16No. of Lines SearchNo. of LinesFlowFieldInteger4
17Cost (LCY) SearchCost ($)FlowFieldDecimal12
18Duration (Min.) SearchDuration (Min.)FlowFieldDecimal12
19Language Code (Default) SearchLanguage Code (Default)NormalCode10Language Code (Default)nvarchar(20)
Key to join to the Language table.

Show/hide example query

SELECT
	       [Segment Header].[Language Code (Default)]
	       ,[Language].[Code]
	FROM
	       [CRONUS UK Ltd_$Segment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
	              ON
	                     [Segment Header].[Language Code (Default)] = [Language].[Code]
20Interaction Group Code SearchInteraction Group CodeNormalCode10Interaction Group Codenvarchar(20)
Key to join to the Interaction Group table.

Show/hide example query

SELECT
	       [Segment Header].[Interaction Group Code]
	       ,[Interaction Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Segment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Interaction Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Group]
	              ON
	                     [Segment Header].[Interaction Group Code] = [Interaction Group].[Code]
21No. of Criteria Actions SearchNo. of Criteria ActionsFlowFieldInteger4
22Send Word Docs. as Attmt. SearchSend Word Docs. as Attmt.NormalBoolean4Send Word Docs_ as Attmt_tinyint
23Ignore Contact Corres. Type SearchIgnore Contact Corres. TypeNormalBoolean4Ignore Contact Corres_ Typetinyint
24Subject (Default) SearchSubject (Default)NormalText100Subject (Default)nvarchar(200)
25Campaign Description SearchCampaign DescriptionFlowFieldText100
26Word Template Code SearchWord Template CodeNormalCode30Word Template Codenvarchar(60)
Key to join to the Word Template table.

Show/hide example query

SELECT
	       [Segment Header].[Word Template Code]
	       ,[Word Template].[Code]
	FROM
	       [CRONUS UK Ltd_$Segment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Word Template$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Word Template]
	              ON
	                     [Segment Header].[Word Template Code] = [Word Template].[Code]
27Modified Word Template SearchModified Word TemplateFlowFieldInteger4
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 Header].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Segment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Header]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Segment Header].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Segment Header table

Salesperson/PurchaserSalesperson/Purchaser
Dynamics 365 BC Table ReferenceTablesCompany TablesSSegment Header

Leave a Reply

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