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. (No.) Code20
2 Location Code (Location Code) Code10
3 Assigned User ID (Assigned User ID) Code50
4 Assignment Date (Assignment Date) Date Editable: No
5 Assignment Time (Assignment Time) Time Editable: No
6 Sorting Method (Sorting Method) Option
7 No. Series (No. Series) Code20
8 Zone Code (Zone Code) Code10
9 Bin Code (Bin Code) Code20
10 Document Status (Document Status) Option Editable: No
11 Comment (Comment) Boolean Editable: No
FlowField
12 Posting Date (Posting Date) Date
13 Vendor Shipment No. (Vendor Shipment No.) Code35
16 Cross-Dock Zone Code (Cross-Dock Zone Code) Code10
17 Cross-Dock Bin Code (Cross-Dock Bin Code) Code20
50 Create Posted Header (Create Posted Header) Boolean
51 Receiving No. (Receiving No.) Code20
62 Last Receiving No. (Last Receiving No.) Code20
63 Receiving No. Series (Receiving No. Series) Code20

Keys

# Fields
0 No. (No.) Clustered: Yes
1 Location Code (Location Code)

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field