Res. Ledger Entry #203

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

48
Fields
0
Records
1
Primary key
6
FlowFields
17
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Entry No..

All fields (48)

Res. Ledger Entry — FIELDS
NO.FIELDTYPECLASSRELATION
1 Entry No. PK Integer Normal
2 Entry Type Option Normal
3 Document No. Code Normal
4 Posting Date Date Normal
5 Resource No. Code Normal → Resource #156
6 Resource Group No. Code Normal → Resource Group #152
7 Description Text Normal
8 Work Type Code Code Normal → Work Type #200
9 Project No. Code Normal → Job #167
10 Unit of Measure Code Code Normal → Unit of Measure #204
11 Quantity Decimal Normal
12 Direct Unit Cost Decimal Normal
13 Unit Cost Decimal Normal
14 Total Cost Decimal Normal
15 Unit Price Decimal Normal
16 Total Price Decimal Normal
17 Global Dimension 1 Code Code Normal → Dimension Value #349
18 Global Dimension 2 Code Code Normal → Dimension Value #349
20 User ID Code Normal
21 Source Code Code Normal → Source Code #230
22 Chargeable Boolean Normal
23 Journal Batch Name Code Normal
24 Reason Code Code Normal → Reason Code #231
25 Gen. Bus. Posting Group Code Normal → Gen. Business Posting Group #250
26 Gen. Prod. Posting Group Code Normal → Gen. Product Posting Group #251
27 Document Date Date Normal
28 External Document No. Code Normal
29 No. Series Code Normal → No. Series #308
30 Source Type Option Normal
31 Source No. Code Normal
32 Qty. per Unit of Measure Decimal Normal
33 Quantity (Base) Decimal Normal
34 Resource Register No. Integer Normal → Resource Register #240
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
481 Shortcut Dimension 3 Code ⚡ FLOW Code FlowField
482 Shortcut Dimension 4 Code ⚡ FLOW Code FlowField
483 Shortcut Dimension 5 Code ⚡ FLOW Code FlowField
484 Shortcut Dimension 6 Code ⚡ FLOW Code FlowField
485 Shortcut Dimension 7 Code ⚡ FLOW Code FlowField
486 Shortcut Dimension 8 Code ⚡ FLOW Code FlowField
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 (14)

Tables referenced by fields on the Res. Ledger Entry table through TableRelation properties.

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.
Unit of Measure
#204 · Other · via Unit of Measure Code
Dimension Value
#349 · Dimensions · via Global Dimension 1 Code, Global Dimension 2 Code
Source Code
#230 · Other · via Source Code
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 No. Series
Resource Register
#240 · Other · via Resource Register No.
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID