Diagrams


Table

Posted Whse. Shipment Header

DynamicsDocs.comPosted Whse. Shipment Header«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.«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 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<Location Code><Assigned User ID><No. Series><Bin Code><Zone Code><Shipping Agent Code><Shipping Agent Service Code><Shipment Method Code><Last Shipping 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><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><Shipping Agent 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
7 No. Series Code10
11 Comment Boolean Editable: No
FlowField
12 Bin Code Code20
13 Zone Code Code10
39 Posting Date Date
40 Shipment Date Date
41 Shipping Agent Code Code10
42 Shipping Agent Service Code Code10
43 Shipment Method Code Code10
45 Whse. Shipment No. Code20
48 External Document No. Code35

Keys

# Fields
0 No. Clustered: Yes
1 Location Code
2 Whse. Shipment 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
Shipment Method Code Shipment Method Code 1..n
Shipping Agent Code Shipping Agent Code 1..n
Shipping Agent Service Code Shipping Agent Services 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
Warehouse Shipment Header Last Shipping No. 1..n