Diagrams


Table

Posted Whse. Receipt Header

DynamicsDocs.comPosted Whse. Receipt Header«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 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 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 7324»Whse. Put-away RequestDocument Type; [Receipt,Internal Put-a...Document No. [PK]Location CodeZone CodeBin CodeCompletely Put AwayStatus; [Open,Released]«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 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<Location Code><Assigned User ID><No. Series><Zone Code><Bin Code><Whse. Document No.><Whse. Document No.><Last Receiving No.><Document No.><Whse. Document No.><Location Code><Destination No.><Bin Code><Zone Code><Location Code><Destination No.><Bin Code><Zone Code><Location Code><Assigned User ID><No. Series><Receiving No. Series><Zone Code><Cross-Dock Zone Code><Bin Code><Cross-Dock Bin Code><Location Code><Zone Code><Bin Code><Location Code><Destination No.><From Zone Code><To Zone Code><To 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><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 No. Code20
2 Location Code Code10
3 Assigned User ID Code50 Editable: No
4 Assignment Date Date Editable: No
5 Assignment Time Time Editable: No
7 No. Series Code20
8 Zone Code Code10
9 Bin Code Code20
11 Comment Boolean Editable: No
FlowField
12 Posting Date Date
13 Vendor Shipment No. Code35
14 Whse. Receipt No. Code20
15 Document Status Option Editable: No

Keys

# Fields
0 No. Clustered: Yes
1 Location Code
2 Whse. Receipt No.

Table Relations To Other Tables

Field Related Table Related Field
Bin Code Bin Code 1..n
Location Code Location 1..n
No. Series No. Series Code 1..n
Assigned User ID Warehouse Employee User ID 1..n
Zone Code Zone Code 1..n

Table Relations From Other Tables

From Table From Field
Registered Whse. Activity Line Whse. Document No. 1..n
Warehouse Activity Line Whse. Document No. 1..n
Warehouse Receipt Header Last Receiving No. 1..n
Whse. Put-away Request Document No. 1..n
Whse. Worksheet Line Whse. Document No. 1..n