Diagrams


Table

Campaign Entry

DynamicsDocs.comCampaign Entry«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 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 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 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 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact Email«Table 5076»Segment HeaderNo. [PK]DescriptionCampaign No.Salesperson CodeCorrespondence Type [Default]; [,Hard...Interaction Template CodeUnit Cost [LCY]Unit Duration [Min.]Attachment No.DateCampaign TargetInformation Flow; [,Outbound,Inbound]Initiated By; [,Us,Them]No. SeriesCampaign ResponseNo. of LinesCost [LCY]Duration [Min.]Language Code [Default]Interaction Group CodeNo. of Criteria ActionsSend Word Docs. as Attmt.Ignore Contact Corres. TypeSubject [Default]Campaign Description«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 5075»Logged SegmentEntry No. [PK]Segment No.DescriptionNo. of InteractionsNo. of Campaign EntriesCreation DateUser IDCanceled<Campaign No.><User ID><Segment No.><Salesperson Code><Register No.><Campaign Entry No.><Campaign Entry No.><User ID><Campaign No.><Salesperson Code><Logged Segment Entry No.><Segment No.><Campaign No.><Salesperson Code><Salesperson Code><Salesperson Filter><Campaign Filter><Campaign No.><User ID><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. Integer
2 Campaign No. Code20
3 Description Text50
4 Date Date
5 User ID Code50 Editable: No
6 Segment No. Code20
7 Canceled Boolean BlankZero: Yes
8 No. of Interactions Integer Editable: No
FlowField
10 Cost (LCY) Decimal Editable: No
FlowField
11 Duration (Min.) Decimal (0:0) Editable: No
FlowField
12 Salesperson Code Code10
13 Register No. Integer
14 Document Type Option

Keys

# Fields
0 Entry No. Clustered: Yes
1 Campaign No.,Date,Document Type
2 Register No.

Table Relations To Other Tables

Field Related Table Related Field
Campaign No. Campaign No. 1..n
Register No. Logged Segment Entry No. 1..n
Salesperson Code Salesperson/Purchaser Code 1..n
Segment No. Segment Header No. 1..n
User ID User User Name 1..n

Table Relations From Other Tables

From Table From Field
Interaction Log Entry Campaign Entry No. 1..n
Segment Line Campaign Entry No. 1..n