Hist. Gen. Journal Line #40901

Other table in Microsoft Dynamics 365 Business Central. 29 fields, 0 records in Cronus demo.

The Hist. Gen. Journal Line table (ID 40901) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 29 fields, with a primary key of Primary Key. Use the reference below to explore every field, data type, and table relation.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Primary Key.

All fields (29)

Hist. Gen. Journal Line — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Primary Key PK	Integer	Normal
2	Journal Entry No.	Code	Normal
3	Source Type	Option	Normal
4	Account No.	Code	Normal	→ Hist. G/L Account #40900
5	Sequence No.	Integer	Normal
6	Closed	Boolean	Normal
7	Audit Code	Text	Normal
8	Year	Integer	Normal
9	Date	Date	Normal
10	Currency Code	Code	Normal
11	Debit Amount	Decimal	Normal
12	Originating Debit Amount	Decimal	Normal
13	Credit Amount	Decimal	Normal
14	Originating Credit Amount	Decimal	Normal
15	Document Type	Text	Normal
16	Originating Document No.	Text	Normal
17	Originating Trx. Source No.	Text	Normal
18	Source No.	Text	Normal
19	Source Name	Text	Normal
20	Reference Desc.	Text	Normal
21	Description	Text	Normal
22	User	Text	Normal
23	Custom 1	Text	Normal
24	Custom 2	Text	Normal
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal

Related tables (2)

Tables referenced by fields on the Hist. Gen. Journal Line table through TableRelation properties.

Hist. G/L Account

#40900 · Other · via Account No.