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 |
|
NotBlank: Yes |
| 2 | Name (Name) | Code10 | NotBlank: Yes | |
| 3 | Line No. (Line No.) | Integer | Editable: No | |
| 4 | Source Type (Source Type) | Integer | Editable: No | |
| 5 | Source Subtype (Source Subtype) | Option | [0,1,2,3,4,5,6,7,8,9,10] | Editable: No |
| 6 | Source No. (Source No.) | Code20 | Editable: No | |
| 7 | Source Line No. (Source Line No.) | Integer | BlankZero: Yes Editable: No |
|
| 8 | Source Subline No. (Source Subline No.) | Integer | BlankZero: Yes Editable: No |
|
| 9 | Source Document (Source Document) | Option | [,Sales Order,,,Sales Return Order,Purchase Order,,,Purchase Return Order,Inbound Transfer,Outbound Transfer,Prod. Consumption,,,,,,,,,Assembly Consumption,Assembly Order] | BlankZero: Yes Editable: No |
| 10 | Location Code (Location Code) | Code10 |
|
Editable: No |
| 11 | Shelf No. (Shelf No.) | Code10 | ||
| 12 | From Zone Code (From Zone Code) | Code10 |
|
|
| 13 | From Bin Code (From Bin Code) | Code20 | ||
| 14 | To Bin Code (To Bin Code) | Code20 |
|
|
| 15 | To Zone Code (To Zone Code) | Code10 |
|
|
| 16 | Item No. (Item No.) | Code20 |
|
|
| 17 | Quantity (Quantity) | Decimal (0:5) | ||
| 18 | Qty. (Base) (Qty. (Base)) | Decimal (0:5) | Editable: No | |
| 19 | Qty. Outstanding (Qty. Outstanding) | Decimal (0:5) | Editable: No | |
| 20 | Qty. Outstanding (Base) (Qty. Outstanding (Base)) | Decimal (0:5) | Editable: No | |
| 21 | Qty. to Handle (Qty. to Handle) | Decimal (0:5) | ||
| 22 | Qty. to Handle (Base) (Qty. to Handle (Base)) | Decimal (0:5) | ||
| 23 | Qty. Handled (Qty. Handled) | Decimal (0:5) | Editable: No | |
| 24 | Qty. Handled (Base) (Qty. Handled (Base)) | Decimal (0:5) | Editable: No | |
| 27 | From Unit of Measure Code (From Unit of Measure Code) | Code10 |
|
NotBlank: Yes |
| 28 | Qty. per From Unit of Measure (Qty. per From Unit of Measure) | Decimal (0:5) | InitValue: 1 | Editable: No |
| 29 | Unit of Measure Code (Unit of Measure Code) | Code10 |
|
NotBlank: Yes |
| 30 | Qty. per Unit of Measure (Qty. per Unit of Measure) | Decimal (0:5) | InitValue: 1 | Editable: No |
| 31 | Variant Code (Variant Code) | Code10 |
|
|
| 32 | Description (Description) | Text50 | ||
| 33 | Description 2 (Description 2) | Text50 | ||
| 35 | Sorting Sequence No. (Sorting Sequence No.) | Integer | Editable: No | |
| 36 | Due Date (Due Date) | Date | ||
| 39 | Destination Type (Destination Type) | Option | [ ,Customer,Vendor,Location] | Editable: No |
| 40 | Destination No. (Destination No.) | Code20 |
|
Editable: No |
| 41 | Shipping Agent Code (Shipping Agent Code) | Code10 | AccessByPermission: TableData 5790=R
|
|
| 42 | Shipping Agent Service Code (Shipping Agent Service Code) | Code10 |
|
|
| 43 | Shipment Method Code (Shipment Method Code) | Code10 |
|
|
| 44 | Shipping Advice (Shipping Advice) | Option | [Partial,Complete] | Editable: No |
| 45 | Shipment Date (Shipment Date) | Date | ||
| 46 | Whse. Document Type (Whse. Document Type) | Option | [ ,Receipt,Shipment,Internal Put-away,Internal Pick,Production,Whse. Mov.-Worksheet,Internal Movement,Assembly] | Editable: No |
| 47 | Whse. Document No. (Whse. Document No.) | Code20 |
|
Editable: No |
| 48 | Whse. Document Line No. (Whse. Document Line No.) | Integer |
|
BlankZero: Yes Editable: No |
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | Worksheet Template Name,Name,Location Code,Line No. (Worksheet Template Name,Name,Location Code,Line No.) | Clustered: Yes | |
| 1 | Worksheet Template Name,Name,Location Code,Sorting Sequence No. (Worksheet Template Name,Name,Location Code,Sorting Sequence No.) | ||
| 2 | Item No.,Location Code,Worksheet Template Name,Variant Code,Unit of Measure Code (Item No.,Location Code,Worksheet Template Name,Variant Code,Unit of Measure Code) | SumIndexFields: Qty. to Handle (Base) | MaintainSIFTIndex: No |
| 3 | Whse. Document Type,Whse. Document No.,Whse. Document Line No. (Whse. Document Type,Whse. Document No.,Whse. Document Line No.) | ||
| 4 | Worksheet Template Name,Name,Location Code,Item No. (Worksheet Template Name,Name,Location Code,Item No.) | MaintainSQLIndex: No | |
| 5 | Worksheet Template Name,Name,Location Code,Due Date (Worksheet Template Name,Name,Location Code,Due Date) | MaintainSQLIndex: No | |
| 6 | Worksheet Template Name,Name,Location Code,Destination Type,Destination No. (Worksheet Template Name,Name,Location Code,Destination Type,Destination No.) | MaintainSQLIndex: No | |
| 7 | Worksheet Template Name,Name,Location Code,Source Document,Source No. (Worksheet Template Name,Name,Location Code,Source Document,Source No.) | MaintainSQLIndex: No | |
| 8 | Worksheet Template Name,Name,Location Code,To Bin Code (Worksheet Template Name,Name,Location Code,To Bin Code) | MaintainSQLIndex: No | |
| 9 | Worksheet Template Name,Name,Location Code,Shelf No. (Worksheet Template Name,Name,Location Code,Shelf No.) | MaintainSQLIndex: No | |
| 10 | Source Type,Source Subtype,Source No.,Source Line No.,Source Subline No. (Source Type,Source Subtype,Source No.,Source Line No.,Source Subline No.) | ||
| 11 | Item No.,From Bin Code,Location Code,Variant Code,From Unit of Measure Code (Item No.,From Bin Code,Location Code,Variant Code,From Unit of Measure Code) | SumIndexFields: Qty. to Handle,Qty. to Handle (Base) | MaintainSIFTIndex: No |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| Whse. Document No. (Whse. Document No.) | Assembly Header | No. (No.) |
|
1..n |
| Whse. Document Line No. (Whse. Document Line No.) | Assembly Line | Line No. (Line No.) |
|
1..n |
| To Bin Code (To Bin Code) | Bin | Code (Code) |
|
1..n |
| Destination No. (Destination No.) | Customer | No. (No.) |
|
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 |
| Destination No. (Destination No.) | Location | Code (Code) |
|
1..n |
| Whse. Document No. (Whse. Document No.) | Posted Whse. Receipt Header | No. (No.) |
|
1..n |
| Whse. Document Line No. (Whse. Document Line No.) | Posted Whse. Receipt Line | Line No. (Line No.) |
|
1..n |
| Whse. Document Line No. (Whse. Document Line No.) | Prod. Order Line | Line No. (Line No.) |
|
1..n |
| Whse. Document No. (Whse. Document No.) | Production Order | No. (No.) |
|
1..n |
| Shipment Method Code (Shipment Method Code) | Shipment Method | Code (Code) |
|
1..n |
| Shipping Agent Code (Shipping Agent Code) | Shipping Agent | Code (Code) |
|
1..n |
| Shipping Agent Service Code (Shipping Agent Service Code) | Shipping Agent Services | Code (Code) |
|
1..n |
| Destination No. (Destination No.) | Vendor | No. (No.) |
|
1..n |
| Whse. Document No. (Whse. Document No.) | Warehouse Shipment Header | No. (No.) |
|
1..n |
| Whse. Document Line No. (Whse. Document Line No.) | Warehouse Shipment Line | Line No. (Line No.) |
|
1..n |
| Whse. Document No. (Whse. Document No.) | Whse. Internal Pick Header | No. (No.) |
|
1..n |
| Whse. Document Line No. (Whse. Document Line No.) | Whse. Internal Pick Line | Line No. (Line No.) |
|
1..n |
| Whse. Document No. (Whse. Document No.) | Whse. Internal Put-away Header | No. (No.) |
|
1..n |
| Whse. Document Line No. (Whse. Document Line No.) | Whse. Internal Put-away Line | Line No. (Line No.) |
|
1..n |
| Worksheet Template Name (Worksheet Template Name) | Whse. Worksheet Template | Name (Name) |
|
1..n |
| To Zone Code (To Zone Code) | Zone | Code (Code) |
|
1..n |
Table Relations From Other Tables
| From Table | From Field |
|---|