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

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field