Segment History

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

Table Type: Company

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

Table Number: 5078

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Segment History$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [Segment No_]
   ,[Segment Action No_]
   ,[Segment Line No_]
   ,[Contact No_]
   ,[Action Taken]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Segment History$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 History$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment History]
LEFT JOIN
   [User] AS [User]
      ON
         [Segment History].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Segment History].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Segment History 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 History].[Segment No_]
       ,[Segment Header].[No_]
FROM
       [CRONUS UK Ltd_$Segment History$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment History]
LEFT JOIN
       [CRONUS UK Ltd_$Segment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Header]
              ON
                     [Segment History].[Segment No_] = [Segment Header].[No_]
2Segment Action No. Primary Key SearchSegment Action No.NormalInteger4Segment Action No_int
3Segment Line No. Primary Key SearchSegment Line No.NormalInteger4Segment Line No_int
4Contact No. SearchContact No.NormalCode20Contact No_nvarchar(40)
Key to join to the Contact table.

Show/hide example query

SELECT
       [Segment History].[Contact No_]
       ,[Contact].[No_]
FROM
       [CRONUS UK Ltd_$Segment History$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment History]
LEFT JOIN
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
              ON
                     [Segment History].[Contact No_] = [Contact].[No_]
5Action Taken SearchAction TakenNormalOption4Action Takenint
Available options are:
  • “Insertion”
  • “Deletion”
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 History].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Segment History$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment History]
LEFT JOIN
       [User] AS [User]
              ON
                     [Segment History].[$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 History].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Segment History$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment History]
LEFT JOIN
       [User] AS [User]
              ON
                     [Segment History].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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