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 %ImageGlobal Dimension 1 CodeGlobal Dimension 2 CodeE-MailPhone No.Next Task 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 % FilterTask Status Filter; [Not Started,In Pr......«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 SchemeLast Modified Date TimeId«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. Code20
3 Campaign Nos. Code20
4 Segment Nos. Code20
5 To-do Nos. Code20
6 Opportunity Nos. Code20
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 Code20
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
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
74 Sync with Microsoft Graph Boolean Editable: No
75 WebHook Run Notification As GUID
76 Cust. Template Company Code Code10
77 Cust. Template Person Code Code10

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