G_L Account (Analysis View)

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

Table Type: Company

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

Table Number: 376

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 (Analysis View) can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Account Source]
   ,[Name]
   ,[Search Name]
   ,[Account Type]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Income_Balance]
   ,[Debit_Credit]
   ,[No_ 2]
   ,[Blocked]
   ,[Direct Posting]
   ,[Reconciliation Account]
   ,[New Page]
   ,[No_ of Blank Lines]
   ,[Indentation]
   ,[Last Date Modified]
   ,[Totaling]
   ,[Consol_ Debit Acc_]
   ,[Consol_ Credit Acc_]
   ,[Gen_ Posting Type]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Automatic Ext_ Texts]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[Tax Group Code]
   ,[VAT Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[Exchange Rate Adjustment]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$G_L Account (Analysis View)$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 (Analysis View)$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Account (Analysis View)]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [G_L Account (Analysis View)].[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 (Analysis View)].[Tax Group Code] = [Tax Group].[Code]

Show/hide columns in G_L Account (Analysis View) table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Account Source Primary Key Searchint
4Name Searchnvarchar(200)
5Search Name Searchnvarchar(200)
6Account Type Searchint
7Global Dimension 1 Code Searchnvarchar(40)
8Global Dimension 2 Code Searchnvarchar(40)
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 Date Modified Searchdatetime
19Totaling Searchnvarchar(500)
20Consol_ Debit Acc_ Searchnvarchar(40)
21Consol_ Credit Acc_ Searchnvarchar(40)
22Gen_ Posting Type Searchint
23Gen_ Bus_ Posting Group Searchnvarchar(40)
24Gen_ Prod_ Posting Group Searchnvarchar(40)
25Automatic Ext_ Texts Searchtinyint
26Tax Area Code Searchnvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

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

Show/hide example query

SELECT
       [G_L Account (Analysis View)].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$G_L Account (Analysis View)$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Account (Analysis View)]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [G_L Account (Analysis View)].[Tax Group Code] = [Tax Group].[Code]
29VAT Bus_ Posting Group Searchnvarchar(40)
30VAT Prod_ Posting Group Searchnvarchar(40)
31Exchange Rate Adjustment Searchint
32$systemId Searchuniqueidentifier
33$systemCreatedAt Searchdatetime
34$systemCreatedBy Searchuniqueidentifier
35$systemModifiedAt Searchdatetime
36$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from G_L Account (Analysis View) table

Leave a Reply

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