G_L Entry

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

Table Type: Company

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[G_L Account No_]
   ,[Posting Date]
   ,[Document Type]
   ,[Document No_]
   ,[Description]
   ,[Bal_ Account No_]
   ,[Amount]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[User ID]
   ,[Source Code]
   ,[System-Created Entry]
   ,[Prior-Year Entry]
   ,[Job No_]
   ,[Quantity]
   ,[VAT Amount]
   ,[Business Unit Code]
   ,[Journal Batch Name]
   ,[Reason Code]
   ,[Gen_ Posting Type]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Bal_ Account Type]
   ,[Transaction No_]
   ,[Debit Amount]
   ,[Credit Amount]
   ,[Document Date]
   ,[External Document No_]
   ,[Source Type]
   ,[Source No_]
   ,[No_ Series]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[Tax Group Code]
   ,[Use Tax]
   ,[VAT Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[Additional-Currency Amount]
   ,[Add_-Currency Debit Amount]
   ,[Add_-Currency Credit Amount]
   ,[Close Income Statement Dim_ ID]
   ,[IC Partner Code]
   ,[Reversed]
   ,[Reversed by Entry No_]
   ,[Reversed Entry No_]
   ,[Journal Templ_ Name]
   ,[Dimension Set ID]
   ,[Last Dim_ Correction Entry No_]
   ,[Last Dim_ Correction Node]
   ,[Dimension Changes Count]
   ,[Prod_ Order No_]
   ,[FA Entry Type]
   ,[FA Entry No_]
   ,[Comment]
   ,[Last Modified DateTime]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$G_L Entry$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 Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Entry]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Account]
      ON
         [G_L Entry].[G_L Account No_] = [G_L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [G_L Entry].[Job No_] = [Job].[Job No_]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [G_L Entry].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [G_L Entry].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [G_L Entry].[IC Partner Code] = [IC Partner].[Code]

Show/hide columns in G_L Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3G_L Account No_ Searchnvarchar(40)
Key to join to the G_L Account table.

Show/hide example query

SELECT
       [G_L Entry].[G_L Account No_]
       ,[G_L Account].[No_]
FROM
       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Entry]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Account]
              ON
                     [G_L Entry].[G_L Account No_] = [G_L Account].[No_]
4Posting Date Searchdatetime
5Document Type Searchint
6Document No_ Searchnvarchar(40)
7Description Searchnvarchar(200)
8Bal_ Account No_ Searchnvarchar(40)
9Amount Searchdecimal(38,38)
10Global Dimension 1 Code Searchnvarchar(40)
11Global Dimension 2 Code Searchnvarchar(40)
12User ID Searchnvarchar(100)
13Source Code Searchnvarchar(20)
14System-Created Entry Searchtinyint
15Prior-Year Entry Searchtinyint
16Job No_ Searchnvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [G_L Entry].[Job No_]
       ,[Job].[Job No_]
FROM
       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
              ON
                     [G_L Entry].[Job No_] = [Job].[Job No_]
17Quantity Searchdecimal(38,38)
18VAT Amount Searchdecimal(38,38)
19Business Unit Code Searchnvarchar(40)
20Journal Batch Name Searchnvarchar(20)
21Reason Code Searchnvarchar(20)
22Gen_ Posting Type Searchint
23Gen_ Bus_ Posting Group Searchnvarchar(40)
24Gen_ Prod_ Posting Group Searchnvarchar(40)
25Bal_ Account Type Searchint
26Transaction No_ Searchint
27Debit Amount Searchdecimal(38,38)
28Credit Amount Searchdecimal(38,38)
29Document Date Searchdatetime
30External Document No_ Searchnvarchar(70)
31Source Type Searchint
32Source No_ Searchnvarchar(40)
33No_ Series Searchnvarchar(40)
34Tax Area Code Searchnvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

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

Show/hide example query

SELECT
       [G_L Entry].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [G_L Entry].[Tax Group Code] = [Tax Group].[Code]
37Use Tax Searchtinyint
38VAT Bus_ Posting Group Searchnvarchar(40)
39VAT Prod_ Posting Group Searchnvarchar(40)
40Additional-Currency Amount Searchdecimal(38,38)
41Add_-Currency Debit Amount Searchdecimal(38,38)
42Add_-Currency Credit Amount Searchdecimal(38,38)
43Close Income Statement Dim_ ID Searchint
44IC Partner Code Searchnvarchar(40)
Key to join to the IC Partner table.

Show/hide example query

SELECT
       [G_L Entry].[IC Partner Code]
       ,[IC Partner].[Code]
FROM
       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Entry]
LEFT JOIN
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
              ON
                     [G_L Entry].[IC Partner Code] = [IC Partner].[Code]
45Reversed Searchtinyint
46Reversed by Entry No_ Searchint
47Reversed Entry No_ Searchint
48Journal Templ_ Name Searchnvarchar(20)
49Dimension Set ID Searchint
50Last Dim_ Correction Entry No_ Searchint
51Last Dim_ Correction Node Searchint
52Dimension Changes Count Searchint
53Prod_ Order No_ Searchnvarchar(40)
54FA Entry Type Searchint
55FA Entry No_ Searchint
56Comment Searchnvarchar(500)
57Last Modified DateTime Searchdatetime
58$systemId Searchuniqueidentifier
59$systemCreatedAt Searchdatetime
60$systemCreatedBy Searchuniqueidentifier
61$systemModifiedAt Searchdatetime
62$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from G_L Entry table

Leave a Reply

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