Diagrams

Table

Prod. Order Routing Line

DynamicsDocs.comProd. Order Routing Line«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 121»Purch. Rcpt. LineBuy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityDirect Unit CostUnit Cost [LCY]VAT %Line Discount %Unit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryItem Rcpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeJob No.Indirect Cost %Qty. Rcd. Not InvoicedQuantity InvoicedOrder No....«Table 123»Purch. Inv. LineBuy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityDirect Unit CostUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATUnit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeJob No.Indirect Cost %Receipt No....«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 39»Purchase LineDocument Type; [Quote,Order,Invoice,Cr...Buy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ReceiveDirect Unit CostUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATUnit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 Code...«Table 5110»Purchase Line ArchiveDocument Type; [Quote,Order,Invoice,Cr...Buy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ReceiveDirect Unit CostUnit Cost [LCY]VAT %Quantity Disc. %Line Discount %Line Discount AmountAmountAmount Including VATUnit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item Entry...«Table 5411»Prod. Order Routing ToolRouting No. [PK,NN]Line No. [PK]No.DescriptionOperation No. [PK]Status; [Simulated,Planned,Firm Planne...Prod. Order No. [PK,NN]Routing Reference No. [PK]«Table 5412»Prod. Order Routing PersonnelRouting No. [PK,NN]Line No. [PK]No.DescriptionOperation No. [PK,NN]Status; [Simulated,Planned,Firm Planne...Prod. Order No. [PK,NN]Routing Reference No. [PK]«Table 5413»Prod. Order Rtng Qlty Meas.Routing No. [PK,NN]Line No. [PK]Qlty Measure CodeDescriptionMin. ValueMax. ValueMean ToleranceOperation No. [PK,NN]Status; [Simulated,Planned,Firm Planne...Prod. Order No. [PK,NN]Routing Reference No. [PK]«Table 5415»Prod. Order Rtng Comment LineRouting No. [PK,NN]Operation No. [PK,NN]Line No. [PK]DateCommentCodeStatus; [Simulated,Planned,Firm Planne...Prod. Order No. [PK,NN]Routing Reference No. [PK]«Table 83»Item Journal LineJournal Template Name [PK]Line No. [PK]Item No.Posting DateEntry Type; [Purchase,Sale,Positive Ad...Source No.Document No.DescriptionLocation CodeInventory Posting GroupSource Posting GroupQuantityInvoiced QuantityUnit AmountUnit CostAmountDiscount AmountSalespers./Purch. CodeSource CodeApplies-to EntryItem Shpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeIndirect Cost %Source Type; [,Customer,Vendor,Item]Journal Batch Name [PK]Reason CodeRecurring Method; [,Fixed,Variable]Expiration DateRecurring FrequencyDrop Shipment...«Table 99000763»Routing HeaderNo. [PK]DescriptionDescription 2Search DescriptionLast Date ModifiedCommentStatus; [New,Certified,Under Developme...Type; [Serial,Parallel]Version Nos.No. 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«Table 5405»Production OrderStatus; [Simulated,Planned,Firm Planne...No. [PK]DescriptionSearch DescriptionDescription 2Creation DateLast Date ModifiedSource Type; [Item,Family,Sales Header...Source No.Routing No.Inventory Posting GroupGen. Prod. Posting GroupGen. Bus. Posting GroupCommentStarting TimeStarting DateEnding TimeEnding DateDue DateFinished DateBlockedShortcut Dimension 1 CodeShortcut Dimension 2 CodeLocation CodeBin CodeReplan Ref. No.Replan Ref. Status; [Simulated,Planned...Low-Level CodeQuantityUnit CostCost Amount...<Routing No.><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><Prod. Order No.><Operation No.><Operation No.><Operation No.><Operation No.><Operation No.><Operation No.><Operation No.><Operation No.><Operation No.><Operation No.><Attached to Line No.><Blanket Order Line No.><Routing No.><Work Center No.><Attached to Line No.><Blanket Order Line No.><Routing No.><Work Center No.><Routing No.><Work Center No.><Attached to Line No.><Blanket Order Line No.><Routing No.><Work Center No.><Blanket Order Line No.><Attached to Line No.><Routing No.><Work Center No.><Routing No.><Prod. Order No.><Routing No.><Prod. Order No.><Routing No.><Prod. Order No.><Routing No.><Prod. Order No.><Order No.><No.><No.><Work Center No.><Cap. Unit of Measure Code><Routing No.><Work Center Group Code><Routing No.><Alternate Work Center><Work Center Group Code><Queue Time Unit of Meas. Code><Unit of Measure Code><Work Center Filter><Capacity No. Filter><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><Capacity No. Filter>

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
3 Routing Reference No. (Routing Reference No.) Integer Editable: No
4 Operation No. (Operation No.) Code10 NotBlank: Yes
5 Next Operation No. (Next Operation No.) Code30
6 Previous Operation No. (Previous Operation No.) Code30
7 Type (Type) Option
8 No. (No.) Code20
9 Work Center No. (Work Center No.) Code20 Editable: No
10 Work Center Group Code (Work Center Group Code) Code10 Editable: No
11 Description (Description) Text50
12 Setup Time (Setup Time) Decimal (0:5)
13 Run Time (Run Time) Decimal (0:5)
14 Wait Time (Wait Time) Decimal (0:5)
15 Move Time (Move Time) Decimal (0:5)
16 Fixed Scrap Quantity (Fixed Scrap Quantity) Decimal (0:5)
17 Lot Size (Lot Size) Decimal (0:5)
18 Scrap Factor % (Scrap Factor %) Decimal (0:5)
19 Setup Time Unit of Meas. Code (Setup Time Unit of Meas. Code) Code10
20 Run Time Unit of Meas. Code (Run Time Unit of Meas. Code) Code10
21 Wait Time Unit of Meas. Code (Wait Time Unit of Meas. Code) Code10
22 Move Time Unit of Meas. Code (Move Time Unit of Meas. Code) Code10
27 Minimum Process Time (Minimum Process Time) Decimal (0:5)
28 Maximum Process Time (Maximum Process Time) Decimal (0:5)
30 Concurrent Capacities (Concurrent Capacities) Decimal (0:5)
31 Send-Ahead Quantity (Send-Ahead Quantity) Decimal (0:5)
34 Routing Link Code (Routing Link Code) Code10 Editable: No
35 Standard Task Code (Standard Task Code) Code10
40 Unit Cost per (Unit Cost per) Decimal
41 Recalculate (Recalculate) Boolean
50 Sequence No. (Forward) (Sequence No. (Forward)) Integer Editable: No
51 Sequence No. (Backward) (Sequence No. (Backward)) Integer Editable: No
52 Fixed Scrap Qty. (Accum.) (Fixed Scrap Qty. (Accum.)) Decimal (0:5) Editable: No
53 Scrap Factor % (Accumulated) (Scrap Factor % (Accumulated)) Decimal (0:5) Editable: No
55 Sequence No. (Actual) (Sequence No. (Actual)) Integer Editable: No
56 Direct Unit Cost (Direct Unit Cost) Decimal (2:5)
57 Indirect Cost % (Indirect Cost %) Decimal (0:5)
58 Overhead Rate (Overhead Rate) Decimal (0:5)
70 Starting Time (Starting Time) Time
71 Starting Date (Starting Date) Date
72 Ending Time (Ending Time) Time
73 Ending Date (Ending Date) Date
74 Status (Status) Option
75 Prod. Order No. (Prod. Order No.) Code20 NotBlank: Yes
Editable: No
76 Unit Cost Calculation (Unit Cost Calculation) Option
77 Input Quantity (Input Quantity) Decimal (0:5)
78 Critical Path (Critical Path) Boolean Editable: No
79 Routing Status (Routing Status) Option
81 Flushing Method (Flushing Method) Option
90 Expected Operation Cost Amt. (Expected Operation Cost Amt.) Decimal Editable: No
91 Expected Capacity Need (Expected Capacity Need) Decimal (0:5) Editable: No
Normal
96 Expected Capacity Ovhd. Cost (Expected Capacity Ovhd. Cost) Decimal Editable: No
98 Starting Date-Time (Starting Date-Time) DateTime
99 Ending Date-Time (Ending Date-Time) DateTime
100 Schedule Manually (Schedule Manually) Boolean
101 Location Code (Location Code) Code10 Editable: No
7301 Open Shop Floor Bin Code (Open Shop Floor Bin Code) Code20 Editable: No
7302 To-Production Bin Code (To-Production Bin Code) Code20 Editable: No
7303 From-Production Bin Code (From-Production Bin Code) Code20 Editable: No

Keys

# Fields
0 Status,Prod. Order No.,Routing Reference No.,Routing No.,Operation No. (Status,Prod. Order No.,Routing Reference No.,Routing No.,Operation No.) Clustered: Yes
1 Prod. Order No.,Routing Reference No.,Status,Routing No.,Operation No. (Prod. Order No.,Routing Reference No.,Status,Routing No.,Operation No.) MaintainSIFTIndex: No
2 Status,Prod. Order No.,Routing Reference No.,Routing No.,Sequence No. (Forward) (Status,Prod. Order No.,Routing Reference No.,Routing No.,Sequence No. (Forward))
3 Status,Prod. Order No.,Routing Reference No.,Routing No.,Sequence No. (Backward) (Status,Prod. Order No.,Routing Reference No.,Routing No.,Sequence No. (Backward))
4 Status,Prod. Order No.,Routing Reference No.,Routing No.,Sequence No. (Actual) (Status,Prod. Order No.,Routing Reference No.,Routing No.,Sequence No. (Actual))
5 Work Center No. (Work Center No.) MaintainSIFTIndex: No
6 Type,No.,Starting Date (Type,No.,Starting Date) MaintainSIFTIndex: No
7 Status,Work Center No. (Status,Work Center No.)
8 Prod. Order No.,Status,Flushing Method (Prod. Order No.,Status,Flushing Method)
9 Starting Date,Starting Time (Starting Date,Starting Time) MaintainSQLIndex: No
MaintainSIFTIndex: No
10 Ending Date,Ending Time (Ending Date,Ending Time) MaintainSQLIndex: No
MaintainSIFTIndex: No

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field
Item Journal Line Operation No. (Operation No.) 1..n
Prod. Order Routing Personnel Operation No. (Operation No.) 1..n
Prod. Order Routing Tool Operation No. (Operation No.) 1..n
Prod. Order Rtng Comment Line Operation No. (Operation No.) 1..n
Prod. Order Rtng Qlty Meas. Operation No. (Operation No.) 1..n
Purch. Inv. Line Operation No. (Operation No.) 1..n
Purch. Rcpt. Line Operation No. (Operation No.) 1..n
Purchase Line Operation No. (Operation No.) 1..n
Purchase Line Archive Operation No. (Operation No.) 1..n
Requisition Line Operation No. (Operation No.) 1..n