Diagrams


Table

Contact

DynamicsDocs.comContact«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 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«Table 5051»Contact Alt. AddressContact No. [PK]Code [PK,NN]Company NameCompany Name 2AddressAddress 2CityPost CodeCountyCountry/Region CodePhone No.Telex No.Extension No.Mobile Phone No.PagerE-MailHome PageFax No.Telex Answer BackLast Date ModifiedSearch E-Mail«Table 5052»Contact Alt. Addr. Date RangeContact No. [PK]Contact Alt. Address CodeStarting Date [PK,NN]Ending Date«Table 5054»Contact Business RelationContact No. [PK,NN]Business Relation Code [PK,NN]Link to Table; [,Customer,Vendor,Bank...No.Business Relation DescriptionContact Name«Table 5056»Contact Mailing GroupContact No. [PK,NN]Mailing Group Code [PK,NN]Contact NameContact Company NameMailing Group Description«Table 5058»Contact Industry GroupContact No. [PK,NN]Industry Group Code [PK,NN]Industry Group DescriptionContact Name«Table 5060»Contact Web SourceContact No. [PK,NN]Web Source Code [PK,NN]Search WordWeb Source DescriptionContact Name«Table 5067»Contact Job ResponsibilityContact No. [PK,NN]Job Responsibility Code [PK,NN]Job Responsibility DescriptionContact NameContact Company Name«Table 5069»Salutation FormulaSalutation Code [PK,NN]Language Code [PK]Salutation Type; [Formal,Informal] [PK...SalutationName 1; [,Job Title,First Name,Middle...Name 2; [,Job Title,First Name,Middle...Name 3; [,Job Title,First Name,Middle...Name 4; [,Job Title,First Name,Middle...Name 5; [,Job Title,First Name,Middle...Contact No. Filter«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 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 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 5085»Contact DuplicateContact No. [PK,NN]Duplicate Contact No. [PK,NN]Separate ContactsNo. of Matching StringsContact NameDuplicate Contact Name«Table 5086»Cont. Duplicate Search StringContact Company No. [PK,NN]Field; [Name,Name 2,Address,Address 2,...Part of Field; [First,Last] [PK]Search String«Table 5089»Contact Profile AnswerContact No. [PK,NN]Contact Company No. [NN]Profile Questionnaire Code [PK,NN]Line No. [PK]AnswerContact Company NameContact NameProfile Questionnaire Priority; [Very...Answer Priority; [Very Low <Hidden>,Lo...Last Date UpdatedQuestions Answered [%]«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 5100»Communication MethodKey [PK]DescriptionNumberContact No.NameType; [Company,Person]E-Mail«Table 5101»Contact ValueContact No. [PK]ValueLast Date UpdatedQuestions Answered [%]«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...«Table 5199»AttendeeTo-do No. [PK]Line No. [PK]Attendance Type; [Required,Optional,To...Attendee Type; [Contact,Salesperson]Attendee No.Attendee NameSend InvitationInvitation Response Type; [None,Accept...Invitation Sent«Table 7030»Campaign Target GroupType; [Customer,Contact] [PK]No. [PK]Campaign No. [PK]«Table 5070»Organizational LevelCode [PK,NN]Description«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 5094»Close Opportunity CodeCode [PK,NN]DescriptionNo. of OpportunitiesType; [Won,Lost]«Table 5068»SalutationCode [PK,NN]Description<Company No.><Lookup Contact No.><Organizational Level Code><Campaign Filter><Contact Filter><Contact Company Filter><Sales Cycle Filter><Sales Cycle Stage Filter><Team Filter><Contact Filter><Contact Company Filter><Close Opportunity Filter><Salutation Code><Primary Contact No.><Primary Contact No.><Contact No.><Contact No.><Contact No.><Contact No.><Contact No.><Contact No.><Contact No.><Contact No. Filter><Contact No.><Contact No.><Contact Company No.><Contact No.><Duplicate Contact No.><Contact Company No.><Contact No.><Contact Company No.><Contact No.><Contact Company No.><Contact No.><Contact No.><Contact Filter><Company No.><Contact Company Filter><Attendee No.><No.><Bill-to Customer No.><No.><No.><Pay-to Vendor No.><No.><Contact Alt. Address Code><Salutation Code><Sales Cycle Filter><Sales Cycle Stage Filter><Team Filter><Campaign Filter><Close Opportunity Filter><Campaign No.><Campaign No.><Campaign Filter><Campaign No.><Team Code><Opportunity No.><Organizer To-do No.><To-do No.><Team Filter><Sales Cycle Code><Sales Cycle Filter><Sales Cycle Stage Filter><Close Opportunity Filter><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 No. Code20
2 Name Text50
3 Search Name Code50
4 Name 2 Text50
5 Address Text50
6 Address 2 Text50
7 City Text30
9 Phone No. Text30 [Phone No.]
10 Telex No. Text20
15 Territory Code Code10
22 Currency Code Code10
24 Language Code Code10
29 Salesperson Code Code10
35 Country/Region Code Code10
38 Comment Boolean Editable: No
FlowField
54 Last Date Modified Date Editable: No
84 Fax No. Text30
85 Telex Answer Back Text20
86 VAT Registration No. Text20
89 Picture BLOB [Bitmap]
91 Post Code Code20
92 County Text30
102 E-Mail Text80 [E-Mail]
103 Home Page Text80 [URL]
107 No. Series Code10
5050 Type Option
5051 Company No. Code20
5052 Company Name Text50 Editable: No
5053 Lookup Contact No. Code20 Editable: No
5054 First Name Text30
5055 Middle Name Text30
5056 Surname Text30
5058 Job Title Text30
5059 Initials Text30
5060 Extension No. Text30
5061 Mobile Phone No. Text30 [Phone No.]
5062 Pager Text30
5063 Organizational Level Code Code10
5064 Exclude from Segment Boolean
5065 Date Filter Date FlowFilter
5066 Next To-do Date Date Editable: No
FlowField
5067 Last Date Attempted Date Editable: No
FlowField
5068 Date of Last Interaction Date Editable: No
FlowField
5069 No. of Job Responsibilities Integer Editable: No
FlowField
5070 No. of Industry Groups Integer Editable: No
FlowField
5071 No. of Business Relations Integer Editable: No
FlowField
5072 No. of Mailing Groups Integer Editable: No
FlowField
5073 External ID Code20
5074 No. of Interactions Integer Editable: No
FlowField
5076 Cost (LCY) Decimal Editable: No
FlowField
5077 Duration (Min.) Decimal (0:0) Editable: No
FlowField
5078 No. of Opportunities Integer Editable: No
FlowField
5079 Estimated Value (LCY) Decimal Editable: No
FlowField
5080 Calcd. Current Value (LCY) Decimal Editable: No
FlowField
5082 Opportunity Entry Exists Boolean Editable: No
FlowField
5083 To-do Entry Exists Boolean Editable: No
FlowField
5084 Salesperson Filter Code10 FlowFilter
5085 Campaign Filter Code20 FlowFilter
5087 Action Taken Filter Option FlowFilter
5088 Sales Cycle Filter Code10 FlowFilter
5089 Sales Cycle Stage Filter Integer FlowFilter
5090 Probability % Filter Decimal (1:1) FlowFilter
5091 Completed % Filter Decimal (1:1) FlowFilter
5092 Estimated Value Filter Decimal FlowFilter
5093 Calcd. Current Value Filter Decimal FlowFilter
5094 Chances of Success % Filter Decimal (0:0) FlowFilter
5095 To-do Status Filter Option FlowFilter
5096 To-do Closed Filter Boolean FlowFilter
5097 Priority Filter Option FlowFilter
5098 Team Filter Code10 FlowFilter
5099 Close Opportunity Filter Code10 FlowFilter
5100 Correspondence Type Option
5101 Salutation Code Code10
5102 Search E-Mail Code80
5104 Last Time Modified Time
5105 E-Mail 2 Text80 [E-Mail]

Keys

# Fields
0 No. Clustered: Yes
1 Search Name
2 Company Name,Company No.,Type,Name
3 Company No.
4 Territory Code
5 Salesperson Code
6 VAT Registration No.
7 Search E-Mail
8 Name
9 City
10 Post Code
11 Phone No.

Table Relations To Other Tables

Field Related Table Related Field
Campaign Filter Campaign No. 1..n
Close Opportunity Filter Close Opportunity Code Code 1..n
Lookup Contact No. Contact No. 1..n
Country/Region Code Country/Region Code 1..n
Currency Code Currency Code 1..n
Language Code Language Code 1..n
No. Series No. Series Code 1..n
Organizational Level Code Organizational Level Code 1..n
Sales Cycle Filter Sales Cycle Code 1..n
Sales Cycle Stage Filter Sales Cycle Stage Stage 1..n
Salesperson Filter Salesperson/Purchaser Code 1..n
Salutation Code Salutation Code 1..n
Team Filter Team Code 1..n
Territory Code Territory Code 1..n

Table Relations From Other Tables

From Table From Field
Attendee Attendee No. 1..n
Campaign Contact Company Filter 1..n
Campaign Target Group No. 1..n
Communication Method Contact No. 1..n
Cont. Duplicate Search String Contact Company No. 1..n
Contact Lookup Contact No. 1..n
Contact Alt. Addr. Date Range Contact No. 1..n
Contact Alt. Address Contact No. 1..n
Contact Business Relation Contact No. 1..n
Contact Duplicate Duplicate Contact No. 1..n
Contact Industry Group Contact No. 1..n
Contact Job Responsibility Contact No. 1..n
Contact Mailing Group Contact No. 1..n
Contact Profile Answer Contact Company No. 1..n
Contact Value Contact No. 1..1
Contact Web Source Contact No. 1..n
Customer Primary Contact No. 1..n
Interaction Log Entry Contact Company No. 1..n
Opportunity Contact Company No. 1..n
Opportunity Entry Contact Company No. 1..n
Purch. Cr. Memo Hdr. Pay-to Contact No. 1..n
Purch. Inv. Header Pay-to Contact No. 1..n
Purch. Rcpt. Header Pay-to Contact no. 1..n
Purchase Header Pay-to Contact No. 1..n
Purchase Header Archive Pay-to Contact No. 1..n
RM Matrix Management Contact Company Filter 1..n
Return Receipt Header Bill-to Contact No. 1..n
Return Shipment Header Pay-to Contact No. 1..n
Rlshp. Mgt. Comment Line No. 1..n
Sales Cr.Memo Header Bill-to Contact No. 1..n
Sales Header Bill-to Contact No. 1..n
Sales Header Archive Bill-to Contact No. 1..n
Sales Invoice Header Bill-to Contact No. 1..n
Sales Shipment Header Bill-to Contact No. 1..n
Salesperson/Purchaser Contact Company Filter 1..n
Salutation Formula Contact No. Filter 1..n
Segment History Contact No. 1..n
Segment Line Contact Company No. 1..n
Service Contract Header Bill-to Contact No. 1..n
Service Cr.Memo Header Bill-to Contact No. 1..n
Service Header Bill-to Contact No. 1..n
Service Invoice Header Bill-to Contact No. 1..n
Service Shipment Header Bill-to Contact No. 1..n
Team Contact Company Filter 1..n
To-do Contact Company No. 1..n
Vendor Primary Contact No. 1..n