Segment Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables SSegment Line

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

Table Type: Company

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

Table Number: 5077

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Segment No_]
   ,[Line No_]
   ,[Contact No_]
   ,[Campaign No_]
   ,[Salesperson Code]
   ,[Correspondence Type]
   ,[Interaction Template Code]
   ,[Cost (LCY)]
   ,[Duration (Min_)]
   ,[Attachment No_]
   ,[Campaign Response]
   ,[Information Flow]
   ,[Initiated By]
   ,[Contact Alt_ Address Code]
   ,[Evaluation]
   ,[Campaign Target]
   ,[Language Code]
   ,[Description]
   ,[Date]
   ,[Time of Interaction]
   ,[Attempt Failed]
   ,[To-do No_]
   ,[Contact Company No_]
   ,[Campaign Entry No_]
   ,[Interaction Group Code]
   ,[Document Type]
   ,[Document No_]
   ,[Send Word Doc_ As Attmt_]
   ,[Contact Via]
   ,[Version No_]
   ,[Doc_ No_ Occurrence]
   ,[Subject]
   ,[Opportunity No_]
   ,[Word Template Code]
   ,[Merged]
   ,[Wizard Step]
   ,[Wizard Contact Name]
   ,[Opportunity Description]
   ,[Campaign Description]
   ,[Interaction Successful]
   ,[Dial Contact]
   ,[Mail Contact]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide columns in Segment Line 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 query SELECT [Segment Line].[Segment No_] ,[Segment Header].[No_] FROM [CRONUS UK Ltd_$Segment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Line] LEFT JOIN [CRONUS UK Ltd_$Segment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Header] ON [Segment Line].[Segment No_] = [Segment Header].[No_]
2	Line No.	Line No.	Normal	Integer	4	Line No_	int
3	Contact No.	Contact No.	Normal	Code	20	Contact No_	nvarchar(40)
	Key to join to the Contact table. Show/hide example query SELECT [Segment Line].[Contact No_] ,[Contact].[No_] FROM [CRONUS UK Ltd_$Segment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Line] LEFT JOIN [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact] ON [Segment Line].[Contact No_] = [Contact].[No_]
4	Campaign No.	Campaign No.	Normal	Code	20	Campaign No_	nvarchar(40)
	Key to join to the Campaign table. Show/hide example query SELECT [Segment Line].[Campaign No_] ,[Campaign].[No_] FROM [CRONUS UK Ltd_$Segment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Line] LEFT JOIN [CRONUS UK Ltd_$Campaign$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign] ON [Segment Line].[Campaign No_] = [Campaign].[No_]
5	Salesperson Code	Salesperson Code	Normal	Code	20	Salesperson Code	nvarchar(40)
	Key to join to the Salesperson/Purchaser table. Show/hide example query SELECT [Segment Line].[Salesperson Code] ,[Salesperson/Purchaser].[Code] FROM [CRONUS UK Ltd_$Segment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Line] LEFT JOIN [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser] ON [Segment Line].[Salesperson Code] = [Salesperson/Purchaser].[Code]
6	Correspondence Type	Correspondence Type	Normal	Option	4	Correspondence Type	int
	Available options are: ” “ “Hard Copy” “Email” “Fax”
7	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 [Segment Line].[Interaction Template Code] ,[Interaction Template].[Code] FROM [CRONUS UK Ltd_$Segment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Line] LEFT JOIN [CRONUS UK Ltd_$Interaction Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Template] ON [Segment Line].[Interaction Template Code] = [Interaction Template].[Code]
8	Cost (LCY)	Cost ($)	Normal	Decimal	12	Cost (LCY)	decimal(38,38)
9	Duration (Min.)	Duration (Min.)	Normal	Decimal	12	Duration (Min_)	decimal(38,38)
10	Attachment No.	Attachment No.	Normal	Integer	4	Attachment No_	int
	Key to join to the Attachment table. Show/hide example query SELECT [Segment Line].[Attachment No_] ,[Attachment].[No_] FROM [CRONUS UK Ltd_$Segment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Line] LEFT JOIN [CRONUS UK Ltd_$Attachment$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Attachment] ON [Segment Line].[Attachment No_] = [Attachment].[No_]
11	Campaign Response	Campaign Response	Normal	Boolean	4	Campaign Response	tinyint
12	Contact Name	Contact Name	FlowField	Text	100
13	Information Flow	Information Flow	Normal	Option	4	Information Flow	int
	Available options are: ” “ “Outbound” “Inbound”
14	Initiated By	Initiated By	Normal	Option	4	Initiated By	int
	Available options are: ” “ “Us” “Them”
15	Contact Alt. Address Code	Contact Alt. Address Code	Normal	Code	10	Contact Alt_ Address Code	nvarchar(20)
16	Evaluation	Evaluation	Normal	Option	4	Evaluation	int
	Available options are: ” “ “Very Positive” “Positive” “Neutral” “Negative” “Very Negative”
17	Campaign Target	Campaign Target	Normal	Boolean	4	Campaign Target	tinyint
18	Contact Company Name	Contact Company Name	FlowField	Text	100
19	Language Code	Language Code	Normal	Code	10	Language Code	nvarchar(20)
	Key to join to the Language table. Show/hide example query SELECT [Segment Line].[Language Code] ,[Language].[Code] FROM [CRONUS UK Ltd_$Segment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Line] LEFT JOIN [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language] ON [Segment Line].[Language Code] = [Language].[Code]
