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