Diagrams

Table

Warehouse Shipment Header

DynamicsDocs.comWarehouse Shipment Header«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 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 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 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 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 7300»ZoneLocation Code [PK,NN]Code [PK,NN]DescriptionBin Type CodeWarehouse Class CodeSpecial Equipment CodeZone RankingCross-Dock Bin Zone«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«Table 10»Shipment MethodCode [PK,NN]Description«Table 7322»Posted Whse. Shipment HeaderNo. [PK]Location CodeAssigned User IDAssignment DateAssignment TimeNo. SeriesCommentBin CodeZone CodePosting DateShipment DateShipping Agent CodeShipping Agent Service CodeShipment Method CodeWhse. Shipment No.External Document No.<Location Code><Assigned User ID><No. Series><Shipping No. Series><Bin Code><Zone Code><Shipping Agent Code><Shipping Agent Service Code><Shipment Method Code><Last Shipping No.><Whse. Document No.><Whse. Document No.><Document No.><Whse. Document No.><Location Code><Destination No.><Shipping Agent Code><Shipping Agent Service Code><Shipment Method Code><Bin Code><Zone Code><Location Code><Destination No.><Shipping Agent Code><Shipping Agent Service Code><Shipment Method Code><Bin Code><Zone Code><Location Code><Zone Code><Bin Code><Shipment Method Code><Shipping Agent Code><Shipping Agent Service Code><Location Code><Destination No.><From Zone Code><To Zone Code><To Bin Code><Shipping Agent Code><Shipping Agent Service Code><Shipment Method 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><Location Code><Assigned User ID><No. Series><Zone Code><Bin Code><Zone Code><Shipping Agent Code><Shipping Agent Code><Shipping Agent Service Code><Shipment Method 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) Code10
11 Comment (Comment) Boolean Editable: No
FlowField
12 Bin Code (Bin Code) Code20
13 Zone Code (Zone Code) Code10
34 Document Status (Document Status) Option Editable: No
39 Posting Date (Posting Date) Date
41 Shipping Agent Code (Shipping Agent Code) Code10
42 Shipping Agent Service Code (Shipping Agent Service Code) Code10
43 Shipment Method Code (Shipment Method Code) Code10
45 Shipment Date (Shipment Date) Date
46 Completely Picked (Completely Picked) Boolean Editable: No
FlowField
47 Status (Status) Option Editable: No
48 External Document No. (External Document No.) Code35
50 Create Posted Header (Create Posted Header) Boolean
61 Shipping No. (Shipping No.) Code20
62 Last Shipping No. (Last Shipping No.) Code20 Editable: No
63 Shipping No. Series (Shipping No. Series) Code10

Keys

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

Table Relations To Other Tables

Field Related Table Related Field
Bin Code (Bin Code) Bin Code (Code) 1..n
Location Code (Location Code) Location () 1..n
Shipping No. Series (Shipping No. Series) No. Series Code (Code) 1..n
Last Shipping No. (Last Shipping No.) Posted Whse. Shipment Header No. (No.) 1..n
Shipment Method Code (Shipment Method Code) Shipment Method Code (Code) 1..n
Shipping Agent Code (Shipping Agent Code) Shipping Agent Code (Code) 1..n
Shipping Agent Service Code (Shipping Agent Service Code) Shipping Agent Services Code (Code) 1..n
Assigned User ID (Assigned User ID) Warehouse Employee User ID (User ID) 1..n
Zone Code (Zone Code) Zone Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Registered Whse. Activity Line Whse. Document No. (Whse. Document No.) 1..n
Warehouse Activity Line Whse. Document No. (Whse. Document No.) 1..n
Whse. Pick Request Document No. (Document No.) 1..n
Whse. Worksheet Line Whse. Document No. (Whse. Document No.) 1..n