Diagrams

Table

Routing Quality Measure

DynamicsDocs.comRouting Quality Measure«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 99000785»Quality MeasureCode [PK,NN]Description«Table 99000786»Routing VersionRouting No. [PK,NN]Version Code [PK]DescriptionStarting DateStatus; [New,Certified,Under Developme...Type; [Serial,Parallel]Last Date ModifiedNo. Series«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]...<Routing No.><Qlty Measure Code><Version Code><Operation No.><Routing No.><Routing No.><Version 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 Line No. (Line No.) Integer
9 Qlty Measure Code (Qlty Measure Code) Code10
10 Description (Description) Text50
11 Min. Value (Min. Value) Decimal (0:5)
12 Max. Value (Max. Value) Decimal (0:5)
13 Mean Tolerance (Mean Tolerance) Decimal (0:5)
20 Version Code (Version Code) Code20
21 Operation No. (Operation No.) Code10 NotBlank: Yes

Keys

# Fields
0 Routing No.,Version Code,Operation No.,Line No. (Routing No.,Version Code,Operation No.,Line No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Qlty Measure Code (Qlty Measure Code) Quality Measure Code (Code) 1..n
Routing No. (Routing No.) Routing Header No. (No.) 1..n
Operation No. (Operation No.) Routing Line Operation No. (Operation No.) 1..n
Version Code (Version Code) Routing Version Version Code (Version Code) 1..n

Table Relations From Other Tables

From Table From Field