Trial Balance Entity Buffer

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5488

Table Type: Company

Table Name: Trial Balance Entity Buffer
Database Table Name: CRONUS UK Ltd_$Trial Balance Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5488

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 Trial Balance Entity Buffer can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Trial Balance Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Name]
   ,[Net Change Debit]
   ,[Net Change Credit]
   ,[Balance at Date Debit]
   ,[Balance at Date Credit]
   ,[Date Filter]
   ,[Total Debit]
   ,[Total Credit]
   ,[Account Type]
   ,[Account Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Trial Balance Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Trial Balance Entity Buffer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Name Searchnvarchar(200)
4Net Change Debit Searchnvarchar(60)
5Net Change Credit Searchnvarchar(60)
6Balance at Date Debit Searchnvarchar(60)
7Balance at Date Credit Searchnvarchar(60)
8Date Filter Searchdatetime
9Total Debit Searchnvarchar(60)
10Total Credit Searchnvarchar(60)
11Account Type Searchint
12Account Id Searchuniqueidentifier
13$systemId Searchuniqueidentifier
14$systemCreatedAt Searchdatetime
15$systemCreatedBy Searchuniqueidentifier
16$systemModifiedAt Searchdatetime
17$systemModifiedBy Searchuniqueidentifier

Leave a Reply

Your email address will not be published. Required fields are marked *