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
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 ID | Column Name | Data Type | ||||
|---|---|---|---|---|---|---|
| 1 | timestamp  | timestamp | ||||
| 2 | No_  | nvarchar(40) | ||||
| 3 | Description | nvarchar(200) | ||||
| 4 | Campaign No_ | nvarchar(40) | ||||
| 5 | Salesperson Code | nvarchar(40) | ||||
Key to join to the Salesperson_Purchaser table.Show/hide example querySELECT
[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_] | ||||||
| 6 | Correspondence Type (Default) | int | ||||
| 7 | Interaction Template Code | nvarchar(20) | ||||
| 8 | Unit Cost (LCY) | decimal(38,38) | ||||
| 9 | Unit Duration (Min_) | decimal(38,38) | ||||
| 10 | Date | datetime | ||||
| 11 | Campaign Target | tinyint | ||||
| 12 | Information Flow | int | ||||
| 13 | Initiated By | int | ||||
| 14 | No_ Series | nvarchar(40) | ||||
| 15 | Campaign Response | tinyint | ||||
| 16 | Language Code (Default) | nvarchar(20) | ||||
| 17 | Interaction Group Code | nvarchar(20) | ||||
| 18 | Send Word Docs_ as Attmt_ | tinyint | ||||
| 19 | Ignore Contact Corres_ Type | tinyint | ||||
| 20 | Subject (Default) | nvarchar(200) | ||||
| 21 | Word Template Code | nvarchar(60) | ||||
| 22 | $systemId | uniqueidentifier | ||||
| 23 | $systemCreatedAt | datetime | ||||
| 24 | $systemCreatedBy | uniqueidentifier | ||||
| 25 | $systemModifiedAt | datetime | ||||
| 26 | $systemModifiedBy | uniqueidentifier | ||||