Diagrams


Table

Contact Profile Answer

DynamicsDocs.comContact Profile Answer«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 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. SeriesImageType; [Company,Person]Company No.Company NameLookup Contact No.First Name...«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.<Contact No.><Contact Company No.><Profile Questionnaire Code><Line No.><Company No.><Lookup Contact No.><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 Contact No. Code20 NotBlank: Yes
2 Contact Company No. Code20 NotBlank: Yes
3 Profile Questionnaire Code Code10 NotBlank: Yes
4 Line No. Integer
5 Answer Text50 Editable: No
FlowField
6 Contact Company Name Text50 Editable: No
FlowField
7 Contact Name Text50 Editable: No
FlowField
8 Profile Questionnaire Priority Option Editable: No
9 Answer Priority Option
10 Last Date Updated Date
11 Questions Answered (%) Decimal (0:0) BlankZero: Yes

Keys

# Fields
0 Contact No.,Profile Questionnaire Code,Line No. Clustered: Yes
1 Contact No.,Answer Priority,Profile Questionnaire Priority
2 Profile Questionnaire Code,Line No.

Table Relations To Other Tables

Field Related Table Related Field
Contact Company No. Contact 1..n
Profile Questionnaire Code Profile Questionnaire Header Code 1..n
Line No. Profile Questionnaire Line Line No. 1..n

Table Relations From Other Tables

From Table From Field