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 |
|
|
| 2 | Worksheet Batch Name (Worksheet Batch Name) | Code10 |
|
|
| 3 | Worksheet Line No. (Worksheet Line No.) | Integer |
|
|
| 5 | Line No. (Line No.) | Integer | BlankZero: Yes | |
| 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 | BlankNumbers: BlankNeg |
| 21 | Variant Code (Variant Code) | Code10 |
|
|
| 25 | Expected Quantity (Expected Quantity) | Decimal (0:5) | Editable: No | |
| 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 | Ref. Order Status (Ref. Order Status) | Option | [Simulated,Planned,Firm Planned,Released] | |
| 38 | Ref. Order No. (Ref. Order No.) | Code20 | ||
| 39 | Ref. Order Line No. (Ref. Order Line No.) | 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) | ||
| 46 | Ref. Order Type (Ref. Order Type) | Option | [ ,Purchase,Prod. Order,Transfer,Assembly] | Editable: No |
| 50 | Unit Cost (Unit Cost) | Decimal | AutoFormatType: 1 | |
| 51 | Cost Amount (Cost Amount) | Decimal | AutoFormatType: 2 | |
| 52 | Due Date (Due Date) | Date | ||
| 53 | Due Time (Due Time) | Time | ||
| 55 | Direct Unit Cost (Direct Unit Cost) | Decimal (2:5) | ||
| 56 | Indirect Cost % (Indirect Cost %) | Decimal (0:5) | ||
| 57 | Overhead Rate (Overhead Rate) | Decimal (0:5) | ||
| 58 | Direct Cost Amount (Direct Cost Amount) | Decimal (2:2) | ||
| 59 | Overhead Amount (Overhead Amount) | Decimal (2:2) | ||
| 60 | Qty. per Unit of Measure (Qty. per Unit of Measure) | Decimal (0:5) | Editable: No | |
| 62 | Quantity (Base) (Quantity (Base)) | Decimal (0:5) | ||
| 63 | Reserved Qty. (Base) (Reserved Qty. (Base)) | Decimal (0:5) |
|
Editable: No FlowField |
| 71 | Reserved Quantity (Reserved Quantity) | Decimal (0:5) |
|
Editable: No FlowField |
| 73 | Expected Quantity (Base) (Expected Quantity (Base)) | Decimal (0:5) | Editable: No | |
| 74 | Original Expected Qty. (Base) (Original Expected Qty. (Base)) | Decimal (0:5) | BlankZero: Yes Editable: No |
|
| 75 | Net Quantity (Base) (Net Quantity (Base)) | Decimal (0:5) | Editable: No | |
| 76 | Due Date-Time (Due Date-Time) | DateTime | ||
| 480 | Dimension Set ID (Dimension Set ID) | Integer |
|
Editable: No |
| 99000875 | Critical (Critical) | Boolean | ||
| 99000915 | Planning Line Origin (Planning Line Origin) | Option | [ ,Action Message,Planning,Order Planning] | Editable: No |
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | Worksheet Template Name,Worksheet Batch Name,Worksheet Line No.,Line No. (Worksheet Template Name,Worksheet Batch Name,Worksheet Line No.,Line No.) | SumIndexFields: Cost Amount | Clustered: Yes MaintainSIFTIndex: No |
| 1 | Item No.,Variant Code,Location Code,Due Date,Planning Line Origin (Item No.,Variant Code,Location Code,Due Date,Planning Line Origin) | SumIndexFields: Expected Quantity (Base),Cost Amount | MaintainSIFTIndex: No |
| 2 | Item No.,Variant Code,Location Code,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Planning Line Origin,Due Date (Item No.,Variant Code,Location Code,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Planning Line Origin,Due Date) | SumIndexFields: Expected Quantity (Base),Cost Amount | MaintainSQLIndex: No MaintainSIFTIndex: No |
| 3 | Worksheet Template Name,Worksheet Batch Name,Worksheet Line No.,Item No. (Worksheet Template Name,Worksheet Batch Name,Worksheet Line No.,Item No.) | 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 |
| Item No. (Item No.) | Item | () |
|
1..n |
| Unit of Measure Code (Unit of Measure Code) | Item Unit of Measure | Code (Code) |
|
1..n |
| Variant Code (Variant Code) | Item Variant | Code (Code) |
|
1..n |
| Location Code (Location Code) | Location | () |
|
1..n |
| Worksheet Template Name (Worksheet Template Name) | Req. Wksh. Template | Name (Name) |
|
1..n |
| Supplied-by Line No. (Supplied-by 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 |
Table Relations From Other Tables
| From Table | From Field |
|---|