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 [%]Profile Questionnaire Value«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. (Contact No.) Code20 NotBlank: Yes
2 Contact Company No. (Contact Company No.) Code20 NotBlank: Yes
3 Profile Questionnaire Code (Profile Questionnaire Code) Code20 NotBlank: Yes
4 Line No. (Line No.) Integer
5 Answer (Answer) Text50 Editable: No
FlowField
6 Contact Company Name (Contact Company Name) Text50 Editable: No
FlowField
7 Contact Name (Contact Name) Text50 Editable: No
FlowField
8 Profile Questionnaire Priority (Profile Questionnaire Priority) Option Editable: No
9 Answer Priority (Answer Priority) Option
10 Last Date Updated (Last Date Updated) Date
11 Questions Answered (%) (Questions Answered (%)) Decimal (0:0) BlankZero: Yes
5088 Profile Questionnaire Value (Profile Questionnaire Value) Text250

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field