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