Diagrams

Table

Interaction Log Entry

DynamicsDocs.comInteraction Log Entry«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 5123»Inter. Log Entry Comment LineEntry No. [PK]Line No. [PK]DateCodeCommentLast Date Modified«Table 5050»ContactNo. [PK]NameSearch NameName 2AddressAddress 2CityPhone No.Telex No.Territory CodeCurrency CodeLanguage CodeSalesperson CodeCountry/Region CodeCommentLast Date ModifiedFax No.Telex Answer BackVAT Registration No.PicturePost CodeCountyE-MailHome PageNo. SeriesType; [Company,Person]Company No.Company NameLookup Contact No.First NameMiddle Name...«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 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact Email«Table 5063»Interaction GroupCode [PK,NN]DescriptionDate FilterNo. of InteractionsCost [LCY]Duration [Min.]«Table 5064»Interaction TemplateCode [PK,NN]Interaction Group Code [NN]DescriptionUnit Cost [LCY]Unit Duration [Min.]Information Flow; [,Outbound,Inbound]Initiated By; [,Us,Them]Attachment No.Campaign No.Campaign TargetCampaign ResponseCorrespondence Type [Default]; [,Hard...Date FilterNo. of InteractionsCost [LCY]Duration [Min.]Language Code [Default]Wizard Action; [,Open,Import]Ignore Contact Corres. Type«Table 5071»CampaignNo. [PK]DescriptionStarting DateEnding DateSalesperson CodeCommentLast Date ModifiedNo. SeriesGlobal Dimension 1 CodeGlobal Dimension 2 CodeStatus CodeTarget Contacts ContactedContacts RespondedDuration [Min.]Cost [LCY]No. of OpportunitiesEstimated Value [LCY]Calcd. Current Value [LCY]Date FilterAction Taken Filter; [,Next,Previous,U...Sales Cycle FilterSales Cycle Stage FilterProbability % FilterCompleted % FilterContact FilterContact Company FilterEstimated Value FilterCalcd. Current Value FilterChances of Success % FilterTo-do Status Filter; [Not Started,In P...To-do Closed Filter...«Table 5072»Campaign EntryEntry No. [PK]Campaign No.DescriptionDateUser IDSegment No.CanceledNo. of InteractionsCost [LCY]Duration [Min.]Salesperson CodeRegister No.Document Type; [,Sales Qte.,Sales Blnk...«Table 5080»To-doNo. [PK]Team CodeSalesperson CodeCampaign No.Contact No.Opportunity No.Segment No.Type; [,Meeting,Phone Call]Date [NN]Status; [Not Started,In Progress,Compl...Priority; [Low,Normal,High]DescriptionClosedDate ClosedNo. SeriesCommentCanceledContact NameTeam NameSalesperson NameCampaign DescriptionContact Company No.Contact Company NameRecurringRecurring Date IntervalCalc. Due Date From; [,Due Date,Closin...Opportunity DescriptionStart TimeDurationOpportunity Entry No.Last Date Modified...«Table 13»Salesperson/PurchaserCode [PK,NN]NameCommission %Global Dimension 1 CodeGlobal Dimension 2 CodeE-MailPhone No.Next To-do DateNo. of OpportunitiesEstimated Value [LCY]Calcd. Current Value [LCY]Date FilterNo. of InteractionsCost [LCY]Duration [Min.]Job TitleAction Taken Filter; [,Next,Previous,U...Sales Cycle FilterSales Cycle Stage FilterProbability % FilterCompleted % FilterAvg. Estimated Value [LCY]Avg.Calcd. Current Value [LCY]Contact FilterContact Company FilterCampaign FilterEstimated Value FilterCalcd. Current Value FilterChances of Success % FilterTo-do Status Filter; [Not Started,In P...Closed To-do Filter...«Table 5051»Contact Alt. AddressContact No. [PK]Code [PK,NN]Company NameCompany Name 2AddressAddress 2CityPost CodeCountyCountry/Region CodePhone No.Telex No.Extension No.Mobile Phone No.PagerE-MailHome PageFax No.Telex Answer BackLast Date ModifiedSearch E-Mail«Table 5075»Logged SegmentEntry No. [PK]Segment No.DescriptionNo. of InteractionsNo. of Campaign EntriesCreation DateUser IDCanceled«Table 8»LanguageCode [PK,NN]NameWindows Language IDWindows Language Name«Table 5092»OpportunityNo. [PK]DescriptionSalesperson CodeCampaign No.Contact No.Contact Company No.Sales Cycle CodeSales Document No.Creation DateStatus; [Not Started,In Progress,Won,L...Priority; [Low,Normal,High]ClosedDate ClosedNo. SeriesCommentCurrent Sales Cycle StageEstimated Value [LCY]Probability %Calcd. Current Value [LCY]Chances of Success %Completed %Contact NameContact Company NameSalesperson NameCampaign DescriptionSegment No.Estimated Closing DateSales Document Type; [,Quote,Order,Pos...No. of InteractionsWizard Step; [,1,2,3,4,5,6]Activate First Stage...<Contact No.><Contact Company No.><Attachment No.><User ID><Interaction Group Code><Interaction Template Code><Campaign No.><Campaign Entry No.><To-do No.><Salesperson Code><Contact Alt. Address Code><Logged Segment Entry No.><Interaction Language Code><Opportunity No.><Entry No.><Language Code><Salesperson Code><Salesperson Filter><Contact Filter><Contact Company Filter><Company No.><Lookup Contact No.><Campaign Filter><Contact Filter><Contact Company Filter><Contact No.><Contact No.><Contact Company No.><Contact No.><Contact Company No.><User ID><User ID><Interaction Group Code><Campaign No.><Language Code (Default)><Interaction Template Code><Salesperson Code><Salesperson Filter><Campaign Filter><Campaign No.><Campaign No.><Campaign No.><Salesperson Code><Register No.><Salesperson Code><Completed By><Opportunity No.><Organizer To-do No.><Language Code><Salesperson Code>

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

Fields

# Name Type
1 Entry No. (Entry No.) Integer
2 Contact No. (Contact No.) Code20
3 Contact Company No. (Contact Company No.) Code20
4 Date (Date) Date
5 Description (Description) Text50
6 Information Flow (Information Flow) Option
7 Initiated By (Initiated By) Option
8 Attachment No. (Attachment No.) Integer
9 Cost (LCY) (Cost (LCY)) Decimal Editable: No
10 Duration (Min.) (Duration (Min.)) Decimal (0:0) Editable: No
11 User ID (User ID) Code50
12 Interaction Group Code (Interaction Group Code) Code10
13 Interaction Template Code (Interaction Template Code) Code10
14 Campaign No. (Campaign No.) Code20
15 Campaign Entry No. (Campaign Entry No.) Integer
16 Campaign Response (Campaign Response) Boolean
17 Campaign Target (Campaign Target) Boolean
18 Segment No. (Segment No.) Code20
19 Evaluation (Evaluation) Option Editable: No
20 Time of Interaction (Time of Interaction) Time
21 Attempt Failed (Attempt Failed) Boolean
23 To-do No. (To-do No.) Code20
24 Salesperson Code (Salesperson Code) Code10
25 Delivery Status (Delivery Status) Option
26 Canceled (Canceled) Boolean
27 Correspondence Type (Correspondence Type) Option
28 Contact Alt. Address Code (Contact Alt. Address Code) Code10
29 Logged Segment Entry No. (Logged Segment Entry No.) Integer
30 Document Type (Document Type) Option
31 Document No. (Document No.) Code20
32 Version No. (Version No.) Integer
33 Doc. No. Occurrence (Doc. No. Occurrence) Integer
34 Contact Via (Contact Via) Text80
35 Send Word Docs. as Attmt. (Send Word Docs. as Attmt.) Boolean
36 Interaction Language Code (Interaction Language Code) Code10
37 E-Mail Logged (E-Mail Logged) Boolean
38 Subject (Subject) Text50
39 Contact Name (Contact Name) Text50 Editable: No
FlowField
40 Contact Company Name (Contact Company Name) Text50 Editable: No
FlowField
43 Comment (Comment) Boolean Editable: No
FlowField
44 Opportunity No. (Opportunity No.) Code20
45 Postponed (Postponed) Boolean

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Contact Company No.,Contact No.,Date,Postponed (Contact Company No.,Contact No.,Date,Postponed)
2 Contact Company No.,Date,Contact No.,Canceled,Initiated By,Attempt Failed,Postponed (Contact Company No.,Date,Contact No.,Canceled,Initiated By,Attempt Failed,Postponed) MaintainSIFTIndex: No
3 Interaction Group Code,Date (Interaction Group Code,Date)
4 Interaction Group Code,Canceled,Date,Postponed (Interaction Group Code,Canceled,Date,Postponed)
5 Interaction Template Code,Date (Interaction Template Code,Date)
6 Interaction Template Code,Canceled,Date,Postponed (Interaction Template Code,Canceled,Date,Postponed)
7 Canceled,Campaign No.,Campaign Entry No.,Date,Postponed (Canceled,Campaign No.,Campaign Entry No.,Date,Postponed)
8 Campaign No.,Campaign Entry No.,Date,Postponed (Campaign No.,Campaign Entry No.,Date,Postponed)
9 Salesperson Code,Date,Postponed (Salesperson Code,Date,Postponed)
10 Canceled,Salesperson Code,Date,Postponed (Canceled,Salesperson Code,Date,Postponed)
11 Logged Segment Entry No.,Postponed (Logged Segment Entry No.,Postponed)
12 Attachment No. (Attachment No.)
13 To-do No.,Date (To-do No.,Date)
14 Contact No.,Correspondence Type,E-Mail Logged,Subject,Postponed (Contact No.,Correspondence Type,E-Mail Logged,Subject,Postponed)
15 Campaign No.,Campaign Target (Campaign No.,Campaign Target)
16 Campaign No.,Contact Company No.,Campaign Target,Postponed (Campaign No.,Contact Company No.,Campaign Target,Postponed)
17 Opportunity No.,Date (Opportunity No.,Date)

Table Relations To Other Tables

Field Related Table Related Field
Attachment No. (Attachment No.) Attachment No. (No.) 1..n
Campaign No. (Campaign No.) Campaign No. (No.) 1..n
Campaign Entry No. (Campaign Entry No.) Campaign Entry Entry No. (Entry No.) 1..n
Contact Company No. (Contact Company No.) Contact () 1..n
Contact Alt. Address Code (Contact Alt. Address Code) Contact Alt. Address Code (Code) 1..n
Interaction Group Code (Interaction Group Code) Interaction Group Code (Code) 1..n
Interaction Template Code (Interaction Template Code) Interaction Template Code (Code) 1..n
Interaction Language Code (Interaction Language Code) Language Code (Code) 1..n
Logged Segment Entry No. (Logged Segment Entry No.) Logged Segment Entry No. (Entry No.) 1..n
Opportunity No. (Opportunity No.) Opportunity No. (No.) 1..n
Salesperson Code (Salesperson Code) Salesperson/Purchaser Code (Code) 1..n
To-do No. (To-do No.) To-do No. (No.) 1..n
User ID (User ID) User User Name (User Name) 1..n

Table Relations From Other Tables

From Table From Field
Inter. Log Entry Comment Line Entry No. (Entry No.) 1..n