Diagrams


Table

Internal Movement Line

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

Fields

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

Keys

# Fields
0 No.,Line No. Clustered: Yes
1 No.,Item No. MaintainSQLIndex: No
2 No.,From Bin Code MaintainSQLIndex: No
3 No.,Shelf No. MaintainSQLIndex: No
4 No.,Sorting Sequence No.
5 No.,Due Date MaintainSQLIndex: No
6 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 Bin Code 1..n
Variant Code Item Variant Code 1..n
Location Code Location Code 1..n

Table Relations From Other Tables

From Table From Field