Table 5051 "Contact Alt. Address"

Base Application · Microsoft.CRM.Contact · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Contact Alt. Address
DataClassification	CustomerContent
Permissions	TableData Contact = rm, TableData “Contact Alt. Addr. Date Range” = rd

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	Contact No.	Code[20]	—	TableRelation Table 5050 “Contact”
2	Code Δ BC28	Code[10]	Specifies the code for the alternate address.	NotBlank
3	Company Name Δ BC28	Text[100]	Specifies the name of the company for the alternate address.
4	Company Name 2 Δ BC28	Text[50]	Specifies the additional part of the company name for the alternate address.
5	Address Δ BC28	Text[100]	Specifies the alternate address of the contact.
6	Address 2 Δ BC28	Text[50]	Specifies additional address information.
7	City Δ BC28	Text[30]	Specifies the city of the contact’s alternate address.	TableRelation Table 225 “Post Code” (if (“Country/Region Code” = const(‘’)) “Post Code”.City else if (“Country/Region Code” = filter(<> ‘’)) “Post Code”.City where(“Country/Region Code” = field(“Country/Region Code”)))
8	Post Code Δ BC28	Code[20]	Specifies the postal code.	TableRelation Table 225 “Post Code” (if (“Country/Region Code” = const(‘’)) “Post Code” else if (“Country/Region Code” = filter(<> ‘’)) “Post Code” where(“Country/Region Code” = field(“Country/Region Code”)))
9	County Δ BC28	Text[30]	Specifies the county for the contact’s alternate address.
10	Country/Region Code Δ BC28	Code[10]	Specifies the country/region of the address.	TableRelation Table 9 “Country/Region” (Country/Region)
12	Phone No. Δ BC28	Text[30]	Specifies the telephone number for the alternate address.
13	Telex No. Δ BC28	Text[20]	Specifies the telex number for the alternate address.
14	Extension No.	Text[30]	—
15	Mobile Phone No. Δ BC28	Text[30]	Specifies the mobile phone number for the alternate address.
16	Pager Δ BC28	Text[30]	Specifies the pager number for the contact at the alternate address.
17	E-Mail Δ BC28	Text[80]	Specifies the e-mail address for the contact at the alternate address.
18	Home Page Δ BC24 Δ BC27 Δ BC28	Text[255]	Specifies the contact’s web site.
19	Fax No. Δ BC28	Text[30]	Specifies the fax number for the alternate address.
20	Telex Answer Back Δ BC28	Text[20]	Specifies the telex answer back number for the alternate address.
21	Last Date Modified	Date	—
22	Search E-Mail	Code[80]	Search Email caption

Keys

Key1: Contact No., Code (clustered)
Key2: Search E-Mail

Events published

OnAfterLookupPostCode(var ContactAltAddress: Record "Contact Alt. Address"; FieldNo: Integer; var PostCode: Record "Post Code") (integration)
OnBeforeValidateCity(var ContactAltAddress: Record "Contact Alt. Address"; var PostCode: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean) (integration)
OnBeforeValidatePostCode(var ContactAltAddress: Record "Contact Alt. Address"; var PostCode: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean) (integration)

Procedures

2 local procedures, no public ones.

Triggers

OnDelete, OnInsert, OnModify, OnRename

Relations

lookup page Page 5057 “Contact Alt. Address List”
City: TableRelation Table 225 “Post Code” (conditional)
Post Code: TableRelation Table 225 “Post Code” (conditional)
Contact No.: TableRelation Table 5050 “Contact”
Country/Region Code: TableRelation Table 9 “Country/Region”

Referenced by

3 fields in 3 objects relate to this table (TableRelation or CalcFormula).

Table 5052 “Contact Alt. Addr. Date Range”: Contact Alt. Address Code
Table 5065 “Interaction Log Entry”: Contact Alt. Address Code
Table 5077 “Segment Line”: Contact Alt. Address Code

Pages and codeunits on this table

Page 5056 “Contact Alt. Address Card” (source table)
Page 5057 “Contact Alt. Address List” (source table)

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Contact Alt. Address"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.