Diagrams

Table

Routing Line

DynamicsDocs.comRouting Line«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 99000775»Routing Comment LineRouting No. [PK,NN]Operation No. [PK,NN]Line No. [PK]Version Code [PK]DateCommentCode«Table 99000802»Routing ToolRouting No. [PK,NN]Line No. [PK]No.DescriptionVersion Code [PK]Operation No. [PK,NN]«Table 99000803»Routing PersonnelRouting No. [PK,NN]Line No. [PK]No.DescriptionVersion Code [PK]Operation No. [PK,NN]«Table 99000805»Routing Quality MeasureRouting No. [PK,NN]Line No. [PK]Qlty Measure CodeDescriptionMin. ValueMax. ValueMean ToleranceVersion Code [PK]Operation No. [PK,NN]«Table 99000763»Routing HeaderNo. [PK]DescriptionDescription 2Search DescriptionLast Date ModifiedCommentStatus; [New,Certified,Under Developme...Type; [Serial,Parallel]Version Nos.No. Series«Table 99000786»Routing VersionRouting No. [PK,NN]Version Code [PK]DescriptionStarting DateStatus; [New,Certified,Under Developme...Type; [Serial,Parallel]Last Date ModifiedNo. Series«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 99000756»Work Center GroupCode [PK,NN]NameDate FilterWork Shift FilterCapacity [Total]Capacity [Effective]Prod. Order Need [Qty.]Prod. Order Status Filter; [Simulated,...«Table 99000780»Capacity Unit of MeasureCode [PK,NN]DescriptionType; [,100/Hour,Minutes,Hours,Days]«Table 99000777»Routing LinkCode [PK,NN]Description«Table 99000778»Standard TaskCode [PK,NN]Description<Routing No.><Version Code><No.><Work Center No.><No.><Work Center Group Code><Setup Time Unit of Meas. Code><Run Time Unit of Meas. Code><Wait Time Unit of Meas. Code><Move Time Unit of Meas. Code><Routing Link Code><Standard Task Code><Operation No.><Operation No.><Operation No.><Operation No.><Routing No.><Version Code><Routing No.><Version Code><Routing No.><Version Code><Routing No.><Version Code><Routing No.><Alternate Work Center><Work Center Group Code><Queue Time Unit of Meas. Code><Unit of Measure Code><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>

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

Fields

# Name Type
1 Routing No. (Routing No.) Code20 NotBlank: Yes
2 Version Code (Version Code) Code20
4 Operation No. (Operation No.) Code10 NotBlank: Yes
5 Next Operation No. (Next Operation No.) Code30
6 Previous Operation No. (Previous Operation No.) Code30
7 Type (Type) Option
8 No. (No.) Code20
9 Work Center No. (Work Center No.) Code20 Editable: No
10 Work Center Group Code (Work Center Group Code) Code10 Editable: No
11 Description (Description) Text50
12 Setup Time (Setup Time) Decimal (0:5)
13 Run Time (Run Time) Decimal (0:5)
14 Wait Time (Wait Time) Decimal (0:5)
15 Move Time (Move Time) Decimal (0:5)
16 Fixed Scrap Quantity (Fixed Scrap Quantity) Decimal (0:5)
17 Lot Size (Lot Size) Decimal (0:5)
18 Scrap Factor % (Scrap Factor %) Decimal (0:5)
19 Setup Time Unit of Meas. Code (Setup Time Unit of Meas. Code) Code10
20 Run Time Unit of Meas. Code (Run Time Unit of Meas. Code) Code10
21 Wait Time Unit of Meas. Code (Wait Time Unit of Meas. Code) Code10
22 Move Time Unit of Meas. Code (Move Time Unit of Meas. Code) Code10
27 Minimum Process Time (Minimum Process Time) Decimal (0:5)
28 Maximum Process Time (Maximum Process Time) Decimal (0:5)
30 Concurrent Capacities (Concurrent Capacities) Decimal (0:5)
31 Send-Ahead Quantity (Send-Ahead Quantity) Decimal (0:5)
34 Routing Link Code (Routing Link Code) Code10
35 Standard Task Code (Standard Task Code) Code10
40 Unit Cost per (Unit Cost per) Decimal
41 Recalculate (Recalculate) Boolean Editable: No
45 Comment (Comment) Boolean Editable: No
FlowField
50 Sequence No. (Forward) (Sequence No. (Forward)) Integer Editable: No
51 Sequence No. (Backward) (Sequence No. (Backward)) Integer Editable: No
52 Fixed Scrap Qty. (Accum.) (Fixed Scrap Qty. (Accum.)) Decimal (0:5) Editable: No
53 Scrap Factor % (Accumulated) (Scrap Factor % (Accumulated)) Decimal (0:5) Editable: No

Keys

# Fields
0 Routing No.,Version Code,Operation No. (Routing No.,Version Code,Operation No.) Clustered: Yes
1 Routing No.,Version Code,Sequence No. (Forward) (Routing No.,Version Code,Sequence No. (Forward))
2 Routing No.,Version Code,Sequence No. (Backward) (Routing No.,Version Code,Sequence No. (Backward))
3 Work Center No. (Work Center No.)
4 Type,No. (Type,No.)
5 Routing Link Code (Routing Link Code)

Table Relations To Other Tables

Field Related Table Related Field
Move Time Unit of Meas. Code (Move Time Unit of Meas. Code) Capacity Unit of Measure Code (Code) 1..n
No. (No.) Machine Center No. (No.) 1..n
Routing No. (Routing No.) Routing Header No. (No.) 1..n
Routing Link Code (Routing Link Code) Routing Link Code (Code) 1..n
Version Code (Version Code) Routing Version Version Code (Version Code) 1..n
Standard Task Code (Standard Task Code) Standard Task Code (Code) 1..n
Work Center No. (Work Center No.) Work Center No. (No.) 1..n
Work Center Group Code (Work Center Group Code) Work Center Group Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Routing Comment Line Operation No. (Operation No.) 1..n
Routing Personnel Operation No. (Operation No.) 1..n
Routing Quality Measure Operation No. (Operation No.) 1..n
Routing Tool Operation No. (Operation No.) 1..n