G/L Account Where-Used – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GG/L Account Where-Used

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

Table Type: Company

Table Name: G/L Account Where-Used
Database Table Name: CRONUS UK Ltd_$G_L Account Where-Used$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 180

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 Where-Used can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$G_L Account Where-Used$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Entry No_]
   ,[Table ID]
   ,[Table Name]
   ,[Field Name]
   ,[Line]
   ,[G_L Account No_]
   ,[G_L Account Name]
   ,[Key 1]
   ,[Key 2]
   ,[Key 3]
   ,[Key 4]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$G_L Account Where-Used$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 Where-Used$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account Where-Used]
LEFT JOIN
   [CRONUS UK Ltd_$Data Exch_ Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Mapping]
      ON
         [G/L Account Where-Used].[Table ID] = [Data Exch. Mapping].[Table ID]
LEFT JOIN
   [User] AS [User]
      ON
         [G/L Account Where-Used].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [G/L Account Where-Used].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in G/L Account Where-Used table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Entry No.	Entry No.	Normal	Integer	4	Entry No_	int
2	Table ID	Table ID	Normal	Integer	4	Table ID	int
	Key to join to the Data Exch. Mapping table. Show/hide example query SELECT [G/L Account Where-Used].[Table ID] ,[Data Exch. Mapping].[Table ID] FROM [CRONUS UK Ltd_$G_L Account Where-Used$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account Where-Used] LEFT JOIN [CRONUS UK Ltd_$Data Exch_ Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Mapping] ON [G/L Account Where-Used].[Table ID] = [Data Exch. Mapping].[Table ID]
3	Table Name	Table Name	Normal	Text	150	Table Name	nvarchar(300)
5	Field Name	Field Name	Normal	Text	150	Field Name	nvarchar(300)
6	Line	Line	Normal	Text	250	Line	nvarchar(500)
7	G/L Account No.	G/L Account No.	Normal	Code	20	G_L Account No_	nvarchar(40)
8	G/L Account Name	G/L Account Name	Normal	Text	100	G_L Account Name	nvarchar(200)
9	Key 1	Key 1	Normal	Text	50	Key 1	nvarchar(100)
10	Key 2	Key 2	Normal	Text	50	Key 2	nvarchar(100)
11	Key 3	Key 3	Normal	Text	50	Key 3	nvarchar(100)
12	Key 4	Key 4	Normal	Text	50	Key 4	nvarchar(100)
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 Account Where-Used].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$G_L Account Where-Used$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account Where-Used] LEFT JOIN [User] AS [User] ON [G/L Account Where-Used].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier