Employee Ledger Entry #5222

Human Resources table in Microsoft Dynamics 365 Business Central. 66 fields, 0 records in Cronus demo.

66
Fields
0
Records
1
Primary key
16
FlowFields
18
Relations
Open in Data Explorer →

Primary key

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

All fields (66)

Employee Ledger Entry — FIELDS
NO.FIELDTYPECLASSRELATION
1 Entry No. PK Integer Normal
3 Employee No. Code Normal → Employee #5200
4 Posting Date Date Normal
5 Document Type Option Normal
6 Document No. Code Normal
7 Description Text Normal
11 Currency Code Code Normal → Currency #4
13 Amount ⚡ FLOW Decimal FlowField
14 Remaining Amount ⚡ FLOW Decimal FlowField
15 Original Amt. (LCY) ⚡ FLOW Decimal FlowField
16 Remaining Amt. (LCY) ⚡ FLOW Decimal FlowField
17 Amount (LCY) ⚡ FLOW Decimal FlowField
22 Employee Posting Group Code Normal → Employee Posting Group #5221
23 Global Dimension 1 Code Code Normal → Dimension Value #349
24 Global Dimension 2 Code Code Normal → Dimension Value #349
25 Salespers./Purch. Code Code Normal → Salesperson/Purchaser #13
27 User ID Code Normal
28 Source Code Code Normal → Source Code #230
34 Applies-to Doc. Type Option Normal
35 Applies-to Doc. No. Code Normal
36 Open Boolean Normal
43 Positive Boolean Normal
44 Closed by Entry No. Integer Normal → Employee Ledger Entry #5222
45 Closed at Date Date Normal
46 Closed by Amount Decimal Normal
47 Applies-to ID Code Normal
48 Journal Template Name Code Normal
49 Journal Batch Name Code Normal
50 Reason Code Code Normal → Reason Code #231
51 Bal. Account Type Option Normal
52 Bal. Account No. Code Normal
53 Transaction No. Integer Normal
54 Closed by Amount (LCY) Decimal Normal
58 Debit Amount ⚡ FLOW Decimal FlowField
59 Credit Amount ⚡ FLOW Decimal FlowField
60 Debit Amount (LCY) ⚡ FLOW Decimal FlowField
61 Credit Amount (LCY) ⚡ FLOW Decimal FlowField
64 No. Series Code Normal → No. Series #308
65 Closed by Currency Code Code Normal → Currency #4
66 Closed by Currency Amount Decimal Normal
73 Adjusted Currency Factor Decimal Normal
74 Original Currency Factor Decimal Normal
75 Original Amount ⚡ FLOW Decimal FlowField
76 Date Filter Date FlowFilter
84 Amount to Apply Decimal Normal
86 Applying Entry Boolean Normal
87 Reversed Boolean Normal
88 Reversed by Entry No. Integer Normal → Employee Ledger Entry #5222
89 Reversed Entry No. Integer Normal → Employee Ledger Entry #5222
170 Creditor No. Code Normal
171 Payment Reference Code Normal
172 Payment Method Code Code Normal → Payment Method #289
289 Message to Recipient Text Normal
290 Exported to Payment File Boolean 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 (12)

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

Employee
#5200 · Human Resources · via Employee No.
Currency
#4 · General Ledger · via Currency Code, Closed by Currency Code
Employee Posting Group
#5221 · Human Resources · via Employee Posting Group
Dimension Value
#349 · Dimensions · via Global Dimension 1 Code, Global Dimension 2 Code
Salesperson/Purchaser
#13 · General Ledger · via Salespers./Purch. Code
Source Code
#230 · Other · via Source Code
Employee Ledger Entry
#5222 · Human Resources · via Closed by Entry No., Reversed by Entry No., Reversed Entry No.
Reason Code
#231 · Other · via Reason Code
No. Series
#308 · Other · via No. Series
Payment Method
#289 · Other · via Payment Method Code
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID