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 | [Work Center,Machine Center] | |
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) | InitValue: 1 | |
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 | AutoFormatType: 2 | |
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 | [Simulated,Planned,Firm Planned,Released,Finished] | |
75 | Prod. Order No. (Prod. Order No.) | Code20 |
|
NotBlank: Yes Editable: No |
76 | Unit Cost Calculation (Unit Cost Calculation) | Option | [Time,Units] | |
77 | Input Quantity (Input Quantity) | Decimal (0:5) | ||
78 | Critical Path (Critical Path) | Boolean | Editable: No | |
79 | Routing Status (Routing Status) | Option | [ ,Planned,In Progress,Finished] | |
81 | Flushing Method (Flushing Method) | Option | [Manual,Forward,Backward] InitValue: Manual |
|
90 | Expected Operation Cost Amt. (Expected Operation Cost Amt.) | Decimal | AutoFormatType: 1 | 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 | AutoFormatType: 1 | 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 | AccessByPermission: TableData 14=R | Editable: No |
7301 | Open Shop Floor Bin Code (Open Shop Floor Bin Code) | Code20 | AccessByPermission: TableData 5771=R | Editable: No |
7302 | To-Production Bin Code (To-Production Bin Code) | Code20 | AccessByPermission: TableData 5771=R | Editable: No |
7303 | From-Production Bin Code (From-Production Bin Code) | Code20 | AccessByPermission: TableData 5771=R | 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.) | SumIndexFields: Expected Operation Cost Amt.,Expected Capacity Need,Expected Capacity Ovhd. Cost | 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.) | SumIndexFields: Expected Operation Cost Amt. | MaintainSIFTIndex: No |
6 | Type,No.,Starting Date (Type,No.,Starting Date) | SumIndexFields: Expected Operation Cost Amt. | 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 |