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