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,Invt. Put-away,Invt. Pick,Invt. Movement] | Editable: No |
2 | No. | Code20 | Editable: No | |
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,Prod. Output,,,,,,Service Order,,Assembly Consumption,Assembly Order] | BlankZero: Yes Editable: No |
11 | Location Code | Code10 |
|
Editable: No |
12 | Shelf No. | Code10 | ||
13 | Sorting Sequence No. | Integer | Editable: No | |
14 | Item No. | Code20 |
|
Editable: No |
15 | Variant Code | Code10 |
|
Editable: No |
16 | Unit of Measure Code | Code10 |
|
Editable: No |
17 | Qty. per Unit of Measure | Decimal (0:5) | InitValue: 1 | Editable: No |
18 | Description | Text50 | Editable: No | |
19 | Description 2 | Text50 | Editable: No | |
20 | Quantity | Decimal (0:5) | Editable: No | |
21 | Qty. (Base) | Decimal (0:5) | Editable: No | |
24 | Qty. Outstanding | Decimal (0:5) | Editable: No | |
25 | Qty. Outstanding (Base) | Decimal (0:5) | Editable: No | |
26 | Qty. to Handle | Decimal (0:5) | ||
27 | Qty. to Handle (Base) | Decimal (0:5) | ||
28 | Qty. Handled | Decimal (0:5) | Editable: No | |
29 | Qty. Handled (Base) | Decimal (0:5) | Editable: No | |
31 | Shipping Advice | Option | [Partial,Complete] | Editable: No Normal |
34 | Due Date | Date | ||
39 | Destination Type | Option | [ ,Customer,Vendor,Location,Item,Family,Sales Order] | Editable: No |
40 | Destination No. | Code20 |
|
Editable: No |
42 | Shipping Agent Code | Code10 |
|
|
43 | Shipping Agent Service Code | Code10 |
|
|
44 | Shipment Method Code | Code10 |
|
|
47 | Starting Date | Date | ||
900 | Assemble to Order | Boolean | AccessByPermission: TableData 90=R | Editable: No |
901 | ATO Component | Boolean | Editable: No | |
6500 | Serial No. | Code20 | ||
6501 | Lot No. | Code20 | ||
6502 | Warranty Date | Date | ||
6503 | Expiration Date | Date | ||
6504 | Serial No. Blocked | Boolean |
|
Editable: No FlowField |
6505 | Lot No. Blocked | Boolean |
|
Editable: No FlowField |
7300 | Bin Code | Code20 | AccessByPermission: TableData 5771=R
|
|
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 |
7309 | Bin Ranking | Integer | Editable: No | |
7310 | Cubage | Decimal (0:5) | ||
7311 | Weight | Decimal (0:5) | ||
7312 | Special Equipment Code | Code10 |
|
|
7313 | Bin Type Code | Code10 |
|
|
7314 | Breakbulk No. | Integer | BlankZero: Yes | |
7315 | Original Breakbulk | Boolean | ||
7316 | Breakbulk | Boolean | ||
7317 | Cross-Dock Information | Option | [ ,Cross-Dock Items,Some Items Cross-Docked] | |
7318 | Dedicated | Boolean | Editable: No |
Keys
# | Fields | ||
---|---|---|---|
0 | Activity Type,No.,Line No. | SumIndexFields: Qty. to Handle (Base) | Clustered: Yes MaintainSIFTIndex: No |
1 | No.,Line No.,Activity Type | ||
2 | Source Type,Source Subtype,Source No.,Source Line No.,Source Subline No.,Unit of Measure Code,Action Type,Breakbulk No.,Original Breakbulk,Activity Type,Assemble to Order | SumIndexFields: Qty. Outstanding,Qty. Outstanding (Base) | MaintainSIFTIndex: No |
3 | Activity Type,No.,Sorting Sequence No. | MaintainSQLIndex: No | |
4 | Activity Type,No.,Shelf No. | MaintainSQLIndex: No | |
5 | Activity Type,No.,Location Code,Source Document,Source No.,Action Type,Zone Code | MaintainSQLIndex: No | |
6 | Activity Type,No.,Due Date,Action Type,Bin Code | MaintainSQLIndex: No | |
7 | Activity Type,No.,Bin Code,Breakbulk No.,Action Type | MaintainSQLIndex: No | |
8 | Activity Type,No.,Bin Ranking,Breakbulk No.,Action Type | MaintainSQLIndex: No | |
9 | Activity Type,No.,Destination Type,Destination No.,Action Type,Bin Code | MaintainSQLIndex: No | |
10 | Activity Type,No.,Whse. Document Type,Whse. Document No.,Whse. Document Line No. | MaintainSQLIndex: No | |
11 | Activity Type,No.,Action Type,Bin Code | MaintainSQLIndex: No | |
12 | Activity Type,No.,Item No.,Variant Code,Action Type,Bin Code | MaintainSQLIndex: No | |
13 | Whse. Document No.,Whse. Document Type,Activity Type,Whse. Document Line No.,Action Type,Unit of Measure Code,Original Breakbulk,Breakbulk No.,Lot No.,Serial No.,Assemble to Order | SumIndexFields: Qty. Outstanding (Base),Qty. Outstanding | MaintainSIFTIndex: No |
14 | Item No.,Bin Code,Location Code,Action Type,Variant Code,Unit of Measure Code,Breakbulk No.,Activity Type,Lot No.,Serial No.,Original Breakbulk,Assemble to Order,ATO Component | SumIndexFields: Quantity,Qty. (Base),Qty. Outstanding,Qty. Outstanding (Base),Cubage,Weight | MaintainSIFTIndex: No |
15 | Item No.,Location Code,Activity Type,Bin Type Code,Unit of Measure Code,Variant Code,Breakbulk No.,Action Type,Lot No.,Serial No.,Assemble to Order | SumIndexFields: Qty. Outstanding (Base) | MaintainSIFTIndex: No |
16 | Bin Code,Location Code,Action Type,Breakbulk No. | SumIndexFields: Cubage,Weight | MaintainSQLIndex: No MaintainSIFTIndex: No |
17 | Location Code,Activity Type | ||
18 | Source No.,Source Line No.,Source Subline No.,Serial No.,Lot No. | MaintainSQLIndex: 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 Type Code | Bin Type | 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 |
---|