Segment Criteria Line

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

Table Type: Company

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

Table Number: 5097

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [Segment No_]
   ,[Line No_]
   ,[Type]
   ,[Action]
   ,[Table No_]
   ,[Table View]
   ,[View]
   ,[Allow Existing Contacts]
   ,[Expand Contact]
   ,[Allow Company with Persons]
   ,[Ignore Exclusion]
   ,[Entire Companies]
   ,[No_ of Filters]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Segment Criteria 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 Criteria Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Criteria Line]
LEFT JOIN
   [User] AS [User]
      ON
         [Segment Criteria Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Segment Criteria Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Segment Criteria 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 Criteria Line].[Segment No_]
       ,[Segment Header].[No_]
FROM
       [CRONUS UK Ltd_$Segment Criteria Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Criteria Line]
LEFT JOIN
       [CRONUS UK Ltd_$Segment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Header]
              ON
                     [Segment Criteria Line].[Segment No_] = [Segment Header].[No_]
2Line No. Primary Key SearchLine No.NormalInteger4Line No_int
3Type SearchTypeNormalOption4Typeint
Available options are:
  • “Action”
  • “Filter”
4Action SearchActionNormalOption4Actionint
Available options are:
  • ” “
  • “Add Contacts”
  • “Remove Contacts (Reduce)”
  • “Remove Contacts (Refine)”
5Table No. SearchTable No.NormalInteger4Table No_int
6Table View SearchViewNormalText2048Table Viewnvarchar(4096)
7View SearchViewNormalText250Viewnvarchar(500)
8Allow Existing Contacts SearchAllow Existing ContactsNormalBoolean4Allow Existing Contactstinyint
9Expand Contact SearchExpand ContactNormalBoolean4Expand Contacttinyint
10Allow Company with Persons SearchAllow Company with PersonsNormalBoolean4Allow Company with Personstinyint
11Ignore Exclusion SearchIgnore ExclusionNormalBoolean4Ignore Exclusiontinyint
12Entire Companies SearchEntire CompaniesNormalBoolean4Entire Companiestinyint
13Table Caption SearchTable CaptionFlowFieldText250
14No. of Filters SearchNo. of FiltersNormalInteger4No_ of Filtersint
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 Criteria Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Segment Criteria Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Criteria Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Segment Criteria 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 Criteria Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Segment Criteria Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Criteria Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Segment Criteria Line].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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