Diagrams


Table

Work Center Group

DynamicsDocs.comWork Center Group«Table 99000756»Work Center GroupCode [PK,NN]NameDate FilterWork Shift FilterCapacity [Total]Capacity [Effective]Prod. Order Need [Qty.]Prod. Order Status Filter; [Simulated,...«Table 5409»Prod. Order Routing LineRouting No. [PK]Routing Reference No. [PK]Operation No. [PK,NN]Next Operation No.Previous Operation No.Type; [Work Center,Machine Center]No.Work Center No.Work Center Group CodeDescriptionSetup TimeRun TimeWait TimeMove TimeFixed Scrap QuantityLot SizeScrap Factor %Setup Time Unit of Meas. CodeRun Time Unit of Meas. CodeWait Time Unit of Meas. CodeMove Time Unit of Meas. CodeMinimum Process TimeMaximum Process TimeConcurrent CapacitiesSend-Ahead QuantityRouting Link CodeStandard Task CodeUnit Cost perRecalculateSequence No. [Forward]Sequence No. [Backward]...«Table 5410»Prod. Order Capacity NeedStatus; [Simulated,Planned,Firm Planne...Prod. Order No. [PK]Routing No. [PK]Line No. [PK]Operation No. [PK]Type; [Work Center,Machine Center]No.Work Center No.Work Center Group CodeRouting Reference No. [PK]DateStarting TimeEnding TimeAllocated TimeSend-Ahead Type; [,Input,Output,Both]Time Type; [Setup,Run]Needed TimeNeeded Time [ms]Lot SizeConcurrent CapacitiesEfficiencyStarting Date-TimeEnding Date-TimeWorksheet Template NameWorksheet Batch NameWorksheet Line No.ActiveRequested Only [PK]«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 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 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 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 99000764»Routing LineRouting No. [PK,NN]Version Code [PK]Operation No. [PK,NN]Next Operation No.Previous Operation No.Type; [Work Center,Machine Center,]No.Work Center No.Work Center Group CodeDescriptionSetup TimeRun TimeWait TimeMove TimeFixed Scrap QuantityLot SizeScrap Factor %Setup Time Unit of Meas. CodeRun Time Unit of Meas. CodeWait Time Unit of Meas. CodeMove Time Unit of Meas. CodeMinimum Process TimeMaximum Process TimeConcurrent CapacitiesSend-Ahead QuantityRouting Link CodeStandard Task CodeUnit Cost perRecalculateCommentSequence No. [Forward]...«Table 99000830»Planning Routing LineWorksheet Template Name [PK]Worksheet Batch Name [PK]Worksheet Line No. [PK]Operation No. [PK,NN]Next Operation No.Previous Operation No.Type; [Work Center,Machine Center]No.Work Center No.Work Center Group CodeDescriptionSetup TimeRun TimeWait TimeMove TimeFixed Scrap QuantityLot SizeScrap Factor %Setup Time Unit of Meas. CodeRun Time Unit of Meas. CodeWait Time Unit of Meas. CodeMove Time Unit of Meas. CodeMinimum Process TimeMaximum Process TimeConcurrent CapacitiesSend-Ahead QuantityRouting Link CodeStandard Task CodeUnit Cost perRecalculateSequence No.[Forward]...«Table 99000750»Work ShiftCode [PK,NN]Description<Work Shift Filter><Work Center Group Code><Work Center Group Code><Work Center Group Code><Work Center Group Code><Work Center Group Code><Work Center Group Code><Work Center Group Code><Work Center Group Code><Work Center Group Code><No.><Work Center No.><Operation No.><No.><Work Center No.><No.><Work Center No.><Work Shift Code><No.><Work Center No.><Work Shift Code><Alternate Work Center><Work Shift Filter><No.><Work Center No.><No.><Work Center No.><No.><Work Center No.><No.><Work Center No.><Work Shift Code>

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

Fields

# Name Type
1 Code Code10 NotBlank: Yes
2 Name Text50
20 Date Filter Date FlowFilter
21 Work Shift Filter Code10 FlowFilter
22 Capacity (Total) Decimal (0:5) Editable: No
FlowField
23 Capacity (Effective) Decimal (0:5) Editable: No
FlowField
24 Prod. Order Need (Qty.) Decimal (0:5) Editable: No
FlowField
47 Prod. Order Status Filter Option FlowFilter

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Work Shift Filter Work Shift Code 1..n

Table Relations From Other Tables

From Table From Field
Calendar Absence Entry Work Center Group Code 1..n
Calendar Entry Work Center Group Code 1..n
Capacity Ledger Entry Work Center Group Code 1..n
Item Journal Line Work Center Group Code 1..n
Planning Routing Line Work Center Group Code 1..n
Prod. Order Capacity Need Work Center Group Code 1..n
Prod. Order Routing Line Work Center Group Code 1..n
Routing Line Work Center Group Code 1..n
Work Center Work Center Group Code 1..n