Internal Movement Line

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback


# Name Type
1 No. (No.) Code20 Editable: No
2 Line No. (Line No.) Integer Editable: No
10 Location Code (Location Code) Code10 Editable: No
11 Shelf No. (Shelf No.) Code10
12 From Bin Code (From Bin Code) Code20
13 To Bin Code (To Bin Code) Code20
14 Item No. (Item No.) Code20
15 Quantity (Quantity) Decimal (0:5)
16 Qty. (Base) (Qty. (Base)) Decimal (0:5) Editable: No
29 Unit of Measure Code (Unit of Measure Code) Code10
30 Qty. per Unit of Measure (Qty. per Unit of Measure) Decimal (0:5) Editable: No
31 Variant Code (Variant Code) Code10
32 Description (Description) Text50
33 Description 2 (Description 2) Text50
35 Sorting Sequence No. (Sorting Sequence No.) Integer Editable: No
36 Due Date (Due Date) Date
37 Cubage (Cubage) Decimal (0:5)
38 Weight (Weight) Decimal (0:5)


# Fields
0 No.,Line No. (No.,Line No.) Clustered: Yes
1 No.,Item No. (No.,Item No.) MaintainSQLIndex: No
2 No.,From Bin Code (No.,From Bin Code) MaintainSQLIndex: No
3 No.,Shelf No. (No.,Shelf No.) MaintainSQLIndex: No
4 No.,Sorting Sequence No. (No.,Sorting Sequence No.)
5 No.,Due Date (No.,Due Date) MaintainSQLIndex: No
6 Item No.,From Bin Code,Location Code,Unit of Measure Code,Variant Code (Item No.,From Bin Code,Location Code,Unit of Measure Code,Variant Code) MaintainSIFTIndex: No

Table Relations To Other Tables

Field Related Table Related Field
To Bin Code (To Bin Code) Bin Code (Code) 1..n
Variant Code (Variant Code) Item Variant Code (Code) 1..n
Location Code (Location Code) Location Code (Code) 1..n

Table Relations From Other Tables

From Table From Field