Diagrams

Table

Warehouse Employee

DynamicsDocs.comWarehouse Employee«Table 7301»Warehouse EmployeeUser ID [PK]Location Code [PK]DefaultADCS User«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 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 7310»Warehouse Journal BatchJournal Template Name [PK,NN]Name [PK,NN]DescriptionReason CodeNo. SeriesRegistering No. SeriesLocation Code [PK,NN]Template Type; [Item,Physical Inventor...Assigned User ID«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 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 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 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 7331»Whse. Internal Put-away HeaderNo. [PK]Location CodeAssigned User IDAssignment DateAssignment TimeNo. SeriesCommentFrom Bin CodeFrom Zone CodeDue DateDocument Status; [,Partially Put Away,...Sorting Method; [,Item,Shelf or Bin,Du...Status; [Open,Released]«Table 7333»Whse. Internal Pick HeaderNo. [PK]Location CodeAssigned User IDAssignment DateAssignment TimeSorting Method; [,Item,Shelf or Bin,Du...No. SeriesCommentTo Bin CodeTo Zone CodeDocument Status; [,Partially Picked,Co...Due DateStatus; [Open,Released]«Table 7340»Posted Invt. Put-away HeaderNo. [PK]Location Code [NN]Assigned User IDAssignment DateAssignment TimeRegistering DateNo. SeriesCommentInvt. Put-away No.No. PrintedPosting DateSource 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 DateExternal Document No.2«Table 7342»Posted Invt. Pick HeaderNo. [PK]Location Code [NN]Assigned User IDAssignment DateAssignment TimeRegistering DateNo. SeriesCommentInvt Pick No.No. PrintedPosting DateSource 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.Shipment DateExternal Document No.2«Table 7344»Registered Invt. Movement Hdr.No. [PK]Location Code [NN]Assigned User IDAssignment DateAssignment TimeRegistering DateNo. SeriesCommentInvt. Movement No.No. PrintedPosting DateSource 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.Shipment DateExternal Document No.2«Table 7346»Internal Movement HeaderNo. [PK]Location CodeAssigned User IDAssignment DateAssignment TimeNo. SeriesCommentTo Bin CodeDue DateSorting Method; [,Item,Shelf or Bin,Du...«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 7710»ADCS UserName [PK,NN]Password [NN]<Location Code><ADCS User><Assigned User ID><Assigned User ID><Assigned User ID><Assigned User ID><Assigned User ID><Assigned User ID><Assigned User ID><Assigned User ID><Assigned User ID><Assigned User ID><Assigned User ID><Assigned User ID><Assigned User ID><Location Code><Destination No.><Last Registering No.><Location Code><Location Code><Location Code><Last Receiving No.><Location Code><Location Code><Last Shipping No.><Location Code><Location Code><Location Code><Location Code><Destination No.><Location Code><Destination No.><Location Code><Destination No.><Location Code>

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

Fields

# Name Type
1 User ID (User ID) Code50
2 Location Code (Location Code) Code10
4 Default (Default) Boolean
7710 ADCS User (ADCS User) Code50

Keys

# Fields
0 User ID,Location Code (User ID,Location Code) Clustered: Yes
1 Default (Default)
2 Location Code (Location Code)

Table Relations To Other Tables

Field Related Table Related Field
ADCS User (ADCS User) ADCS User Name (Name) 1..n
Location Code (Location Code) Location Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Internal Movement Header Assigned User ID (Assigned User ID) 1..n
Posted Invt. Pick Header Assigned User ID (Assigned User ID) 1..n
Posted Invt. Put-away Header Assigned User ID (Assigned User ID) 1..n
Posted Whse. Receipt Header Assigned User ID (Assigned User ID) 1..n
Posted Whse. Shipment Header Assigned User ID (Assigned User ID) 1..n
Registered Invt. Movement Hdr. Assigned User ID (Assigned User ID) 1..n
Registered Whse. Activity Hdr. Assigned User ID (Assigned User ID) 1..n
Warehouse Activity Header Assigned User ID (Assigned User ID) 1..n
Warehouse Journal Batch Assigned User ID (Assigned User ID) 1..n
Warehouse Receipt Header Assigned User ID (Assigned User ID) 1..n
Warehouse Shipment Header Assigned User ID (Assigned User ID) 1..n
Whse. Internal Pick Header Assigned User ID (Assigned User ID) 1..n
Whse. Internal Put-away Header Assigned User ID (Assigned User ID) 1..n