XPT / Schema / Gen. Journal Line

Gen. Journal Line #81

Other table in Microsoft Dynamics 365 Business Central. 228 fields, 1 records in Cronus demo.

228
Fields
1
Records
3
Primary key
3
FlowFields
56
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., Journal Batch Name.

All fields (228)

Gen. Journal Line — FIELDS
NO.FIELDTYPECLASSRELATION
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
5 Posting Date Date Normal
6 Document Type Option Normal
7 Document No. Code 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
28 Pending Approval Boolean Normal
29 Source Code Code Normal → Source Code #230
30 System-Created Entry Boolean Normal
31 Your Reference Text Normal
34 On Hold Code Normal
35 Applies-to Doc. Type Option Normal
36 Applies-to Doc. No. Code Normal
38 Due Date Date Normal
39 Pmt. Discount Date Date Normal
40 Payment Discount % Decimal Normal
42 Project No. Code Normal → Job #167
43 Quantity Decimal Normal
44 VAT Amount Decimal Normal
45 VAT Posting Option Normal
47 Payment Terms Code Code Normal → Payment Terms #3
48 Applies-to ID Code Normal
50 Business Unit Code Code Normal → Business Unit #220
51 Journal Batch Name PK Code Normal → Gen. Journal Batch #232
52 Reason Code Code Normal → Reason Code #231
53 Recurring Method Option Normal
54 Expiration Date Date Normal
55 Recurring Frequency DateFormula Normal
56 Allocated Amt. (LCY) ⚡ FLOW Decimal FlowField
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
61 EU 3-Party Trade Boolean Normal
62 Allow Application Boolean 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
74 Print Posted Documents Boolean Normal
75 Check Printed Boolean Normal
76 Document Date Date 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
95 Additional-Currency Posting Option Normal
98 FA Add.-Currency Factor Decimal Normal
99 Source Currency Code Code Normal → Currency #4
100 Source Currency Amount Decimal Normal
101 Source Curr. VAT Base Amount Decimal Normal
102 Source Curr. VAT Amount Decimal Normal
103 VAT Base Discount % Decimal Normal
104 VAT Amount (LCY) Decimal Normal
105 VAT Base Amount (LCY) Decimal Normal
106 Bal. VAT Amount (LCY) Decimal Normal
107 Bal. VAT Base Amount (LCY) Decimal Normal
108 Reversing Entry Boolean Normal
109 Allow Zero-Amount Posting Boolean Normal
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
114 IC Direction Option Normal
117 IC Partner Transaction No. Integer Normal
118 Sell-to/Buy-from No. Code Normal
119 VAT Registration No. Text Normal
120 Country/Region Code Code Normal → Country/Region #9
121 Prepayment Boolean Normal
122 Financial Void Boolean Normal
123 Copy VAT Setup to Jnl. Lines Boolean Normal
125 VAT Base Before Pmt. Disc. Decimal Normal
126 Original Pmt. Disc. Possible Decimal Normal
127 Orig. Pmt. Disc. Possible (LCY) Decimal Normal
128 VAT Date Date Normal
129 Zero Source Currency Amount Boolean Normal
130 IC Account Type Option Normal
131 IC Account No. Code Normal
160 Job Queue Status Option Normal
161 Job Queue Entry ID GUID Normal
165 Incoming Document Entry No. Integer Normal → Incoming Document #130
170 Creditor No. Code Normal
171 Payment Reference Code Normal
172 Payment Method Code Code Normal → Payment Method #289
173 Applies-to Ext. Doc. No. Code Normal
175 Invoice Received Date Date Normal
180 Keep Description Boolean Normal
288 Recipient Bank Account Code Normal
289 Message to Recipient Text Normal
290 Exported to Payment File Boolean Normal
291 Has Payment Export Error ⚡ FLOW Boolean FlowField
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
1000 Remit-to Code Code Normal → Remit Address #2224
1001 Project Task No. Code Normal → Job Task #1001
1002 Project Unit Price (LCY) Decimal Normal
1003 Project Total Price (LCY) Decimal Normal
1004 Project Quantity Decimal Normal
1005 Project Unit Cost (LCY) Decimal Normal
1006 Project Line Discount % Decimal Normal
1007 Project Line Disc. Amount (LCY) Decimal Normal
1008 Project Unit Of Measure Code Code Normal → Unit of Measure #204
1009 Project Line Type Option Normal
1010 Project Unit Price Decimal Normal
1011 Project Total Price Decimal Normal
1012 Project Unit Cost Decimal Normal
1013 Project Total Cost Decimal Normal
1014 Project Line Discount Amount Decimal Normal
1015 Project Line Amount Decimal Normal
1016 Project Total Cost (LCY) Decimal Normal
1017 Project Line Amount (LCY) Decimal Normal
1018 Project Currency Factor Decimal Normal
1019 Project Currency Code Code Normal
1020 Project Planning Line No. Integer Normal
1030 Project Remaining Qty. Decimal Normal
1200 Direct Debit Mandate ID Code Normal
1220 Data Exch. Entry No. Integer Normal → Data Exch. #1220
1221 Payer Information Text Normal
1222 Transaction Information Text Normal
1223 Data Exch. Line No. Integer Normal
1224 Applied Automatically Boolean Normal
1300 Linked Table ID Integer Normal
1301 Linked System ID GUID Normal
1700 Deferral Code Code Normal → Deferral Template #1700
1701 Deferral Line No. Integer Normal
2676 Allocation Account No. Code Normal → Allocation Account #2670
2677 Allocation Account Distributions Modified ⚡ FLOW Boolean FlowField
2678 Posting Allocation Account No. Code Normal → Allocation Account #2670
2679 Allocation Journal Line SystemId GUID Normal
5050 Campaign No. Code Normal → Campaign #5071
5400 Prod. Order No. Code Normal
5600 FA Posting Date Date Normal
5601 FA Posting Type Option Normal
5602 Depreciation Book Code Code Normal → Depreciation Book #5611
5603 Salvage Value Decimal Normal
5604 No. of Depreciation Days Integer Normal
5605 Depr. until FA Posting Date Boolean Normal
5606 Depr. Acquisition Cost Boolean Normal
5609 Maintenance Code Code Normal → Maintenance #5626
5610 Insurance No. Code Normal → Insurance #5628
5611 Budgeted FA No. Code Normal → Fixed Asset #5600
5612 Duplicate in Depreciation Book Code Normal → Depreciation Book #5611
5613 Use Duplication List Boolean Normal
5614 FA Reclassification Entry Boolean Normal
5615 FA Error Entry No. Integer Normal → FA Ledger Entry #5601
5616 Index Entry Boolean Normal
5617 Source Line No. Integer Normal
5618 Comment Text Normal
5701 Check Exported Boolean Normal
5702 Check Transmitted Boolean Normal
5703 Reverse Date Calculation DateFormula Normal
6200 Non-Deductible VAT % Decimal Normal
6201 Non-Deductible VAT Base Decimal Normal
6202 Non-Deductible VAT Amount Decimal Normal
6203 Non-Deductible VAT Base LCY Decimal Normal
6204 Non-Deductible VAT Amount LCY Decimal Normal
6205 Non-Deductible VAT Base ACY Decimal Normal
6206 Non-Deductible VAT Amount ACY Decimal Normal
6207 FA G/L Account No. Code Normal
6208 Non-Deductible VAT Difference Decimal Normal
6209 Bal. Non-Deductible VAT % Decimal Normal
6210 Bal. Non-Deductible VAT Base Decimal Normal
6211 Bal. Non-Deductible VAT Amount Decimal Normal
6212 Bal. Non-Deductible VAT Base LCY Decimal Normal
6213 Bal. Non-Deductible VAT Amount LCY Decimal Normal
6214 Sustainability Account No. Code Normal → Sustainability Account #6210
6215 Sustainability Account Name Text Normal
6216 Sustainability Account Category Code Normal → Sustain. Account Category #6211
6217 Sustainability Account Subcategory Code Normal → Sustain. Account Subcategory #6212
6218 Total Emission CO2 Decimal Normal
6219 Total Emission CH4 Decimal Normal
6220 Total Emission N2O Decimal Normal
6221 CO2e per Unit Decimal Normal
6222 Total CO2e Decimal Normal
6230 Non-Ded. VAT FA Cost Boolean Normal
8001 Account Id GUID Normal → G/L Account #15
8002 Customer Id GUID Normal → Customer #18
8003 Applies-to Invoice Id GUID Normal → Sales Invoice Entity Aggregate #5475
8004 Contact Graph Id Text Normal
8005 Last Modified DateTime DateTime Normal
8006 Journal Batch Id GUID Normal → Gen. Journal Batch #232
8007 Payment Method Id GUID Normal → Payment Method #289
8008 Balance Account Id GUID Normal → G/L Account #15
8009 Vendor Id GUID Normal → Vendor #23
8051 Subscription Contract No. Code Normal
30100 Shopify Transaction Id BigInteger 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 (42)

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

