Objects/Tables/Table 181 Posted Gen. Journal Line

Table 181 Posted Gen. Journal Line in 21

Jonas Paprotka, Base Application 21.5.53619.63803, checked 2026-09-20

App: Base Application

Fields, 180 Keys, 3 Procedures, 1 Events, 2

Versions17 18 19 202122 23 24 25 26 27 28 latest

Source29

Fields, 180

Id	Name	Type	Obsolete
1	Journal Template Name	Code[10]	-
2	Line No.	Integer	-
3	Account Type	Enum Gen. Journal Account Type	-
4	Account No.	Code[20]	-
5	Posting Date	Date	-
6	Document Type	Enum Gen. Journal Document Type	-
7	Document No.	Code[20]	-
8	Description	Text[100]	-
10	VAT %	Decimal	-
11	Bal. Account No.	Code[20]	-
12	Currency Code	Code[10]	-
13	Amount	Decimal	-
14	Debit Amount	Decimal	-
15	Credit Amount	Decimal	-
16	Amount (LCY)	Decimal	-
17	Balance (LCY)	Decimal	-
18	Currency Factor	Decimal	-
19	Sales/Purch. (LCY)	Decimal	-
20	Profit (LCY)	Decimal	-
21	Inv. Discount (LCY)	Decimal	-
22	Bill-to/Pay-to No.	Code[20]	-
23	Posting Group	Code[20]	-
24	Shortcut Dimension 1 Code	Code[20]	-
25	Shortcut Dimension 2 Code	Code[20]	-
26	Salespers./Purch. Code	Code[20]	-
29	Source Code	Code[10]	-
30	System-Created Entry	Boolean	-
34	On Hold	Code[3]	-
35	Applies-to Doc. Type	Enum Gen. Journal Document Type	-
36	Applies-to Doc. No.	Code[20]	-
38	Due Date	Date	-
39	Pmt. Discount Date	Date	-
40	Payment Discount %	Decimal	-
42	Job No.	Code[20]	-
43	Quantity	Decimal	-
44	VAT Amount	Decimal	-
45	VAT Posting	Option	-
47	Payment Terms Code	Code[10]	-
48	Applies-to ID	Code[50]	-
50	Business Unit Code	Code[20]	-
51	Journal Batch Name	Code[10]	-
52	Reason Code	Code[10]	-
53	Recurring Method	Enum Gen. Journal Recurring Method	-
54	Expiration Date	Date	-
55	Recurring Frequency	DateFormula	-
57	Gen. Posting Type	Enum General Posting Type	-
58	Gen. Bus. Posting Group	Code[20]	-
59	Gen. Prod. Posting Group	Code[20]	-
60	VAT Calculation Type	Enum Tax Calculation Type	-
61	EU 3-Party Trade	Boolean	-
62	Allow Application	Boolean	-
63	Bal. Account Type	Enum Gen. Journal Account Type	-
64	Bal. Gen. Posting Type	Enum General Posting Type	-
65	Bal. Gen. Bus. Posting Group	Code[20]	-
66	Bal. Gen. Prod. Posting Group	Code[20]	-
67	Bal. VAT Calculation Type	Enum Tax Calculation Type	-
68	Bal. VAT %	Decimal	-
69	Bal. VAT Amount	Decimal	-
70	Bank Payment Type	Enum Bank Payment Type	-
71	VAT Base Amount	Decimal	-
72	Bal. VAT Base Amount	Decimal	-
73	Correction	Boolean	-
74	Print Posted Documents	Boolean	-
75	Check Printed	Boolean	-
76	Document Date	Date	-
77	External Document No.	Code[35]	-
78	Source Type	Enum Gen. Journal Source Type	-
79	Source No.	Code[20]	-
80	Posting No. Series	Code[20]	-
82	Tax Area Code	Code[20]	-
83	Tax Liable	Boolean	-
84	Tax Group Code	Code[20]	-
85	Use Tax	Boolean	-
86	Bal. Tax Area Code	Code[20]	-
87	Bal. Tax Liable	Boolean	-
88	Bal. Tax Group Code	Code[20]	-
89	Bal. Use Tax	Boolean	-
90	VAT Bus. Posting Group	Code[20]	-
91	VAT Prod. Posting Group	Code[20]	-
92	Bal. VAT Bus. Posting Group	Code[20]	-
93	Bal. VAT Prod. Posting Group	Code[20]	-
95	Additional-Currency Posting	Option	-
98	FA Add.-Currency Factor	Decimal	-
99	Source Currency Code	Code[10]	-
100	Source Currency Amount	Decimal	-
101	Source Curr. VAT Base Amount	Decimal	-
102	Source Curr. VAT Amount	Decimal	-
103	VAT Base Discount %	Decimal	-
104	VAT Amount (LCY)	Decimal	-
105	VAT Base Amount (LCY)	Decimal	-
106	Bal. VAT Amount (LCY)	Decimal	-
107	Bal. VAT Base Amount (LCY)	Decimal	-
108	Reversing Entry	Boolean	-
109	Allow Zero-Amount Posting	Boolean	-
110	Ship-to/Order Address Code	Code[10]	-
111	VAT Difference	Decimal	-
112	Bal. VAT Difference	Decimal	-
113	IC Partner Code	Code[20]	-
114	IC Direction	Enum IC Direction Type	-
116	IC Partner G/L Acc. No.	Code[20]	-
117	IC Partner Transaction No.	Integer	-
118	Sell-to/Buy-from No.	Code[20]	-
119	VAT Registration No.	Text[20]	-
120	Country/Region Code	Code[10]	-
121	Prepayment	Boolean	-
122	Financial Void	Boolean	-
123	Copy VAT Setup to Jnl. Lines	Boolean	-
125	VAT Base Before Pmt. Disc.	Decimal	-
126	Orig. Pmt. Disc. Possible	Decimal	-
127	Orig. Pmt. Disc. Possible(LCY)	Decimal	-
160	Job Queue Status	Option	-
161	Job Queue Entry ID	Guid	-
165	Incoming Document Entry No.	Integer	-
170	Creditor No.	Code[20]	-
171	Payment Reference	Code[50]	-
172	Payment Method Code	Code[10]	-
173	Applies-to Ext. Doc. No.	Code[35]	-
288	Recipient Bank Account	Code[20]	-
289	Message to Recipient	Text[140]	-
290	Exported to Payment File	Boolean	-
480	Dimension Set ID	Integer	-
1001	Job Task No.	Code[20]	-
1002	Job Unit Price (LCY)	Decimal	-
1003	Job Total Price (LCY)	Decimal	-
1004	Job Quantity	Decimal	-
1005	Job Unit Cost (LCY)	Decimal	-
1006	Job Line Discount %	Decimal	-
1007	Job Line Disc. Amount (LCY)	Decimal	-
1008	Job Unit Of Measure Code	Code[10]	-
1009	Job Line Type	Enum Job Line Type	-
1010	Job Unit Price	Decimal	-
1011	Job Total Price	Decimal	-
1012	Job Unit Cost	Decimal	-
1013	Job Total Cost	Decimal	-
1014	Job Line Discount Amount	Decimal	-
1015	Job Line Amount	Decimal	-
1016	Job Total Cost (LCY)	Decimal	-
1017	Job Line Amount (LCY)	Decimal	-
1018	Job Currency Factor	Decimal	-
1019	Job Currency Code	Code[10]	-
1020	Job Planning Line No.	Integer	-
1030	Job Remaining Qty.	Decimal	-
1200	Direct Debit Mandate ID	Code[35]	-
1220	Data Exch. Entry No.	Integer	-
1221	Payer Information	Text[50]	-
1222	Transaction Information	Text[100]	-
1223	Data Exch. Line No.	Integer	-
1224	Applied Automatically	Boolean	-
1700	Deferral Code	Code[10]	-
1701	Deferral Line No.	Integer	-
5050	Campaign No.	Code[20]	-
5400	Prod. Order No.	Code[20]	-
5600	FA Posting Date	Date	-
5601	FA Posting Type	Enum Gen. Journal Line FA Posting Type	-
5602	Depreciation Book Code	Code[10]	-
5603	Salvage Value	Decimal	-
5604	No. of Depreciation Days	Integer	-
5605	Depr. until FA Posting Date	Boolean	-
5606	Depr. Acquisition Cost	Boolean	-
5609	Maintenance Code	Code[10]	-
5610	Insurance No.	Code[20]	-
5611	Budgeted FA No.	Code[20]	-
5612	Duplicate in Depreciation Book	Code[10]	-
5613	Use Duplication List	Boolean	-
5614	FA Reclassification Entry	Boolean	-
5615	FA Error Entry No.	Integer	-
5616	Index Entry	Boolean	-
5617	Source Line No.	Integer	-
5618	Comment	Text[250]	-
5701	Check Exported	Boolean	-
5702	Check Transmitted	Boolean	-
8001	Account Id	Guid	-
8002	Customer Id	Guid	-
8003	Applies-to Invoice Id	Guid	-
8004	Contact Graph Id	Text[250]	-
8005	Last Modified DateTime	DateTime	-
8006	Journal Batch Id	Guid	-
8007	Payment Method Id	Guid	-
8010	G/L Register No.	Integer	-
8011	Indentation	Integer	-

Keys, 3

Name	Fields	Obsolete
Key1	Line No.	-
Key2, clustered	Journal Template Name, Journal Batch Name, Line No.	-
Key3	G/L Register No.	-

Procedures, 1

Name	Parameters	Returns	Access	Obsolete
InsertFromGenJournalLine	(Record Gen. Journal Line, Integer, Boolean)		public	-

Events, 2

Kind	Name	Parameters	Obsolete
Integration event	OnBeforeInsertFromGenJournalLine	(Record Gen. Journal Line, var Boolean)	-
Integration event	OnAfterInsertFromGenJournalLine	(Record Gen. Journal Line)	-