Job Journal Line #210

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

100

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., Journal Batch Name.

All fields (100)

Job Journal Line — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Journal Template Name PK	Code	Normal	→ Job Journal Template #209
2	Line No. PK	Integer	Normal
3	Project No.	Code	Normal	→ Job #167
4	Posting Date	Date	Normal
5	Document No.	Code	Normal
6	Type	Option	Normal
8	No.	Code	Normal
9	Description	Text	Normal
10	Quantity	Decimal	Normal
12	Direct Unit Cost (LCY)	Decimal	Normal
13	Unit Cost (LCY)	Decimal	Normal
14	Total Cost (LCY)	Decimal	Normal
15	Unit Price (LCY)	Decimal	Normal
16	Total Price (LCY)	Decimal	Normal
17	Resource Group No.	Code	Normal	→ Resource Group #152
18	Unit of Measure Code	Code	Normal
19	Qty. Rounding Precision	Decimal	Normal
20	Qty. Rounding Precision (Base)	Decimal	Normal
21	Location Code	Code	Normal	→ Location #14
22	Chargeable	Boolean	Normal
30	Posting Group	Code	Normal
31	Shortcut Dimension 1 Code	Code	Normal	→ Dimension Value #349
32	Shortcut Dimension 2 Code	Code	Normal	→ Dimension Value #349
33	Work Type Code	Code	Normal	→ Work Type #200
34	Customer Price Group	Code	Normal	→ Customer Price Group #6
37	Applies-to Entry	Integer	Normal
40	Shpt. Method Code	Code	Normal	→ Shipment Method #10
61	Entry Type	Option	Normal
62	Source Code	Code	Normal	→ Source Code #230
73	Journal Batch Name PK	Code	Normal	→ Job Journal Batch #237
74	Reason Code	Code	Normal	→ Reason Code #231
75	Recurring Method	Option	Normal
76	Expiration Date	Date	Normal
77	Recurring Frequency	DateFormula	Normal
79	Gen. Bus. Posting Group	Code	Normal	→ Gen. Business Posting Group #250
80	Gen. Prod. Posting Group	Code	Normal	→ Gen. Product Posting Group #251
81	Transaction Type	Code	Normal	→ Transaction Type #258
82	Transport Method	Code	Normal	→ Transport Method #259
83	Country/Region Code	Code	Normal	→ Country/Region #9
86	Entry/Exit Point	Code	Normal	→ Entry/Exit Point #282
87	Document Date	Date	Normal
88	External Document No.	Code	Normal
89	Area	Code	Normal	→ Area #284
90	Transaction Specification	Code	Normal	→ Transaction Specification #285
91	Serial No.	Code	Normal
92	Posting No. Series	Code	Normal	→ No. Series #308
93	Source Currency Code	Code	Normal	→ Currency #4
94	Source Currency Total Cost	Decimal	Normal
95	Source Currency Total Price	Decimal	Normal
96	Source Currency Line Amount	Decimal	Normal
480	Dimension Set ID	Integer	Normal	→ Dimension Set Entry #480
902	Assemble to Order	Boolean	Normal
950	Time Sheet No.	Code	Normal	→ Time Sheet Header #950
951	Time Sheet Line No.	Integer	Normal	→ Time Sheet Line #951
952	Time Sheet Date	Date	Normal	→ Time Sheet Detail #952
1000	Project Task No.	Code	Normal	→ Job Task #1001
1001	Total Cost	Decimal	Normal
1002	Unit Price	Decimal	Normal
1003	Line Type	Option	Normal
1004	Applies-from Entry	Integer	Normal
1005	Project Posting Only	Boolean	Normal
1006	Line Discount %	Decimal	Normal
1007	Line Discount Amount	Decimal	Normal
1008	Currency Code	Code	Normal	→ Currency #4
1009	Line Amount	Decimal	Normal
1010	Currency Factor	Decimal	Normal
1011	Unit Cost	Decimal	Normal
1012	Line Amount (LCY)	Decimal	Normal
1013	Line Discount Amount (LCY)	Decimal	Normal
1014	Total Price	Decimal	Normal
1015	Cost Factor	Decimal	Normal
1016	Description 2	Text	Normal
1017	Ledger Entry Type	Option	Normal
1018	Ledger Entry No.	Integer	Normal
1019	Project Planning Line No.	Integer	Normal
1030	Remaining Qty.	Decimal	Normal
1031	Remaining Qty. (Base)	Decimal	Normal
1081	Qty. to Transfer to Invoice	Decimal	Normal
5402	Variant Code	Code	Normal
5403	Bin Code	Code	Normal
5404	Qty. per Unit of Measure	Decimal	Normal
5410	Quantity (Base)	Decimal	Normal
5468	Reserved Qty. (Base) ⚡ FLOW	Decimal	FlowField
5900	Service Order No.	Code	Normal
5901	Posted Service Shipment No.	Code	Normal
6210	Sustainability Account No.	Code	Normal	→ Sustainability Account #6210
6211	Sustainability Account Name	Text	Normal
6212	Sustainability Account Category	Code	Normal	→ Sustain. Account Category #6211
6213	Sustainability Account Subcategory	Code	Normal	→ Sustain. Account Subcategory #6212
6214	CO2e per Unit	Decimal	Normal
6215	Total CO2e	Decimal	Normal
6501	Lot No.	Code	Normal
6515	Package No.	Code	Normal
7000	Price Calculation Method	Option	Normal
7001	Cost Calculation Method	Option	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