Diagrams

Table

Whse. Put-away Request

DynamicsDocs.comWhse. Put-away Request«Table 7324»Whse. Put-away RequestDocument Type; [Receipt,Internal Put-a...Document No. [PK]Location CodeZone CodeBin CodeCompletely Put AwayStatus; [Open,Released]«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 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 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<Document No.><Document No.><Location Code><Zone Code><Bin Code><Location Code><Zone Code><Bin Code><Location Code><From Bin Code><From Zone 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>

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

Fields

# Name Type
1 Document Type (Document Type) Option
2 Document No. (Document No.) Code20
3 Location Code (Location Code) Code10
4 Zone Code (Zone Code) Code10
5 Bin Code (Bin Code) Code20
7 Completely Put Away (Completely Put Away) Boolean
8 Status (Status) Option

Keys

# Fields
0 Document Type,Document No. (Document Type,Document No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Bin Code (Bin Code) Bin Code (Code) 1..n
Location Code (Location Code) Location Code (Code) 1..n
Document No. (Document No.) Posted Whse. Receipt Header No. (No.) 1..n
Document No. (Document No.) Whse. Internal Put-away Header No. (No.) 1..n
Zone Code (Zone Code) Zone Code (Code) 1..n

Table Relations From Other Tables

From Table From Field