Diagrams


Table

Marketing Setup

DynamicsDocs.comMarketing Setup«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 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 5053»Business RelationCode [PK,NN]DescriptionNo. of Contacts«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 286»TerritoryCode [PK,NN]Name«Table 9»Country/RegionCode [PK,NN]NameEU Country/Region CodeIntrastat CodeAddress Format; [Post Code+City,City+P...Contact Address Format; [First,After C...VAT Scheme«Table 8»LanguageCode [PK,NN]NameWindows Language IDWindows Language Name«Table 5090»Sales CycleCode [PK,NN]DescriptionProbability Calculation; [Multiply,Add...BlockedNo. of OpportunitiesEstimated Value [LCY]Calcd. Current Value [LCY]CommentDate Filter«Table 5068»SalutationCode [PK,NN]Description<Contact Nos.><Campaign Nos.><Segment Nos.><To-do Nos.><Opportunity Nos.><Bus. Rel. Code for Customers><Bus. Rel. Code for Vendors><Bus. Rel. Code for Bank Accs.><Default Salesperson Code><Default Territory Code><Default Country/Region Code><Default Language Code><Default Sales Cycle Code><Def. Company Salutation Code><Default Person Salutation Code><Sales Cycle Filter>

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

Fields

# Name Type
1 Primary Key Code10
2 Contact Nos. Code10
3 Campaign Nos. Code10
4 Segment Nos. Code10
5 To-do Nos. Code10
6 Opportunity Nos. Code10
7 Bus. Rel. Code for Customers Code10
8 Bus. Rel. Code for Vendors Code10
9 Bus. Rel. Code for Bank Accs. Code10
22 Inherit Salesperson Code Boolean
23 Inherit Territory Code Boolean
24 Inherit Country/Region Code Boolean
25 Inherit Language Code Boolean
26 Inherit Address Details Boolean
27 Inherit Communication Details Boolean
28 Default Salesperson Code Code10
29 Default Territory Code Code10
30 Default Country/Region Code Code10
31 Default Language Code Code10
33 Default Sales Cycle Code Code10
35 Attachment Storage Type Option
36 Attachment Storage Location Text250
37 Autosearch for Duplicates Boolean
38 Search Hit % Integer NotBlank: Yes
39 Maintain Dupl. Search Strings Boolean NotBlank: Yes
50 Mergefield Language ID Integer BlankZero: Yes
51 Def. Company Salutation Code Code10
52 Default Person Salutation Code Code10
53 Default Correspondence Type Option
56 Queue Folder Path Text250 Editable: No
57 Queue Folder UID BLOB
59 Storage Folder Path Text250 Editable: No
60 Storage Folder UID BLOB
67 Default To-do Date Calculation DateFormula
68 Enable Connector Boolean
69 Autodiscovery E-Mail Address Text250
70 Email Batch Size Integer
71 Exchange Service URL Text250
72 Exchange Account User Name Text250
73 Exchange Account Password Key GUID

Keys

# Fields
0 Primary Key Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Bus. Rel. Code for Bank Accs. Business Relation Code 1..n
Default Country/Region Code Country/Region Code 1..n
Default Language Code Language Code 1..n
Opportunity Nos. No. Series Code 1..n
Default Sales Cycle Code Sales Cycle Code 1..n
Default Salesperson Code Salesperson/Purchaser Code 1..n
Default Person Salutation Code Salutation Code 1..n
Default Territory Code Territory Code 1..n
Mergefield Language ID Windows Language 1..n

Table Relations From Other Tables

From Table From Field