Diagrams


Table

Date Compr. Register

DynamicsDocs.comDate Compr. Register«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 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 45»G/L RegisterNo. [PK]From Entry No.To Entry No.Creation DateSource CodeUser IDJournal Batch NameFrom VAT Entry No.To VAT Entry No.Reversed«Table 46»Item RegisterNo. [PK]From Entry No.To Entry No.Creation DateSource CodeUser IDJournal Batch NameFrom Phys. Inventory Entry No.To Phys. Inventory Entry No.From Value Entry No.To Value Entry No.From Capacity Entry No.To Capacity Entry No.«Table 240»Resource RegisterNo. [PK]From Entry No.To Entry No.Creation DateSource CodeUser IDJournal Batch Name«Table 241»Job RegisterNo. [PK]From Entry No.To Entry No.Creation DateSource CodeUser IDJournal Batch Name«Table 5617»FA RegisterNo. [PK]From Entry No.To Entry No.Creation DateSource CodeUser IDJournal Batch NameJournal Type; [G/L,Fixed Asset]G/L Register No.From Maintenance Entry No.To Maintenance Entry No.«Table 5636»Insurance RegisterNo. [PK]From Entry No.To Entry No.Creation DateSource CodeUser IDJournal Batch Name«Table 7313»Warehouse RegisterNo. [PK]From Entry No.To Entry No.Creation DateSource CodeUser IDJournal Batch Name«Table 230»Source CodeCode [PK,NN]Description<User ID><Register No.><Register No.><Register No.><Register No.><Register No.><Register No.><Register No.><Source Code><User ID><User ID><User ID><User ID><User ID><User ID><User ID><Source Code><G/L Register No.><Source Code><Source Code><Source Code><Source Code><Source Code><Source Code>

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 Creation Date (Creation Date) Date
3 Table Caption (Table Caption) Text250 Editable: No
FlowField
4 Period Length (Period Length) Option
5 Ending Date (Ending Date) Date [ClosingDates:Yes]
6 No. of New Records (No. of New Records) Integer
7 No. Records Deleted (No. Records Deleted) Integer
8 User ID (User ID) Code50
9 Filter (Filter) Text250
10 Starting Date (Starting Date) Date [ClosingDates:Yes]
11 Table ID (Table ID) Integer
12 Register No. (Register No.) Integer
13 Source Code (Source Code) Code10
14 Retain Field Contents (Retain Field Contents) Text80
15 Retain Totals (Retain Totals) Text80

Keys

# Fields
0 No. (No.) Clustered: Yes
1 Table ID (Table ID)
2 Table ID,Ending Date (Table ID,Ending Date)

Table Relations To Other Tables

Field Related Table Related Field
Table ID (Table ID) AllObjWithCaption Object ID (Object ID) 1..n
Register No. (Register No.) FA Register No. (No.) 1..n
Register No. (Register No.) G/L Register No. (No.) 1..n
Register No. (Register No.) Insurance Register No. (No.) 1..n
Register No. (Register No.) Item Register No. (No.) 1..n
Register No. (Register No.) Job Register No. (No.) 1..n
Register No. (Register No.) Resource Register No. (No.) 1..n
Source Code (Source Code) Source Code Code (Code) 1..n
User ID (User ID) User User Name (User Name) 1..n
Register No. (Register No.) Warehouse Register No. (No.) 1..n

Table Relations From Other Tables

From Table From Field