Segment Wizard Filter

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

Table Type: Company

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

Table Number: 5096

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [Segment No_]
   ,[Functionality]
   ,[Profile Questionnaire Code]
   ,[Add Additional Criteria]
   ,[Wizard Step]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Segment Wizard Filter$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [] AS [Segment Wizard Filter]
LEFT JOIN
   [CRONUS UK Ltd_$Mailing Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Mailing Group]
      ON
         [Segment Wizard Filter].[Mailing Group Code Filter] = [Mailing Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Industry Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Industry Group]
      ON
         [Segment Wizard Filter].[Industry Group Code Filter] = [Industry Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Segment Wizard Filter].[Salesperson Code Filter] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Territory$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Territory]
      ON
         [Segment Wizard Filter].[Territory Code Filter] = [Territory].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Segment Wizard Filter].[Post Code Filter] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Business Relation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Relation]
      ON
         [Segment Wizard Filter].[Business Relation Code Filter] = [Business Relation].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job Responsibility$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Responsibility]
      ON
         [Segment Wizard Filter].[Job Responsibility Code Filter] = [Job Responsibility].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Profile Questionnaire Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Profile Questionnaire Header]
      ON
         [Segment Wizard Filter].[Profile Questionnaire Code] = [Profile Questionnaire Header].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Segment Wizard Filter].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Segment Wizard Filter].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Segment Wizard Filter 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 Wizard Filter].[Segment No_]
       ,[Segment Header].[No_]
FROM
       [CRONUS UK Ltd_$Segment Wizard Filter$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Wizard Filter]
LEFT JOIN
       [CRONUS UK Ltd_$Segment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Header]
              ON
                     [Segment Wizard Filter].[Segment No_] = [Segment Header].[No_]
2Functionality SearchFunctionalityNormalOption4Functionalityint
Available options are:
  • “Add Contacts”
  • “Remove Contacts”
  • “Reduce Contacts”
  • “Refine Contacts”
3Mailing Group Code Filter SearchMailing Group Code FilterFlowFilterCode10
4Industry Group Code Filter SearchIndustry Group Code FilterFlowFilterCode10
5Salesperson Code Filter SearchSalesperson Code FilterFlowFilterCode20
6Country/Region Code Filter SearchCountry/Region Code FilterFlowFilterCode10
7Territory Code Filter SearchTerritory Code FilterFlowFilterCode10
8Post Code Filter SearchZIP Code FilterFlowFilterCode20
9Business Relation Code Filter SearchBusiness Relation Code FilterFlowFilterCode10
10Profile Questn. Code Filter SearchProfile Questn. Code FilterFlowFilterCode20
11Profile Questn. Line Filter SearchProfile Questn. Line FilterFlowFilterInteger4
12Job Responsibility Code Filter SearchJob Responsibility Code FilterFlowFilterCode10
13Profile Questionnaire Code SearchProfile Questionnaire CodeNormalCode20Profile Questionnaire Codenvarchar(40)
Key to join to the Profile Questionnaire Header table.

Show/hide example query

SELECT
       [Segment Wizard Filter].[Profile Questionnaire Code]
       ,[Profile Questionnaire Header].[Code]
FROM
       [CRONUS UK Ltd_$Segment Wizard Filter$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Wizard Filter]
LEFT JOIN
       [CRONUS UK Ltd_$Profile Questionnaire Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Profile Questionnaire Header]
              ON
                     [Segment Wizard Filter].[Profile Questionnaire Code] = [Profile Questionnaire Header].[Code]
15Add Additional Criteria SearchAdd Additional CriteriaNormalBoolean4Add Additional Criteriatinyint
9501Wizard Step SearchWizard StepNormalOption4Wizard Stepint
Available options are:
  • ” “
  • “1”
  • “2”
  • “3”
  • “4”
  • “5”
  • “6”
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 Wizard Filter].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Segment Wizard Filter$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Wizard Filter]
LEFT JOIN
       [User] AS [User]
              ON
                     [Segment Wizard Filter].[$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 Wizard Filter].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Segment Wizard Filter$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Wizard Filter]
LEFT JOIN
       [User] AS [User]
              ON
                     [Segment Wizard Filter].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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