Diagrams

Table

Capacity Constrained Resource

DynamicsDocs.comCapacity Constrained Resource«Table 99000866»Capacity Constrained ResourceCapacity No. [PK]Capacity Type; [Work Center,Machine Ce...NameCritical Load %Dampener [% of Total Capacity]Work Center No.Date FilterWork Shift FilterCapacity [Effective]Prod. Order Need Qty.Work Center Load Qty.Prod. Order Need Qty. for PlanWork Center Load Qty. for Plan«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<Capacity No.><Work Center No.><Capacity No.><Work Shift Filter><Alternate Work Center><Work Shift Filter><Work Center No.><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 No. (Capacity No.) Code20
2 Capacity Type (Capacity Type) Option
3 Name (Name) Text50
10 Critical Load % (Critical Load %) Decimal (1:1)
11 Dampener (% of Total Capacity) (Dampener (% of Total Capacity)) Decimal (1:1)
14 Work Center No. (Work Center No.) Code20
39 Date Filter (Date Filter) Date FlowFilter
40 Work Shift Filter (Work Shift Filter) Code10 FlowFilter
42 Capacity (Effective) (Capacity (Effective)) Decimal (0:5) Editable: No
FlowField
44 Prod. Order Need Qty. (Prod. Order Need Qty.) Decimal (0:5) Editable: No
FlowField
46 Work Center Load Qty. (Work Center Load Qty.) Decimal (0:5) Editable: No
FlowField
48 Prod. Order Need Qty. for Plan (Prod. Order Need Qty. for Plan) Decimal (0:5) Editable: No
FlowField
49 Work Center Load Qty. for Plan (Work Center Load Qty. for Plan) Decimal (0:5) Editable: No
FlowField

Keys

# Fields
0 Capacity Type,Capacity No. (Capacity Type,Capacity No.) Clustered: Yes

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field