G_L Account Category

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

Table Type: Company

Table Name: G_L Account Category
Database Table Name: CRONUS UK Ltd_$G_L Account Category$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 0

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 Category can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$G_L Account Category$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Parent Entry No_]
   ,[Sibling Sequence No_]
   ,[Presentation Order]
   ,[Indentation]
   ,[Description]
   ,[Account Category]
   ,[Income_Balance]
   ,[Additional Report Definition]
   ,[System Generated]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$G_L Account Category$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in G_L Account Category table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Parent Entry No_ Searchint
4Sibling Sequence No_ Searchint
5Presentation Order Searchnvarchar(200)
6Indentation Searchint
7Description Searchnvarchar(160)
8Account Category Searchint
9Income_Balance Searchint
10Additional Report Definition Searchint
11System Generated Searchtinyint
12$systemId Searchuniqueidentifier
13$systemCreatedAt Searchdatetime
14$systemCreatedBy Searchuniqueidentifier
15$systemModifiedAt Searchdatetime
16$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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