Diagrams

Table

Whse. Internal Pick Line

DynamicsDocs.comWhse. Internal Pick Line«Table 7334»Whse. Internal Pick LineNo. [PK]Line No. [PK]Location CodeShelf No.To Bin CodeTo Zone CodeItem No.QuantityQty. [Base]Qty. OutstandingQty. Outstanding [Base]Qty. PickedQty. Picked [Base]Pick Qty.Pick Qty. [Base]Unit of Measure Code [NN]Qty. per Unit of MeasureVariant CodeDescriptionDescription 2Status; [,Partially Picked,Completely...Sorting Sequence No.Due DateCubageWeight«Table 5767»Warehouse Activity LineActivity Type; [,Put-away,Pick,Movemen...No. [PK]Line No. [PK]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Subline No.Source Document; [,Sales Order,,,Sales...Location CodeShelf No.Sorting Sequence No.Item No.Variant CodeUnit of Measure CodeQty. per Unit of MeasureDescriptionDescription 2QuantityQty. [Base]Qty. OutstandingQty. Outstanding [Base]Qty. to HandleQty. to Handle [Base]Qty. HandledQty. Handled [Base]Shipping Advice; [Partial,Complete]Due DateDestination Type; [,Customer,Vendor,Lo...Destination No.Shipping Agent Code...«Table 5773»Registered Whse. Activity LineActivity Type; [,Put-away,Pick,Movemen...No. [PK]Line No. [PK]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Subline No.Source Document; [,Sales Order,,,Sales...Location CodeShelf No.Sorting Sequence No.Item No.Variant CodeUnit of Measure CodeQty. per Unit of MeasureDescriptionDescription 2QuantityQty. [Base]Shipping Advice; [Partial,Complete]Due DateDestination Type; [,Customer,Vendor,Lo...Destination No.Whse. Activity No.Shipping Agent CodeShipping Agent Service CodeShipment Method CodeStarting DateSerial No.Lot No....«Table 7326»Whse. Worksheet LineWorksheet Template Name [PK,NN]Name [PK,NN]Line No. [PK]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Subline No.Source Document; [,Sales Order,,,Sales...Location Code [PK]Shelf No.From Zone CodeFrom Bin CodeTo Bin CodeTo Zone CodeItem No.QuantityQty. [Base]Qty. OutstandingQty. Outstanding [Base]Qty. to HandleQty. to Handle [Base]Qty. HandledQty. Handled [Base]From Unit of Measure Code [NN]Qty. per From Unit of MeasureUnit of Measure Code [NN]Qty. per Unit of MeasureVariant CodeDescriptionDescription 2...«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 7300»ZoneLocation Code [PK,NN]Code [PK,NN]DescriptionBin Type CodeWarehouse Class CodeSpecial Equipment CodeZone RankingCross-Dock Bin Zone«Table 27»ItemNo. [PK]No. 2DescriptionSearch DescriptionDescription 2Assembly BOMBase Unit of MeasurePrice Unit ConversionType; [Inventory,Service]Inventory Posting GroupShelf No.Item Disc. GroupAllow Invoice Disc.Statistics GroupCommission GroupUnit PricePrice/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Unit CostStandard CostLast Direct CostIndirect Cost %Cost is AdjustedAllow Online AdjustmentVendor No.Vendor Item No.Lead Time CalculationReorder PointMaximum InventoryReorder Quantity...«Table 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2<Location Code><To Bin Code><To Zone Code><Item No.><Unit of Measure Code><Variant Code><Whse. Document Line No.><Whse. Document Line No.><Whse. Document Line No.><Location Code><Destination No.><Item No.><Destination No.><Variant Code><Unit of Measure Code><Bin Code><Zone Code><Location Code><Destination No.><Item No.><Destination No.><Variant Code><Unit of Measure Code><Bin Code><Zone Code><Location Code><Destination No.><From Zone Code><To Zone Code><To Bin Code><Item No.><From Unit of Measure Code><Unit of Measure 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><Location Filter><Location Code><Zone Code><Item Filter><Bin Filter><Alternative Item No.><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.>

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 To Bin Code (To Bin Code) Code20
13 To Zone Code (To Zone Code) Code10
14 Item No. (Item No.) Code20
15 Quantity (Quantity) Decimal (0:5)
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
23 Qty. Picked (Qty. Picked) Decimal (0:5) Editable: No
Normal
24 Qty. Picked (Base) (Qty. Picked (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 NotBlank: Yes
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
34 Status (Status) Option Editable: No
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.,Sorting Sequence No. (No.,Sorting Sequence No.)
2 No.,Item No. (No.,Item No.) MaintainSQLIndex: No
3 No.,Shelf No. (No.,Shelf No.) MaintainSQLIndex: No
4 No.,To Bin Code (No.,To Bin Code) MaintainSQLIndex: No
5 No.,Due Date (No.,Due Date) MaintainSQLIndex: No
6 To Bin Code,Location Code (To Bin Code,Location Code) MaintainSIFTIndex: No

Table Relations To Other Tables

Field Related Table Related Field
To Bin Code (To Bin Code) Bin Code (Code) 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
Location Code (Location Code) Location Code (Code) 1..n
To Zone Code (To 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