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
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 ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Line No_  | int |
| 3 | Line Type | int |
| 4 | Table ID | int |
| 5 | Name | nvarchar(500) |
| 6 | Promoted Table | tinyint |
| 7 | Dimensions as Columns | tinyint |
| 8 | Copying Available | tinyint |
| 9 | Page ID | int |
| 10 | Starting Date | datetime |
| 11 | Ending Date | datetime |
| 12 | Responsible ID | nvarchar(100) |
| 13 | Status | int |
| 14 | Vertical Sorting | int |
| 15 | Data Origin | nvarchar(100) |
| 16 | Reference | nvarchar(500) |
| 17 | Parent Line No_ | int |
| 18 | Package Code | nvarchar(40) |
| 19 | $systemId | uniqueidentifier |
| 20 | $systemCreatedAt | datetime |
| 21 | $systemCreatedBy | uniqueidentifier |
| 22 | $systemModifiedAt | datetime |
| 23 | $systemModifiedBy | uniqueidentifier |