G/L Account Category – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GG/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: 570

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

   [Entry No_]
   ,[Parent Entry No_]
   ,[Sibling Sequence No_]
   ,[Presentation Order]
   ,[Indentation]
   ,[Description]
   ,[Account Category]
   ,[Income_Balance]
   ,[Additional Report Definition]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$G_L Account Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account Category]
LEFT JOIN
   [User] AS [User]
      ON
         [G/L Account Category].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [G/L Account Category].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in G/L Account Category table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Entry No.	Entry No.	Normal	Integer	4	Entry No_	int
2	Parent Entry No.	Parent Entry No.	Normal	Integer	4	Parent Entry No_	int
3	Sibling Sequence No.	Sibling Sequence No.	Normal	Integer	4	Sibling Sequence No_	int
4	Presentation Order	Presentation Order	Normal	Text	100	Presentation Order	nvarchar(200)
5	Indentation	Indentation	Normal	Integer	4	Indentation	int
6	Description	Description	Normal	Text	80	Description	nvarchar(160)
7	Account Category	Account Category	Normal	Option	4	Account Category	int
	Available options are: “” “Assets” “Liabilities” “Equity” “Income” “Cost of Goods Sold” “Expense”
8	Income/Balance	Income/Balance	Normal	Option	4	Income_Balance	int
	Available options are: “Income Statement” “Balance Sheet”
9	Additional Report Definition	Additional Report Definition	Normal	Option	4	Additional Report Definition	int
	Available options are: ” “ “Operating Activities” “Investing Activities” “Financing Activities” “Cash Accounts” “Retained Earnings” “Distribution to Shareholders”
11	System Generated	System Generated	Normal	Boolean	4
12	Has Children	Has Children	FlowField	Boolean	4
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [G/L Account Category].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$G_L Account Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account Category] LEFT JOIN [User] AS [User] ON [G/L Account Category].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [G/L Account Category].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$G_L Account Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account Category] LEFT JOIN [User] AS [User] ON [G/L Account Category].[$systemModifiedBy] = [User].[User Security ID]