Diagrams


Table

Work Center

DynamicsDocs.comWork Center«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 5405»Production OrderStatus; [Simulated,Planned,Firm Planne...No. [PK]DescriptionSearch DescriptionDescription 2Creation DateLast Date ModifiedSource Type; [Item,Family,Sales Header...Source No.Routing No.Inventory Posting GroupGen. Prod. Posting GroupGen. Bus. Posting GroupCommentStarting TimeStarting DateEnding TimeEnding DateDue DateFinished DateBlockedShortcut Dimension 1 CodeShortcut Dimension 2 CodeLocation CodeBin CodeReplan Ref. No.Replan Ref. Status; [Simulated,Planned...Low-Level CodeQuantityUnit CostCost Amount...«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 5841»Standard Cost WorksheetStandard Cost Worksheet Name [PK]Type; [Item,Work Center,Machine Center...No. [PK,NN]DescriptionImplementedReplenishment System; [Purchase,Prod....Standard CostNew Standard CostIndirect Cost %New Indirect Cost %Overhead RateNew Overhead RateSingle-Lvl Material CostNew Single-Lvl Material CostSingle-Lvl Cap. CostNew Single-Lvl Cap. CostSingle-Lvl Subcontrd CostNew Single-Lvl Subcontrd CostSingle-Lvl Cap. Ovhd CostNew Single-Lvl Cap. Ovhd CostSingle-Lvl Mfg. Ovhd CostNew Single-Lvl Mfg. Ovhd CostRolled-up Material CostNew Rolled-up Material CostRolled-up Cap. CostNew Rolled-up Cap. CostRolled-up Subcontrd CostNew Rolled-up Subcontrd CostRolled-up Cap. Ovhd CostNew Rolled-up Cap. Ovhd CostRolled-up Mfg. Ovhd Cost...«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 99000848»Registered AbsenceCapacity Type; [Work Center,Machine Ce...No. [PK]Date [PK]Starting Time [PK]Ending Time [PK]DescriptionCapacityStarting Date-TimeEnding Date-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«Table 99000756»Work Center GroupCode [PK,NN]NameDate FilterWork Shift FilterCapacity [Total]Capacity [Effective]Prod. Order Need [Qty.]Prod. Order Status Filter; [Simulated,...«Table 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«Table 99000780»Capacity Unit of MeasureCode [PK,NN]DescriptionType; [,100/Hour,Minutes,Hours,Days]«Table 99000751»Shop CalendarCode [PK,NN]Description«Table 99000750»Work ShiftCode [PK,NN]Description«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 14»LocationCode [PK,NN]NameDefault Bin CodeName 2AddressAddress 2CityPhone No.Phone No. 2Telex No.Fax No.ContactPost CodeCountyE-MailHome PageCountry/Region CodeUse As In-TransitRequire Put-awayRequire PickCross-Dock Due Date Calc.Use Cross-DockingRequire ReceiveRequire ShipmentBin MandatoryDirected Put-away and PickDefault Bin Selection; [,Fixed Bin,Las...Outbound Whse. Handling TimeInbound Whse. Handling TimePut-away Template CodeUse Put-away Worksheet...«Table 7354»BinLocation Code [PK,NN]Code [PK,NN]DescriptionZone CodeAdjustment BinBin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Special Equipment CodeBin RankingMaximum CubageMaximum WeightEmptyItem FilterVariant FilterDefaultCross-Dock BinDedicated<Alternate Work Center><Work Center Group Code><Subcontractor No.><Queue Time Unit of Meas. Code><Unit of Measure Code><Shop Calendar Code><Work Shift Filter><Gen. Prod. Posting Group><Location Code><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><Work Center Filter><Capacity No. Filter><No.><Work Center No.><No.><Work Center No.><No.><Capacity No.><Work Center No.><Gen. Prod. Posting Group><Location Code><Bin Code><Capacity No. Filter><No.><Work Center Group Code><No.><Queue Time Unit of Meas. Code><Setup Time Unit of Meas. Code><Wait Time Unit of Meas. Code><Move Time Unit of Meas. Code><Work Shift Filter><Gen. Prod. Posting Group><Location Code><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><No.><Capacity No.><Work Shift Filter><Work Shift Filter><Pay-to Vendor No.><Location Code><Default Bin Code><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><Adjustment Bin Code><Receipt Bin Code><Shipment Bin Code><Cross-Dock Bin Code><To-Assembly Bin Code><From-Assembly Bin Code><Asm.-to-Order Shpt. Bin Code><Location Code>

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

Fields

# Name Type
1 No. Code20
3 Name Text50
4 Search Name Code50
5 Name 2 Text50
6 Address Text50
7 Address 2 Text50
8 City Text30
9 Post Code Code20
12 Alternate Work Center Code20
14 Work Center Group Code Code10
16 Global Dimension 1 Code Code20
17 Global Dimension 2 Code Code20
18 Subcontractor No. Code20
19 Direct Unit Cost Decimal
20 Indirect Cost % Decimal (0:5)
21 Unit Cost Decimal (2:5)
22 Queue Time Decimal (0:5)
23 Queue Time Unit of Meas. Code Code10
26 Last Date Modified Date Editable: No
27 Comment Boolean Editable: No
FlowField
30 Unit of Measure Code Code10
31 Capacity Decimal (0:5)
32 Efficiency Decimal (0:5)
33 Maximum Efficiency Decimal (0:5)
34 Minimum Efficiency Decimal (0:5)
35 Calendar Rounding Precision Decimal (0:5) NotBlank: Yes
36 Simulation Type Option
37 Shop Calendar Code Code10
38 Blocked Boolean
39 Date Filter Date FlowFilter
40 Work Shift Filter Code10 FlowFilter
41 Capacity (Total) Decimal (0:5) Editable: No
FlowField
42 Capacity (Effective) Decimal (0:5) Editable: No
FlowField
44 Prod. Order Need (Qty.) Decimal (0:5) Editable: No
FlowField
45 Prod. Order Need Amount Decimal Editable: No
FlowField
47 Prod. Order Status Filter Option FlowFilter
50 Unit Cost Calculation Option
51 Specific Unit Cost Boolean
52 Consolidated Calendar Boolean
53 Flushing Method Option
80 No. Series Code20 Editable: No
81 Overhead Rate Decimal
82 Gen. Prod. Posting Group Code20
83 County Text30
84 Country/Region Code Code10
7300 Location Code Code10
7301 Open Shop Floor Bin Code Code20
7302 To-Production Bin Code Code20
7303 From-Production Bin Code Code20

Keys

# Fields
0 No. Clustered: Yes
1 Search Name
2 Work Center Group Code
3 Subcontractor No.
4 Name

Table Relations To Other Tables

Field Related Table Related Field
From-Production Bin Code Bin Code 1..n
Unit of Measure Code Capacity Unit of Measure Code 1..n
Country/Region Code Country/Region Code 1..n
Global Dimension 2 Code Dimension Value Code 1..n
Gen. Prod. Posting Group Gen. Product Posting Group Code 1..n
Location Code Location Code 1..n
No. Series No. Series Code 1..n
Shop Calendar Code Shop Calendar Code 1..n
Subcontractor No. Vendor No. 1..n
Alternate Work Center Work Center No. 1..n
Work Center Group Code Work Center Group Code 1..n
Work Shift Filter Work Shift Code 1..n

Table Relations From Other Tables

From Table From Field
BOM Buffer No. 1..n
Calendar Absence Entry Work Center No. 1..n
Calendar Entry Work Center No. 1..n
Capacity Constrained Resource Work Center No. 1..n
Capacity Ledger Entry Work Center No. 1..n
Default Dimension No. 1..n
Item Journal Line Work Center No. 1..n
Machine Center Work Center No. 1..n
Manufacturing Comment Line No. 1..n
Planning Routing Line Work Center No. 1..n
Prod. Order Capacity Need Work Center No. 1..n
Prod. Order Line Capacity No. Filter 1..n
Prod. Order Routing Line Work Center No. 1..n
Production Order Capacity No. Filter 1..n
Purch. Inv. Line Work Center No. 1..n
Purch. Rcpt. Line Work Center No. 1..n
Purchase Line Work Center No. 1..n
Purchase Line Archive Work Center No. 1..n
Registered Absence No. 1..n
Requisition Line Work Center No. 1..n
Routing Line Work Center No. 1..n
Standard Cost Worksheet No. 1..n
Standard Item Journal Line Work Center No. 1..n
Value Entry No. 1..n
Work Center Alternate Work Center 1..n