Diagrams


Table

Contact Alt. Address

DynamicsDocs.comContact Alt. Address«Table 5051»Contact Alt. AddressContact No. [PK]Code [PK,NN]Company NameCompany Name 2AddressAddress 2CityPost CodeCountyCountry/Region CodePhone No.Telex No.Extension No.Mobile Phone No.PagerE-MailHome PageFax No.Telex Answer BackLast Date ModifiedSearch E-Mail«Table 5052»Contact Alt. Addr. Date RangeContact No. [PK]Contact Alt. Address CodeStarting Date [PK,NN]Ending Date«Table 5065»Interaction Log EntryEntry No. [PK]Contact No.Contact Company No.DateDescriptionInformation Flow; [,Outbound,Inbound]Initiated By; [,Us,Them]Attachment No.Cost [LCY]Duration [Min.]User IDInteraction Group CodeInteraction Template CodeCampaign No.Campaign Entry No.Campaign ResponseCampaign TargetSegment No.Evaluation; [,Very Positive,Positive,N...Time of InteractionAttempt FailedTo-do No.Salesperson CodeDelivery Status; [,In Progress,Error]CanceledCorrespondence Type; [,Hard Copy,Email...Contact Alt. Address CodeLogged Segment Entry No.Document Type; [,Sales Qte.,Sales Blnk...Document No.Version No....«Table 5077»Segment LineSegment No. [PK]Line No. [PK]Contact No.Campaign No.Salesperson CodeCorrespondence Type; [,Hard Copy,Email...Interaction Template CodeCost [LCY]Duration [Min.]Attachment No.Campaign ResponseContact NameInformation Flow; [,Outbound,Inbound]Initiated By; [,Us,Them]Contact Alt. Address CodeEvaluation; [,Very Positive,Positive,N...Campaign TargetContact Company NameLanguage CodeDescriptionDateTime of InteractionAttempt FailedTo-do No.Contact Company No.Campaign Entry No.Interaction Group CodeDocument Type; [,Sales Qte.,Sales Blnk...Document No.Send Word Doc. As Attmt.Contact Via...«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 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<Contact No.><Country/Region Code><Contact Alt. Address Code><Contact Alt. Address Code><Contact Alt. Address Code><Contact No.><Contact No.><Contact Company No.><Contact No.><Contact Company No.><Country/Region Code><Company No.><Lookup Contact No.>

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
2 Code Code10 NotBlank: Yes
3 Company Name Text50
4 Company Name 2 Text50
5 Address Text50
6 Address 2 Text50
7 City Text30
8 Post Code Code20
9 County Text30
10 Country/Region Code Code10
12 Phone No. Text30 [Phone No.]
13 Telex No. Text20
14 Extension No. Text30
15 Mobile Phone No. Text30 [Phone No.]
16 Pager Text30
17 E-Mail Text80 [E-Mail]
18 Home Page Text80 [URL]
19 Fax No. Text30
20 Telex Answer Back Text20
21 Last Date Modified Date
22 Search E-Mail Code80

Keys

# Fields
0 Contact No.,Code Clustered: Yes
1 Search E-Mail

Table Relations To Other Tables

Field Related Table Related Field
Contact No. Contact No. 1..n
Country/Region Code Country/Region Code 1..n

Table Relations From Other Tables

From Table From Field
Contact Alt. Addr. Date Range Contact Alt. Address Code 1..n
Interaction Log Entry Contact Alt. Address Code 1..n
Segment Line Contact Alt. Address Code 1..n