Diagrams


Table

Bin Type

DynamicsDocs.comBin Type«Table 7303»Bin TypeCode [PK,NN]DescriptionReceiveShipPut AwayPick«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 7300»ZoneLocation Code [PK,NN]Code [PK,NN]DescriptionBin Type CodeWarehouse Class CodeSpecial Equipment CodeZone RankingCross-Dock Bin Zone«Table 7302»Bin ContentLocation Code [PK,NN]Zone Code [NN]Bin Code [PK,NN]Item No. [PK,NN]Bin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Min. Qty.Max. Qty.Bin RankingQuantityPick Qty.Neg. Adjmt. Qty.Put-away Qty.Pos. Adjmt. Qty.FixedCross-Dock BinDefaultQuantity [Base]Pick Quantity [Base]Negative Adjmt. Qty. [Base]Put-away Quantity [Base]Positive Adjmt. Qty. [Base]ATO Components Pick Qty.ATO Components Pick Qty [Base]Variant Code [PK]Qty. per Unit of MeasureUnit of Measure Code [PK,NN]Lot No. FilterSerial No. FilterDedicated...«Table 7311»Warehouse Journal LineJournal Template Name [PK]Journal Batch Name [PK]Line No. [PK]Registering DateLocation Code [PK]From Zone CodeFrom Bin CodeDescriptionItem No.QuantityQty. [Base]Qty. [Absolute]Qty. [Absolute, Base]Zone CodeBin CodeSource TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Subline No.Source Document; [,S. Order,S. Invoice...Source CodeTo Zone CodeTo Bin CodeReason CodeRegistering No. SeriesFrom Bin Type CodeCubageWeightWhse. Document No.Whse. Document Type; [Whse. Journal,Re......«Table 7312»Warehouse EntryEntry No. [PK]Journal Batch NameLine No.Registering DateLocation CodeZone CodeBin CodeDescriptionItem No.QuantityQty. [Base]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Subline No.Source Document; [,S. Order,S. Invoice...Source CodeReason CodeNo. SeriesBin Type CodeCubageWeightJournal Template NameWhse. Document No.Whse. Document Type; [Whse. Journal,Re...Whse. Document Line No.Entry Type; [Negative Adjmt.,Positive...Reference Document; [,Posted Rcpt.,Pos...Reference No.User ID...«Table 7335»Bin TemplateCode [PK,NN]DescriptionLocation Code [NN]Bin DescriptionZone CodeBin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Special Equipment CodeBin RankingMaximum CubageMaximum WeightDedicated«Table 7338»Bin Creation Worksheet LineWorksheet Template Name [PK]Name [PK]Line No. [PK]Type; [Bin,Bin Content]Location Code [PK,NN]Zone CodeBin Code [NN]Item No. [NN]DescriptionBin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Min. Qty.Max. Qty.Special Equipment CodeBin RankingMaximum CubageMaximum WeightFixedDefaultCross-Dock BinUser IDVariant CodeQty. per Unit of MeasureUnit of Measure Code [NN]Dedicated«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<Bin Type Code><Bin Type Code><Bin Type Code><From Bin Type Code><Bin Type Code><Bin Type Code><Bin Type Code><Bin Type Code><Bin Code><Zone Code><Zone Code><From Zone Code><Zone Code><To Zone Code><Zone Code><Zone Code><Zone Code><Zone Code><Bin Code><From Bin Code><From Bin Code><Bin Code><To Bin Code><Bin Code>

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

Fields

# Name Type
1 Code Code10 NotBlank: Yes
5 Description Text50
10 Receive Boolean
11 Ship Boolean
12 Put Away Boolean
13 Pick Boolean

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field
Bin Bin Type Code 1..n
Bin Content Bin Type Code 1..n
Bin Creation Worksheet Line Bin Type Code 1..n
Bin Template Bin Type Code 1..n
Warehouse Activity Line Bin Type Code 1..n
Warehouse Entry Bin Type Code 1..n
Warehouse Journal Line From Bin Type Code 1..n
Zone Bin Type Code 1..n