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

Keys

# Fields
0 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) MaintainSQLIndex: No
2 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) MaintainSQLIndex: No
4 Worksheet Template Name,Worksheet Batch Name,Type,No.,Starting Date MaintainSQLIndex: No
5 Work Center No.
6 Type,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
Worksheet Template Name Req. Wksh. Template Name 1..n
Worksheet Line No. Requisition Line Line No. 1..n
Worksheet Batch Name Requisition Wksh. Name Name 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