Diagrams

Table

Work Shift

DynamicsDocs.comWork Shift«Table 99000750»Work ShiftCode [PK,NN]Description«Table 5832»Capacity Ledger EntryEntry No. [PK]No.Posting DateType; [Work Center,Machine Center, ,Re...Document No.DescriptionOperation No.Work Center No.QuantitySetup TimeRun TimeStop TimeInvoiced QuantityOutput QuantityScrap QuantityConcurrent CapacityCap. Unit of Measure CodeQty. per Cap. Unit of MeasureGlobal Dimension 1 CodeGlobal Dimension 2 CodeLast Output LineCompletely InvoicedStarting TimeEnding TimeRouting No.Routing Reference No.Item No.Variant CodeUnit of Measure CodeQty. per Unit of MeasureDocument Date...«Table 83»Item Journal LineJournal Template Name [PK]Line No. [PK]Item No.Posting DateEntry Type; [Purchase,Sale,Positive Ad...Source No.Document No.DescriptionLocation CodeInventory Posting GroupSource Posting GroupQuantityInvoiced QuantityUnit AmountUnit CostAmountDiscount AmountSalespers./Purch. CodeSource CodeApplies-to EntryItem Shpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeIndirect Cost %Source Type; [,Customer,Vendor,Item]Journal Batch Name [PK]Reason CodeRecurring Method; [,Fixed,Variable]Expiration DateRecurring FrequencyDrop Shipment...«Table 99000752»Shop Calendar Working DaysShop Calendar Code [PK,NN]Day; [Monday,Tuesday,Wednesday,Thursda...Work Shift Code [PK,NN]Starting Time [PK]Ending Time [PK]«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 99000756»Work Center GroupCode [PK,NN]NameDate FilterWork Shift FilterCapacity [Total]Capacity [Effective]Prod. Order Need [Qty.]Prod. Order Status Filter; [Simulated,...«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 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 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<Work Shift Code><Work Shift Code><Work Shift Code><Work Shift Filter><Work Shift Filter><Work Shift Code><Work Shift Filter><Work Shift Filter><No.><No.><Work Center No.><Work Center Group Code><No.><No.><Work Center No.><Work Center Group Code><Alternate Work Center><Work Center Group Code><No.><Work Center No.><Work Center No.><Capacity No.><Work Center No.><Work Center Group Code><No.><Capacity No.>

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

Fields

# Name Type
1 Code (Code) Code10 NotBlank: Yes
2 Description (Description) Text50

Keys

# Fields
0 Code (Code) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field
Calendar Entry Work Shift Code (Work Shift Code) 1..n
Capacity Constrained Resource Work Shift Filter (Work Shift Filter) 1..n
Capacity Ledger Entry Work Shift Code (Work Shift Code) 1..n
Item Journal Line Work Shift Code (Work Shift Code) 1..n
Machine Center Work Shift Filter (Work Shift Filter) 1..n
Shop Calendar Working Days Work Shift Code (Work Shift Code) 1..n
Work Center Work Shift Filter (Work Shift Filter) 1..n
Work Center Group Work Shift Filter (Work Shift Filter) 1..n