Segment Wizard Filter

Dynamics 365 BC Table ReferenceTablesCompany TablesSSegment 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. 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 Primary Key SearchFunctionalityNormalOption4Functionalityint
Available options are:
  • “Add Contacts”
  • “Remove Contacts”
  • “Reduce Contacts”
  • “Refine Contacts”
3Mailing Group Code Filter SearchMailing Group Code FilterFlowFilterCode10
Key to join to the Mailing Group table.

Show/hide example query

SELECT
	       [Segment Wizard Filter].[]
	       ,[Mailing Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Segment Wizard Filter$437dbf0e-84ff-417a-965d-ed2bb9650972] 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]
4Industry Group Code Filter SearchIndustry Group Code FilterFlowFilterCode10
Key to join to the Industry Group table.

Show/hide example query

SELECT
	       [Segment Wizard Filter].[]
	       ,[Industry Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Segment Wizard Filter$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Wizard Filter]
	LEFT JOIN
	       [CRONUS UK Ltd_$Industry Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Industry Group]
	              ON
	                     [Segment Wizard Filter].[] = [Industry Group].[Code]
5Salesperson Code Filter SearchSalesperson Code FilterFlowFilterCode20
Key to join to the Salesperson/Purchaser table.

Show/hide example query

SELECT
	       [Segment Wizard Filter].[]
	       ,[Salesperson/Purchaser].[Code]
	FROM
	       [CRONUS UK Ltd_$Segment Wizard Filter$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Wizard Filter]
	LEFT JOIN
	       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
	              ON
	                     [Segment Wizard Filter].[] = [Salesperson/Purchaser].[Code]
6Country/Region Code Filter SearchCountry/Region Code FilterFlowFilterCode10
7Territory Code Filter SearchTerritory Code FilterFlowFilterCode10
Key to join to the Territory table.

Show/hide example query

SELECT
	       [Segment Wizard Filter].[]
	       ,[Territory].[Code]
	FROM
	       [CRONUS UK Ltd_$Segment Wizard Filter$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Wizard Filter]
	LEFT JOIN
	       [CRONUS UK Ltd_$Territory$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Territory]
	              ON
	                     [Segment Wizard Filter].[] = [Territory].[Code]
8Post Code Filter SearchZIP Code FilterFlowFilterCode20
Key to join to the Post Code table.

Show/hide example query

SELECT
	       [Segment Wizard Filter].[]
	       ,[Post Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Segment Wizard Filter$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Wizard Filter]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Segment Wizard Filter].[] = [Post Code].[Code]
9Business Relation Code Filter SearchBusiness Relation Code FilterFlowFilterCode10
Key to join to the Business Relation table.

Show/hide example query

SELECT
	       [Segment Wizard Filter].[]
	       ,[Business Relation].[Code]
	FROM
	       [CRONUS UK Ltd_$Segment Wizard Filter$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Wizard Filter]
	LEFT JOIN
	       [CRONUS UK Ltd_$Business Relation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Relation]
	              ON
	                     [Segment Wizard Filter].[] = [Business Relation].[Code]
10Profile Questn. Code Filter SearchProfile Questn. Code FilterFlowFilterCode20
Key to join to the Profile Questionnaire Header table.

Show/hide example query

SELECT
	       [Segment Wizard Filter].[]
	       ,[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 Header].[Code]
11Profile Questn. Line Filter SearchProfile Questn. Line FilterFlowFilterInteger4
12Job Responsibility Code Filter SearchJob Responsibility Code FilterFlowFilterCode10
Key to join to the Job Responsibility table.

Show/hide example query

SELECT
	       [Segment Wizard Filter].[]
	       ,[Job Responsibility].[Code]
	FROM
	       [CRONUS UK Ltd_$Segment Wizard Filter$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Wizard Filter]
	LEFT JOIN
	       [CRONUS UK Ltd_$Job Responsibility$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Responsibility]
	              ON
	                     [Segment Wizard Filter].[] = [Job Responsibility].[Code]
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
Dynamics 365 BC Table ReferenceTablesCompany TablesSSegment Wizard Filter

Leave a Reply

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