Manufacturing table in Microsoft Dynamics 365 Business Central. 21 fields, 14,094 records in Cronus demo.
The Calendar Entry table (ID 99000757) is part of the Manufacturing area in Microsoft Dynamics 365 Business Central. It contains 21 fields, with a primary key of Capacity Type, No., Date, Work Shift Code, Starting Time, Ending Time. 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: 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.