Res. Journal Line #207

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

The Res. Journal Line table (ID 207) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 46 fields, with a primary key of Journal Template Name, Line No., Journal Batch Name. Use the reference below to explore every field, data type, and table relation.

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 (46)

Res. Journal Line — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Journal Template Name PK	Code	Normal	→ Res. Journal Template #206
2	Line No. PK	Integer	Normal
3	Entry Type	Option	Normal
4	Document No.	Code	Normal
5	Posting Date	Date	Normal
6	Resource No.	Code	Normal	→ Resource #156
7	Resource Group No.	Code	Normal	→ Resource Group #152
8	Description	Text	Normal
9	Work Type Code	Code	Normal	→ Work Type #200
10	Project No.	Code	Normal	→ Job #167
11	Unit of Measure Code	Code	Normal	→ Resource Unit of Measure #205
12	Quantity	Decimal	Normal
13	Direct Unit Cost	Decimal	Normal
14	Unit Cost	Decimal	Normal
15	Total Cost	Decimal	Normal
16	Unit Price	Decimal	Normal
17	Total Price	Decimal	Normal
18	Shortcut Dimension 1 Code	Code	Normal	→ Dimension Value #349
19	Shortcut Dimension 2 Code	Code	Normal	→ Dimension Value #349
21	Source Code	Code	Normal	→ Source Code #230
23	Journal Batch Name PK	Code	Normal	→ Res. Journal Batch #236
24	Reason Code	Code	Normal	→ Reason Code #231
25	Recurring Method	Option	Normal
26	Expiration Date	Date	Normal
27	Recurring Frequency	DateFormula	Normal
28	Gen. Bus. Posting Group	Code	Normal	→ Gen. Business Posting Group #250
29	Gen. Prod. Posting Group	Code	Normal	→ Gen. Product Posting Group #251
30	Document Date	Date	Normal
31	External Document No.	Code	Normal
32	Posting No. Series	Code	Normal	→ No. Series #308
33	Source Type	Option	Normal
34	Source No.	Code	Normal
35	Qty. per Unit of Measure	Decimal	Normal
90	Order Type	Option	Normal
91	Order No.	Code	Normal
92	Order Line No.	Integer	Normal
480	Dimension Set ID	Integer	Normal	→ Dimension Set Entry #480
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
959	System-Created Entry	Boolean	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