Diagrams

Table

Manufacturing Comment Line

DynamicsDocs.comManufacturing Comment Line«Table 99000770»Manufacturing Comment LineTable Name; [Work Center,Machine Cente...No. [PK,NN]Line No. [PK]DateCodeComment«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 99000763»Routing HeaderNo. [PK]DescriptionDescription 2Search DescriptionLast Date ModifiedCommentStatus; [New,Certified,Under Developme...Type; [Serial,Parallel]Version Nos.No. Series«Table 99000771»Production BOM HeaderNo. [PK]DescriptionDescription 2Search NameUnit of Measure CodeLow-Level CodeCommentCreation DateLast Date ModifiedStatus; [New,Certified,Under Developme...Version Nos.No. Series<No.><No.><No.><No.><Alternate Work Center><Work Center No.>

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

Fields

# Name Type
1 Table Name (Table Name) Option
2 No. (No.) Code20 NotBlank: Yes
3 Line No. (Line No.) Integer
4 Date (Date) Date
5 Code (Code) Code10
6 Comment (Comment) Text80

Keys

# Fields
0 Table Name,No.,Line No. (Table Name,No.,Line No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
No. (No.) Machine Center No. (No.) 1..n
No. (No.) Production BOM Header No. (No.) 1..n
No. (No.) Routing Header No. (No.) 1..n
No. (No.) Work Center No. (No.) 1..n

Table Relations From Other Tables

From Table From Field