Diagrams

Table

Service Document Log

DynamicsDocs.comService Document Log«Table 5912»Service Document LogDocument No. [PK]Entry No. [PK]Event No.Service Item Line No.AfterBeforeChange DateChange TimeUser IDDocument Type; [Quote,Order,Invoice,Cr...«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<User ID>

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

Fields

# Name Type
1 Document No. (Document No.) Code20
2 Entry No. (Entry No.) Integer
3 Event No. (Event No.) Integer
4 Service Item Line No. (Service Item Line No.) Integer
5 After (After) Text50
6 Before (Before) Text50
7 Change Date (Change Date) Date
8 Change Time (Change Time) Time
9 User ID (User ID) Code50
10 Document Type (Document Type) Option Editable: No

Keys

# Fields
0 Document Type,Document No.,Entry No. (Document Type,Document No.,Entry No.) Clustered: Yes
1 Change Date,Change Time (Change Date,Change Time)

Table Relations To Other Tables

Field Related Table Related Field
User ID (User ID) User User Name (User Name) 1..n

Table Relations From Other Tables

From Table From Field