Diagrams


Table

Segment Header

DynamicsDocs.comSegment Header«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 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 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 5078»Segment HistorySegment No. [PK]Segment Action No. [PK]Segment Line No. [PK]Contact No.Action Taken; [Insertion,Deletion]«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 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...«Table 5096»Segment Wizard FilterSegment No. [PK]Functionality; [Add Contacts,Remove Co...Mailing Group Code FilterIndustry Group Code FilterSalesperson Code FilterCountry/Region Code FilterTerritory Code FilterPost Code FilterBusiness Relation Code FilterProfile Questn. Code FilterProfile Questn. Line FilterJob Responsibility Code FilterProfile Questionnaire CodeAdd Additional CriteriaWizard Step; [,1,2,3,4,5,6]«Table 5097»Segment Criteria LineSegment No. [PK]Line No. [PK]Type; [Action,Filter]Action; [,Add Contacts,Remove Contacts...Table No.ViewAllow Existing ContactsExpand ContactAllow Company with PersonsIgnore ExclusionEntire CompaniesTable CaptionNo. of Filters«Table 5104»Segment Interaction LanguageSegment No. [PK]Segment Line No. [PK]Language Code [PK]DescriptionAttachment No.Subject«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 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 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 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 8»LanguageCode [PK,NN]NameWindows Language IDWindows Language Name«Table 5063»Interaction GroupCode [PK,NN]DescriptionDate FilterNo. of InteractionsCost [LCY]Duration [Min.]<Campaign No.><Salesperson Code><Interaction Template Code><No. Series><Language Code (Default)><Interaction Group Code><Segment No.><Segment No.><Segment No.><Segment No.><Segment No.><Segment No.><Segment No.><Segment No.><Campaign No.><Salesperson Code><Campaign Entry No.><Campaign No.><Salesperson Code><Interaction Template Code><Language Code><To-do No.><Interaction Group Code><Opportunity No.><Segment Line No.><Salesperson Code><Completed By><Campaign No.><Opportunity No.><No. Series><Organizer To-do No.><Interaction Template Code><Language Code><Salesperson Code><Campaign No.><No. Series><Salesperson Code Filter><Language Code><Salesperson Code><Salesperson Filter><Campaign Filter><No. Series><Campaign No.><Interaction Group Code><Language Code (Default)>

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

Fields

# Name Type
1 No. Code20
2 Description Text50
3 Campaign No. Code20
4 Salesperson Code Code10
5 Correspondence Type (Default) Option
6 Interaction Template Code Code10
7 Unit Cost (LCY) Decimal
8 Unit Duration (Min.) Decimal (0:0)
9 Attachment No. Integer FlowField
10 Date Date
11 Campaign Target Boolean
12 Information Flow Option BlankZero: Yes
13 Initiated By Option BlankZero: Yes
14 No. Series Code10 Editable: No
15 Campaign Response Boolean
16 No. of Lines Integer Editable: No
FlowField
17 Cost (LCY) Decimal Editable: No
FlowField
18 Duration (Min.) Decimal (0:0) Editable: No
FlowField
19 Language Code (Default) Code10
20 Interaction Group Code Code10
21 No. of Criteria Actions Integer Editable: No
FlowField
22 Send Word Docs. as Attmt. Boolean
23 Ignore Contact Corres. Type Boolean
24 Subject (Default) Text50
25 Campaign Description Text50 Editable: No
FlowField

Keys

# Fields
0 No. Clustered: Yes
1 Salesperson Code
2 Campaign No.

Table Relations To Other Tables

Field Related Table Related Field
Campaign No. Campaign No. 1..n
Interaction Group Code Interaction Group Code 1..n
Interaction Template Code Interaction Template Code 1..n
Language Code (Default) Language Code 1..n
No. Series No. Series Code 1..n
Salesperson Code Salesperson/Purchaser Code 1..n

Table Relations From Other Tables

From Table From Field
Campaign Entry Segment No. 1..n
Opportunity Segment No. 1..n
Segment Criteria Line Segment No. 1..n
Segment History Segment No. 1..n
Segment Interaction Language Segment No. 1..n
Segment Line Segment No. 1..n
Segment Wizard Filter Segment No. 1..1
To-do Segment No. 1..n