Diagrams


Table

Sales Cycle

DynamicsDocs.comSales Cycle«Table 5090»Sales CycleCode [PK,NN]DescriptionProbability Calculation; [Multiply,Add...BlockedNo. of OpportunitiesEstimated Value [LCY]Calcd. Current Value [LCY]CommentDate 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 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 5061»Rlshp. Mgt. Comment LineTable Name; [Contact,Campaign,To-do,We...No. [PK]Sub No. [PK]Line No. [PK]DateCodeCommentLast Date Modified«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 5079»Marketing SetupPrimary Key [PK]Contact Nos.Campaign Nos.Segment Nos.To-do Nos.Opportunity Nos.Bus. Rel. Code for CustomersBus. Rel. Code for VendorsBus. Rel. Code for Bank Accs.Inherit Salesperson CodeInherit Territory CodeInherit Country/Region CodeInherit Language CodeInherit Address DetailsInherit Communication DetailsDefault Salesperson CodeDefault Territory CodeDefault Country/Region CodeDefault Language CodeDefault Sales Cycle CodeAttachment Storage Type; [Embedded,Dis...Attachment Storage LocationAutosearch for DuplicatesSearch Hit % [NN]Maintain Dupl. Search Strings [NN]Mergefield Language IDDef. Company Salutation CodeDefault Person Salutation CodeDefault Correspondence Type; [,Hard Co...Queue Folder PathQueue Folder UID...«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...«Table 5093»Opportunity EntryEntry No. [PK]Opportunity No.Sales Cycle CodeSales Cycle StageContact No.Contact Company No.Salesperson CodeCampaign No.Date of ChangeActiveDate ClosedDays OpenAction Taken; [,Next,Previous,Updated,...Estimated Value [LCY]Calcd. Current Value [LCY]Completed %Chances of Success %Probability %Close Opportunity CodePrevious Sales Cycle StageEstimated Close DateWizard Step; [,1,2,3,4,5,6]Cancel Old To DoAction Type; [,First,Next,Previous,Ski...Sales Cycle Stage Description«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...<Sales Cycle Filter><Sales Cycle Filter><No.><Sales Cycle Filter><Default Sales Cycle Code><Sales Cycle Code><Sales Cycle Code><Sales Cycle Code><Sales Cycle Filter><Sales Cycle Stage Filter><Contact Filter><Contact Company Filter><Salesperson Code><Salesperson Filter><Campaign Filter><Salesperson Code><Salesperson Filter><Default Salesperson Code><Salesperson Code><Salesperson Code><Salesperson Filter><Company No.><Lookup Contact No.><Campaign Filter><Contact Filter><Contact Company Filter><Sales Cycle Stage Filter><No.><Contact No.><Contact Company No.><Contact No.><Contact Company No.><Contact Filter><Company No.><Contact Company Filter><No.><No.><Sub No.><No.><Sales Cycle Stage Filter><Campaign No.><Campaign No.><Campaign Filter><Sales Cycle Stage><Previous Sales Cycle Stage><Sales Cycle Stage Filter><Opportunity 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 Description Text50
3 Probability Calculation Option
4 Blocked Boolean
5 No. of Opportunities Integer Editable: No
FlowField
6 Estimated Value (LCY) Decimal Editable: No
FlowField
7 Calcd. Current Value (LCY) Decimal Editable: No
FlowField
8 Comment Boolean Editable: No
FlowField
9 Date Filter Date FlowFilter

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field
Campaign Sales Cycle Filter 1..n
Contact Sales Cycle Filter 1..n
Marketing Setup Default Sales Cycle Code 1..n
Opportunity Sales Cycle Code 1..n
Opportunity Entry Sales Cycle Code 1..n
RM Matrix Management Sales Cycle Filter 1..n
Rlshp. Mgt. Comment Line No. 1..n
Sales Cycle Stage Sales Cycle Code 1..n
Salesperson/Purchaser Sales Cycle Filter 1..n