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 (Type) Option
2 No. (No.) Code20
3 Location Code (Location Code) Code10 NotBlank: Yes
4 Assigned User ID (Assigned User ID) Code50
5 Assignment Date (Assignment Date) Date
6 Assignment Time (Assignment Time) Time
7 Sorting Method (Sorting Method) Option
8 Registering Date (Registering Date) Date
9 No. Series (No. Series) Code10 Editable: No
10 Comment (Comment) Boolean Editable: No
FlowField
11 Whse. Activity No. (Whse. Activity No.) Code20
12 No. Printed (No. Printed) Integer Editable: No

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

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