Hist. Gen. Journal Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables HHist. Gen. Journal Line

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

Table Type: Company

Table Name: Hist. Gen. Journal Line
Database Table Name:

Table Number: 40901

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 Hist. Gen. Journal Line can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   []

Show/hide an example select of all columns by name

SELECT



FROM

   []

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

SELECT
   *
FROM
   [] AS [Hist. Gen. Journal Line]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Hist. Gen. Journal Line].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Hist. Gen. Journal Line].[Document Type] = [Sales Header].[Document Type]
      AND
         [Hist. Gen. Journal Line].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Hist. Gen. Journal Line].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Hist. Gen. Journal Line].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [User] AS [User]
      ON
         [Hist. Gen. Journal Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Hist. Gen. Journal Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Hist. Gen. Journal Line table

Field No.	Field Name	Field Caption	Class	Type	Length
1	Primary Key	Primary Key	Normal	Integer	4
2	Journal Entry No.	Journal Entry No.	Normal	Code	35
3	Source Type	Source Type	Normal	Option	4
4	Account No.	Account No.	Normal	Code	130
	Key to join to the G/L Account table. Show/hide example query SELECT [Hist. Gen. Journal Line].[] ,[G/L Account].[No_] FROM [] AS [Hist. Gen. Journal Line] LEFT JOIN [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account] ON [Hist. Gen. Journal Line].[] = [G/L Account].[No_]
5	Sequence No.	Sequence No.	Normal	Integer	4
6	Closed	Closed	Normal	Boolean	4
7	Audit Code	Audit Code	Normal	Text	35
8	Year	Year	Normal	Integer	4
9	Date	Date	Normal	Date	4
10	Currency Code	Currency Code	Normal	Code	10
	Key to join to the Currency table. Show/hide example query SELECT [Hist. Gen. Journal Line].[] ,[Currency].[Code] FROM [] AS [Hist. Gen. Journal Line] LEFT JOIN [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency] ON [Hist. Gen. Journal Line].[] = [Currency].[Code]
11	Debit Amount	Debit Amount	Normal	Decimal	12
12	Orig. Debit Amount	Originating Debit Amount	Normal	Decimal	12
13	Credit Amount	Credit Amount	Normal	Decimal	12
14	Orig. Credit Amount	Originating Credit Amount	Normal	Decimal	12
15	Document Type	Document Type	Normal	Text	35
16	Orig. Document No.	Originating Document No.	Normal	Text	35
17	Orig. Trx. Source No.	Originating Trx. Source No.	Normal	Text	35
18	Source No.	Source No.	Normal	Text	35
19	Source Name	Source Name	Normal	Text	50
20	Reference Desc.	Reference Desc.	Normal	Text	50
21	Description	Description	Normal	Text	50
22	User	User	Normal	Text	50
23	Custom1	Custom 1	Normal	Text	50
24	Custom2	Custom 2	Normal	Text	50
2000000000	$systemId	System ID	Normal	GUID	16
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8
2000000002	SystemCreatedBy	Created By	Normal	GUID	16
	Key to join to the User table. Show/hide example query SELECT [Hist. Gen. Journal Line].[] ,[User].[User Security ID] FROM [] AS [Hist. Gen. Journal Line] LEFT JOIN [User] AS [User] ON [Hist. Gen. Journal Line].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16

Show/hide tables related from Hist. Gen. Journal Line table

Currency Sales Header Sales Header Archive

Dynamics 365 BC Table Reference Tables Company Tables HHist. Gen. Journal Line

Leave a Reply Cancel reply