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 Email«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. Integer
2 From Entry No. Integer
3 To Entry No. Integer
4 Creation Date Date
5 Source Code Code10
6 User ID Code50
7 Journal Batch Name Code10

Keys

# Fields
0 No. Clustered: Yes
1 Source Code

Table Relations To Other Tables

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

Table Relations From Other Tables

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