Segment 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: 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 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
   [timestamp]
   ,[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].[No_]

Show/hide columns in Segment Header table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Description Searchnvarchar(200)
4Campaign No_ Searchnvarchar(40)
5Salesperson Code Searchnvarchar(40)
Key to join to the Salesperson_Purchaser table.

Show/hide example query

SELECT
       [Segment Header].[Salesperson Code]
       ,[Salesperson_Purchaser].[No_]
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].[No_]
6Correspondence Type (Default) Searchint
7Interaction Template Code Searchnvarchar(20)
8Unit Cost (LCY) Searchdecimal(38,38)
9Unit Duration (Min_) Searchdecimal(38,38)
10Date Searchdatetime
11Campaign Target Searchtinyint
12Information Flow Searchint
13Initiated By Searchint
14No_ Series Searchnvarchar(40)
15Campaign Response Searchtinyint
16Language Code (Default) Searchnvarchar(20)
17Interaction Group Code Searchnvarchar(20)
18Send Word Docs_ as Attmt_ Searchtinyint
19Ignore Contact Corres_ Type Searchtinyint
20Subject (Default) Searchnvarchar(200)
21Word Template Code Searchnvarchar(60)
22$systemId Searchuniqueidentifier
23$systemCreatedAt Searchdatetime
24$systemCreatedBy Searchuniqueidentifier
25$systemModifiedAt Searchdatetime
26$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Segment Header table

Leave a Reply

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