Diagrams

Table

Campaign

DynamicsDocs.comCampaign«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 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 5064»Interaction TemplateCode [PK,NN]Interaction Group Code [NN]DescriptionUnit Cost [LCY]Unit Duration [Min.]Information Flow; [,Outbound,Inbound]Initiated By; [,Us,Them]Attachment No.Campaign No.Campaign TargetCampaign ResponseCorrespondence Type [Default]; [,Hard...Date FilterNo. of InteractionsCost [LCY]Duration [Min.]Language Code [Default]Wizard Action; [,Open,Import]Ignore Contact Corres. Type«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 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 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 7002»Sales PriceItem No. [PK,NN]Sales Code [PK]Currency Code [PK]Starting Date [PK]Unit PricePrice Includes VATAllow Invoice Disc.VAT Bus. Posting Gr. [Price]Sales Type; [Customer,Customer Price G...Minimum Quantity [PK]Ending DateUnit of Measure Code [PK]Variant Code [PK]Allow Line Disc.«Table 7023»Sales Price WorksheetItem No. [PK,NN]Sales Code [PK]Currency Code [PK]Starting Date [PK]Current Unit PriceNew Unit PricePrice Includes VATAllow Invoice Disc.VAT Bus. Posting Gr. [Price]Sales Type; [Customer,Customer Price G...Minimum Quantity [PK]Ending Date [PK]Item DescriptionSales DescriptionUnit of Measure Code [PK]Variant Code [PK]Allow Line Disc.«Table 7030»Campaign Target GroupType; [Customer,Contact] [PK]No. [PK]Campaign No. [PK]«Table 5073»Campaign StatusCode [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]<Status Code><Sales Cycle Filter><Sales Cycle Stage Filter><Contact Filter><Contact Company Filter><Campaign Filter><Team Filter><Campaign Filter><Close Opportunity Filter><Campaign No.><Campaign No.><Campaign No.><Campaign Filter><Sales Code><Sales Code><Campaign No.><Company No.><Lookup Contact No.><Sales Cycle Filter><Sales Cycle Stage Filter><Team Filter><Contact Filter><Contact Company Filter><Close Opportunity Filter><Contact No.><Contact Company No.><Contact No.><Contact Company No.><Contact Filter><Company No.><Contact Company Filter><No.><Interaction Template Code><Team Code><Opportunity No.><Organizer 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. (No.) Code20
2 Description (Description) Text50
3 Starting Date (Starting Date) Date
4 Ending Date (Ending Date) Date
5 Salesperson Code (Salesperson Code) Code10
6 Comment (Comment) Boolean Editable: No
FlowField
7 Last Date Modified (Last Date Modified) Date Editable: No
8 No. Series (No. Series) Code10 Editable: No
9 Global Dimension 1 Code (Global Dimension 1 Code) Code20
10 Global Dimension 2 Code (Global Dimension 2 Code) Code20
11 Status Code (Status Code) Code10
12 Target Contacts Contacted (Target Contacts Contacted) Integer Editable: No
FlowField
13 Contacts Responded (Contacts Responded) Integer Editable: No
FlowField
14 Duration (Min.) (Duration (Min.)) Decimal (0:0) Editable: No
FlowField
16 Cost (LCY) (Cost (LCY)) Decimal Editable: No
FlowField
17 No. of Opportunities (No. of Opportunities) Integer Editable: No
FlowField
18 Estimated Value (LCY) (Estimated Value (LCY)) Decimal Editable: No
FlowField
19 Calcd. Current Value (LCY) (Calcd. Current Value (LCY)) Decimal Editable: No
FlowField
20 Date Filter (Date Filter) Date FlowFilter
23 Action Taken Filter (Action Taken Filter) Option FlowFilter
24 Sales Cycle Filter (Sales Cycle Filter) Code10 FlowFilter
25 Sales Cycle Stage Filter (Sales Cycle Stage Filter) Integer FlowFilter
26 Probability % Filter (Probability % Filter) Decimal (1:1) FlowFilter
27 Completed % Filter (Completed % Filter) Decimal (1:1) FlowFilter
28 Contact Filter (Contact Filter) Code20 FlowFilter
29 Contact Company Filter (Contact Company Filter) Code20 FlowFilter
30 Estimated Value Filter (Estimated Value Filter) Decimal FlowFilter
31 Calcd. Current Value Filter (Calcd. Current Value Filter) Decimal FlowFilter
32 Chances of Success % Filter (Chances of Success % Filter) Decimal (0:0) FlowFilter
33 To-do Status Filter (To-do Status Filter) Option FlowFilter
34 To-do Closed Filter (To-do Closed Filter) Boolean FlowFilter
35 Priority Filter (Priority Filter) Option FlowFilter
36 Team Filter (Team Filter) Code10 FlowFilter
37 Salesperson Filter (Salesperson Filter) Code10 FlowFilter
38 Opportunity Entry Exists (Opportunity Entry Exists) Boolean Editable: No
FlowField
39 To-do Entry Exists (To-do Entry Exists) Boolean Editable: No
FlowField
40 Close Opportunity Filter (Close Opportunity Filter) Code10 FlowFilter
41 Activated (Activated) Boolean Editable: No
FlowField

Keys

# Fields
0 No. (No.) Clustered: Yes
1 Salesperson Code (Salesperson Code)

Table Relations To Other Tables

Field Related Table Related Field
Status Code (Status Code) Campaign Status Code (Code) 1..n
Close Opportunity Filter (Close Opportunity Filter) Close Opportunity Code Code (Code) 1..n
Contact Company Filter (Contact Company Filter) Contact () 1..n
Global Dimension 2 Code (Global Dimension 2 Code) Dimension Value Code (Code) 1..n
No. Series (No. Series) No. Series Code (Code) 1..n
Sales Cycle Filter (Sales Cycle Filter) Sales Cycle Code (Code) 1..n
Sales Cycle Stage Filter (Sales Cycle Stage Filter) Sales Cycle Stage Stage (Stage) 1..n
Salesperson Filter (Salesperson Filter) Salesperson/Purchaser Code (Code) 1..n
Team Filter (Team Filter) Team Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Campaign Entry Campaign No. (Campaign No.) 1..n
Campaign Target Group Campaign No. (Campaign No.) 1..n
Comment Line No. (No.) 1..n
Contact Campaign Filter (Campaign Filter) 1..n
Default Dimension No. (No.) 1..n
Gen. Journal Line Campaign No. (Campaign No.) 1..n
Interaction Log Entry Campaign No. (Campaign No.) 1..n
Interaction Template Campaign No. (Campaign No.) 1..n
Opportunity Campaign No. (Campaign No.) 1..n
Opportunity Entry Campaign No. (Campaign No.) 1..n
Purch. Cr. Memo Hdr. Campaign No. (Campaign No.) 1..n
Purch. Inv. Header Campaign No. (Campaign No.) 1..n
Purch. Rcpt. Header Campaign No. (Campaign No.) 1..n
Purchase Header Campaign No. (Campaign No.) 1..n
Purchase Header Archive Campaign No. (Campaign No.) 1..n
RM Matrix Management Campaign Filter (Campaign Filter) 1..n
Return Receipt Header Campaign No. (Campaign No.) 1..n
Return Shipment Header Campaign No. (Campaign No.) 1..n
Rlshp. Mgt. Comment Line No. (No.) 1..n
Sales Cr.Memo Header Campaign No. (Campaign No.) 1..n
Sales Header Campaign No. (Campaign No.) 1..n
Sales Header Archive Campaign No. (Campaign No.) 1..n
Sales Invoice Header Campaign No. (Campaign No.) 1..n
Sales Line Discount Sales Code (Sales Code) 1..n
Sales Price Sales Code (Sales Code) 1..n
Sales Price Worksheet Sales Code (Sales Code) 1..n
Sales Shipment Header Campaign No. (Campaign No.) 1..n
Salesperson/Purchaser Campaign Filter (Campaign Filter) 1..n
Segment Header Campaign No. (Campaign No.) 1..n
Segment Line Campaign No. (Campaign No.) 1..n
Standard General Journal Line Campaign No. (Campaign No.) 1..n
Team Campaign Filter (Campaign Filter) 1..n
To-do Campaign No. (Campaign No.) 1..n