Diagrams


Table

Segment Wizard Filter

DynamicsDocs.comSegment Wizard Filter«Table 5096»Segment Wizard FilterSegment No. [PK]Functionality; [Add Contacts,Remove Co...Mailing Group Code FilterIndustry Group Code FilterSalesperson Code FilterCountry/Region Code FilterTerritory Code FilterPost Code FilterBusiness Relation Code FilterProfile Questn. Code FilterProfile Questn. Line FilterJob Responsibility Code FilterProfile Questionnaire CodeAdd Additional CriteriaWizard Step; [,1,2,3,4,5,6]«Table 5076»Segment HeaderNo. [PK]DescriptionCampaign No.Salesperson CodeCorrespondence Type [Default]; [,Hard...Interaction Template CodeUnit Cost [LCY]Unit Duration [Min.]Attachment No.DateCampaign TargetInformation Flow; [,Outbound,Inbound]Initiated By; [,Us,Them]No. SeriesCampaign ResponseNo. of LinesCost [LCY]Duration [Min.]Language Code [Default]Interaction Group CodeNo. of Criteria ActionsSend Word Docs. as Attmt.Ignore Contact Corres. TypeSubject [Default]Campaign Description«Table 5055»Mailing GroupCode [PK,NN]DescriptionNo. of Contacts«Table 5057»Industry GroupCode [PK,NN]DescriptionNo. of Contacts«Table 13»Salesperson/PurchaserCode [PK,NN]NameCommission %ImageGlobal 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......«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 286»TerritoryCode [PK,NN]Name«Table 225»Post CodeCode [PK,NN]City [PK,NN]Search CityCountry/Region CodeCounty«Table 5053»Business RelationCode [PK,NN]DescriptionNo. of Contacts«Table 5087»Profile Questionnaire HeaderCode [PK,NN]DescriptionContact Type; [,Companies,People]Business Relation CodePriority; [Very Low,Low,Normal,High,Ve...«Table 5088»Profile Questionnaire LineProfile Questionnaire Code [PK]Line No. [PK]Type; [Question,Answer]Description [NN]Multiple AnswersAuto Contact ClassificationCustomer Class. Field; [,Sales <LCY>,P...Vendor Class. Field; [,Purchase <LCY>,...Contact Class. Field; [,Interaction Qu...Starting Date FormulaEnding Date FormulaClassification Method; [,Defined Value...Sorting Method; [,Descending,Ascending...From ValueTo ValueNo. of ContactsPriority; [Very Low <Hidden>,Low,Norma...No. of DecimalsMin. % Questions AnsweredWizard Step; [,1,2,3,4,5,6]Interval Option; [Minimum,Maximum,Inte...Answer Option; [HighLow,ABC,Custom]Answer DescriptionWizard From ValueWizard To ValueWizard From Line No.«Table 5066»Job ResponsibilityCode [PK,NN]DescriptionNo. of Contacts<Segment No.><Mailing Group Code Filter><Industry Group Code Filter><Salesperson Code Filter><Country/Region Code Filter><Territory Code Filter><Post Code Filter><Business Relation Code Filter><Profile Questn. Code Filter><Profile Questionnaire Code><Profile Questn. Line Filter><Job Responsibility Code Filter><Salesperson Code><Country/Region Code><Business Relation Code><Profile Questionnaire Code>

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

Fields

# Name Type
1 Segment No. Code20
2 Functionality Option
3 Mailing Group Code Filter Code10 FlowFilter
4 Industry Group Code Filter Code10 FlowFilter
5 Salesperson Code Filter Code10 FlowFilter
6 Country/Region Code Filter Code10 FlowFilter
7 Territory Code Filter Code10 FlowFilter
8 Post Code Filter Code20 FlowFilter
9 Business Relation Code Filter Code10 FlowFilter
10 Profile Questn. Code Filter Code10 FlowFilter
11 Profile Questn. Line Filter Integer FlowFilter
12 Job Responsibility Code Filter Code10 FlowFilter
13 Profile Questionnaire Code Code10
15 Add Additional Criteria Boolean
9501 Wizard Step Option Editable: No

Keys

# Fields
0 Segment No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Business Relation Code Filter Business Relation Code 1..n
Country/Region Code Filter Country/Region Code 1..n
Industry Group Code Filter Industry Group Code 1..n
Job Responsibility Code Filter Job Responsibility Code 1..n
Mailing Group Code Filter Mailing Group Code 1..n
Post Code Filter Post Code Code 1..n
Profile Questionnaire Code Profile Questionnaire Header Code 1..n
Profile Questn. Line Filter Profile Questionnaire Line Line No. 1..n
Salesperson Code Filter Salesperson/Purchaser Code 1..n
Segment No. Segment Header No. 1..1
Territory Code Filter Territory Code 1..n

Table Relations From Other Tables

From Table From Field