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
   [timestamp]
   ,[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 columns in Segment Wizard Filter table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Segment No_ Primary Key Searchnvarchar(40)
3Functionality Searchint
4Profile Questionnaire Code Searchnvarchar(40)
5Add Additional Criteria Searchtinyint
6Wizard Step Searchint
7$systemId Searchuniqueidentifier
8$systemCreatedAt Searchdatetime
9$systemCreatedBy Searchuniqueidentifier
10$systemModifiedAt Searchdatetime
11$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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