G/L Account Category

Dynamics 365 BC Table ReferenceTablesCompany TablesGG/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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. SearchEntry No.NormalInteger4Entry No_int
2Parent Entry No. Primary Key SearchParent Entry No.NormalInteger4Parent Entry No_int
3Sibling Sequence No. SearchSibling Sequence No.NormalInteger4Sibling Sequence No_int
4Presentation Order SearchPresentation OrderNormalText100Presentation Ordernvarchar(200)
5Indentation SearchIndentationNormalInteger4Indentationint
6Description SearchDescriptionNormalText80Descriptionnvarchar(160)
7Account Category SearchAccount CategoryNormalOption4Account Categoryint
Available options are:
  • “”
  • “Assets”
  • “Liabilities”
  • “Equity”
  • “Income”
  • “Cost of Goods Sold”
  • “Expense”
8Income/Balance SearchIncome/BalanceNormalOption4Income_Balanceint
9Additional Report Definition SearchAdditional Report DefinitionNormalOption4Additional Report Definitionint
Available options are:
  • ” “
  • “Operating Activities”
  • “Investing Activities”
  • “Financing Activities”
  • “Cash Accounts”
  • “Retained Earnings”
  • “Distribution to Shareholders”
11System Generated SearchSystem GeneratedNormalBoolean4
12Has Children SearchHas ChildrenFlowFieldBoolean4
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesGG/L Account Category

Leave a Reply

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