Diagrams

Table

Routing Version

DynamicsDocs.comRouting Version«Table 99000786»Routing VersionRouting No. [PK,NN]Version Code [PK]DescriptionStarting DateStatus; [New,Certified,Under Developme...Type; [Serial,Parallel]Last Date ModifiedNo. Series«Table 246»Requisition LineWorksheet Template Name [PK]Journal Batch Name [PK]Line No. [PK]Type; [,G/L Account,Item]No.DescriptionDescription 2QuantityVendor No.Direct Unit CostDue DateRequester IDConfirmedShortcut Dimension 1 CodeShortcut Dimension 2 CodeLocation CodeRecurring Method; [,Fixed,Variable]Expiration DateRecurring FrequencyOrder DateVendor Item No.Sales Order No.Sales Order Line No.Sell-to Customer No.Ship-to CodeOrder Address CodeCurrency CodeCurrency FactorReserved QuantityDimension Set IDProd. Order No....«Table 5406»Prod. Order LineStatus; [Simulated,Planned,Firm Planne...Prod. Order No. [PK]Line No. [PK]Item No.Variant CodeDescriptionDescription 2Location CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeBin CodeQuantityFinished QuantityRemaining QuantityScrap %Due DateStarting DateStarting TimeEnding DateEnding TimePlanning Level CodePriorityProduction BOM No.Routing No.Inventory Posting GroupRouting Reference No.Unit CostCost AmountReserved QuantityCapacity Type Filter; [Work Center,Mac...Capacity No. Filter...«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 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order<Routing No.><No. Series><Routing Version Code><Routing Version Code><Version Code><Version Code><Version Code><Version Code><Version Code><Routing No.><Prod. Order Line No.><No. Series><Routing No.><Routing No.><Operation No.><Operation No.><Operation No.><Operation No.><Routing No.><Routing No.><Routing No.><Routing No.><Version Nos.><No. Series>

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
3 Description (Description) Text50
10 Starting Date (Starting Date) Date
20 Status (Status) Option
21 Type (Type) Option
22 Last Date Modified (Last Date Modified) Date Editable: No
50 No. Series (No. Series) Code10 Editable: No

Keys

# Fields
0 Routing No.,Version Code (Routing No.,Version Code) Clustered: Yes
1 Routing No.,Starting Date (Routing No.,Starting Date)

Table Relations To Other Tables

Field Related Table Related Field
No. Series (No. Series) No. Series Code (Code) 1..n
Routing No. (Routing No.) Routing Header No. (No.) 1..n

Table Relations From Other Tables

From Table From Field
Prod. Order Line Routing Version Code (Routing Version Code) 1..n
Requisition Line Routing Version Code (Routing Version Code) 1..n
Routing Comment Line Version Code (Version Code) 1..n
Routing Line Version Code (Version Code) 1..n
Routing Personnel Version Code (Version Code) 1..n
Routing Quality Measure Version Code (Version Code) 1..n
Routing Tool Version Code (Version Code) 1..n