Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
| # | Name | Type | ||
|---|---|---|---|---|
| 1 | No. (No.) | Code20 | Editable: No | |
| 2 | Line No. (Line No.) | Integer | Editable: No | |
| 3 | Source Type (Source Type) | Integer | Editable: No | |
| 4 | 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 | Editable: No | |
| 9 | Source Document (Source Document) | Option | [,Sales Order,,,Sales Return Order,Purchase Order,,,Purchase Return Order,,Outbound Transfer,,,,,,,,Service Order] | Editable: No |
| 10 | Location Code (Location Code) | Code10 |
|
Editable: No |
| 11 | Shelf No. (Shelf No.) | Code10 | ||
| 12 | Bin Code (Bin Code) | Code20 |
|
|
| 13 | Zone Code (Zone Code) | Code10 |
|
|
| 14 | Item No. (Item No.) | Code20 |
|
Editable: No |
| 15 | Quantity (Quantity) | Decimal (0:5) | Editable: No | |
| 16 | Qty. (Base) (Qty. (Base)) | Decimal (0:5) | Editable: No | |
| 19 | Qty. Outstanding (Qty. Outstanding) | Decimal (0:5) | Editable: No | |
| 20 | Qty. Outstanding (Base) (Qty. Outstanding (Base)) | Decimal (0:5) | Editable: No | |
| 21 | Qty. to Ship (Qty. to Ship) | Decimal (0:5) | ||
| 22 | Qty. to Ship (Base) (Qty. to Ship (Base)) | Decimal (0:5) | ||
| 23 | Qty. Picked (Qty. Picked) | Decimal (0:5) | Editable: No Normal |
|
| 24 | Qty. Picked (Base) (Qty. Picked (Base)) | Decimal (0:5) | Editable: No | |
| 25 | Qty. Shipped (Qty. Shipped) | Decimal (0:5) | Editable: No | |
| 26 | Qty. Shipped (Base) (Qty. Shipped (Base)) | Decimal (0:5) | Editable: No | |
| 27 | Pick Qty. (Pick Qty.) | Decimal (0:5) |
|
Editable: No FlowField |
| 28 | Pick Qty. (Base) (Pick Qty. (Base)) | Decimal (0:5) |
|
Editable: No FlowField |
| 29 | Unit of Measure Code (Unit of Measure Code) | Code10 |
|
Editable: No |
| 30 | Qty. per Unit of Measure (Qty. per Unit of Measure) | Decimal (0:5) | InitValue: 1 | Editable: No |
| 31 | Variant Code (Variant Code) | Code10 |
|
Editable: No |
| 32 | Description (Description) | Text50 | Editable: No | |
| 33 | Description 2 (Description 2) | Text50 | Editable: No | |
| 34 | Status (Status) | Option | [ ,Partially Picked,Partially Shipped,Completely Picked,Completely Shipped] | Editable: No |
| 35 | Sorting Sequence No. (Sorting Sequence No.) | Integer | Editable: No | |
| 36 | Due Date (Due Date) | Date | ||
| 39 | Destination Type (Destination Type) | Option | [ ,Customer,Vendor,Location] | Editable: No |
| 40 | Destination No. (Destination No.) | Code20 |
|
Editable: No |
| 41 | Cubage (Cubage) | Decimal (0:5) | ||
| 42 | Weight (Weight) | Decimal (0:5) | ||
| 44 | Shipping Advice (Shipping Advice) | Option | [Partial,Complete] | Editable: No |
| 45 | Shipment Date (Shipment Date) | Date | ||
| 46 | Completely Picked (Completely Picked) | Boolean | Editable: No | |
| 48 | Not upd. by Src. Doc. Post. (Not upd. by Src. Doc. Post.) | Boolean | Editable: No | |
| 49 | Posting from Whse. Ref. (Posting from Whse. Ref.) | Integer | Editable: No | |
| 900 | Assemble to Order (Assemble to Order) | Boolean | AccessByPermission: TableData 90=R | Editable: No |
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | No.,Line No. (No.,Line No.) | Clustered: Yes | |
| 1 | No.,Sorting Sequence No. (No.,Sorting Sequence No.) | MaintainSQLIndex: No | |
| 2 | No.,Item No. (No.,Item No.) | MaintainSQLIndex: No | |
| 3 | No.,Source Document,Source No. (No.,Source Document,Source No.) | MaintainSQLIndex: No | |
| 4 | No.,Shelf No. (No.,Shelf No.) | MaintainSQLIndex: No | |
| 5 | No.,Bin Code (No.,Bin Code) | MaintainSQLIndex: No | |
| 6 | No.,Due Date (No.,Due Date) | MaintainSQLIndex: No | |
| 7 | No.,Destination Type,Destination No. (No.,Destination Type,Destination No.) | MaintainSQLIndex: No | |
| 8 | Source Type,Source Subtype,Source No.,Source Line No.,Assemble to Order (Source Type,Source Subtype,Source No.,Source Line No.,Assemble to Order) | SumIndexFields: Qty. Outstanding,Qty. Outstanding (Base) | MaintainSIFTIndex: No |
| 9 | No.,Source Type,Source Subtype,Source No.,Source Line No. (No.,Source Type,Source Subtype,Source No.,Source Line No.) | MaintainSQLIndex: No | |
| 10 | Item No.,Location Code,Variant Code,Due Date (Item No.,Location Code,Variant Code,Due Date) | SumIndexFields: Qty. Outstanding (Base),Qty. Picked (Base),Qty. Shipped (Base) | MaintainSIFTIndex: No |
| 11 | Bin Code,Location Code (Bin Code,Location Code) | SumIndexFields: Cubage,Weight | MaintainSIFTIndex: No |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| Bin Code (Bin Code) | Bin | Code (Code) |
|
1..n |
| Destination No. (Destination No.) | Customer | No. (No.) |
|
1..n |
| Item No. (Item 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 |
| Destination No. (Destination No.) | Vendor | No. (No.) |
|
1..n |
| Zone Code (Zone Code) | Zone | Code (Code) |
|
1..n |
Table Relations From Other Tables
| From Table | From Field | ||
|---|---|---|---|
| Registered Whse. Activity Line | Whse. Document Line No. (Whse. Document Line No.) |
|
1..n |
| Warehouse Activity Line | Whse. Document Line No. (Whse. Document Line No.) |
|
1..n |
| Whse. Worksheet Line | Whse. Document Line No. (Whse. Document Line No.) |
|
1..n |