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 |
---|