Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
| # | Name | Type | ||
|---|---|---|---|---|
| 1 | Status (Status) | Option | [Simulated,Planned,Firm Planned,Released,Finished] | |
| 2 | Prod. Order No. (Prod. Order No.) | Code20 |
|
|
| 3 | Prod. Order Line No. (Prod. Order Line No.) | Integer |
|
|
| 4 | Line No. (Line No.) | Integer | ||
| 11 | Item No. (Item No.) | Code20 |
|
|
| 12 | Description (Description) | Text50 | ||
| 13 | Unit of Measure Code (Unit of Measure Code) | Code10 |
|
|
| 14 | Quantity (Quantity) | Decimal (0:5) | Editable: No | |
| 15 | Position (Position) | Code10 | ||
| 16 | Position 2 (Position 2) | Code10 | ||
| 17 | Position 3 (Position 3) | Code10 | ||
| 18 | Lead-Time Offset (Lead-Time Offset) | DateFormula | ||
| 19 | Routing Link Code (Routing Link Code) | Code10 |
|
|
| 20 | Scrap % (Scrap %) | Decimal (0:5) | MaxValue: 100 | |
| 21 | Variant Code (Variant Code) | Code10 |
|
|
| 25 | Expected Quantity (Expected Quantity) | Decimal (0:5) | Editable: No | |
| 26 | Remaining Quantity (Remaining Quantity) | Decimal (0:5) | Editable: No | |
| 27 | Act. Consumption (Qty) (Act. Consumption (Qty)) | Decimal (0:5) | AccessByPermission: TableData 5405=R
|
Editable: No FlowField |
| 28 | Flushing Method (Flushing Method) | Option | [Manual,Forward,Backward,Pick + Forward,Pick + Backward] | |
| 30 | Location Code (Location Code) | Code10 |
|
|
| 31 | Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) | Code20 | CaptionClass: '1,2,1'
|
|
| 32 | Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) | Code20 | CaptionClass: '1,2,2'
|
|
| 33 | Bin Code (Bin Code) | Code20 |
|
|
| 35 | Supplied-by Line No. (Supplied-by Line No.) | Integer |
|
|
| 36 | Planning Level Code (Planning Level Code) | Integer | Editable: No | |
| 37 | Item Low-Level Code (Item Low-Level Code) | Integer | ||
| 40 | Length (Length) | Decimal (0:5) | ||
| 41 | Width (Width) | Decimal (0:5) | ||
| 42 | Weight (Weight) | Decimal (0:5) | ||
| 43 | Depth (Depth) | Decimal (0:5) | ||
| 44 | Calculation Formula (Calculation Formula) | Option | [ ,Length,Length * Width,Length * Width * Depth,Weight] | |
| 45 | Quantity per (Quantity per) | Decimal (0:5) | ||
| 50 | Unit Cost (Unit Cost) | Decimal (2:5) | ||
| 51 | Cost Amount (Cost Amount) | Decimal | AutoFormatType: 1 | Editable: No |
| 52 | Due Date (Due Date) | Date | ||
| 53 | Due Time (Due Time) | Time | ||
| 60 | Qty. per Unit of Measure (Qty. per Unit of Measure) | Decimal (0:5) | Editable: No | |
| 61 | Remaining Qty. (Base) (Remaining Qty. (Base)) | Decimal (0:5) | Editable: No | |
| 62 | Quantity (Base) (Quantity (Base)) | Decimal (0:5) | ||
| 63 | Reserved Qty. (Base) (Reserved Qty. (Base)) | Decimal (0:5) |
|
Editable: Yes FlowField |
| 71 | Reserved Quantity (Reserved Quantity) | Decimal (0:5) |
|
Editable: No FlowField |
| 73 | Expected Qty. (Base) (Expected Qty. (Base)) | Decimal (0:5) | Editable: No | |
| 76 | Due Date-Time (Due Date-Time) | DateTime | ||
| 480 | Dimension Set ID (Dimension Set ID) | Integer |
|
Editable: No |
| 5702 | Substitution Available (Substitution Available) | Boolean |
|
Editable: No FlowField |
| 5703 | Original Item No. (Original Item No.) | Code20 |
|
Editable: No |
| 5704 | Original Variant Code (Original Variant Code) | Code10 |
|
Editable: No |
| 5750 | Pick Qty. (Pick Qty.) | Decimal (0:5) |
|
Editable: No FlowField |
| 7300 | Qty. Picked (Qty. Picked) | Decimal (0:5) | Editable: No | |
| 7301 | Qty. Picked (Base) (Qty. Picked (Base)) | Decimal (0:5) | Editable: No | |
| 7302 | Completely Picked (Completely Picked) | Boolean | Editable: No | |
| 7303 | Pick Qty. (Base) (Pick Qty. (Base)) | Decimal (0:5) |
|
Editable: No FlowField |
| 99000754 | Direct Unit Cost (Direct Unit Cost) | Decimal (2:5) | ||
| 99000755 | Indirect Cost % (Indirect Cost %) | Decimal (0:5) | ||
| 99000756 | Overhead Rate (Overhead Rate) | Decimal (0:5) | ||
| 99000757 | Direct Cost Amount (Direct Cost Amount) | Decimal (2:2) | ||
| 99000758 | Overhead Amount (Overhead Amount) | Decimal (2:2) |
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | Status,Prod. Order No.,Prod. Order Line No.,Line No. (Status,Prod. Order No.,Prod. Order Line No.,Line No.) | Clustered: Yes | |
| 1 | Prod. Order No.,Prod. Order Line No.,Line No.,Status (Prod. Order No.,Prod. Order Line No.,Line No.,Status) | ||
| 2 | Status,Prod. Order No.,Prod. Order Line No.,Due Date (Status,Prod. Order No.,Prod. Order Line No.,Due Date) | SumIndexFields: Expected Quantity,Cost Amount | |
| 3 | Status,Prod. Order No.,Prod. Order Line No.,Item No.,Line No. (Status,Prod. Order No.,Prod. Order Line No.,Item No.,Line No.) | MaintainSQLIndex: No | |
| 4 | Status,Item No.,Variant Code,Location Code,Due Date (Status,Item No.,Variant Code,Location Code,Due Date) | SumIndexFields: Expected Quantity,Remaining Qty. (Base),Cost Amount,Overhead Amount | MaintainSIFTIndex: No |
| 5 | Item No.,Variant Code,Location Code,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Due Date (Item No.,Variant Code,Location Code,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Due Date) | SumIndexFields: Expected Quantity,Remaining Qty. (Base),Cost Amount,Overhead Amount | |
| 6 | Status,Prod. Order No.,Routing Link Code,Flushing Method (Status,Prod. Order No.,Routing Link Code,Flushing Method) | ||
| 7 | Status,Prod. Order No.,Location Code (Status,Prod. Order No.,Location Code) | ||
| 8 | Item No.,Variant Code,Location Code,Status,Due Date (Item No.,Variant Code,Location Code,Status,Due Date) | SumIndexFields: Expected Qty. (Base),Remaining Qty. (Base),Cost Amount,Overhead Amount,Qty. Picked (Base) | MaintainSIFTIndex: No |
| 9 | Status,Prod. Order No.,Prod. Order Line No.,Item Low-Level Code (Status,Prod. Order No.,Prod. Order Line No.,Item Low-Level Code) | MaintainSQLIndex: No |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| Bin Code (Bin Code) | Bin | Code (Code) |
|
1..n |
| Dimension Set ID (Dimension Set ID) | Dimension Set Entry | () |
|
1..n |
| Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) | Dimension Value | Code (Code) |
|
1..n |
| Original Item No. (Original Item No.) | Item | No. (No.) |
|
1..n |
| Unit of Measure Code (Unit of Measure Code) | Item Unit of Measure | Code (Code) |
|
1..n |
| Original Variant Code (Original Variant Code) | Item Variant | Code (Code) |
|
1..n |
| Location Code (Location Code) | Location | () |
|
1..n |
| Supplied-by Line No. (Supplied-by Line No.) | Prod. Order Line | Line No. (Line No.) |
|
1..n |
| Prod. Order No. (Prod. Order No.) | Production Order | No. (No.) |
|
1..n |
| Routing Link Code (Routing Link Code) | Routing Link | Code (Code) |
|
1..n |
Table Relations From Other Tables
| From Table | From Field | ||
|---|---|---|---|
| Item Journal Line | Prod. Order Comp. Line No. (Prod. Order Comp. Line No.) |
|
1..n |
| Prod. Order Comp. Cmt Line | Prod. Order BOM Line No. (Prod. Order BOM Line No.) |
|
1..n |