Config_ Selection

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

Table Type: Company

Table Name: Config_ Selection
Database Table Name: CRONUS UK Ltd_$Config_ Selection$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 8621

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 Config_ Selection can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Config_ Selection$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Line No_]
   ,[Table ID]
   ,[Name]
   ,[Line Type]
   ,[Parent Line No_]
   ,[Selected]
   ,[Vertical Sorting]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Config_ Selection$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Config_ Selection table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Line No_ Primary Key Searchint
3Table ID Searchint
4Name Searchnvarchar(500)
5Line Type Searchint
6Parent Line No_ Searchint
7Selected Searchtinyint
8Vertical Sorting Searchint
9$systemId Searchuniqueidentifier
10$systemCreatedAt Searchdatetime
11$systemCreatedBy Searchuniqueidentifier
12$systemModifiedAt Searchdatetime
13$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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