Diagrams


Table

Rlshp. Mgt. Comment Line

DynamicsDocs.comRlshp. Mgt. Comment Line«Table 5061»Rlshp. Mgt. Comment LineTable Name; [Contact,Campaign,To-do,We...No. [PK]Sub No. [PK]Line No. [PK]DateCodeCommentLast Date Modified«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. SeriesImageType; [Company,Person]Company No.Company NameLookup Contact No.First 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 5059»Web SourceCode [PK,NN]DescriptionURLComment«Table 5090»Sales CycleCode [PK,NN]DescriptionProbability Calculation; [Multiply,Add...BlockedNo. of OpportunitiesEstimated Value [LCY]Calcd. Current Value [LCY]CommentDate Filter«Table 5091»Sales Cycle StageSales Cycle Code [PK,NN]Stage [PK,NN]DescriptionCompleted %Activity CodeQuote RequiredAllow SkipCommentNo. of OpportunitiesEstimated Value [LCY]Calcd. Current Value [LCY]Average No. of DaysDate FilterDate Formula«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...<No.><No.><No.><No.><No.><No.><Sub No.><No.><Company No.><Lookup Contact No.><Campaign Filter><Contact Filter><Contact Company Filter><Sales Cycle Filter><Sales Cycle Stage Filter><Contact No.><Contact Company No.><Contact No.><Contact Company No.><Sales Cycle Filter><Sales Cycle Stage Filter><Campaign No.><Campaign No.><Opportunity No.><Organizer To-do No.><Sales Cycle Code><Sales Cycle Code>

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

Fields

# Name Type
1 Table Name Option
2 No. Code20
3 Sub No. Integer
4 Line No. Integer
5 Date Date
6 Code Code10
7 Comment Text80
8 Last Date Modified Date Editable: No

Keys

# Fields
0 Table Name,No.,Sub No.,Line No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
No. Campaign No. 1..n
No. Contact No. 1..n
No. Opportunity No. 1..n
No. Sales Cycle Code 1..n
Sub No. Sales Cycle Stage Stage 1..n
No. To-do No. 1..n
No. Web Source Code 1..n

Table Relations From Other Tables

From Table From Field