Manufacturing table in Microsoft Dynamics 365 Business Central. 21 fields, 14,094 records in Cronus demo.
The primary key uniquely identifies each record in this table. It consists of: Capacity Type, No., Date, Work Shift Code, Starting Time, Ending Time.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Capacity Type PK | Option | Normal | |
| 2 | No. PK | Code | Normal | |
| 4 | Date PK | Date | Normal | |
| 5 | Work Shift Code PK | Code | Normal | → Work Shift #99000750 |
| 6 | Starting Time PK | Time | Normal | |
| 7 | Ending Time PK | Time | Normal | |
| 8 | Work Center No. | Code | Normal | → Work Center #99000754 |
| 9 | Work Center Group Code | Code | Normal | → Work Center Group #99000756 |
| 10 | Capacity (Total) | Decimal | Normal | |
| 11 | Capacity (Effective) | Decimal | Normal | |
| 20 | Efficiency | Decimal | Normal | |
| 21 | Capacity | Decimal | Normal | |
| 22 | Absence Efficiency | Decimal | Normal | |
| 23 | Absence Capacity | Decimal | Normal | |
| 24 | Starting Date-Time | DateTime | Normal | |
| 25 | Ending Date-Time | DateTime | 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 Calendar Entry table through TableRelation properties.