Calendar Entry #99000757

Manufacturing table in Microsoft Dynamics 365 Business Central. 21 fields, 14,094 records in Cronus demo.

21
Fields
14,094
Records
6
Primary key
0
FlowFields
5
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Capacity Type, No., Date, Work Shift Code, Starting Time, Ending Time.

All fields (21)

Calendar Entry — FIELDS
NO.FIELDTYPECLASSRELATION
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

Related tables (4)

Tables referenced by fields on the Calendar Entry table through TableRelation properties.

Work Shift
#99000750 · Manufacturing · via Work Shift Code
Work Center
#99000754 · Manufacturing · via Work Center No.
Work Center Group
#99000756 · Manufacturing · via Work Center Group Code