Employee Ledger Entry #5222

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

The Employee Ledger Entry table (ID 5222) is part of the Human Resources area in Microsoft Dynamics 365 Business Central. It contains 66 fields, with a primary key of Entry No., and includes 16 calculated FlowFields. 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: Entry No..

All fields (66)

Employee Ledger Entry — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
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