Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/85
Table Type: Company
Table Name: Acc_ Schedule Line
Database Table Name: CRONUS UK Ltd_$Acc_ Schedule 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_ Schedule Line can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Acc_ Schedule Line$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[Schedule Name]
,[Line No_]
,[Row No_]
,[Description]
,[Totaling]
,[Totaling Type]
,[New Page]
,[Indentation]
,[Show]
,[Dimension 1 Totaling]
,[Dimension 2 Totaling]
,[Dimension 3 Totaling]
,[Dimension 4 Totaling]
,[Bold]
,[Italic]
,[Underline]
,[Show Opposite Sign]
,[Row Type]
,[Amount Type]
,[Double Underline]
,[Hide Currency Symbol]
,[Cost Center Totaling]
,[Cost Object Totaling]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Acc_ Schedule Line$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide columns in Acc_ Schedule Line table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Schedule Name  | nvarchar(20) |
| 3 | Line No_ | int |
| 4 | Row No_ | nvarchar(20) |
| 5 | Description | nvarchar(200) |
| 6 | Totaling | nvarchar(500) |
| 7 | Totaling Type | int |
| 8 | New Page | tinyint |
| 9 | Indentation | int |
| 10 | Show | int |
| 11 | Dimension 1 Totaling | nvarchar(500) |
| 12 | Dimension 2 Totaling | nvarchar(500) |
| 13 | Dimension 3 Totaling | nvarchar(500) |
| 14 | Dimension 4 Totaling | nvarchar(500) |
| 15 | Bold | tinyint |
| 16 | Italic | tinyint |
| 17 | Underline | tinyint |
| 18 | Show Opposite Sign | tinyint |
| 19 | Row Type | int |
| 20 | Amount Type | int |
| 21 | Double Underline | tinyint |
| 22 | Hide Currency Symbol | tinyint |
| 23 | Cost Center Totaling | nvarchar(160) |
| 24 | Cost Object Totaling | nvarchar(160) |
| 25 | $systemId | uniqueidentifier |
| 26 | $systemCreatedAt | datetime |
| 27 | $systemCreatedBy | uniqueidentifier |
| 28 | $systemModifiedAt | datetime |
| 29 | $systemModifiedBy | uniqueidentifier |