Objects/Tables/Table 81 Gen. Journal Line

Fields, 215

Jonas Paprotka, Base Application 28.5.54151.54365, versions 17-28, checked 2026-09-20

Id	Name	Type	Versions	Obsolete
1	Journal Template Name	Code[10]	17-28	-
2	Line No.	Integer	17-28	-
3	Account Type	Enum Gen. Journal Account Type	17-28	-
4	Account No.	Code[20]	17-28	-
5	Posting Date	Date	17-28	-
6	Document Type	Enum Gen. Journal Document Type	17-28	-
7	Document No.	Code[20]	17-28	-
8	Description	Text[100]	17-28	-
10	VAT %	Decimal	17-28	-
11	Bal. Account No.	Code[20]	17-28	-
12	Currency Code	Code[10]	17-28	-
13	Amount	Decimal	17-28	-
14	Debit Amount	Decimal	17-28	-
15	Credit Amount	Decimal	17-28	-
16	Amount (LCY)	Decimal	17-28	-
17	Balance (LCY)	Decimal	17-28	-
18	Currency Factor	Decimal	17-28	-
19	Sales/Purch. (LCY)	Decimal	17-28	-
20	Profit (LCY)	Decimal	17-28	-
21	Inv. Discount (LCY)	Decimal	17-28	-
22	Bill-to/Pay-to No.	Code[20]	17-28	-
23	Posting Group	Code[20]	17-28	-
24	Shortcut Dimension 1 Code	Code[20]	17-28	-
25	Shortcut Dimension 2 Code	Code[20]	17-28	-
26	Salespers./Purch. Code	Code[20]	17-28	-
28	Pending Approval	Boolean	19-28	-
29	Source Code	Code[10]	17-28	-
30	System-Created Entry	Boolean	17-28	-
31	Your Reference	Text[35]	22-28	-
34	On Hold	Code[3]	17-28	-
35	Applies-to Doc. Type	Enum Gen. Journal Document Type	17-28	-
36	Applies-to Doc. No.	Code[20]	17-28	-
38	Due Date	Date	17-28	-
39	Pmt. Discount Date	Date	17-28	-
40	Payment Discount %	Decimal	17-28	-
42	Job No.	Code[20]	17-28	-
43	Quantity	Decimal	17-28	-
44	VAT Amount	Decimal	17-28	-
45	VAT Posting	Option	17-28	-
47	Payment Terms Code	Code[10]	17-28	-
48	Applies-to ID	Code[50]	17-28	-
50	Business Unit Code	Code[20]	17-28	-
51	Journal Batch Name	Code[10]	17-28	-
52	Reason Code	Code[10]	17-28	-
53	Recurring Method	Enum Gen. Journal Recurring Method	17-28	-
54	Expiration Date	Date	17-28	-
55	Recurring Frequency	DateFormula	17-28	-
56	Allocated Amt. (LCY)	Decimal	17-28	-
57	Gen. Posting Type	Enum General Posting Type	17-28	-
58	Gen. Bus. Posting Group	Code[20]	17-28	-
59	Gen. Prod. Posting Group	Code[20]	17-28	-
60	VAT Calculation Type	Enum Tax Calculation Type	17-28	-
61	EU 3-Party Trade	Boolean	17-28	-
62	Allow Application	Boolean	17-28	-
63	Bal. Account Type	Enum Gen. Journal Account Type	17-28	-
64	Bal. Gen. Posting Type	Enum General Posting Type	17-28	-
65	Bal. Gen. Bus. Posting Group	Code[20]	17-28	-
66	Bal. Gen. Prod. Posting Group	Code[20]	17-28	-
67	Bal. VAT Calculation Type	Enum Tax Calculation Type	17-28	-
68	Bal. VAT %	Decimal	17-28	-
69	Bal. VAT Amount	Decimal	17-28	-
70	Bank Payment Type	Enum Bank Payment Type	17-28	-
71	VAT Base Amount	Decimal	17-28	-
72	Bal. VAT Base Amount	Decimal	17-28	-
73	Correction	Boolean	17-28	-
74	Print Posted Documents	Boolean	17-28	-
75	Check Printed	Boolean	17-28	-
76	Document Date	Date	17-28	-
77	External Document No.	Code[35]	17-28	-
78	Source Type	Enum Gen. Journal Source Type	17-28	-
79	Source No.	Code[20]	17-28	-
80	Posting No. Series	Code[20]	17-28	-
82	Tax Area Code	Code[20]	17-28	-
83	Tax Liable	Boolean	17-28	-
84	Tax Group Code	Code[20]	17-28	-
85	Use Tax	Boolean	17-28	-
86	Bal. Tax Area Code	Code[20]	17-28	-
87	Bal. Tax Liable	Boolean	17-28	-
88	Bal. Tax Group Code	Code[20]	17-28	-
89	Bal. Use Tax	Boolean	17-28	-
90	VAT Bus. Posting Group	Code[20]	17-28	-
91	VAT Prod. Posting Group	Code[20]	17-28	-
92	Bal. VAT Bus. Posting Group	Code[20]	17-28	-
93	Bal. VAT Prod. Posting Group	Code[20]	17-28	-
95	Additional-Currency Posting	Option	17-28	-
98	FA Add.-Currency Factor	Decimal	17-28	-
99	Source Currency Code	Code[10]	17-28	-
100	Source Currency Amount	Decimal	17-28	-
101	Source Curr. VAT Base Amount	Decimal	17-28	-
102	Source Curr. VAT Amount	Decimal	17-28	-
103	VAT Base Discount %	Decimal	17-28	-
104	VAT Amount (LCY)	Decimal	17-28	-
105	VAT Base Amount (LCY)	Decimal	17-28	-
106	Bal. VAT Amount (LCY)	Decimal	17-28	-
107	Bal. VAT Base Amount (LCY)	Decimal	17-28	-
108	Reversing Entry	Boolean	17-28	-
109	Allow Zero-Amount Posting	Boolean	17-28	-
110	Ship-to/Order Address Code	Code[10]	17-28	-
111	VAT Difference	Decimal	17-28	-
112	Bal. VAT Difference	Decimal	17-28	-
113	IC Partner Code	Code[20]	17-28	-
114	IC Direction	Enum IC Direction Type	17-28	-
116	IC Partner G/L Acc. No.	Code[20]	17-28	Removed 25.0
Replaced by IC Account No.
117	IC Partner Transaction No.	Integer	17-28	-
118	Sell-to/Buy-from No.	Code[20]	17-28	-
119	VAT Registration No.	Text[20]	17-28	-
120	Country/Region Code	Code[10]	17-28	-
121	Prepayment	Boolean	17-28	-
122	Financial Void	Boolean	17-28	-
123	Copy VAT Setup to Jnl. Lines	Boolean	17-28	-
125	VAT Base Before Pmt. Disc.	Decimal	17-28	-
126	Orig. Pmt. Disc. Possible	Decimal	20-28	-
127	Orig. Pmt. Disc. Possible(LCY)	Decimal	20-28	-
128	VAT Reporting Date	Date	21-28	-
129	Zero Src. Curr. Amount	Boolean	27-28	-
130	IC Account Type	Enum IC Journal Account Type	22-28	-
131	IC Account No.	Code[20]	22-28	-
160	Job Queue Status	Enum Document Job Queue Status	17-28	-
161	Job Queue Entry ID	Guid	17-28	-
165	Incoming Document Entry No.	Integer	17-28	-
170	Creditor No.	Code[20]	17-28	-
171	Payment Reference	Code[50]	17-28	-
172	Payment Method Code	Code[10]	17-28	-
173	Applies-to Ext. Doc. No.	Code[35]	17-28	-
175	Invoice Received Date	Date	22-28	-
180	Keep Description	Boolean	19-28	-
288	Recipient Bank Account	Code[20]	17-28	-
289	Message to Recipient	Text[140]	17-28	-
290	Exported to Payment File	Boolean	17-28	-
291	Has Payment Export Error	Boolean	17-28	-
480	Dimension Set ID	Integer	17-28	-
827	Credit Card No.	Code[20]	17-25, gone	Removed 15.0
This field is not needed and it is not used anymore.
1000	Remit-to Code	Code[20]	21-28	-
1001	Job Task No.	Code[20]	17-28	-
1002	Job Unit Price (LCY)	Decimal	17-28	-
1003	Job Total Price (LCY)	Decimal	17-28	-
1004	Job Quantity	Decimal	17-28	-
1005	Job Unit Cost (LCY)	Decimal	17-28	-
1006	Job Line Discount %	Decimal	17-28	-
1007	Job Line Disc. Amount (LCY)	Decimal	17-28	-
1008	Job Unit Of Measure Code	Code[10]	17-28	-
1009	Job Line Type	Enum Job Line Type	17-28	-
1010	Job Unit Price	Decimal	17-28	-
1011	Job Total Price	Decimal	17-28	-
1012	Job Unit Cost	Decimal	17-28	-
1013	Job Total Cost	Decimal	17-28	-
1014	Job Line Discount Amount	Decimal	17-28	-
1015	Job Line Amount	Decimal	17-28	-
1016	Job Total Cost (LCY)	Decimal	17-28	-
1017	Job Line Amount (LCY)	Decimal	17-28	-
1018	Job Currency Factor	Decimal	17-28	-
1019	Job Currency Code	Code[10]	17-28	-
1020	Job Planning Line No.	Integer	17-28	-
1030	Job Remaining Qty.	Decimal	17-28	-
1200	Direct Debit Mandate ID	Code[35]	17-28	-
1220	Data Exch. Entry No.	Integer	17-28	-
1221	Payer Information	Text[50]	17-28	-
1222	Transaction Information	Text[100]	17-28	-
1223	Data Exch. Line No.	Integer	17-28	-
1224	Applied Automatically	Boolean	17-28	-
1300	Linked Table ID	Integer	19-28	-
1301	Linked System ID	Guid	19-28	-
1700	Deferral Code	Code[10]	17-28	-
1701	Deferral Line No.	Integer	17-28	-
2676	Selected Alloc. Account No.	Code[20]	23-28	-
2677	Alloc. Acc. Modified by User	Boolean	23-28	-
2678	Allocation Account No.	Code[20]	23-28	-
2679	Alloc. Journal Line SystemId	Guid	27-28	-
5050	Campaign No.	Code[20]	17-28	-
5400	Prod. Order No.	Code[20]	17-28	-
5600	FA Posting Date	Date	17-28	-
5601	FA Posting Type	Enum Gen. Journal Line FA Posting Type	17-28	-
5602	Depreciation Book Code	Code[10]	17-28	-
5603	Salvage Value	Decimal	17-28	-
5604	No. of Depreciation Days	Integer	17-28	-
5605	Depr. until FA Posting Date	Boolean	17-28	-
5606	Depr. Acquisition Cost	Boolean	17-28	-
5609	Maintenance Code	Code[10]	17-28	-
5610	Insurance No.	Code[20]	17-28	-
5611	Budgeted FA No.	Code[20]	17-28	-
5612	Duplicate in Depreciation Book	Code[10]	17-28	-
5613	Use Duplication List	Boolean	17-28	-
5614	FA Reclassification Entry	Boolean	17-28	-
5615	FA Error Entry No.	Integer	17-28	-
5616	Index Entry	Boolean	17-28	-
5617	Source Line No.	Integer	17-28	-
5618	Comment	Text[250]	17-28	-
5701	Check Exported	Boolean	17-28	-
5702	Check Transmitted	Boolean	17-28	-
5703	Reverse Date Calculation	DateFormula	17-28	-
6200	Non-Deductible VAT %	Decimal	22-28	-
6201	Non-Deductible VAT Base	Decimal	22-28	-
6202	Non-Deductible VAT Amount	Decimal	22-28	-
6203	Non-Deductible VAT Base LCY	Decimal	22-28	-
6204	Non-Deductible VAT Amount LCY	Decimal	22-28	-
6205	Non-Deductible VAT Base ACY	Decimal	22-28	-
6206	Non-Deductible VAT Amount ACY	Decimal	22-28	-
6207	FA G/L Account No.	Code[20]	22-28	-
6208	Non-Deductible VAT Diff.	Decimal	22-28	-
6209	Bal. Non-Ded. VAT %	Decimal	22-28	-
6210	Bal. Non-Ded. VAT Base	Decimal	22-28	-
6211	Bal. Non-Ded. VAT Amount	Decimal	22-28	-
6212	Bal. Non-Ded. VAT Base LCY	Decimal	22-28	-
6213	Bal. Non-Ded. VAT Amount LCY	Decimal	22-28	-
6230	Non-Ded. VAT FA Cost	Boolean	25-28	-
8000	Id	Guid	17-25, gone	Removed 22.0
This functionality will be replaced by the systemID field
8001	Account Id	Guid	17-28	-
8002	Customer Id	Guid	17-28	-
8003	Applies-to Invoice Id	Guid	17-28	-
8004	Contact Graph Id	Text[250]	17-28	-
8005	Last Modified DateTime	DateTime	17-28	-
8006	Journal Batch Id	Guid	17-28	-
8007	Payment Method Id	Guid	17-28	-
8008	Balance Account Id	Guid	17-28	-
8009	Vendor Id	Guid	17-28	-