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,Email...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,Email...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 EmailExchange IdentifierApplication ID«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 %ImageGlobal 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......«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


# Name Type
1 Entry No. (Entry No.) Integer
2 Campaign No. (Campaign No.) Code20
3 Description (Description) Text50
4 Date (Date) Date
5 User ID (User ID) Code50 Editable: No
6 Segment No. (Segment No.) Code20
7 Canceled (Canceled) Boolean BlankZero: Yes
8 No. of Interactions (No. of Interactions) Integer Editable: No
10 Cost (LCY) (Cost (LCY)) Decimal Editable: No
11 Duration (Min.) (Duration (Min.)) Decimal (0:0) Editable: No
12 Salesperson Code (Salesperson Code) Code10
13 Register No. (Register No.) Integer
14 Document Type (Document Type) Option


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

Table Relations To Other Tables

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

Table Relations From Other Tables

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