Diagrams


Table

Whse. Pick Request

DynamicsDocs.comWhse. Pick Request«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 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 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 5405»Production OrderStatus; [Simulated,Planned,Firm Planne...No. [PK]DescriptionSearch DescriptionDescription 2Creation DateLast Date ModifiedSource Type; [Item,Family,Sales Header...Source No.Routing No.Inventory Posting GroupGen. Prod. Posting GroupGen. Bus. Posting GroupCommentStarting TimeStarting DateEnding TimeEnding DateDue DateFinished DateBlockedShortcut Dimension 1 CodeShortcut Dimension 2 CodeLocation CodeBin CodeReplan Ref. No.Replan Ref. Status; [Simulated,Planned...Low-Level CodeQuantityUnit CostCost Amount...«Table 900»Assembly HeaderDocument Type; [Quote,Order,,,Blanket...No. [PK]DescriptionSearch DescriptionDescription 2Creation DateLast Date ModifiedItem No.Variant CodeInventory Posting GroupGen. Prod. Posting GroupCommentLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodePosting DateDue DateStarting DateEnding DateBin CodeQuantityQuantity [Base]Remaining QuantityRemaining Quantity [Base]Assembled QuantityAssembled Quantity [Base]Quantity to AssembleQuantity to Assemble [Base]Reserved QuantityReserved Qty. [Base]Planning Flexibility; [Unlimited,None]...«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 7300»ZoneLocation Code [PK,NN]Code [PK,NN]DescriptionBin Type CodeWarehouse Class CodeSpecial Equipment CodeZone RankingCross-Dock Bin Zone«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 10»Shipment MethodCode [PK,NN]DescriptionLast Modified Date TimeId«Table 291»Shipping AgentCode [PK,NN]NameInternet AddressAccount No.«Table 5790»Shipping Agent ServicesShipping Agent Code [PK,NN]Code [PK,NN]DescriptionShipping TimeBase Calendar Code<Document No.><Document No.><Document No.><Document No.><Location Code><Zone Code><Bin Code><Shipment Method Code><Shipping Agent Code><Shipping Agent Service Code><Location Code><Bin Code><Zone Code><Shipping Agent Code><Shipping Agent Service Code><Shipment Method Code><Location Code><To Bin Code><To Zone Code><Location Code><Bin Code><Location Code><Bin 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 Code><Zone Code><Shipping Agent Code>

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

Fields

# Name Type
1 Document Type Option
2 Document Subtype Option
3 Document No. Code20 NotBlank: Yes
4 Location Code Code10
5 Zone Code Code10
6 Bin Code Code20
7 Status Option Editable: No
8 Completely Picked Boolean
9 Shipment Method Code Code10 Editable: No
FlowField
10 Shipping Agent Code Code10 Editable: No
FlowField
11 Shipping Agent Service Code Code10 Editable: No
FlowField

Keys

# Fields
0 Document Type,Document Subtype,Document No.,Location Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Document No. Assembly Header No. 1..n
Bin Code Bin Code 1..n
Location Code Location Code 1..n
Document No. Production Order No. 1..n
Shipment Method Code Shipment Method Code 1..n
Shipping Agent Code Shipping Agent Code 1..n
Shipping Agent Service Code Shipping Agent Services Code 1..n
Document No. Warehouse Shipment Header No. 1..n
Document No. Whse. Internal Pick Header No. 1..n
Zone Code Zone Code 1..n

Table Relations From Other Tables

From Table From Field