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

Keys

# Fields
0 No. Clustered: Yes
1 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. 1..n
Interaction Log Entry Attachment No. 1..n
Segment Line Attachment No. 1..n
To-do Interaction Language Attachment No. 1..n