Segment 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$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_$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_$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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Segment No. Primary Key SearchSegment No.NormalCode20Segment 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_]
2Line No. Primary Key SearchLine No.NormalInteger4Line No_int
3Contact No. SearchContact No.NormalCode20Contact 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_]
4Campaign No. SearchCampaign No.NormalCode20Campaign 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_]
5Salesperson Code SearchSalesperson CodeNormalCode20Salesperson Codenvarchar(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]
6Correspondence Type SearchCorrespondence TypeNormalOption4Correspondence Typeint
Available options are:
  • ” “
  • “Hard Copy”
  • “Email”
  • “Fax”
7Interaction Template Code SearchInteraction Template CodeNormalCode10Interaction Template Codenvarchar(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]
8Cost (LCY) SearchCost ($)NormalDecimal12Cost (LCY)decimal(38,38)
9Duration (Min.) SearchDuration (Min.)NormalDecimal12Duration (Min_)decimal(38,38)
10Attachment No. SearchAttachment No.NormalInteger4Attachment 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_]
11Campaign Response SearchCampaign ResponseNormalBoolean4Campaign Responsetinyint
12Contact Name SearchContact NameFlowFieldText100
13Information Flow SearchInformation FlowNormalOption4Information Flowint
Available options are:
  • ” “
  • “Outbound”
  • “Inbound”
14Initiated By SearchInitiated ByNormalOption4Initiated Byint
Available options are:
  • ” “
  • “Us”
  • “Them”
15Contact Alt. Address Code SearchContact Alt. Address CodeNormalCode10Contact Alt_ Address Codenvarchar(20)
16Evaluation SearchEvaluationNormalOption4Evaluationint
Available options are:
  • ” “
  • “Very Positive”
  • “Positive”
  • “Neutral”
  • “Negative”
  • “Very Negative”
17Campaign Target SearchCampaign TargetNormalBoolean4Campaign Targettinyint
18Contact Company Name SearchContact Company NameFlowFieldText100
19Language Code SearchLanguage CodeNormalCode10Language Codenvarchar(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]
22Description SearchDescriptionNormalText100Descriptionnvarchar(200)
23Date SearchDateNormalDate4Datedatetime
24Time of Interaction SearchTime of InteractionNormalTime4Time of Interactiondatetime
25Attempt Failed SearchAttempt FailedNormalBoolean4Attempt Failedtinyint
26To-do No. SearchTask No.NormalCode20To-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_]
27Contact Company No. SearchContact Company No.NormalCode20Contact Company No_nvarchar(40)
28Campaign Entry No. SearchCampaign Entry No.NormalInteger4Campaign 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_]
29Interaction Group Code SearchInteraction Group CodeNormalCode10Interaction Group Codenvarchar(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]
31Document Type SearchDocument TypeNormalOption4Document Typeint
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”
32Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
33Send Word Doc. As Attmt. SearchSend Word Doc. As Attmt.NormalBoolean4Send Word Doc_ As Attmt_tinyint
34Contact Via SearchContact ViaNormalText80Contact Vianvarchar(160)
35Version No. SearchVersion No.NormalInteger4Version No_int
36Doc. No. Occurrence SearchDoc. No. OccurrenceNormalInteger4Doc_ No_ Occurrenceint
37Subject SearchSubjectNormalText100Subjectnvarchar(200)
44Opportunity No. SearchOpportunity No.NormalCode20Opportunity 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_]
50Contact Phone No. SearchContact Phone No.FlowFieldText30
51Contact Mobile Phone No. SearchContact Mobile Phone No.FlowFieldText30
52Contact Email SearchContact EmailFlowFieldText80
53Word Template Code SearchWord Template CodeNormalCode30Word Template Codenvarchar(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]
54Merged SearchMergedNormalBoolean4Mergedtinyint
9501Wizard Step SearchWizard StepNormalOption4Wizard Stepint
Available options are:
  • ” “
  • “1”
  • “2”
  • “3”
  • “4”
  • “5”
  • “6”
9502Wizard Contact Name SearchWizard Contact NameNormalText100Wizard Contact Namenvarchar(200)
9503Opportunity Description SearchOpportunity DescriptionNormalText100Opportunity Descriptionnvarchar(200)
9504Campaign Description SearchCampaign DescriptionNormalText100Campaign Descriptionnvarchar(200)
9505Interaction Successful SearchInteraction SuccessfulNormalBoolean4Interaction Successfultinyint
9506Dial Contact SearchDial ContactNormalBoolean4Dial Contacttinyint
9507Mail Contact SearchMail ContactNormalBoolean4Mail Contacttinyint
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 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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Segment Line].[$systemModifiedBy]
       ,[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].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Segment Line table

Leave a Reply

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