Standard General Journal Line #751

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

The Standard General Journal Line table (ID 751) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 80 fields, with a primary key of Journal Template Name, Line No., Standard Journal Code. 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: Journal Template Name, Line No., Standard Journal Code.

All fields (80)

Standard General Journal Line — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Journal Template Name PK	Code	Normal	→ Gen. Journal Template #80
2	Line No. PK	Integer	Normal
3	Account Type	Option	Normal
4	Account No.	Code	Normal
6	Document Type	Option	Normal
8	Description	Text	Normal
10	VAT %	Decimal	Normal
11	Bal. Account No.	Code	Normal
12	Currency Code	Code	Normal	→ Currency #4
13	Amount	Decimal	Normal
14	Debit Amount	Decimal	Normal
15	Credit Amount	Decimal	Normal
16	Amount (LCY)	Decimal	Normal
17	Balance (LCY)	Decimal	Normal
18	Currency Factor	Decimal	Normal
19	Sales/Purch. (LCY)	Decimal	Normal
20	Profit (LCY)	Decimal	Normal
21	Inv. Discount (LCY)	Decimal	Normal
22	Bill-to/Pay-to No.	Code	Normal
23	Posting Group	Code	Normal
24	Shortcut Dimension 1 Code	Code	Normal	→ Dimension Value #349
25	Shortcut Dimension 2 Code	Code	Normal	→ Dimension Value #349
26	Salespers./Purch. Code	Code	Normal	→ Salesperson/Purchaser #13
29	Source Code	Code	Normal	→ Source Code #230
34	On Hold	Code	Normal
35	Applies-to Doc. Type	Option	Normal
40	Payment Discount %	Decimal	Normal
42	Project No.	Code	Normal	→ Job #167
43	Quantity	Decimal	Normal
44	VAT Amount	Decimal	Normal
47	Payment Terms Code	Code	Normal	→ Payment Terms #3
50	Business Unit Code	Code	Normal	→ Business Unit #220
51	Standard Journal Code PK	Code	Normal	→ Standard General Journal #750
52	Reason Code	Code	Normal	→ Reason Code #231
57	Gen. Posting Type	Option	Normal
58	Gen. Bus. Posting Group	Code	Normal	→ Gen. Business Posting Group #250
59	Gen. Prod. Posting Group	Code	Normal	→ Gen. Product Posting Group #251
60	VAT Calculation Type	Option	Normal
63	Bal. Account Type	Option	Normal
64	Bal. Gen. Posting Type	Option	Normal
65	Bal. Gen. Bus. Posting Group	Code	Normal	→ Gen. Business Posting Group #250
66	Bal. Gen. Prod. Posting Group	Code	Normal	→ Gen. Product Posting Group #251
67	Bal. VAT Calculation Type	Option	Normal
68	Bal. VAT %	Decimal	Normal
69	Bal. VAT Amount	Decimal	Normal
70	Bank Payment Type	Option	Normal
71	VAT Base Amount	Decimal	Normal
72	Bal. VAT Base Amount	Decimal	Normal
73	Correction	Boolean	Normal
77	External Document No.	Code	Normal
78	Source Type	Option	Normal
79	Source No.	Code	Normal
80	Posting No. Series	Code	Normal	→ No. Series #308
82	Tax Area Code	Code	Normal	→ Tax Area #318
83	Tax Liable	Boolean	Normal
84	Tax Group Code	Code	Normal	→ Tax Group #321
85	Use Tax	Boolean	Normal
86	Bal. Tax Area Code	Code	Normal	→ Tax Area #318
87	Bal. Tax Liable	Boolean	Normal
88	Bal. Tax Group Code	Code	Normal	→ Tax Group #321
89	Bal. Use Tax	Boolean	Normal
90	VAT Bus. Posting Group	Code	Normal	→ VAT Business Posting Group #323
91	VAT Prod. Posting Group	Code	Normal	→ VAT Product Posting Group #324
92	Bal. VAT Bus. Posting Group	Code	Normal	→ VAT Business Posting Group #323
93	Bal. VAT Prod. Posting Group	Code	Normal	→ VAT Product Posting Group #324
110	Ship-to/Order Address Code	Code	Normal
111	VAT Difference	Decimal	Normal
112	Bal. VAT Difference	Decimal	Normal
113	IC Partner Code	Code	Normal	→ IC Partner #413
118	Sell-to/Buy-from No.	Code	Normal
130	IC Account Type	Option	Normal
131	IC Account No.	Code	Normal
480	Dimension Set ID	Integer	Normal	→ Dimension Set Entry #480
5050	Campaign No.	Code	Normal	→ Campaign #5071
5616	Index Entry	Boolean	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