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

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

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