Employee #5200

Human Resources table in Microsoft Dynamics 365 Business Central. 83 fields, 7 records in Cronus demo.

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: No..

All fields (83)

Employee — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	No. PK	Code	Normal
2	First Name	Text	Normal
3	Middle Name	Text	Normal
4	Last Name	Text	Normal
5	Initials	Text	Normal
6	Job Title	Text	Normal
7	Search Name	Code	Normal
8	Address	Text	Normal
9	Address 2	Text	Normal
10	City	Text	Normal
11	Post Code	Code	Normal
12	County	Text	Normal
13	Phone No.	Text	Normal
14	Mobile Phone No.	Text	Normal
15	Email	Text	Normal
16	Alt. Address Code	Code	Normal	→ Alternative Address #5201
17	Alt. Address Start Date	Date	Normal
18	Alt. Address End Date	Date	Normal
20	Birth Date	Date	Normal
21	Social Security No.	Text	Normal
22	Union Code	Code	Normal	→ Union #5209
23	Union Membership No.	Text	Normal
24	Gender	Option	Normal
25	Country/Region Code	Code	Normal	→ Country/Region #9
26	Manager No.	Code	Normal	→ Employee #5200
27	Emplymt. Contract Code	Code	Normal	→ Employment Contract #5211
28	Statistics Group Code	Code	Normal	→ Employee Statistics Group #5212
29	Employment Date	Date	Normal
31	Status	Option	Normal
32	Inactive Date	Date	Normal
33	Cause of Inactivity Code	Code	Normal	→ Cause of Inactivity #5210
34	Termination Date	Date	Normal
35	Grounds for Term. Code	Code	Normal	→ Grounds for Termination #5217
36	Global Dimension 1 Code	Code	Normal	→ Dimension Value #349
37	Global Dimension 2 Code	Code	Normal	→ Dimension Value #349
38	Resource No.	Code	Normal	→ Resource #156
39	Comment ⚡ FLOW	Boolean	FlowField
40	Last Date Modified	Date	Normal
41	Date Filter	Date	FlowFilter
42	Global Dimension 1 Filter	Code	FlowFilter	→ Dimension Value #349
43	Global Dimension 2 Filter	Code	FlowFilter	→ Dimension Value #349
44	Cause of Absence Filter	Code	FlowFilter	→ Cause of Absence #5206
45	Total Absence (Base) ⚡ FLOW	Decimal	FlowField
46	Extension	Text	Normal
47	Employee No. Filter	Code	FlowFilter	→ Employee #5200
48	Pager	Text	Normal
49	Fax No.	Text	Normal
50	Company Email	Text	Normal
51	Title	Text	Normal
52	Salespers./Purch. Code	Code	Normal	→ Salesperson/Purchaser #13
53	No. Series	Code	Normal	→ No. Series #308
54	Last Modified Date Time	DateTime	Normal
55	Employee Posting Group	Code	Normal	→ Employee Posting Group #5221
56	Bank Branch No.	Text	Normal
57	Bank Account No.	Text	Normal
58	IBAN	Code	Normal
59	Balance ⚡ FLOW	Decimal	FlowField
60	SWIFT Code	Code	Normal	→ SWIFT Code #1210
70	Balance (LCY) ⚡ FLOW	Decimal	FlowField
75	Currency Code	Code	Normal	→ Currency #4
80	Application Method	Option	Normal
90	Currency Filter	Code	FlowFilter	→ Currency #4
100	Engagement Type	Option	Normal
101	Collective Bargaining Agreement Info	Boolean	Normal
102	Board Member	Boolean	Normal
103	Manager Role	Boolean	Normal
104	Payroll	Decimal	Normal
105	Payroll Currency Code	Code	Normal	→ Currency #4
106	Payroll (LCY)	Decimal	Normal
107	Payroll Currency Factor	Decimal	Normal
108	Nationality	Code	Normal	→ Nationality #5226
109	Working Type	Option	Normal
110	Working Hours	Decimal	Normal
140	Image	Media	Normal
150	Privacy Blocked	Boolean	Normal
175	Allow Multiple Posting Groups	Boolean	Normal
1100	Cost Center Code	Code	Normal	→ Cost Center #1112
1101	Cost Object Code	Code	Normal	→ Cost Object #1113
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