Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
| # | Name | Type | ||
|---|---|---|---|---|
| 1 | No. (No.) | Code20 | ||
| 3 | Name (Name) | Text50 | ||
| 4 | Search Name (Search Name) | Code50 | ||
| 5 | Name 2 (Name 2) | Text50 | ||
| 6 | Address (Address) | Text50 | ||
| 7 | Address 2 (Address 2) | Text50 | ||
| 8 | City (City) | Text30 |
|
|
| 9 | Post Code (Post Code) | Code20 |
|
|
| 14 | Work Center No. (Work Center No.) | Code20 |
|
|
| 19 | Direct Unit Cost (Direct Unit Cost) | Decimal | AutoFormatType: 2 | |
| 20 | Indirect Cost % (Indirect Cost %) | Decimal (0:5) | ||
| 21 | Unit Cost (Unit Cost) | Decimal (2:5) | AutoFormatType: 2 | |
| 22 | Queue Time (Queue Time) | Decimal (0:5) | ||
| 23 | Queue Time Unit of Meas. Code (Queue Time Unit of Meas. Code) | Code10 |
|
|
| 26 | Last Date Modified (Last Date Modified) | Date | Editable: No | |
| 27 | Comment (Comment) | Boolean |
|
Editable: No FlowField |
| 31 | Capacity (Capacity) | Decimal (0:5) | ||
| 32 | Efficiency (Efficiency) | Decimal (0:5) | InitValue: 100 | |
| 33 | Maximum Efficiency (Maximum Efficiency) | Decimal (0:5) | ||
| 34 | Minimum Efficiency (Minimum Efficiency) | Decimal (0:5) | ||
| 38 | Blocked (Blocked) | Boolean | ||
| 39 | Date Filter (Date Filter) | Date | FlowFilter | |
| 40 | Work Shift Filter (Work Shift Filter) | Code10 |
|
FlowFilter |
| 41 | Capacity (Total) (Capacity (Total)) | Decimal (0:5) |
|
Editable: No FlowField |
| 42 | Capacity (Effective) (Capacity (Effective)) | Decimal (0:5) |
|
Editable: No FlowField |
| 44 | Prod. Order Need (Qty.) (Prod. Order Need (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
| 45 | Prod. Order Need Amount (Prod. Order Need Amount) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 47 | Prod. Order Status Filter (Prod. Order Status Filter) | Option | [Simulated,Planned,Firm Planned,Released,Finished] | FlowFilter |
| 50 | Setup Time (Setup Time) | Decimal (0:5) | ||
| 52 | Wait Time (Wait Time) | Decimal (0:5) | ||
| 53 | Move Time (Move Time) | Decimal (0:5) | ||
| 54 | Fixed Scrap Quantity (Fixed Scrap Quantity) | Decimal (0:5) | ||
| 55 | Scrap % (Scrap %) | Decimal (0:5) | ||
| 56 | Setup Time Unit of Meas. Code (Setup Time Unit of Meas. Code) | Code10 |
|
|
| 57 | Wait Time Unit of Meas. Code (Wait Time Unit of Meas. Code) | Code10 |
|
|
| 58 | Send-Ahead Quantity (Send-Ahead Quantity) | Decimal (0:5) | ||
| 59 | Move Time Unit of Meas. Code (Move Time Unit of Meas. Code) | Code10 |
|
|
| 60 | Flushing Method (Flushing Method) | Option | [Manual,Forward,Backward] InitValue: Manual |
|
| 62 | Minimum Process Time (Minimum Process Time) | Decimal (0:5) | ||
| 63 | Maximum Process Time (Maximum Process Time) | Decimal (0:5) | ||
| 64 | Concurrent Capacities (Concurrent Capacities) | Decimal (0:5) | ||
| 65 | Item Filter (Item Filter) | Code20 |
|
FlowFilter |
| 66 | Stop Code Filter (Stop Code Filter) | Code10 |
|
FlowFilter |
| 67 | Scrap Code Filter (Scrap Code Filter) | Code10 |
|
FlowFilter |
| 80 | No. Series (No. Series) | Code10 |
|
Editable: No |
| 81 | Overhead Rate (Overhead Rate) | Decimal | AutoFormatType: 2 | |
| 82 | Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Code10 |
|
|
| 83 | County (County) | Text30 | ||
| 84 | Country/Region Code (Country/Region Code) | Code10 |
|
|
| 7300 | Location Code (Location Code) | Code10 |
|
Editable: No |
| 7301 | Open Shop Floor Bin Code (Open Shop Floor Bin Code) | Code20 |
|
|
| 7302 | To-Production Bin Code (To-Production Bin Code) | Code20 |
|
|
| 7303 | From-Production Bin Code (From-Production Bin Code) | Code20 |
|
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | No. (No.) | Clustered: Yes | |
| 1 | Search Name (Search Name) | ||
| 2 | Work Center No. (Work Center No.) |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| From-Production Bin Code (From-Production Bin Code) | Bin | Code (Code) |
|
1..n |
| Move Time Unit of Meas. Code (Move Time Unit of Meas. Code) | Capacity Unit of Measure | Code (Code) |
|
1..n |
| Country/Region Code (Country/Region Code) | Country/Region | Code (Code) |
|
1..n |
| Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Gen. Product Posting Group | Code (Code) |
|
1..n |
| Item Filter (Item Filter) | Item | No. (No.) |
|
1..n |
| Location Code (Location Code) | Location | Code (Code) |
|
1..n |
| No. Series (No. Series) | No. Series | Code (Code) |
|
1..n |
| Scrap Code Filter (Scrap Code Filter) | Scrap | Code (Code) |
|
1..n |
| Stop Code Filter (Stop Code Filter) | Stop | Code (Code) |
|
1..n |
| Work Center No. (Work Center No.) | Work Center | No. (No.) |
|
1..n |
| Work Shift Filter (Work Shift Filter) | Work Shift | Code (Code) |
|
1..n |
Table Relations From Other Tables
| From Table | From Field | ||
|---|---|---|---|
| BOM Buffer | No. (No.) |
|
1..n |
| Calendar Absence Entry | No. (No.) |
|
1..n |
| Calendar Entry | No. (No.) |
|
1..n |
| Capacity Constrained Resource | Capacity No. (Capacity No.) |
|
1..n |
| Capacity Ledger Entry | No. (No.) |
|
1..n |
| Item Journal Line | No. (No.) |
|
1..n |
| Manufacturing Comment Line | No. (No.) |
|
1..n |
| Planning Routing Line | No. (No.) |
|
1..n |
| Prod. Order Capacity Need | No. (No.) |
|
1..n |
| Prod. Order Line | Capacity No. Filter (Capacity No. Filter) |
|
1..n |
| Prod. Order Routing Line | No. (No.) |
|
1..n |
| Production Order | Capacity No. Filter (Capacity No. Filter) |
|
1..n |
| Registered Absence | No. (No.) |
|
1..n |
| Routing Line | No. (No.) |
|
1..n |
| Standard Cost Worksheet | No. (No.) |
|
1..n |
| Value Entry | No. (No.) |
|
1..n |