Diagrams


Table

Machine Center

DynamicsDocs.comMachine Center«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 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 5406»Prod. Order LineStatus; [Simulated,Planned,Firm Planne...Prod. Order No. [PK]Line No. [PK]Item No.Variant CodeDescriptionDescription 2Location CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeBin CodeQuantityFinished QuantityRemaining QuantityScrap %Due DateStarting DateStarting TimeEnding DateEnding TimePlanning Level CodePriorityProduction BOM No.Routing No.Inventory Posting GroupRouting Reference No.Unit CostCost AmountReserved QuantityCapacity Type Filter; [Work Center,Mac...Capacity No. Filter...«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 5802»Value EntryEntry No. [PK]Item No.Posting DateItem Ledger Entry Type; [Purchase,Sale...Source No.Document No.DescriptionLocation CodeInventory Posting GroupSource Posting GroupItem Ledger Entry No.Valued QuantityItem Ledger Entry QuantityInvoiced QuantityCost per UnitSales Amount [Actual]Salespers./Purch. CodeDiscount AmountUser IDSource CodeApplies-to EntryGlobal Dimension 1 CodeGlobal Dimension 2 CodeSource Type; [,Customer,Vendor,Item]Cost Amount [Actual]Cost Posted to G/LReason CodeDrop ShipmentJournal Batch NameGen. Bus. Posting GroupGen. Prod. Posting Group...«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 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 5870»BOM BufferEntry No. [PK]Type; [,Item,Machine Center,Work Cente...No.DescriptionUnit of Measure CodeVariant CodeLocation CodeReplenishment System; [Purchase,Prod....IndentationIs LeafBottleneckRouting No.Production BOM No.Lot SizeLow-Level CodeRounding PrecisionQty. per ParentQty. per Top ItemAble to Make Top ItemAble to Make ParentAvailable QuantityGross RequirementScheduled ReceiptsUnused QuantityLead Time CalculationLead-Time OffsetRolled-up Lead-Time OffsetNeeded by DateSafety Lead TimeUnit CostIndirect Cost %...«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 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 99000770»Manufacturing Comment LineTable Name; [Work Center,Machine Cente...No. [PK,NN]Line No. [PK]DateCodeComment«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 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 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 99000780»Capacity Unit of MeasureCode [PK,NN]DescriptionType; [,100/Hour,Minutes,Hours,Days]«Table 99000750»Work ShiftCode [PK,NN]Description«Table 27»ItemNo. [PK]No. 2DescriptionSearch DescriptionDescription 2Assembly BOMBase Unit of MeasurePrice Unit ConversionType; [Inventory,Service]Inventory Posting GroupShelf No.Item Disc. GroupAllow Invoice Disc.Statistics GroupCommission GroupUnit PricePrice/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Unit CostStandard CostLast Direct CostIndirect Cost %Cost is AdjustedAllow Online AdjustmentVendor No.Vendor Item No.Lead Time CalculationReorder PointMaximum InventoryReorder Quantity...«Table 99000761»StopCode [PK,NN]Description«Table 99000762»ScrapCode [PK,NN]Description«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 9»Country/RegionCode [PK,NN]NameEU Country/Region CodeIntrastat CodeAddress Format; [Post Code+City,City+P...Contact Address Format; [First,After C...VAT Scheme«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<Work Center 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><Item Filter><Stop Code Filter><Scrap Code Filter><No. Series><Gen. Prod. Posting Group><Country/Region Code><Location Code><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><Capacity No. Filter><Capacity No. Filter><No.><No.><No.><No.><No.><No.><No.><No.><No.><No.><No.><No.><No.><Capacity No.><Source No.><Gen. Prod. Posting Group><Location Code><Bin Code><Work Center Filter><Capacity No. Filter><No. Series><Prod. Order No.><Prod. Order No.><Order No.><Order No.><Item No.><Location Code><Bin Code><Capacity No. Filter><Order Line No.><Order Line No.><No.><Work Center No.><Setup Time Unit of Meas. Code><Run Time Unit of Meas. Code><Wait Time Unit of Meas. Code><Move Time Unit of Meas. Code><Operation No.><No.><Work Center No.><Item No.><Source No.><Location Code><Gen. Prod. Posting Group><Capacity Ledger Entry No.><No.><No.><Work Center No.><Cap. Unit of Measure Code><Item No.><Stop Code><Scrap Code><Work Shift Code><No.><No.><No.><No.><Location Code><Item No.><Source No.><Originally Ordered No.><Location Code><New Location Code><Country/Region Code><Gen. Prod. Posting Group><Posting No. Series><Bin Code><New Bin Code><No.><Work Center No.><Cap. Unit of Measure Code><Stop Code><Scrap Code><Work Shift Code><No.><Work Center No.><Work Shift Code><No.><Work Center No.><No.><Work Center No.><Setup Time Unit of Meas. Code><Run Time Unit of Meas. Code><Wait Time Unit of Meas. Code><Move Time Unit of Meas. Code><No.><No.><Work Center No.><Setup Time Unit of Meas. Code><Run Time Unit of Meas. Code><Wait Time Unit of Meas. Code><Move Time Unit of Meas. Code><No.><Capacity No.><Work Center No.><Work Shift Filter><Alternate Work Center><Queue Time Unit of Meas. Code><Unit of Measure Code><Work Shift Filter><No. Series><Gen. Prod. Posting Group><Country/Region Code><Location Code><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><Alternative Item No.><Country/Region Purchased Code><Country/Region of Origin Code><Location Filter><Gen. Prod. Posting Group><No. Series><Serial Nos.><Lot Nos.><Bin Filter><Item Filter><Country/Region 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
14 Work Center 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
31 Capacity Decimal (0:5)
32 Efficiency Decimal (0:5)
33 Maximum Efficiency Decimal (0:5)
34 Minimum Efficiency Decimal (0:5)
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 Setup Time Decimal (0:5)
52 Wait Time Decimal (0:5)
53 Move Time Decimal (0:5)
54 Fixed Scrap Quantity Decimal (0:5)
55 Scrap % Decimal (0:5)
56 Setup Time Unit of Meas. Code Code10
57 Wait Time Unit of Meas. Code Code10
58 Send-Ahead Quantity Decimal (0:5)
59 Move Time Unit of Meas. Code Code10
60 Flushing Method Option
62 Minimum Process Time Decimal (0:5)
63 Maximum Process Time Decimal (0:5)
64 Concurrent Capacities Decimal (0:5)
65 Item Filter Code20 FlowFilter
66 Stop Code Filter Code10 FlowFilter
67 Scrap Code Filter Code10 FlowFilter
80 No. Series Code10 Editable: No
81 Overhead Rate Decimal
82 Gen. Prod. Posting Group Code10
83 County Text30
84 Country/Region Code Code10
7300 Location Code Code10 Editable: No
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 No.

Table Relations To Other Tables

Field Related Table Related Field
From-Production Bin Code Bin Code 1..n
Move Time Unit of Meas. Code Capacity Unit of Measure Code 1..n
Country/Region Code Country/Region Code 1..n
Gen. Prod. Posting Group Gen. Product Posting Group Code 1..n
Item Filter Item No. 1..n
Location Code Location Code 1..n
No. Series No. Series Code 1..n
Scrap Code Filter Scrap Code 1..n
Stop Code Filter Stop Code 1..n
Work Center No. Work Center No. 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 No. 1..n
Calendar Entry No. 1..n
Capacity Constrained Resource Capacity No. 1..n
Capacity Ledger Entry No. 1..n
Item Journal Line No. 1..n
Manufacturing Comment Line No. 1..n
Planning Routing Line No. 1..n
Prod. Order Capacity Need No. 1..n
Prod. Order Line Capacity No. Filter 1..n
Prod. Order Routing Line No. 1..n
Production Order Capacity No. Filter 1..n
Registered Absence No. 1..n
Routing Line No. 1..n
Standard Cost Worksheet No. 1..n
Value Entry No. 1..n