Res. Journal Line #207

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

46
Fields
0
Records
3
Primary key
0
FlowFields
20
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.FIELDTYPECLASSRELATION
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

Related tables (18)

Tables referenced by fields on the Res. Journal Line table through TableRelation properties.

Res. Journal Template
#206 · Other · via Journal Template Name
Resource
#156 · Other · via Resource No.
Resource Group
#152 · Other · via Resource Group No.
Work Type
#200 · Other · via Work Type Code
Job
#167 · Other · via Project No.
Resource Unit of Measure
#205 · Other · via Unit of Measure Code
Dimension Value
#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code
Source Code
#230 · Other · via Source Code
Res. Journal Batch
#236 · Other · via Journal Batch Name
Reason Code
#231 · Other · via Reason Code
Gen. Business Posting Group
#250 · Other · via Gen. Bus. Posting Group
Gen. Product Posting Group
#251 · Other · via Gen. Prod. Posting Group
No. Series
#308 · Other · via Posting No. Series
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID
Time Sheet Header
#950 · Other · via Time Sheet No.
Time Sheet Line
#951 · Other · via Time Sheet Line No.
Time Sheet Detail
#952 · Other · via Time Sheet Date