Diagrams


DynamicsDocs.comTeam«Table 5083»TeamCode [PK,NN]NameNext To-do DateDate FilterContact FilterContact Company FilterTo-do Status Filter; [Not Started,In P...To-do Closed FilterPriority Filter; [Low,Normal,High]Salesperson FilterCampaign FilterTo-do Entry Exists«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 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 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 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 5084»Team SalespersonTeam Code [PK,NN]Salesperson Code [PK,NN]Team NameSalesperson Name«Table 5102»RM Matrix ManagementCompany Name [PK]No. [PK,NN]Name [PK]Type; [Company,Person] [PK]No. of OpportunitiesEstimated Value [LCY]Calcd. Current Value [LCY]Avg. Estimated Value [LCY]Avg.Calcd. Current Value [LCY]Salesperson FilterCampaign FilterContact FilterDate FilterAction Taken Filter; [,Next,Previous,U...Sales Cycle FilterSales Cycle Stage FilterProbability % FilterCompleted % FilterCompany No.Contact Company FilterTo-do Status Filter; [Not Started,In P...To-do Closed FilterPriority Filter; [Low,Normal,High]Team FilterNo. of To-dosEstimated Value FilterCalcd. Current Value FilterChances of Success % FilterClose Opportunity FilterSystem To-do Type Filter; [Organizer,S...<Contact Filter><Contact Company Filter><Team Filter><Salesperson Filter><Team Filter><Campaign Filter><Team Filter><Team Code><Team Code><Team Filter><Contact Filter><Contact Company Filter><Salesperson Code><Salesperson Filter><Campaign Filter><Salesperson Code><Salesperson Filter><Salesperson Code><Completed By><Salesperson Code><Salesperson Filter><Company No.><Lookup Contact No.><Campaign Filter><Contact Filter><Contact Company Filter><Contact No.><Contact Company No.><Contact Filter><Company No.><Contact Company Filter><Campaign No.><Campaign Filter><Organizer To-do No.>

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

Fields

# Name Type
1 Code Code10 NotBlank: Yes
2 Name Text50
3 Next To-do Date Date Editable: No
FlowField
4 Date Filter Date FlowFilter
5 Contact Filter Code20 FlowFilter
6 Contact Company Filter Code20 FlowFilter
7 To-do Status Filter Option FlowFilter
8 To-do Closed Filter Boolean FlowFilter
9 Priority Filter Option FlowFilter
11 Salesperson Filter Code10 FlowFilter
12 Campaign Filter Code20 FlowFilter
13 To-do Entry Exists Boolean Editable: No
FlowField

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Campaign Filter Campaign No. 1..n
Contact Company Filter Contact 1..n
Salesperson Filter Salesperson/Purchaser Code 1..n

Table Relations From Other Tables

From Table From Field
Campaign Team Filter 1..n
Contact Team Filter 1..n
RM Matrix Management Team Filter 1..n
Salesperson/Purchaser Team Filter 1..n
Team Salesperson Team Code 1..n
To-do Team Code 1..n