Table 5209 "Union"

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

Properties

Property	Value
Caption	Union
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	Code Δ BC28	Code[10]	Specifies a union code.	NotBlank
2	Name Δ BC28	Text[100]	Specifies the name of the union.
3	Address Δ BC28	Text[100]	Specifies the union’s address.
4	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”)))
5	City Δ BC28	Text[30]	Specifies the city of the 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”)))
6	Phone No. Δ BC28	Text[30]	Specifies the union’s telephone number.
7	No. of Members Employed Δ BC28	Integer	Specifies the number of members employed.	FlowField: count(Employee where(Status = filter(<> Terminated), “Union Code” = field(Code))); not editable
8	Name 2	Text[50]	—
9	Address 2	Text[50]	—
10	County	Text[30]	—
11	Fax No.	Text[30]	—
12	E-Mail	Text[80]	Email caption
13	Home Page Δ BC24 Δ BC27	Text[255]	—
14	Country/Region Code	Code[10]	—	TableRelation Table 9 “Country/Region” (Country/Region)

Keys

Key1: Code (clustered)

Events published

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

Relations

drill-down page Page 5213 “Unions”
lookup page Page 5213 “Unions”
City: TableRelation Table 225 “Post Code” (conditional)
Post Code: TableRelation Table 225 “Post Code” (conditional)
No. of Members Employed: CalcFormula Table 5200 “Employee”
Country/Region Code: TableRelation Table 9 “Country/Region”

Referenced by

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

Table 5200 “Employee”: Union Code

Pages and codeunits on this table

Page 5213 “Unions” (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: "Union"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Across versions

Neighbourhood 5 connected objects and pages