Config_ Line

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

Table Type: Company

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

Table Number: 0

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_ Line can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Line No_]
   ,[Line Type]
   ,[Table ID]
   ,[Name]
   ,[Promoted Table]
   ,[Dimensions as Columns]
   ,[Copying Available]
   ,[Page ID]
   ,[Starting Date]
   ,[Ending Date]
   ,[Responsible ID]
   ,[Status]
   ,[Vertical Sorting]
   ,[Data Origin]
   ,[Reference]
   ,[Parent Line No_]
   ,[Package Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Config_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Config_ Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Line No_ Primary Key Searchint
3Line Type Searchint
4Table ID Searchint
5Name Searchnvarchar(500)
6Promoted Table Searchtinyint
7Dimensions as Columns Searchtinyint
8Copying Available Searchtinyint
9Page ID Searchint
10Starting Date Searchdatetime
11Ending Date Searchdatetime
12Responsible ID Searchnvarchar(100)
13Status Searchint
14Vertical Sorting Searchint
15Data Origin Searchnvarchar(100)
16Reference Searchnvarchar(500)
17Parent Line No_ Searchint
18Package Code Searchnvarchar(40)
19$systemId Searchuniqueidentifier
20$systemCreatedAt Searchdatetime
21$systemCreatedBy Searchuniqueidentifier
22$systemModifiedAt Searchdatetime
23$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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