Diagrams

Table

Routing Comment Line

DynamicsDocs.comRouting Comment Line«Table 99000775»Routing Comment LineRouting No. [PK,NN]Operation No. [PK,NN]Line No. [PK]Version Code [PK]DateCommentCode«Table 99000763»Routing HeaderNo. [PK]DescriptionDescription 2Search DescriptionLast Date ModifiedCommentStatus; [New,Certified,Under Developme...Type; [Serial,Parallel]Version Nos.No. 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]...«Table 99000786»Routing VersionRouting No. [PK,NN]Version Code [PK]DescriptionStarting DateStatus; [New,Certified,Under Developme...Type; [Serial,Parallel]Last Date ModifiedNo. Series<Routing No.><Operation No.><Version Code><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 Operation No. (Operation No.) Code10 NotBlank: Yes
3 Line No. (Line No.) Integer
4 Version Code (Version Code) Code20
10 Date (Date) Date
12 Comment (Comment) Text80
13 Code (Code) Code10

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
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