G/L – Item Ledger Relation – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GG/L – Item Ledger Relation

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

Table Type: Company

Table Name: G/L – Item Ledger Relation
Database Table Name: CRONUS UK Ltd_$G_L – Item Ledger Relation$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5823

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 – Item Ledger Relation can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$G_L - Item Ledger Relation$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT



FROM

   [CRONUS UK Ltd_$G_L - Item Ledger Relation$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 - Item Ledger Relation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L - Item Ledger Relation]
LEFT JOIN
   [User] AS [User]
      ON
         [G/L - Item Ledger Relation].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [G/L - Item Ledger Relation].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in G/L – Item Ledger Relation table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	G/L Entry No.	G/L Entry No.	Normal	Integer	4	G_L Entry No_	int
2	Value Entry No.	Value Entry No.	Normal	Integer	4	Value Entry No_	int
	Key to join to the Value Entry table. Show/hide example query SELECT [G/L - Item Ledger Relation].[Value Entry No_] ,[Value Entry].[Entry No_] FROM [CRONUS UK Ltd_$G_L - Item Ledger Relation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L - Item Ledger Relation] LEFT JOIN [CRONUS UK Ltd_$Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Value Entry] ON [G/L - Item Ledger Relation].[Value Entry No_] = [Value Entry].[Entry No_]
3	G/L Register No.	G/L Register No.	Normal	Integer	4	G_L Register No_	int
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [G/L - Item Ledger Relation].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$G_L - Item Ledger Relation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L - Item Ledger Relation] LEFT JOIN [User] AS [User] ON [G/L - Item Ledger Relation].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier