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: 5096Due 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.
SELECT
*
FROM
[CRONUS UK Ltd_$Segment Wizard Filter$437dbf0e-84ff-417a-965d-ed2bb9650972]
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]
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]
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|
| 1 | Segment No.  | Segment No. | Normal | Code | 20 | Segment No_ | nvarchar(40) |
| Key to join to the Segment Header table.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_] |
| 2 | Functionality  | Functionality | Normal | Option | 4 | Functionality | int |
| Available options are:
- “Add Contacts”
- “Remove Contacts”
- “Reduce Contacts”
- “Refine Contacts”
|
| 3 | Mailing Group Code Filter | Mailing Group Code Filter | FlowFilter | Code | 10 | | |
| Key to join to the Mailing Group table.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] |
| 4 | Industry Group Code Filter | Industry Group Code Filter | FlowFilter | Code | 10 | | |
| Key to join to the Industry Group table.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] |
| 5 | Salesperson Code Filter | Salesperson Code Filter | FlowFilter | Code | 20 | | |
| Key to join to the Salesperson/Purchaser table.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] |
| 6 | Country/Region Code Filter | Country/Region Code Filter | FlowFilter | Code | 10 | | |
| 7 | Territory Code Filter | Territory Code Filter | FlowFilter | Code | 10 | | |
| Key to join to the Territory table.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] |
| 8 | Post Code Filter | ZIP Code Filter | FlowFilter | Code | 20 | | |
| Key to join to the Post Code table.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] |
| 9 | Business Relation Code Filter | Business Relation Code Filter | FlowFilter | Code | 10 | | |
| Key to join to the Business Relation table.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] |
| 10 | Profile Questn. Code Filter | Profile Questn. Code Filter | FlowFilter | Code | 20 | | |
| Key to join to the Profile Questionnaire Header table.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] |
| 11 | Profile Questn. Line Filter | Profile Questn. Line Filter | FlowFilter | Integer | 4 | | |
| 12 | Job Responsibility Code Filter | Job Responsibility Code Filter | FlowFilter | Code | 10 | | |
| Key to join to the Job Responsibility table.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] |
| 13 | Profile Questionnaire Code | Profile Questionnaire Code | Normal | Code | 20 | Profile Questionnaire Code | nvarchar(40) |
| Key to join to the Profile Questionnaire Header table.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] |
| 15 | Add Additional Criteria | Add Additional Criteria | Normal | Boolean | 4 | Add Additional Criteria | tinyint |
| 9501 | Wizard Step | Wizard Step | Normal | Option | 4 | Wizard Step | int |
| Available options are:
|
| 2000000000 | $systemId | System ID | Normal | GUID | 16 | $systemId | uniqueidentifier |
| 2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | $systemCreatedAt | datetime |
| 2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | $systemCreatedBy | uniqueidentifier |
| Key to join to the User table.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] |
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
