Diagrams


DynamicsDocs.comZone«Table 7300»ZoneLocation Code [PK,NN]Code [PK,NN]DescriptionBin Type CodeWarehouse Class CodeSpecial Equipment CodeZone RankingCross-Dock Bin Zone«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 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 7316»Warehouse Receipt HeaderNo. [PK]Location CodeAssigned User IDAssignment DateAssignment TimeSorting Method; [,Item,Document,Shelf...No. SeriesZone CodeBin CodeDocument Status; [,Partially Received,...CommentPosting DateVendor Shipment No.Cross-Dock Zone CodeCross-Dock Bin CodeCreate Posted HeaderReceiving No.Last Receiving No.Receiving No. Series«Table 7317»Warehouse Receipt LineNo. [PK]Line No. [PK]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Document; [,Sales Order,,,Sales...Location CodeShelf No.Bin CodeZone CodeItem No.QuantityQty. [Base]Qty. OutstandingQty. Outstanding [Base]Qty. to ReceiveQty. to Receive [Base]Qty. ReceivedQty. Received [Base]Unit of Measure CodeQty. per Unit of MeasureVariant CodeDescriptionDescription 2Status; [,Partially Received,Completel...Sorting Sequence No.Due DateStarting DateCubageWeight...«Table 7318»Posted Whse. Receipt HeaderNo. [PK]Location CodeAssigned User IDAssignment DateAssignment TimeNo. SeriesZone CodeBin CodeCommentPosting DateVendor Shipment No.Whse. Receipt No.Document Status; [,Partially Put Away,...«Table 7319»Posted Whse. Receipt LineNo. [PK]Line No. [PK]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Document; [,Sales Order,,,Sales...Location CodeShelf No.Bin CodeZone CodeItem No.QuantityQty. [Base]Qty. Put AwayQty. Put Away [Base]Put-away Qty.Put-away Qty. [Base]Unit of Measure CodeQty. per Unit of MeasureVariant CodeDescriptionDescription 2Due DateStarting DateQty. Cross-DockedQty. Cross-Docked [Base]Cross-Dock Zone CodeCross-Dock Bin CodePosted Source Document; [,Posted Recei...Posted Source No....«Table 7320»Warehouse Shipment HeaderNo. [PK]Location CodeAssigned User IDAssignment DateAssignment TimeSorting Method; [,Item,Document,Shelf...No. SeriesCommentBin CodeZone CodeDocument Status; [,Partially Picked,Pa...Posting DateShipping Agent CodeShipping Agent Service CodeShipment Method CodeShipment DateCompletely PickedStatus; [Open,Released]External Document No.Create Posted HeaderShipping No.Last Shipping No.Shipping No. Series«Table 7321»Warehouse Shipment LineNo. [PK]Line No. [PK]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Document; [,Sales Order,,,Sales...Location CodeShelf No.Bin CodeZone CodeItem No.QuantityQty. [Base]Qty. OutstandingQty. Outstanding [Base]Qty. to ShipQty. to Ship [Base]Qty. PickedQty. Picked [Base]Qty. ShippedQty. Shipped [Base]Pick Qty.Pick Qty. [Base]Unit of Measure CodeQty. per Unit of MeasureVariant CodeDescriptionDescription 2Status; [,Partially Picked,Partially S...Sorting Sequence No....«Table 7322»Posted Whse. Shipment HeaderNo. [PK]Location CodeAssigned User IDAssignment DateAssignment TimeNo. SeriesCommentBin CodeZone CodePosting DateShipment DateShipping Agent CodeShipping Agent Service CodeShipment Method CodeWhse. Shipment No.External Document No.«Table 7323»Posted Whse. Shipment LineNo. [PK]Line No. [PK]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Document; [,Sales Order,,,Sales...Location CodeShelf No.Bin CodeZone CodeItem No.QuantityQty. [Base]Unit of Measure CodeQty. per Unit of MeasureVariant CodeDescriptionDescription 2Due DateDestination Type; [,Customer,Vendor,Lo...Destination No.Shipping Advice; [Partial,Complete]Shipment DatePosted Source Document; [,Posted Recei...Posted Source No.Posting DateWhse. Shipment No.Whse Shipment Line No.«Table 7324»Whse. Put-away RequestDocument Type; [Receipt,Internal Put-a...Document No. [PK]Location CodeZone CodeBin CodeCompletely Put AwayStatus; [Open,Released]«Table 7325»Whse. Pick RequestDocument Type; [Shipment,Internal Pick...Document Subtype; [0,1,2,3,4,5,6,7,8,9...Document No. [PK,NN]Location Code [PK]Zone CodeBin CodeStatus; [Open,Released]Completely PickedShipment Method CodeShipping Agent CodeShipping Agent Service Code«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 7330»Bin Content BufferLocation Code [PK,NN]Zone Code [NN]Bin Code [PK,NN]Item No. [PK,NN]Variant Code [PK]Unit of Measure Code [PK]CubageWeightBase Unit of MeasureQty. to Handle [Base]Qty. Outstanding [Base]Lot No. [PK]Serial No. [PK]«Table 7331»Whse. Internal Put-away HeaderNo. [PK]Location CodeAssigned User IDAssignment DateAssignment TimeNo. SeriesCommentFrom Bin CodeFrom Zone CodeDue DateDocument Status; [,Partially Put Away,...Sorting Method; [,Item,Shelf or Bin,Du...Status; [Open,Released]«Table 7333»Whse. Internal Pick HeaderNo. [PK]Location CodeAssigned User IDAssignment DateAssignment TimeSorting Method; [,Item,Shelf or Bin,Du...No. SeriesCommentTo Bin CodeTo Zone CodeDocument Status; [,Partially Picked,Co...Due DateStatus; [Open,Released]«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 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 7341»Posted Invt. Put-away LineNo. [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 CodeSerial No.Lot No.Warranty DateExpiration Date...«Table 7343»Posted Invt. Pick LineNo. [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 CodeSerial No.Lot No.Warranty DateExpiration Date...«Table 7345»Registered Invt. Movement LineNo. [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 CodeSerial No.Lot No.Warranty DateExpiration Date...«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 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 7303»Bin TypeCode [PK,NN]DescriptionReceiveShipPut AwayPick«Table 7304»Warehouse ClassCode [PK,NN]Description«Table 7305»Special EquipmentCode [PK,NN]Description<Location Code><Bin Type Code><Warehouse Class Code><Special Equipment Code><Zone Code><Zone Code><Zone Code><From Zone Code><Zone Code><To Zone Code><Zone Code><Zone Code><Cross-Dock Zone Code><Zone Code><Cross-Dock Zone Code><Zone Code><Zone Code><Cross-Dock Zone Code><Zone Code><Zone Code><Zone Code><Zone Code><Zone Code><Zone Code><From Zone Code><To Zone Code><Zone Code><From Zone Code><To Zone Code><To Zone Code><Zone Code><Zone Code><Zone Code><Zone Code><Zone Code><Zone Code><Location Code><Destination No.><Bin Code><Whse. Document No.><Whse. Document No.><Whse. Document No.><Whse. Document No.><Whse. Document Line No.><Whse. Document Line No.><Whse. Document Line No.><Special Equipment Code><Bin Type Code><Location Code><Destination No.><Bin Code><Bin Code><Whse. Document No.><Whse. Document No.><Whse. Document No.><Whse. Document No.><Whse. Document Line No.><Whse. Document Line No.><Whse. Document Line No.><Special Equipment Code><Location Code><Bin Code><Bin Type Code><Warehouse Class Code><From Bin Code><Bin Code><Bin Code><Bin Code><Location Code><From Bin Code><Bin Code><To Bin Code><From Bin Type Code><Location Code><Bin Code><Bin Type Code><Location Code><Bin Code><Cross-Dock Bin Code><Last Receiving No.><Location Code><Bin Code><Cross-Dock Bin Code><Location Code><Bin Code><Document No.><Whse. Document No.><Location Code><Bin Code><Cross-Dock Bin Code><Whse. Document Line No.><Location Code><Bin Code><Last Shipping No.><Document No.><Whse. Document No.><Location Code><Destination No.><Bin Code><Whse. Document Line No.><Location Code><Bin Code><Location Code><Destination No.><Bin Code><Document No.><Location Code><Bin Code><Document No.><Location Code><Bin Code><Location Code><Destination No.><To Bin Code><Whse. Document No.><Whse. Document No.><Whse. Document Line No.><Location Code><Bin Code><Location Code><From Bin Code><Location Code><To Bin Code><Location Code><To Bin Code><Location Code><Bin Type Code><Warehouse Class Code><Special Equipment Code><Location Code><Bin Type Code><Warehouse Class Code><Special Equipment Code><Location Code><Destination No.><Bin Code><Special Equipment Code><Location Code><Destination No.><Bin Code><Special Equipment Code><Location Code><Destination No.><Bin Code><Special Equipment Code><Location 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><Bin Type Code><Warehouse Class Code><Special Equipment Code>

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

Fields

# Name Type
1 Location Code Code10 NotBlank: Yes
Editable: No
2 Code Code10 NotBlank: Yes
5 Description Text50
10 Bin Type Code Code10
11 Warehouse Class Code Code10
20 Special Equipment Code Code10
21 Zone Ranking Integer
40 Cross-Dock Bin Zone Boolean

Keys

# Fields
0 Location Code,Code Clustered: Yes
1 Code
2 Description

Table Relations To Other Tables

Field Related Table Related Field
Bin Type Code Bin Type Code 1..n
Location Code Location Code 1..n
Special Equipment Code Special Equipment Code 1..n
Warehouse Class Code Warehouse Class Code 1..n

Table Relations From Other Tables

From Table From Field
Bin Zone Code 1..n
Bin Content Zone Code 1..n
Bin Content Buffer Zone Code 1..n
Bin Creation Worksheet Line Zone Code 1..n
Bin Template Zone Code 1..n
Posted Invt. Pick Line Zone Code 1..n
Posted Invt. Put-away Line Zone Code 1..n
Posted Whse. Receipt Header Zone Code 1..n
Posted Whse. Receipt Line Cross-Dock Zone Code 1..n
Posted Whse. Shipment Header Zone Code 1..n
Posted Whse. Shipment Line Zone Code 1..n
Registered Invt. Movement Line Zone Code 1..n
Registered Whse. Activity Line Zone Code 1..n
Warehouse Activity Line Zone Code 1..n
Warehouse Entry Zone Code 1..n
Warehouse Journal Line To Zone Code 1..n
Warehouse Receipt Header Cross-Dock Zone Code 1..n
Warehouse Receipt Line Cross-Dock Zone Code 1..n
Warehouse Shipment Header Zone Code 1..n
Warehouse Shipment Line Zone Code 1..n
Whse. Internal Pick Header To Zone Code 1..n
Whse. Internal Pick Line To Zone Code 1..n
Whse. Internal Put-away Header From Zone Code 1..n
Whse. Pick Request Zone Code 1..n
Whse. Put-away Request Zone Code 1..n
Whse. Worksheet Line To Zone Code 1..n