G_L Account

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

Table Type: Company

Table Name: G_L Account
Database Table Name: CRONUS UK Ltd_$G_L Account$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 can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Name]
   ,[Search Name]
   ,[Account Type]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Account Category]
   ,[Income_Balance]
   ,[Debit_Credit]
   ,[No_ 2]
   ,[Blocked]
   ,[Direct Posting]
   ,[Reconciliation Account]
   ,[New Page]
   ,[No_ of Blank Lines]
   ,[Indentation]
   ,[Last Modified Date Time]
   ,[Last Date Modified]
   ,[Totaling]
   ,[Consol_ Translation Method]
   ,[Consol_ Debit Acc_]
   ,[Consol_ Credit Acc_]
   ,[Gen_ Posting Type]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Picture]
   ,[Automatic Ext_ Texts]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[Tax Group Code]
   ,[VAT Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[Exchange Rate Adjustment]
   ,[Default IC Partner G_L Acc_ No]
   ,[Omit Default Descr_ in Jnl_]
   ,[Account Subcategory Entry No_]
   ,[Cost Type No_]
   ,[Default Deferral Template Code]
   ,[Id]
   ,[API Account Type]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$G_L Account$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$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Account]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [G_L Account].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [G_L Account].[Tax Group Code] = [Tax Group].[Code]

Show/hide columns in G_L Account table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Name Searchnvarchar(200)
4Search Name Searchnvarchar(200)
5Account Type Searchint
6Global Dimension 1 Code Searchnvarchar(40)
7Global Dimension 2 Code Searchnvarchar(40)
8Account Category Searchint
9Income_Balance Searchint
10Debit_Credit Searchint
11No_ 2 Searchnvarchar(40)
12Blocked Searchtinyint
13Direct Posting Searchtinyint
14Reconciliation Account Searchtinyint
15New Page Searchtinyint
16No_ of Blank Lines Searchint
17Indentation Searchint
18Last Modified Date Time Searchdatetime
19Last Date Modified Searchdatetime
20Totaling Searchnvarchar(500)
21Consol_ Translation Method Searchint
22Consol_ Debit Acc_ Searchnvarchar(40)
23Consol_ Credit Acc_ Searchnvarchar(40)
24Gen_ Posting Type Searchint
25Gen_ Bus_ Posting Group Searchnvarchar(40)
26Gen_ Prod_ Posting Group Searchnvarchar(40)
27Picture Searchimage
28Automatic Ext_ Texts Searchtinyint
29Tax Area Code Searchnvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [G_L Account].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Account]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [G_L Account].[Tax Area Code] = [Tax Area].[Code]
30Tax Liable Searchtinyint
31Tax Group Code Searchnvarchar(40)
Key to join to the Tax Group table.

Show/hide example query

SELECT
       [G_L Account].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Account]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [G_L Account].[Tax Group Code] = [Tax Group].[Code]
32VAT Bus_ Posting Group Searchnvarchar(40)
33VAT Prod_ Posting Group Searchnvarchar(40)
34Exchange Rate Adjustment Searchint
35Default IC Partner G_L Acc_ No Searchnvarchar(40)
36Omit Default Descr_ in Jnl_ Searchtinyint
37Account Subcategory Entry No_ Searchint
38Cost Type No_ Searchnvarchar(40)
39Default Deferral Template Code Searchnvarchar(20)
40Id Searchuniqueidentifier
41API Account Type Searchint
42$systemId Searchuniqueidentifier
43$systemCreatedAt Searchdatetime
44$systemCreatedBy Searchuniqueidentifier
45$systemModifiedAt Searchdatetime
46$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from G_L Account table

Show/hide tables related to G_L Account table

Leave a Reply

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