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: 0

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
   [timestamp]
   ,[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]
   ,[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].[No_]
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_$Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity]
      ON
         [Segment Line].[Opportunity No_] = [Opportunity].[No_]

Show/hide columns in Segment Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Segment No_ Primary Key Searchnvarchar(40)
3Line No_ Primary Key Searchint
4Contact No_ Searchnvarchar(40)
5Campaign No_ Searchnvarchar(40)
6Salesperson Code Searchnvarchar(40)
Key to join to the Salesperson_Purchaser table.

Show/hide example query

SELECT
       [Segment Line].[Salesperson Code]
       ,[Salesperson_Purchaser].[No_]
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].[No_]
7Correspondence Type Searchint
8Interaction Template Code Searchnvarchar(20)
9Cost (LCY) Searchdecimal(38,38)
10Duration (Min_) Searchdecimal(38,38)
11Attachment No_ Searchint
12Campaign Response Searchtinyint
13Information Flow Searchint
14Initiated By Searchint
15Contact Alt_ Address Code Searchnvarchar(20)
16Evaluation Searchint
17Campaign Target Searchtinyint
18Language Code Searchnvarchar(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]
19Description Searchnvarchar(200)
20Date Searchdatetime
21Time of Interaction Searchdatetime
22Attempt Failed Searchtinyint
23To-do No_ Searchnvarchar(40)
24Contact Company No_ Searchnvarchar(40)
25Campaign Entry No_ Searchint
26Interaction Group Code Searchnvarchar(20)
27Document Type Searchint
28Document No_ Searchnvarchar(40)
29Send Word Doc_ As Attmt_ Searchtinyint
30Contact Via Searchnvarchar(160)
31Version No_ Searchint
32Doc_ No_ Occurrence Searchint
33Subject Searchnvarchar(200)
34Opportunity No_ Searchnvarchar(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_]
35Word Template Code Searchnvarchar(60)
36Wizard Step Searchint
37Wizard Contact Name Searchnvarchar(200)
38Opportunity Description Searchnvarchar(200)
39Campaign Description Searchnvarchar(200)
40Interaction Successful Searchtinyint
41Dial Contact Searchtinyint
42Mail Contact Searchtinyint
43$systemId Searchuniqueidentifier
44$systemCreatedAt Searchdatetime
45$systemCreatedBy Searchuniqueidentifier
46$systemModifiedAt Searchdatetime
47$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Segment Line table

Leave a Reply

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