Diagrams

Table

Warehouse Register

DynamicsDocs.comWarehouse Register«Table 7313»Warehouse RegisterNo. [PK]From Entry No.To Entry No.Creation DateSource CodeUser IDJournal Batch Name«Table 87»Date Compr. RegisterNo. [PK]Creation DateTable CaptionPeriod Length; [Day,Week,Month,Quarter...Ending DateNo. of New RecordsNo. Records DeletedUser IDFilterStarting DateTable IDRegister No.Source CodeRetain Field ContentsRetain Totals«Table 7312»Warehouse EntryEntry No. [PK]Journal Batch NameLine No.Registering DateLocation CodeZone CodeBin CodeDescriptionItem No.QuantityQty. [Base]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Subline No.Source Document; [,S. Order,S. Invoice...Source CodeReason CodeNo. SeriesBin Type CodeCubageWeightJournal Template NameWhse. Document No.Whse. Document Type; [Whse. Journal,Re...Whse. Document Line No.Entry Type; [Negative Adjmt.,Positive...Reference Document; [,Posted Rcpt.,Pos...Reference No.User ID...«Table 230»Source CodeCode [PK,NN]Description«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact EmailExchange IdentifierApplication ID«Table 233»Item Journal BatchJournal Template Name [PK,NN]Name [PK,NN]DescriptionReason CodeNo. SeriesPosting No. SeriesTemplate Type; [Item,Transfer,Phys. In...Recurring<From Entry No.><To Entry No.><Source Code><User ID><Journal Batch Name><Register No.><User ID><Source Code><Source Code><User ID>

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

Fields

# Name Type
1 No. (No.) Integer
2 From Entry No. (From Entry No.) Integer
3 To Entry No. (To Entry No.) Integer
4 Creation Date (Creation Date) Date
5 Source Code (Source Code) Code10
6 User ID (User ID) Code50
7 Journal Batch Name (Journal Batch Name) Code10

Keys

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

Table Relations To Other Tables

Field Related Table Related Field
Journal Batch Name (Journal Batch Name) Item Journal Batch Name (Name) 1..n
Source Code (Source Code) Source Code Code (Code) 1..n
User ID (User ID) User User Name (User Name) 1..n
To Entry No. (To Entry No.) Warehouse Entry Entry No. (Entry No.) 1..n

Table Relations From Other Tables

From Table From Field
Date Compr. Register Register No. (Register No.) 1..n