Table 12159 "Company Officials" (IT)

IT country layer · Microsoft.Foundation.Company · BC29-30 · source at ea08af5e · facts from BC29

An object of the IT localization, not part of W1.

Properties

Property	Value
Caption	Company Officials
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	No.	Code[20]	—
2	First Name	Text[30]	—
3	Middle Name	Text[30]	—
4	Last Name	Text[30]	—
5	Initials	Text[30]	—
6	Job Title	Text[30]	—
7	Search Name	Code[30]	—
8	Address	Text[100]	—
9	Address 2	Text[50]	—
10	City	Text[30]	—	TableRelation 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”))
11	Post Code	Code[20]	—	TableRelation if (“Country/Region Code” = const(‘’)) “Post Code”.Code else if (“Country/Region Code” = filter(<> ‘’)) “Post Code”.Code where(“Country/Region Code” = field(“Country/Region Code”))
12	County	Text[30]	—
13	Phone No.	Text[30]	—
14	Mobile Phone No.	Text[30]	—
15	E-Mail	Text[80]	—
19	Picture	BLOB	—	obsolete Removed 28.0; #if not CLEANSCHEMA28
25	Country/Region Code	Code[10]	—	TableRelation Country/Region
40	Last Date Modified	Date	—	not editable
46	Extension	Text[30]	—
48	Pager	Text[30]	—
49	Fax No.	Text[30]	—
53	No. Series	Code[20]	—	TableRelation No. Series; not editable
55	Employee No.	Code[20]	—	TableRelation Employee
56	Area	Code[10]	—	TableRelation Area
57	Fiscal Code	Code[20]	—
58	Appointment Code	Code[2]	—	TableRelation Appointment Code
60	Date of Birth	Date	—
61	Birth City	Text[30]	—
62	Birth Post Code	Code[20]	—	TableRelation if (“Birth Country/Region Code” = const(‘’)) “Post Code” else if (“Birth Country/Region Code” = filter(<> ‘’)) “Post Code” where(“Country/Region Code” = field(“Birth Country/Region Code”))
63	Birth County	Text[30]	—
64	Birth Country/Region Code	Code[10]	—	TableRelation Country/Region
65	Gender	Option	—	OptionCaption: ,Male,Female

Keys

Key1: No. (clustered)
Key2: Search Name
Key3: Last Name, First Name, Middle Name

Procedures

AssistEdit(CompanyOfficials2: Record "Company Officials"): Boolean
FullName(): Text[100]

Triggers

OnInsert, OnModify, OnRename

Deprecations

field Picture: Removed 28.0 (#if not CLEANSCHEMA28), “If you need a picture field, consider adding your own image field of type Media and use an upgrade codeunit to transfer the value.”

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

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: "Company Officials"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

A IT country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.