Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | Activity Type (Activity Type) | Option | [ ,Put-away,Pick,Movement] | |
2 | No. (No.) | Code20 | ||
3 | Line No. (Line No.) | Integer | ||
4 | Source Type (Source Type) | Integer | ||
5 | Source Subtype (Source Subtype) | Option | [0,1,2,3,4,5,6,7,8,9,10] | |
6 | Source No. (Source No.) | Code20 | ||
7 | Source Line No. (Source Line No.) | Integer | BlankZero: Yes | |
8 | Source Subline No. (Source Subline No.) | Integer | BlankZero: Yes | |
9 | Source Document (Source Document) | Option | [,Sales Order,,,Sales Return Order,Purchase Order,,,Purchase Return Order,Inbound Transfer,Outbound Transfer,Prod. Consumption,,,,,,,Service Order,,Assembly Consumption,Assembly Order] | BlankZero: Yes |
11 | Location Code (Location Code) | Code10 |
|
|
12 | Shelf No. (Shelf No.) | Code10 | ||
13 | Sorting Sequence No. (Sorting Sequence No.) | Integer | ||
14 | Item No. (Item No.) | Code20 |
|
|
15 | Variant Code (Variant Code) | Code10 |
|
|
16 | Unit of Measure Code (Unit of Measure Code) | Code10 |
|
|
17 | Qty. per Unit of Measure (Qty. per Unit of Measure) | Decimal (0:5) | InitValue: 1 | |
18 | Description (Description) | Text50 | ||
19 | Description 2 (Description 2) | Text50 | ||
20 | Quantity (Quantity) | Decimal (0:5) | ||
21 | Qty. (Base) (Qty. (Base)) | Decimal (0:5) | ||
31 | Shipping Advice (Shipping Advice) | Option | [Partial,Complete] | |
34 | Due Date (Due Date) | Date | ||
39 | Destination Type (Destination Type) | Option | [ ,Customer,Vendor,Location,Item,Family,Sales Order] | |
40 | Destination No. (Destination No.) | Code20 |
|
|
41 | Whse. Activity No. (Whse. Activity No.) | Code20 | ||
42 | Shipping Agent Code (Shipping Agent Code) | Code10 |
|
|
43 | Shipping Agent Service Code (Shipping Agent Service Code) | Code10 |
|
|
44 | Shipment Method Code (Shipment Method Code) | Code10 |
|
|
47 | Starting Date (Starting Date) | Date | ||
6500 | Serial No. (Serial No.) | Code20 | ||
6501 | Lot No. (Lot No.) | Code20 | ||
6502 | Warranty Date (Warranty Date) | Date | ||
6503 | Expiration Date (Expiration Date) | Date | ||
7300 | Bin Code (Bin Code) | Code20 |
|
|
7301 | Zone Code (Zone Code) | Code10 |
|
|
7305 | Action Type (Action Type) | Option | [ ,Take,Place] | Editable: No |
7306 | Whse. Document Type (Whse. Document Type) | Option | [ ,Receipt,Shipment,Internal Put-away,Internal Pick,Production,Movement Worksheet,,Assembly] | Editable: No |
7307 | Whse. Document No. (Whse. Document No.) | Code20 |
|
Editable: No |
7308 | Whse. Document Line No. (Whse. Document Line No.) | Integer |
|
BlankZero: Yes Editable: No |
7310 | Cubage (Cubage) | Decimal (0:5) | ||
7311 | Weight (Weight) | Decimal (0:5) | ||
7312 | Special Equipment Code (Special Equipment Code) | Code10 |
|
Keys
# | Fields | ||
---|---|---|---|
0 | Activity Type,No.,Line No. (Activity Type,No.,Line No.) | Clustered: Yes | |
1 | No.,Line No.,Activity Type (No.,Line No.,Activity Type) | ||
2 | Activity Type,No.,Sorting Sequence No. (Activity Type,No.,Sorting Sequence No.) | ||
3 | Whse. Document Type,Whse. Document No.,Whse. Document Line No. (Whse. Document Type,Whse. Document No.,Whse. Document Line No.) | ||
4 | Source Type,Source Subtype,Source No.,Source Line No.,Source Subline No.,Whse. Document No.,Serial No.,Lot No.,Action Type (Source Type,Source Subtype,Source No.,Source Line No.,Source Subline No.,Whse. Document No.,Serial No.,Lot No.,Action Type) | SumIndexFields: Qty. (Base) | MaintainSIFTIndex: No |
5 | Lot No. (Lot No.) | ||
6 | Serial No. (Serial 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 |
Bin Code (Bin Code) | Bin | Code (Code) |
|
1..n |
Bin Code (Bin Code) | Bin Content | Bin Code (Bin Code) |
|
1..n |
Destination No. (Destination No.) | Customer | No. (No.) |
|
1..n |
Destination No. (Destination No.) | Family | No. (No.) |
|
1..n |
Destination No. (Destination No.) | Item | No. (No.) |
|
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 |
Destination No. (Destination No.) | Sales Header | 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 |
Special Equipment Code (Special Equipment Code) | Special Equipment | 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 |
Zone Code (Zone Code) | Zone | Code (Code) |
|
1..n |
Table Relations From Other Tables
From Table | From Field |
---|