Diagrams


Table

Registered Whse. Activity Hdr.

DynamicsDocs.comRegistered Whse. Activity Hdr.«Table 5772»Registered Whse. Activity Hdr.Type; [,Put-away,Pick,Movement] [PK]No. [PK]Location Code [NN]Assigned User IDAssignment DateAssignment TimeSorting Method; [,Item,Document,Shelf...Registering DateNo. SeriesCommentWhse. Activity No.No. Printed«Table 5766»Warehouse Activity HeaderType; [,Put-away,Pick,Movement,Invt. P...No. [PK]Location CodeAssigned User IDAssignment DateAssignment TimeSorting Method; [,Item,Document,Shelf...No. SeriesCommentNo. PrintedNo. of LinesSource Type FilterSource Subtype Filter; [0,1,2,3,4,5,6,...Source No. FilterLocation FilterPosting DateRegistering No.Last Registering No.Registering No. SeriesDate of Last PrintingTime of Last PrintingBreakbulk FilterSource No.Source Document; [,Sales Order,,,Sales...Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Destination Type; [,Customer,Vendor,Lo...Destination No.External Document No.Expected Receipt DateShipment Date...«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<Location Code><Assigned User ID><No. Series><Last Registering No.><Location Code><Destination No.><Assigned User ID><No. Series><Registering No. Series><Location Code>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Type Option
2 No. Code20
3 Location Code Code10 NotBlank: Yes
4 Assigned User ID Code50
5 Assignment Date Date
6 Assignment Time Time
7 Sorting Method Option
8 Registering Date Date
9 No. Series Code10 Editable: No
10 Comment Boolean Editable: No
FlowField
11 Whse. Activity No. Code20
12 No. Printed Integer Editable: No

Keys

# Fields
0 Type,No. Clustered: Yes
1 No.,Type
2 Whse. Activity No.
3 Location Code

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field
Warehouse Activity Header Last Registering No. 1..n