Diagrams

Table

Internal Movement Line

DynamicsDocs.comInternal Movement Line«Table 7347»Internal Movement LineNo. [PK]Line No. [PK]Location CodeShelf No.From Bin CodeTo Bin CodeItem No.QuantityQty. [Base]Unit of Measure CodeQty. per Unit of MeasureVariant CodeDescriptionDescription 2Sorting Sequence No.Due DateCubageWeight«Table 14»LocationCode [PK,NN]NameDefault Bin CodeName 2AddressAddress 2CityPhone No.Phone No. 2Telex No.Fax No.ContactPost CodeCountyE-MailHome PageCountry/Region CodeUse As In-TransitRequire Put-awayRequire PickCross-Dock Due Date Calc.Use Cross-DockingRequire ReceiveRequire ShipmentBin MandatoryDirected Put-away and PickDefault Bin Selection; [,Fixed Bin,Las...Outbound Whse. Handling TimeInbound Whse. Handling TimePut-away Template CodeUse Put-away Worksheet...«Table 7354»BinLocation Code [PK,NN]Code [PK,NN]DescriptionZone CodeAdjustment BinBin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Special Equipment CodeBin RankingMaximum CubageMaximum WeightEmptyItem FilterVariant FilterDefaultCross-Dock BinDedicated«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2<Location Code><From Bin Code><To Bin Code><Variant Code><Default Bin Code><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><Adjustment Bin Code><Receipt Bin Code><Shipment Bin Code><Cross-Dock Bin Code><To-Assembly Bin Code><From-Assembly Bin Code><Asm.-to-Order Shpt. Bin Code><Location Code>

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
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)

Keys

# 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