Posted Gen. Journal Line #181

Other table in Microsoft Dynamics 365 Business Central. 204 fields, 4 records in Cronus demo.

204

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: Line No..

All fields (204)

Posted Gen. Journal Line — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Journal Template Name	Code	Normal
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
29	Source Code	Code	Normal	→ Source Code #230
30	System-Created Entry	Boolean	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	Code	Normal	→ Posted Gen. Journal Batch #182
52	Reason Code	Code	Normal	→ Reason Code #231
53	Recurring Method	Option	Normal
54	Expiration Date	Date	Normal
55	Recurring Frequency	DateFormula	Normal
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
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
288	Recipient Bank Account	Code	Normal
289	Message to Recipient	Text	Normal
290	Exported to Payment File	Boolean	Normal
480	Dimension Set ID	Integer	Normal	→ Dimension Set Entry #480
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
1700	Deferral Code	Code	Normal	→ Deferral Template #1700
1701	Deferral Line No.	Integer	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
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
6208	Non-Deductible VAT Difference	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
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 Header #112
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
8010	G/L Register No.	Integer	Normal	→ G/L Register #45
8011	Indentation	Integer	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