Diagrams

Table

Calendar Entry

DynamicsDocs.comCalendar Entry«Table 99000757»Calendar EntryCapacity Type; [Work Center,Machine Ce...No. [PK,NN]Date [PK,NN]Work Shift Code [PK,NN]Starting Time [PK,NN]Ending Time [PK,NN]Work Center No.Work Center Group CodeCapacity [Total]Capacity [Effective]EfficiencyCapacityAbsence EfficiencyAbsence CapacityStarting Date-TimeEnding Date-Time«Table 99000754»Work CenterNo. [PK]NameSearch NameName 2AddressAddress 2CityPost CodeAlternate Work CenterWork Center Group CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeSubcontractor No.Direct Unit CostIndirect Cost %Unit CostQueue TimeQueue Time Unit of Meas. CodeLast Date ModifiedCommentUnit of Measure CodeCapacityEfficiencyMaximum EfficiencyMinimum EfficiencyCalendar Rounding Precision [NN]Simulation Type; [Moves,Moves When Nec...Shop Calendar CodeBlockedDate FilterWork Shift Filter...«Table 99000758»Machine CenterNo. [PK]NameSearch NameName 2AddressAddress 2CityPost CodeWork Center No.Direct Unit CostIndirect Cost %Unit CostQueue TimeQueue Time Unit of Meas. CodeLast Date ModifiedCommentCapacityEfficiencyMaximum EfficiencyMinimum EfficiencyBlockedDate FilterWork Shift FilterCapacity [Total]Capacity [Effective]Prod. Order Need [Qty.]Prod. Order Need AmountProd. Order Status Filter; [Simulated,...Setup TimeWait TimeMove Time...«Table 99000750»Work ShiftCode [PK,NN]Description«Table 99000756»Work Center GroupCode [PK,NN]NameDate FilterWork Shift FilterCapacity [Total]Capacity [Effective]Prod. Order Need [Qty.]Prod. Order Status Filter; [Simulated,...<No.><Work Center No.><No.><Work Shift Code><Work Center Group Code><Alternate Work Center><Work Center Group Code><Work Shift Filter><Work Center No.><Work Shift Filter><Work Shift Filter>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Capacity Type (Capacity Type) Option
2 No. (No.) Code20 NotBlank: Yes
4 Date (Date) Date NotBlank: Yes
5 Work Shift Code (Work Shift Code) Code10 NotBlank: Yes
6 Starting Time (Starting Time) Time NotBlank: Yes
7 Ending Time (Ending Time) Time NotBlank: Yes
8 Work Center No. (Work Center No.) Code20 Editable: No
9 Work Center Group Code (Work Center Group Code) Code10 Editable: No
10 Capacity (Total) (Capacity (Total)) Decimal (0:5) Editable: No
11 Capacity (Effective) (Capacity (Effective)) Decimal (0:5) Editable: No
20 Efficiency (Efficiency) Decimal (0:5)
21 Capacity (Capacity) Decimal (0:5)
22 Absence Efficiency (Absence Efficiency) Decimal (0:5) Editable: No
23 Absence Capacity (Absence Capacity) Decimal (0:5) Editable: No
24 Starting Date-Time (Starting Date-Time) DateTime
25 Ending Date-Time (Ending Date-Time) DateTime

Keys

# Fields
0 Capacity Type,No.,Date,Starting Time,Ending Time,Work Shift Code (Capacity Type,No.,Date,Starting Time,Ending Time,Work Shift Code) Clustered: Yes
1 Work Center No.,Date,Work Shift Code (Work Center No.,Date,Work Shift Code)
2 Work Center Group Code,Date,Work Shift Code (Work Center Group Code,Date,Work Shift Code)
3 Capacity Type,No.,Starting Date-Time,Ending Date-Time,Absence Capacity (Capacity Type,No.,Starting Date-Time,Ending Date-Time,Absence Capacity)
4 Capacity Type,No.,Ending Date-Time,Starting Date-Time (Capacity Type,No.,Ending Date-Time,Starting Date-Time)

Table Relations To Other Tables

Field Related Table Related Field
No. (No.) Machine Center No. (No.) 1..n
Work Center No. (Work Center No.) Work Center No. (No.) 1..n
Work Center Group Code (Work Center Group Code) Work Center Group Code (Code) 1..n
Work Shift Code (Work Shift Code) Work Shift Code (Code) 1..n

Table Relations From Other Tables

From Table From Field