Diagrams


Table

Warehouse Receipt Header

DynamicsDocs.comWarehouse Receipt Header«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 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 7301»Warehouse EmployeeUser ID [PK]Location Code [PK]DefaultADCS User«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«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 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,...<Location Code><Assigned User ID><No. Series><Receiving No. Series><Zone Code><Cross-Dock Zone Code><Bin Code><Cross-Dock Bin Code><Last Receiving No.><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><Location Code><Location Code><Assigned User ID><No. Series><Zone Code><Zone 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 No. Code20
2 Location Code Code10
3 Assigned User ID Code50
4 Assignment Date Date Editable: No
5 Assignment Time Time Editable: No
6 Sorting Method Option
7 No. Series Code20
8 Zone Code Code10
9 Bin Code Code20
10 Document Status Option Editable: No
11 Comment Boolean Editable: No
FlowField
12 Posting Date Date
13 Vendor Shipment No. Code35
16 Cross-Dock Zone Code Code10
17 Cross-Dock Bin Code Code20
50 Create Posted Header Boolean
51 Receiving No. Code20
62 Last Receiving No. Code20
63 Receiving No. Series Code20

Keys

# Fields
0 No. Clustered: Yes
1 Location Code

Table Relations To Other Tables

Field Related Table Related Field
Cross-Dock Bin Code Bin Code 1..n
Location Code Location 1..n
Receiving No. Series No. Series Code 1..n
Last Receiving No. Posted Whse. Receipt Header No. 1..n
Assigned User ID Warehouse Employee User ID 1..n
Cross-Dock Zone Code Zone Code 1..n

Table Relations From Other Tables

From Table From Field