22	Description	Description	Normal	Text	100	Description	nvarchar(200)
23	Date	Date	Normal	Date	4	Date	datetime
24	Time of Interaction	Time of Interaction	Normal	Time	4	Time of Interaction	datetime
25	Attempt Failed	Attempt Failed	Normal	Boolean	4	Attempt Failed	tinyint
26	To-do No.	Task No.	Normal	Code	20	To-do No_	nvarchar(40)
	Key to join to the To-do table. Show/hide example query SELECT [Segment Line].[To-do No_] ,[To-do].[No_] FROM [CRONUS UK Ltd_$Segment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Line] LEFT JOIN [CRONUS UK Ltd_$To-do$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [To-do] ON [Segment Line].[To-do No_] = [To-do].[No_]
27	Contact Company No.	Contact Company No.	Normal	Code	20	Contact Company No_	nvarchar(40)
28	Campaign Entry No.	Campaign Entry No.	Normal	Integer	4	Campaign Entry No_	int
	Key to join to the Campaign Entry table. Show/hide example query SELECT [Segment Line].[Campaign Entry No_] ,[Campaign Entry].[Entry No_] FROM [CRONUS UK Ltd_$Segment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Line] LEFT JOIN [CRONUS UK Ltd_$Campaign Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign Entry] ON [Segment Line].[Campaign Entry No_] = [Campaign Entry].[Entry No_]
29	Interaction Group Code	Interaction Group Code	Normal	Code	10	Interaction Group Code	nvarchar(20)
	Key to join to the Interaction Group table. Show/hide example query SELECT [Segment Line].[Interaction Group Code] ,[Interaction Group].[Code] FROM [CRONUS UK Ltd_$Segment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Line] LEFT JOIN [CRONUS UK Ltd_$Interaction Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Group] ON [Segment Line].[Interaction Group Code] = [Interaction Group].[Code]
31	Document Type	Document Type	Normal	Option	4	Document Type	int
	Available options are: ” “ “Sales Qte.” “Sales Blnkt. Ord” “Sales Ord. Cnfrmn.” “Sales Inv.” “Sales Shpt. Note” “Sales Cr. Memo” “Sales Stmnt.” “Sales Rmdr.” “Serv. Ord. Create” “Serv. Ord. Post” “Purch.Qte.” “Purch. Blnkt. Ord.” “Purch. Ord.” “Purch. Inv.” “Purch. Rcpt.” “Purch. Cr. Memo” “Cover Sheet” “Sales Return Order” “Sales Finance Charge Memo” “Sales Return Receipt” “Purch. Return Shipment” “Purch. Return Ord. Cnfrmn.” “Service Contract” “Service Contract Quote” “Service Quote” “Sales Draft Invoice”
32	Document No.	Document No.	Normal	Code	20	Document No_	nvarchar(40)
33	Send Word Doc. As Attmt.	Send Word Doc. As Attmt.	Normal	Boolean	4	Send Word Doc_ As Attmt_	tinyint
34	Contact Via	Contact Via	Normal	Text	80	Contact Via	nvarchar(160)
35	Version No.	Version No.	Normal	Integer	4	Version No_	int
36	Doc. No. Occurrence	Doc. No. Occurrence	Normal	Integer	4	Doc_ No_ Occurrence	int
37	Subject	Subject	Normal	Text	100	Subject	nvarchar(200)
44	Opportunity No.	Opportunity No.	Normal	Code	20	Opportunity No_	nvarchar(40)
	Key to join to the Opportunity table. Show/hide example query SELECT [Segment Line].[Opportunity No_] ,[Opportunity].[No_] FROM [CRONUS UK Ltd_$Segment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Line] LEFT JOIN [CRONUS UK Ltd_$Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity] ON [Segment Line].[Opportunity No_] = [Opportunity].[No_]
50	Contact Phone No.	Contact Phone No.	FlowField	Text	30
51	Contact Mobile Phone No.	Contact Mobile Phone No.	FlowField	Text	30
52	Contact Email	Contact Email	FlowField	Text	80
53	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 [Segment Line].[Word Template Code] ,[Word Template].[Code] FROM [CRONUS UK Ltd_$Segment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Line] LEFT JOIN [CRONUS UK Ltd_$Word Template$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Word Template] ON [Segment Line].[Word Template Code] = [Word Template].[Code]
54	Merged	Merged	Normal	Boolean	4	Merged	tinyint
9501	Wizard Step	Wizard Step	Normal	Option	4	Wizard Step	int
	Available options are: ” “ “1” “2” “3” “4” “5” “6”
9502	Wizard Contact Name	Wizard Contact Name	Normal	Text	100	Wizard Contact Name	nvarchar(200)
9503	Opportunity Description	Opportunity Description	Normal	Text	100	Opportunity Description	nvarchar(200)
9504	Campaign Description	Campaign Description	Normal	Text	100	Campaign Description	nvarchar(200)
9505	Interaction Successful	Interaction Successful	Normal	Boolean	4	Interaction Successful	tinyint
9506	Dial Contact	Dial Contact	Normal	Boolean	4	Dial Contact	tinyint
9507	Mail Contact	Mail Contact	Normal	Boolean	4	Mail Contact	tinyint
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 [Segment Line].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Segment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Line] LEFT JOIN [User] AS [User] ON [Segment Line].[$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 Segment Line table

Language Sales Header Sales Header Archive Salesperson/Purchaser Salesperson/Purchaser

Dynamics 365 BC Table Reference Tables Company Tables SSegment Line

Leave a Reply Cancel reply