Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
| # | Name | Type | ||
|---|---|---|---|---|
| 1 | Document Type (Document Type) | Option | [Quote,Order,,,Blanket Order] | |
| 2 | No. (No.) | Code20 | ||
| 3 | Description (Description) | Text50 | ||
| 4 | Search Description (Search Description) | Code50 | ||
| 5 | Description 2 (Description 2) | Text50 | ||
| 6 | Creation Date (Creation Date) | Date | Editable: No | |
| 7 | Last Date Modified (Last Date Modified) | Date | Editable: No | |
| 10 | Item No. (Item No.) | Code20 |
|
|
| 12 | Variant Code (Variant Code) | Code10 |
|
|
| 15 | Inventory Posting Group (Inventory Posting Group) | Code10 |
|
|
| 16 | Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Code10 |
|
|
| 19 | Comment (Comment) | Boolean |
|
Editable: No FlowField |
| 20 | Location Code (Location Code) | Code10 |
|
|
| 21 | Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) | Code20 | CaptionClass: '1,2,1'
|
|
| 22 | Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) | Code20 | CaptionClass: '1,2,2'
|
|
| 23 | Posting Date (Posting Date) | Date | ||
| 24 | Due Date (Due Date) | Date | ||
| 25 | Starting Date (Starting Date) | Date | ||
| 27 | Ending Date (Ending Date) | Date | ||
| 33 | Bin Code (Bin Code) | Code20 |
|
|
| 40 | Quantity (Quantity) | Decimal (0:5) | ||
| 41 | Quantity (Base) (Quantity (Base)) | Decimal (0:5) | ||
| 42 | Remaining Quantity (Remaining Quantity) | Decimal (0:5) | Editable: No | |
| 43 | Remaining Quantity (Base) (Remaining Quantity (Base)) | Decimal (0:5) | Editable: No | |
| 44 | Assembled Quantity (Assembled Quantity) | Decimal (0:5) | AccessByPermission: TableData 90=R | Editable: No |
| 45 | Assembled Quantity (Base) (Assembled Quantity (Base)) | Decimal (0:5) | Editable: No | |
| 46 | Quantity to Assemble (Quantity to Assemble) | Decimal (0:5) | ||
| 47 | Quantity to Assemble (Base) (Quantity to Assemble (Base)) | Decimal (0:5) | ||
| 48 | Reserved Quantity (Reserved Quantity) | Decimal (0:5) |
|
Editable: No FlowField |
| 49 | Reserved Qty. (Base) (Reserved Qty. (Base)) | Decimal (0:5) |
|
Editable: No FlowField |
| 50 | Planning Flexibility (Planning Flexibility) | Option | [Unlimited,None] | |
| 51 | MPS Order (MPS Order) | Boolean | ||
| 54 | Assemble to Order (Assemble to Order) | Boolean |
|
Editable: No FlowField |
| 63 | Posting No. (Posting No.) | Code20 | Editable: No | |
| 65 | Unit Cost (Unit Cost) | Decimal | AutoFormatType: 2 | |
| 67 | Cost Amount (Cost Amount) | Decimal | AutoFormatType: 1 | Editable: No |
| 68 | Rolled-up Assembly Cost (Rolled-up Assembly Cost) | Decimal |
|
FlowField |
| 75 | Indirect Cost % (Indirect Cost %) | Decimal (0:5) | ||
| 76 | Overhead Rate (Overhead Rate) | Decimal (0:5) | ||
| 80 | Unit of Measure Code (Unit of Measure Code) | Code10 |
|
|
| 81 | Qty. per Unit of Measure (Qty. per Unit of Measure) | Decimal (0:5) | Editable: No | |
| 107 | No. Series (No. Series) | Code10 |
|
Editable: No |
| 108 | Posting No. Series (Posting No. Series) | Code10 |
|
|
| 120 | Status (Status) | Option | [Open,Released] | Editable: No |
| 480 | Dimension Set ID (Dimension Set ID) | Integer |
|
Editable: No |
| 9000 | Assigned User ID (Assigned User ID) | Code50 |
|
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | Document Type,No. (Document Type,No.) | Clustered: Yes | |
| 1 | Document Type,Item No.,Variant Code,Location Code,Due Date (Document Type,Item No.,Variant Code,Location Code,Due Date) | SumIndexFields: Remaining Quantity (Base) |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| Bin Code (Bin Code) | Bin | Code (Code) |
|
1..n |
| Bin Code (Bin Code) | Bin Content | Bin Code (Bin 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 |
| Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Gen. Product Posting Group | Code (Code) |
|
1..n |
| Inventory Posting Group (Inventory Posting Group) | Inventory Posting Group | 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 |
| Posting No. Series (Posting No. Series) | No. Series | Code (Code) |
|
1..n |
| Assigned User ID (Assigned User ID) | User Setup | User ID (User ID) |
|
1..n |
Table Relations From Other Tables
| From Table | From Field | ||
|---|---|---|---|
| Assembly Comment Line | Document No. (Document No.) |
|
1..n |
| Assembly Line | Document No. (Document No.) |
|
1..n |
| Registered Invt. Movement Hdr. | Source No. (Source No.) |
|
1..n |
| Registered Whse. Activity Line | Whse. Document No. (Whse. Document No.) |
|
1..n |
| Time Sheet Detail | Assembly Order No. (Assembly Order No.) |
|
1..n |
| Time Sheet Detail Archive | Assembly Order No. (Assembly Order No.) |
|
1..n |
| Time Sheet Line | Assembly Order No. (Assembly Order No.) |
|
1..n |
| Time Sheet Line Archive | Assembly Order No. (Assembly Order No.) |
|
1..n |
| Warehouse Activity Line | Whse. Document No. (Whse. Document No.) |
|
1..n |
| Warehouse Request | Source No. (Source No.) |
|
1..n |
| Whse. Pick Request | Document No. (Document No.) |
|
1..n |
| Whse. Worksheet Line | Whse. Document No. (Whse. Document No.) |
|
1..n |