Diagrams


Table

Routing Link

DynamicsDocs.comRouting Link«Table 99000777»Routing LinkCode [PK,NN]Description«Table 5407»Prod. Order ComponentStatus; [Simulated,Planned,Firm Planne...Prod. Order No. [PK]Prod. Order Line No. [PK]Line No. [PK]Item No.DescriptionUnit of Measure CodeQuantityPositionPosition 2Position 3Lead-Time OffsetRouting Link CodeScrap %Variant CodeExpected QuantityRemaining QuantityAct. Consumption [Qty]Flushing Method; [Manual,Forward,Backw...Location CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeBin CodeSupplied-by Line No.Planning Level CodeItem Low-Level CodeLengthWidthWeightDepthCalculation Formula; [,Length,Length *......«Table 5409»Prod. Order Routing LineRouting No. [PK]Routing Reference No. [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 perRecalculateSequence No. [Forward]Sequence No. [Backward]...«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 99000772»Production BOM LineProduction BOM No. [PK,NN]Line No. [PK]Version Code [PK]Type; [,Item,Production BOM]No.DescriptionUnit of Measure CodeQuantityPositionPosition 2Position 3Lead-Time OffsetRouting Link CodeScrap %Variant CodeCommentStarting DateEnding DateLengthWidthWeightDepthCalculation Formula; [,Length,Length *...Quantity per«Table 99000829»Planning ComponentWorksheet Template Name [PK]Worksheet Batch Name [PK]Worksheet Line No. [PK]Line No. [PK]Item No.DescriptionUnit of Measure CodeQuantityPositionPosition 2Position 3Lead-Time OffsetRouting Link CodeScrap %Variant CodeExpected QuantityFlushing Method; [Manual,Forward,Backw...Location CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeBin CodeSupplied-by Line No.Planning Level CodeRef. Order Status; [Simulated,Planned,...Ref. Order No.Ref. Order Line No.LengthWidthWeightDepthCalculation Formula; [,Length,Length *......«Table 99000830»Planning Routing LineWorksheet Template Name [PK]Worksheet Batch Name [PK]Worksheet Line No. [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 perRecalculateSequence No.[Forward]...<Routing Link Code><Routing Link Code><Routing Link Code><Routing Link Code><Routing Link Code><Routing Link Code>

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

Fields

# Name Type
1 Code (Code) Code10 NotBlank: Yes
2 Description (Description) Text50

Keys

# Fields
0 Code (Code) Clustered: Yes
1 Description (Description)

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field
Planning Component Routing Link Code (Routing Link Code) 1..n
Planning Routing Line Routing Link Code (Routing Link Code) 1..n
Prod. Order Component Routing Link Code (Routing Link Code) 1..n
Prod. Order Routing Line Routing Link Code (Routing Link Code) 1..n
Production BOM Line Routing Link Code (Routing Link Code) 1..n
Routing Line Routing Link Code (Routing Link Code) 1..n