Human Resources table in Microsoft Dynamics 365 Business Central. 18 fields, 12 records in Cronus demo.
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 | Qualification Code | Code | Normal | → Qualification #5202 |
| 4 | From Date | Date | Normal | |
| 5 | To Date | Date | Normal | |
| 6 | Type | Option | Normal | |
| 7 | Description | Text | Normal | |
| 8 | Institution/Company | Text | Normal | |
| 9 | Cost | Decimal | Normal | |
| 10 | Course Grade | Text | Normal | |
| 11 | Employee Status | Option | Normal | |
| 12 | Comment ⚡ FLOW | Boolean | FlowField | |
| 13 | Expiration Date | Date | Normal | |
| 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 Qualification table through TableRelation properties.