G_L Account Net Change

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

Table Number: 269

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 IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Name Searchnvarchar(200)
4Net Change in Jnl_ Searchdecimal(38,38)
5Balance after Posting Searchdecimal(38,38)
6$systemId Searchuniqueidentifier
7$systemCreatedAt Searchdatetime
8$systemCreatedBy Searchuniqueidentifier
9$systemModifiedAt Searchdatetime
10$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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