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

Keys

# Fields
0 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. MaintainSIFTIndex: No
2 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)
4 Status,Prod. Order No.,Routing Reference No.,Routing No.,Sequence No. (Actual)
5 Work Center No. MaintainSIFTIndex: No
6 Type,No.,Starting Date MaintainSIFTIndex: No
7 Status,Work Center No.
8 Prod. Order No.,Status,Flushing Method
9 Starting Date,Starting Time MaintainSQLIndex: No
MaintainSIFTIndex: No
10 Ending Date,Ending Time MaintainSQLIndex: No
MaintainSIFTIndex: No

Table Relations To Other Tables

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

Table Relations From Other Tables

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