Table 5201 "Alternative Address"

Base Application · Microsoft.HumanResources.Employee · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 5204 “Alternative Address List” (3 Learn pages).

Properties

Property	Value
Caption	Alternative Address
DataClassification	CustomerContent

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	Employee No.	Code[20]	—	TableRelation Table 5200 “Employee”; NotBlank
2	Code Δ BC28	Code[10]	Specifies a code for the employee’s alternate address.	NotBlank
3	Name Δ BC28	Text[100]	Specifies the employee’s last name.
4	Name 2 Δ BC28	Text[50]	Specifies the employee’s first name, or an alternate name.
5	Address Δ BC28	Text[100]	Specifies an alternate address for the employee.
6	Address 2 Δ BC28	Text[50]	Specifies additional address information.
7	City Δ BC28	Text[30]	Specifies the city of the 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 of the employee’s alternate address.
10	Phone No. Δ BC28	Text[30]	Specifies the employee’s telephone number at the alternate address.
11	Fax No. Δ BC28	Text[30]	Specifies the employee’s fax number at the alternate address.
12	E-Mail Δ BC28	Text[80]	Specifies the employee’s alternate email address.
13	Comment Δ BC28	Boolean	Specifies if a comment was entered for this entry.	FlowField: exist(“Human Resource Comment Line” where(“Table Name” = const(“Alternative Address”), “No.” = field(“Employee No.”), “Alternative Address Code” = field(Code))); not editable
14	Country/Region Code Δ BC28	Code[10]	Specifies the country/region of the address.	TableRelation Table 9 “Country/Region” (Country/Region)

Keys

Key1: Employee No., Code (clustered)

Events published

OnBeforeValidateCity(var AlternativeAddress: Record "Alternative Address"; var PostCode: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean) (integration)
OnBeforeValidatePostCode(var AlternativeAddress: Record "Alternative Address"; var PostCode: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean) (integration)

Relations

drill-down page Page 5204 “Alternative Address List”
lookup page Page 5204 “Alternative Address List”
City: TableRelation Table 225 “Post Code” (conditional)
Post Code: TableRelation Table 225 “Post Code” (conditional)
Employee No.: TableRelation Table 5200 “Employee”
Comment: CalcFormula Table 5208 “Human Resource Comment Line”
Country/Region Code: TableRelation Table 9 “Country/Region”

Referenced by

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

Table 5208 “Human Resource Comment Line”: Alternative Address Code, No.
Table 5200 “Employee”: Alt. Address Code

Pages and codeunits on this table

Page 5203 “Alternative Address Card” (source table)
Page 5204 “Alternative 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: "Alternative Address"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.