G/L Account Mapping Header – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GG/L Account Mapping Header

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

Table Type: Company

Table Name: G/L Account Mapping Header
Database Table Name: CRONUS UK Ltd_$G_L Account Mapping Header$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada

Table Number: 5260

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 Mapping Header can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$G_L Account Mapping Header$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada]

Show/hide an example select of all columns by name

SELECT

   [Code]
   ,[Standard Account Type]
   ,[Audit File Export Format]
   ,[Starting Date]
   ,[Ending Date]
   ,[Period Type]
   ,[Accounting Period]
   ,[Include Incoming Balance]
   ,[Standard Account Category No_]
   ,[Standard Account No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$G_L Account Mapping Header$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$G_L Account Mapping Header$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada] AS [G/L Account Mapping Header]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
      ON
         [G/L Account Mapping Header].[Ending Date] = [Inventory Period].[Ending Date]
LEFT JOIN
   [User] AS [User]
      ON
         [G/L Account Mapping Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [G/L Account Mapping Header].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in G/L Account Mapping Header table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Code	Code	Normal	Code	20	Code	nvarchar(40)
2	Standard Account Type	Standard Account Type	Normal	Option	4	Standard Account Type	int
	Available options are: “None”
3	Audit File Export Format	Audit File Export Format	Normal	Option	4	Audit File Export Format	int
	Available options are: “None”
10	Starting Date	Starting Date	Normal	Date	4	Starting Date	datetime
11	Ending Date	Ending Date	Normal	Date	4	Ending Date	datetime
	Key to join to the Inventory Period table. Show/hide example query SELECT [G/L Account Mapping Header].[Ending Date] ,[Inventory Period].[Ending Date] FROM [CRONUS UK Ltd_$G_L Account Mapping Header$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada] AS [G/L Account Mapping Header] LEFT JOIN [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period] ON [G/L Account Mapping Header].[Ending Date] = [Inventory Period].[Ending Date]
12	Period Type	Period Type	Normal	Option	4	Period Type	int
	Available options are: “None” “Accounting Period” “Date Range”
13	Accounting Period	Accounting Period	Normal	Date	4	Accounting Period	datetime
14	Include Incoming Balance	Include Incoming Balance	Normal	Boolean	4	Include Incoming Balance	tinyint
15	Standard Account Category No.	Standard Account Category No.	Normal	Code	20	Standard Account Category No_	nvarchar(40)
16	Standard Account No.	Standard Account No.	Normal	Code	20	Standard Account No_	nvarchar(40)
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 Mapping Header].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$G_L Account Mapping Header$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada] AS [G/L Account Mapping Header] LEFT JOIN [User] AS [User] ON [G/L Account Mapping Header].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [G/L Account Mapping Header].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$G_L Account Mapping Header$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada] AS [G/L Account Mapping Header] LEFT JOIN [User] AS [User] ON [G/L Account Mapping Header].[$systemModifiedBy] = [User].[User Security ID]