Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/763
Table Type: Company
Table Name: Acc_ Sched_ Chart Setup Line
Database Table Name: CRONUS UK Ltd_$Acc_ Sched_ Chart Setup 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 Acc_ Sched_ Chart Setup Line can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Acc_ Sched_ Chart Setup Line$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[User ID]
,[Name]
,[Account Schedule Line No_]
,[Column Layout Line No_]
,[Account Schedule Name]
,[Column Layout Name]
,[Original Measure Name]
,[Measure Name]
,[Measure Value]
,[Chart Type]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Acc_ Sched_ Chart Setup Line$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide columns in Acc_ Sched_ Chart Setup Line table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | User ID  | nvarchar(264) |
| 3 | Name | nvarchar(60) |
| 4 | Account Schedule Line No_ | int |
| 5 | Column Layout Line No_ | int |
| 6 | Account Schedule Name | nvarchar(20) |
| 7 | Column Layout Name | nvarchar(20) |
| 8 | Original Measure Name | nvarchar(222) |
| 9 | Measure Name | nvarchar(222) |
| 10 | Measure Value | nvarchar(60) |
| 11 | Chart Type | int |
| 12 | $systemId | uniqueidentifier |
| 13 | $systemCreatedAt | datetime |
| 14 | $systemCreatedBy | uniqueidentifier |
| 15 | $systemModifiedAt | datetime |
| 16 | $systemModifiedBy | uniqueidentifier |