Diagrams

Table

Planning Routing Line

DynamicsDocs.comPlanning Routing Line«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]...«Table 244»Req. Wksh. TemplateName [PK,NN]DescriptionPage IDRecurringPage CaptionType; [Req.,For. Labor,Planning]«Table 245»Requisition Wksh. NameWorksheet Template Name [PK,NN]Name [PK,NN]DescriptionTemplate Type; [Req.,For. Labor,Planni...Recurring«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 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<Worksheet Template Name><Worksheet Batch Name><Worksheet Line 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><Worksheet Template Name><Worksheet Template Name><Journal Batch Name><Work Center No.><Alternate Work Center><Work Center Group Code><Queue Time Unit of Meas. Code><Unit of Measure Code><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>

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

Fields

# Name Type
1 Worksheet Template Name (Worksheet Template Name) Code10 Editable: No
2 Worksheet Batch Name (Worksheet Batch Name) Code10
3 Worksheet Line No. (Worksheet Line No.) Integer
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
35 Standard Task Code (Standard Task Code) Code10
40 Unit Cost per (Unit Cost per) Decimal
41 Recalculate (Recalculate) Boolean Editable: No
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 (1:1) 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)
61 Output Quantity (Output Quantity) Decimal (0:5) Editable: No
70 Starting Time (Starting Time) Time
71 Starting Date (Starting Date) Date
72 Ending Time (Ending Time) Time
73 Ending Date (Ending Date) Date
76 Unit Cost Calculation (Unit Cost Calculation) Option
77 Input Quantity (Input Quantity) Decimal (0:5) Editable: No
78 Critical Path (Critical Path) Boolean Editable: No
98 Starting Date-Time (Starting Date-Time) DateTime
99 Ending Date-Time (Ending Date-Time) DateTime
99000909 Expected Operation Cost Amt. (Expected Operation Cost Amt.) Decimal Editable: No
99000910 Expected Capacity Ovhd. Cost (Expected Capacity Ovhd. Cost) Decimal Editable: No
99000911 Expected Capacity Need (Expected Capacity Need) Decimal (0:5) Editable: No

Keys

# Fields
0 Worksheet Template Name,Worksheet Batch Name,Worksheet Line No.,Operation No. (Worksheet Template Name,Worksheet Batch Name,Worksheet Line No.,Operation No.) Clustered: Yes
MaintainSIFTIndex: No
1 Worksheet Template Name,Worksheet Batch Name,Worksheet Line No.,Sequence No.(Forward) (Worksheet Template Name,Worksheet Batch Name,Worksheet Line No.,Sequence No.(Forward)) MaintainSQLIndex: No
2 Worksheet Template Name,Worksheet Batch Name,Worksheet Line No.,Sequence No.(Backward) (Worksheet Template Name,Worksheet Batch Name,Worksheet Line No.,Sequence No.(Backward)) MaintainSQLIndex: No
3 Worksheet Template Name,Worksheet Batch Name,Worksheet Line No.,Sequence No. (Actual) (Worksheet Template Name,Worksheet Batch Name,Worksheet Line No.,Sequence No. (Actual)) MaintainSQLIndex: No
4 Worksheet Template Name,Worksheet Batch Name,Type,No.,Starting Date (Worksheet Template Name,Worksheet Batch Name,Type,No.,Starting Date) MaintainSQLIndex: No
5 Work Center No. (Work Center No.)
6 Type,No. (Type,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
Worksheet Template Name (Worksheet Template Name) Req. Wksh. Template Name (Name) 1..n
Worksheet Line No. (Worksheet Line No.) Requisition Line Line No. (Line No.) 1..n
Worksheet Batch Name (Worksheet Batch Name) Requisition Wksh. Name Name (Name) 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