Diagrams


Table

Attachment

DynamicsDocs.comAttachment«Table 5062»AttachmentNo. [PK,NN]AttachmentStorage Type; [Embedded,Disk File,Exch...Storage PointerFile ExtensionRead OnlyLast Date ModifiedLast Time ModifiedMerge SourceEmail Message IDEmail Entry IDEmail Message Checksum«Table 5065»Interaction Log EntryEntry No. [PK]Contact No.Contact Company No.DateDescriptionInformation Flow; [,Outbound,Inbound]Initiated By; [,Us,Them]Attachment No.Cost [LCY]Duration [Min.]User IDInteraction Group CodeInteraction Template CodeCampaign No.Campaign Entry No.Campaign ResponseCampaign TargetSegment No.Evaluation; [,Very Positive,Positive,N...Time of InteractionAttempt FailedTo-do No.Salesperson CodeDelivery Status; [,In Progress,Error]CanceledCorrespondence Type; [,Hard Copy,E-Mai...Contact Alt. Address CodeLogged Segment Entry No.Document Type; [,Sales Qte.,Sales Blnk...Document No.Version No....«Table 5074»Delivery SorterNo. [PK]Attachment No.Correspondence Type; [,Hard Copy,E-Mai...SubjectSend Word Docs. as Attmt.Language Code«Table 5077»Segment LineSegment No. [PK]Line No. [PK]Contact No.Campaign No.Salesperson CodeCorrespondence Type; [,Hard Copy,E-Mai...Interaction Template CodeCost [LCY]Duration [Min.]Attachment No.Campaign ResponseContact NameInformation Flow; [,Outbound,Inbound]Initiated By; [,Us,Them]Contact Alt. Address CodeEvaluation; [,Very Positive,Positive,N...Campaign TargetContact Company NameLanguage CodeDescriptionDateTime of InteractionAttempt FailedTo-do No.Contact Company No.Campaign Entry No.Interaction Group CodeDocument Type; [,Sales Qte.,Sales Blnk...Document No.Send Word Doc. As Attmt.Contact Via...«Table 5196»To-do Interaction LanguageTo-do No. [PK]Language Code [PK]DescriptionAttachment No.<Attachment No.><Attachment No.><Attachment No.><Attachment No.>

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 NotBlank: Yes
2 Attachment (Attachment) BLOB
3 Storage Type (Storage Type) Option
4 Storage Pointer (Storage Pointer) Text250
5 File Extension (File Extension) Text250
6 Read Only (Read Only) Boolean
7 Last Date Modified (Last Date Modified) Date
8 Last Time Modified (Last Time Modified) Time
13 Merge Source (Merge Source) BLOB
14 Email Message ID (Email Message ID) BLOB
15 Email Entry ID (Email Entry ID) BLOB
16 Email Message Checksum (Email Message Checksum) Integer

Keys

# Fields
0 No. (No.) Clustered: Yes
1 Email Message Checksum (Email Message Checksum)

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field
Delivery Sorter Attachment No. (Attachment No.) 1..n
Interaction Log Entry Attachment No. (Attachment No.) 1..n
Segment Line Attachment No. (Attachment No.) 1..n
To-do Interaction Language Attachment No. (Attachment No.) 1..n