Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/269
Table Type: Company
Table Name: G_L Account Net Change
Database Table Name: CRONUS UK Ltd_$G_L Account Net Change$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 G_L Account Net Change can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$G_L Account Net Change$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[No_]
,[Name]
,[Net Change in Jnl_]
,[Balance after Posting]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$G_L Account Net Change$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide columns in G_L Account Net Change table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | No_  | nvarchar(40) |
| 3 | Name | nvarchar(200) |
| 4 | Net Change in Jnl_ | decimal(38,38) |
| 5 | Balance after Posting | decimal(38,38) |
| 6 | $systemId | uniqueidentifier |
| 7 | $systemCreatedAt | datetime |
| 8 | $systemCreatedBy | uniqueidentifier |
| 9 | $systemModifiedAt | datetime |
| 10 | $systemModifiedBy | uniqueidentifier |