G/L Entry

Dynamics 365 BC Table ReferenceTablesCompany TablesGG/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: 17

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

   [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]
   ,[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]
   ,[VAT Reporting Date]
   ,[Dimension Set ID]
   ,[Last Dim_ Correction Entry No_]
   ,[Last Dim_ Correction Node]
   ,[Dimension Changes Count]
   ,[Allocation Account No_]
   ,[Prod_ Order No_]
   ,[FA Entry Type]
   ,[FA Entry No_]
   ,[Comment]
   ,[Non-Deductible VAT Amount]
   ,[Non-Deductible VAT Amount ACY]
   ,[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_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [G/L Entry].[Document Type] = [Sales Header].[Document Type]
      AND
         [G/L Entry].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [G/L Entry].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [G/L Entry].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [G/L Entry].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [G/L Entry].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [G/L Entry].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit]
      ON
         [G/L Entry].[Business Unit Code] = [Business Unit].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [G/L Entry].[Reason Code] = [Reason Code].[Code]
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]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [G/L Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [G/L Entry].[Shortcut Dimension 3 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [G/L Entry].[Shortcut Dimension 4 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [G/L Entry].[Shortcut Dimension 5 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [G/L Entry].[Shortcut Dimension 6 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [G/L Entry].[Shortcut Dimension 7 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [G/L Entry].[Shortcut Dimension 8 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [G/L Entry].[Account Id] = [G/L Account].[$systemId]
LEFT JOIN
   [User] AS [User]
      ON
         [G/L Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [G/L Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in G/L Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. SearchEntry No.NormalInteger4Entry No_int
3G/L Account No. Primary Key SearchG/L Account No.NormalCode20G_L Account No_nvarchar(40)
4Posting Date SearchPosting DateNormalDate4Posting Datedatetime
5Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
6Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
7Description SearchDescriptionNormalText100Descriptionnvarchar(200)
10Bal. Account No. SearchBal. Account No.NormalCode20Bal_ Account No_nvarchar(40)
17Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
23Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
	       [G/L Entry].[Global Dimension 1 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [G/L Entry].[Global Dimension 1 Code] = [Dimension].[Code]
24Global Dimension 2 Code SearchGlobal Dimension 2 CodeNormalCode20Global Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
	       [G/L Entry].[Global Dimension 2 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [G/L Entry].[Global Dimension 2 Code] = [Dimension].[Code]
27User ID SearchUser IDNormalCode50User IDnvarchar(100)
28Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
	       [G/L Entry].[Source Code]
	       ,[Source Code].[Code]
	FROM
	       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
	              ON
	                     [G/L Entry].[Source Code] = [Source Code].[Code]
29System-Created Entry SearchSystem-Created EntryNormalBoolean4
30Prior-Year Entry SearchPrior-Year EntryNormalBoolean4Prior-Year Entrytinyint
41Job No. SearchJob No.NormalCode20Job No_nvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
	       [G/L Entry].[Job No_]
	       ,[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].[No_]
42Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
43VAT Amount SearchTax AmountNormalDecimal12VAT Amountdecimal(38,38)
45Business Unit Code SearchBusiness Unit CodeNormalCode20Business Unit Codenvarchar(40)
Key to join to the Business Unit table.

Show/hide example query

SELECT
	       [G/L Entry].[Business Unit Code]
	       ,[Business Unit].[Code]
	FROM
	       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit]
	              ON
	                     [G/L Entry].[Business Unit Code] = [Business Unit].[Code]
46Journal Batch Name SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
47Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
	       [G/L Entry].[Reason Code]
	       ,[Reason Code].[Code]
	FROM
	       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
	              ON
	                     [G/L Entry].[Reason Code] = [Reason Code].[Code]
48Gen. Posting Type SearchGen. Posting TypeNormalOption4Gen_ Posting Typeint
Available options are:
  • ” “
  • “Purchase”
  • “Sale”
  • “Settlement”
49Gen. Bus. Posting Group SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
	       [G/L Entry].[Gen_ Bus_ Posting Group]
	       ,[Gen. Business Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
	              ON
	                     [G/L Entry].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
50Gen. Prod. Posting Group SearchGen. Prod. Posting GroupNormalCode20Gen_ Prod_ Posting Groupnvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

SELECT
	       [G/L Entry].[Gen_ Prod_ Posting Group]
	       ,[Gen. Product Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
	              ON
	                     [G/L Entry].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
51Bal. Account Type SearchBal. Account TypeNormalOption4Bal_ Account Typeint
Available options are:
  • “G/L Account”
  • “Customer”
  • “Vendor”
  • “Bank Account”
  • “Fixed Asset”
  • “IC Partner”
  • “Employee”
  • “Allocation Account”
52Transaction No. SearchTransaction No.NormalInteger4Transaction No_int
53Debit Amount SearchDebit AmountNormalDecimal12Debit Amountdecimal(38,38)
54Credit Amount SearchCredit AmountNormalDecimal12Credit Amountdecimal(38,38)
55Document Date SearchDocument DateNormalDate4Document Datedatetime
56External Document No. SearchExternal Document No.NormalCode35External Document No_nvarchar(70)
57Source Type SearchSource TypeNormalOption4Source Typeint
Available options are:
  • ” “
  • “Customer”
  • “Vendor”
  • “Bank Account”
  • “Fixed Asset”
  • “IC Partner”
  • “Employee”
58Source No. SearchSource No.NormalCode20Source No_nvarchar(40)
59No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
	       [G/L Entry].[No_ Series]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [G/L Entry].[No_ Series] = [No. Series].[Code]
60Tax Area Code SearchTax Area CodeNormalCode20Tax Area Codenvarchar(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]
61Tax Liable SearchTax LiableNormalBoolean4Tax Liabletinyint
62Tax Group Code SearchTax Group CodeNormalCode20Tax Group Codenvarchar(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]
63Use Tax SearchUse TaxNormalBoolean4Use Taxtinyint
64VAT Bus. Posting Group SearchVAT Bus. Posting GroupNormalCode20VAT Bus_ Posting Groupnvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
	       [G/L Entry].[VAT Bus_ Posting Group]
	       ,[VAT Business Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
	              ON
	                     [G/L Entry].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
65VAT Prod. Posting Group SearchVAT Prod. Posting GroupNormalCode20VAT Prod_ Posting Groupnvarchar(40)
Key to join to the VAT Product Posting Group table.

Show/hide example query

SELECT
	       [G/L Entry].[VAT Prod_ Posting Group]
	       ,[VAT Product Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group]
	              ON
	                     [G/L Entry].[VAT Prod_ Posting Group] = [VAT Product Posting Group].[Code]
68Additional-Currency Amount SearchAdditional-Currency AmountNormalDecimal12Additional-Currency Amountdecimal(38,38)
69Add.-Currency Debit Amount SearchAdd.-Currency Debit AmountNormalDecimal12Add_-Currency Debit Amountdecimal(38,38)
70Add.-Currency Credit Amount SearchAdd.-Currency Credit AmountNormalDecimal12Add_-Currency Credit Amountdecimal(38,38)
71Close Income Statement Dim. ID SearchClose Income Statement Dim. IDNormalInteger4Close Income Statement Dim_ IDint
72IC Partner Code SearchIC Partner CodeNormalCode20IC Partner Codenvarchar(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]
73Reversed SearchReversedNormalBoolean4Reversedtinyint
74Reversed by Entry No. SearchReversed by Entry No.NormalInteger4Reversed by Entry No_int
75Reversed Entry No. SearchReversed Entry No.NormalInteger4Reversed Entry No_int
76G/L Account Name SearchG/L Account NameFlowFieldText100
78Journal Templ. Name SearchJournal Template NameNormalCode10Journal Templ_ Namenvarchar(20)
79VAT Reporting Date SearchTax DateNormalDate4VAT Reporting Datedatetime
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
	       [G/L Entry].[Dimension Set ID]
	       ,[Dimension Set Entry].[Dimension Set ID]
	FROM
	       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
	              ON
	                     [G/L Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
481Shortcut Dimension 3 Code SearchShortcut Dimension 3 CodeFlowFieldCode20
Key to join to the Dimension table.

Show/hide example query

SELECT
	       [G/L Entry].[]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [G/L Entry].[] = [Dimension].[Code]
482Shortcut Dimension 4 Code SearchShortcut Dimension 4 CodeFlowFieldCode20
Key to join to the Dimension table.

Show/hide example query

SELECT
	       [G/L Entry].[]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [G/L Entry].[] = [Dimension].[Code]
483Shortcut Dimension 5 Code SearchShortcut Dimension 5 CodeFlowFieldCode20
Key to join to the Dimension table.

Show/hide example query

SELECT
	       [G/L Entry].[]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [G/L Entry].[] = [Dimension].[Code]
484Shortcut Dimension 6 Code SearchShortcut Dimension 6 CodeFlowFieldCode20
Key to join to the Dimension table.

Show/hide example query

SELECT
	       [G/L Entry].[]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [G/L Entry].[] = [Dimension].[Code]
485Shortcut Dimension 7 Code SearchShortcut Dimension 7 CodeFlowFieldCode20
Key to join to the Dimension table.

Show/hide example query

SELECT
	       [G/L Entry].[]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [G/L Entry].[] = [Dimension].[Code]
486Shortcut Dimension 8 Code SearchShortcut Dimension 8 CodeFlowFieldCode20
Key to join to the Dimension table.

Show/hide example query

SELECT
	       [G/L Entry].[]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [G/L Entry].[] = [Dimension].[Code]
495Last Dim. Correction Entry No. SearchLast Dim. Correction Entry No.NormalInteger4Last Dim_ Correction Entry No_int
496Last Dim. Correction Node SearchLast Dim. Correction NodeNormalInteger4Last Dim_ Correction Nodeint
497Dimension Changes Count SearchCount of Dimension ChangesNormalInteger4Dimension Changes Countint
2678Allocation Account No. SearchAllocation Account No.NormalCode20Allocation Account No_nvarchar(40)
Key to join to the Allocation Account table.

Show/hide example query

SELECT
	       [G/L Entry].[Allocation Account No_]
	       ,[Allocation Account].[No_]
	FROM
	       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Allocation Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Allocation Account]
	              ON
	                     [G/L Entry].[Allocation Account No_] = [Allocation Account].[No_]
5400Prod. Order No. SearchProd. Order No.NormalCode20Prod_ Order No_nvarchar(40)
5600FA Entry Type SearchFA Entry TypeNormalOption4FA Entry Typeint
Available options are:
  • ” “
  • “Fixed Asset”
  • “Maintenance”
5601FA Entry No. SearchFA Entry No.NormalInteger4FA Entry No_int
5618Comment SearchCommentNormalText250Commentnvarchar(500)
6200Non-Deductible VAT Amount SearchNon-Deductible Tax AmountNormalDecimal12Non-Deductible VAT Amountdecimal(38,38)
6201Non-Deductible VAT Amount ACY SearchNon-Deductible Tax Amount ACYNormalDecimal12Non-Deductible VAT Amount ACYdecimal(38,38)
8001Account Id SearchAccount IdFlowFieldGUID16
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [G/L Entry].[]
	       ,[G/L Account].[$systemId]
	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].[$systemId]
8005Last Modified DateTime SearchLast Modified DateTimeNormalDateTime8Last Modified DateTimedatetime
10018STE Transaction ID SearchSTE Transaction IDNormalText20
10019GST/HST SearchGST/HSTNormalOption4
22212Reviewed SearchReviewedFlowFieldBoolean4
22213Reviewed By SearchReviewed ByFlowFieldCode50
22214Reviewed Date SearchReviewed DateFlowFieldDateTime8
22215Reviewed Identifier SearchReviewed IdentifierFlowFieldInteger4
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 Entry].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [G/L Entry].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from G/L Entry table

IC PartnerSales HeaderSales Header ArchiveTax AreaTax Group
Dynamics 365 BC Table ReferenceTablesCompany TablesGG/L Entry

Leave a Reply

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