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