Human Resources table in Microsoft Dynamics 365 Business Central. 15 fields, 12 records in Cronus demo.
The Employee Relative table (ID 5205) is part of the Human Resources area in Microsoft Dynamics 365 Business Central. It contains 15 fields, with a primary key of Employee No., Line No., and includes 1 calculated FlowField. Use the reference below to explore every field, data type, and table relation.
The primary key uniquely identifies each record in this table. It consists of: Employee No., Line No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Employee No. PK | Code | Normal | → Employee #5200 |
| 2 | Line No. PK | Integer | Normal | |
| 3 | Relative Code | Code | Normal | → Relative #5204 |
| 4 | First Name | Text | Normal | |
| 5 | Middle Name | Text | Normal | |
| 6 | Last Name | Text | Normal | |
| 7 | Birth Date | Date | Normal | |
| 8 | Phone No. | Text | Normal | |
| 9 | Relative's Employee No. | Code | Normal | → Employee #5200 |
| 10 | Comment ⚡ FLOW | Boolean | 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 |
Tables referenced by fields on the Employee Relative table through TableRelation properties.