Diagrams

Table

Calendar Absence Entry

DynamicsDocs.comCalendar Absence Entry«Table 99000760»Calendar Absence EntryCapacity Type; [Work Center,Machine Ce...No. [PK,NN]Date [PK,NN]Starting Time [PK]Ending Time [PK]Work Center No.Work Center Group CodeCapacityStarting Date-TimeEnding Date-TimeDescriptionUpdated«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 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 Center Group Code><Alternate Work Center><Work Center Group Code><Work Center No.>

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 Editable: No
2 No. (No.) Code20 NotBlank: Yes
4 Date (Date) Date NotBlank: Yes
6 Starting Time (Starting Time) Time
7 Ending Time (Ending Time) Time
8 Work Center No. (Work Center No.) Code20 Editable: No
9 Work Center Group Code (Work Center Group Code) Code10 Editable: No
21 Capacity (Capacity) Decimal (0:5)
24 Starting Date-Time (Starting Date-Time) DateTime
25 Ending Date-Time (Ending Date-Time) DateTime
31 Description (Description) Text50
32 Updated (Updated) Boolean Editable: No

Keys

# Fields
0 Capacity Type,No.,Date,Starting Time,Ending Time (Capacity Type,No.,Date,Starting Time,Ending Time) Clustered: Yes
1 Work Center No. (Work Center No.)
2 Capacity Type,No.,Date,Starting Date-Time,Ending Date-Time (Capacity Type,No.,Date,Starting Date-Time,Ending 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

Table Relations From Other Tables

From Table From Field