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 Scheme<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


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


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

Table Relations To Other Tables

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

Table Relations From Other Tables

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