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 (Code) Code10 NotBlank: Yes
2 Name (Name) Text50
3 Next To-do Date (Next To-do Date) Date Editable: No
FlowField
4 Date Filter (Date Filter) Date FlowFilter
5 Contact Filter (Contact Filter) Code20 FlowFilter
6 Contact Company Filter (Contact Company Filter) Code20 FlowFilter
7 To-do Status Filter (To-do Status Filter) Option FlowFilter
8 To-do Closed Filter (To-do Closed Filter) Boolean FlowFilter
9 Priority Filter (Priority Filter) Option FlowFilter
11 Salesperson Filter (Salesperson Filter) Code10 FlowFilter
12 Campaign Filter (Campaign Filter) Code20 FlowFilter
13 To-do Entry Exists (To-do Entry Exists) Boolean Editable: No
FlowField

Keys

# Fields
0 Code (Code) Clustered: Yes

Table Relations To Other Tables

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

Table Relations From Other Tables

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