Gen. Journal Template
#80 · Other · via Journal Template Name
Currency
#4 · General Ledger · via Currency Code, Source Currency Code
Dimension Value
#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code
Salesperson/Purchaser
#13 · General Ledger · via Salespers./Purch. Code
Source Code
#230 · Other · via Source Code
Job
#167 · Other · via Project No.
Payment Terms
#3 · General Ledger · via Payment Terms Code
Business Unit
#220 · Other · via Business Unit Code
Gen. Journal Batch
#232 · Other · via Journal Batch Name, Journal Batch Id
Reason Code
#231 · Other · via Reason Code
Gen. Business Posting Group
#250 · Other · via Gen. Bus. Posting Group, Bal. Gen. Bus. Posting Group
Gen. Product Posting Group
#251 · Other · via Gen. Prod. Posting Group, Bal. Gen. Prod. Posting Group
No. Series
#308 · Other · via Posting No. Series
Tax Area
#318 · Other · via Tax Area Code, Bal. Tax Area Code
Tax Group
#321 · Other · via Tax Group Code, Bal. Tax Group Code
VAT Business Posting Group
#323 · Other · via VAT Bus. Posting Group, Bal. VAT Bus. Posting Group
VAT Product Posting Group
#324 · Other · via VAT Prod. Posting Group, Bal. VAT Prod. Posting Group
IC Partner
#413 · Other · via IC Partner Code
Country/Region
#9 · General Ledger · via Country/Region Code
Incoming Document
#130 · Other · via Incoming Document Entry No.
Payment Method
#289 · Other · via Payment Method Code, Payment Method Id
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID
Remit Address
#2224 · Other · via Remit-to Code
Job Task
#1001 · Jobs · via Project Task No.
Unit of Measure
#204 · Other · via Project Unit Of Measure Code
Data Exch.
#1220 · Other · via Data Exch. Entry No.
Deferral Template
#1700 · Other · via Deferral Code
Allocation Account
#2670 · Other · via Allocation Account No., Posting Allocation Account No.
Campaign
#5071 · Other · via Campaign No.
Depreciation Book
#5611 · Fixed Assets · via Depreciation Book Code, Duplicate in Depreciation Book
Maintenance
#5626 · Fixed Assets · via Maintenance Code
Insurance
#5628 · Fixed Assets · via Insurance No.
Fixed Asset
#5600 · Fixed Assets · via Budgeted FA No.
FA Ledger Entry
#5601 · Fixed Assets · via FA Error Entry No.
Sustainability Account
#6210 · Other · via Sustainability Account No.
Sustain. Account Category
#6211 · Other · via Sustainability Account Category
Sustain. Account Subcategory
#6212 · Other · via Sustainability Account Subcategory
G/L Account
#15 · General Ledger · via Account Id, Balance Account Id
Customer
#18 · Sales · via Customer Id
Sales Invoice Entity Aggregate
#5475 · Other · via Applies-to Invoice Id
Vendor
#23 · Purchasing · via Vendor Id

© 2026 Xpertly Ltd · Company No. 14753894 · VAT No. 452840787

HomeData ExplorerPricingPrivacyTerms