Table 5054 "Contact Business Relation"
Base Application · Microsoft.CRM.BusinessRelation
Across versions
- BC23present
- BC242 fields changed
- BC25unchanged
- BC261 events added
- BC27unchanged
- BC286 fields changed
- BC29-30unchanged
Neighbourhood 22 connected objects and pages
Base Application · Microsoft.CRM.BusinessRelation · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Contact Business Relation |
| 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 | Contact No. Δ BC28 | Code[20] | Specifies the contact number of the company you are assigning a business relation. | TableRelation Table 5050 “Contact” (Contact where(Type = const(Company))); NotBlank |
| 2 | Business Relation Code Δ BC28 | Code[10] | Specifies the business relation code. | TableRelation Table 5053 “Business Relation” (Business Relation); NotBlank |
| 3 | Link to Table Δ BC28 | Enum “Contact Business Relation Link To Table” | Specifies the name of the table to which the contact is linked. There are four possible options: <blank>, Vendor, Customer, and Bank Account. | enum Enum 5057 “Contact Business Relation Link To Table” |
| 4 | No. Δ BC28 | Code[20] | Specifies the number assigned to the contact in the Customer, Vendor, or Bank Account table. This field is only valid for contacts recorded as customer, vendor or bank accounts. | TableRelation Table 18 “Customer”, Table 23 “Vendor”, Table 270 “Bank Account” (if (“Link to Table” = const(Customer)) Customer else if (“Link to Table” = const(Vendor)) Vendor else if (“Link to Table” = const(“Bank Account”)) “Bank Account” else if (“Link to Table” = const(Employee)) Employee) |
| 5 | Business Relation Description Δ BC24 Δ BC28 | Text[100] | Specifies the description for the business relation you have assigned to the contact. This field is not editable. | FlowField: lookup(“Business Relation”.Description where(Code = field(“Business Relation Code”))); not editable |
| 6 | Contact Name Δ BC24 Δ BC28 | Text[100] | Specifies the name of the contact. | FlowField: lookup(Contact.Name where(“No.” = field(“Contact No.”))); not editable |
Keys
- Key1: Contact No., Business Relation Code (clustered)
- Key2: Link to Table, No.
- Key3: Link to Table, Contact No.
- Key4: Business Relation Code
Events published
OnFindOrRestoreContactBusinessRelationCaseElse(RecVar: Variant)(integration)OnGetBusinessRelationCodeFromSetupCaseElse(LinkToTable: Enum "Contact Business Relation Link To Table"; var Result: Code[10])(integration)OnGetContactBusinessRelation(var ContactBusinessRelation: Record "Contact Business Relation"; var RecordRead: Boolean)(integration)OnGetNameCaseElse(ContactBusinessRelation: Record "Contact Business Relation"; var Name: Text)(integration)OnShowRelatedCardPageCaseElse(ContactBusinessRelation: Record "Contact Business Relation")(integration)OnInsertOnBeforeFindByRelation(ContactBusinessRelation: Record "Contact Business Relation"; var IsHandled: Boolean)(integration)OnInsertOnBeforeFindByContact(ContactBusinessRelation: Record "Contact Business Relation"; var IsHandled: Boolean)(integration)OnBeforeUpdateContactBusinessRelation(ContactBusinessRelation: Record "Contact Business Relation"; var IsHandled: Boolean)+ BC26 (integration)
Trigger event subscribers
- OnAfterDeleteEvent: Codeunit 5055 “CustVendBank-Update” OnAfterDeleteContBusRelation
- OnAfterInsertEvent: Codeunit 5055 “CustVendBank-Update” OnAfterInsertContBusRelation
- OnAfterModifyEvent: Codeunit 5055 “CustVendBank-Update” OnAfterModifyContBusRelation
- OnAfterRenameEvent: Codeunit 5055 “CustVendBank-Update” OnAfterRenameContBusRelation
Procedures
GetLinkedTables(FromLinkToTable: Enum "Contact Business Relation Link To Table"; FromNo: Code[20]; ToLinkToTable: Enum "Contact Business Relation Link To Table"): Code[20]FindByContact(LinkType: Enum "Contact Business Relation Link To Table"; ContactNo: Code[20]): BooleanFindByRelation(LinkType: Enum "Contact Business Relation Link To Table"; LinkNo: Code[20]): BooleanGetContactNo(LinkType: Enum "Contact Business Relation Link To Table"; LinkNo: Code[20]): Code[20]CreateRelation(ContactNo: Code[20]; LinkNo: Code[20]; LinkToTable: Enum "Contact Business Relation Link To Table")FindOrRestoreContactBusinessRelation(var Cont: Record Contact; RecVar: Variant; LinkToTable: Enum "Contact Business Relation Link To Table")UpdateEmptyNoForContact(EntityNo: Code[20]; PrimaryContactNo: Code[20]; LinkToTableOption: Enum "Contact Business Relation Link To Table"): BooleanFindContactsByRelation(var Contact: Record Contact; LinkType: Enum "Contact Business Relation Link To Table"; LinkNo: Code[20]): BooleanGetName(): TextShowRelatedCardPage()UpdateContactBusinessRelation()GetBusinessRelatedSystemIds(TableId: Integer; SystemId: Guid; var RelatedSystemIds: Dictionary of [Integer, List of [Guid]])(internal)
Plus 2 local procedures.
Triggers
OnInsert
Relations
- drill-down page Page 5061 “Contact Business Relations”
- No.: TableRelation Table 18 “Customer” (conditional)
- No.: TableRelation Table 23 “Vendor” (conditional)
- No.: TableRelation Table 270 “Bank Account” (conditional)
- Contact Name: CalcFormula Table 5050 “Contact”
- Contact No.: TableRelation Table 5050 “Contact”
- Business Relation Description: CalcFormula Table 5053 “Business Relation”
- Business Relation Code: TableRelation Table 5053 “Business Relation”
- No.: TableRelation Table 5200 “Employee” (conditional)
Referenced by
2 fields in 2 objects relate to this table (TableRelation or CalcFormula).
- Table 5050 “Contact”: No. of Business Relations
- Table 5053 “Business Relation”: No. of Contacts
Pages and codeunits on this table
- Page 1348 “Employee Link” (source table)
- Page 5061 “Contact Business Relations” (source table)
- Page 5062 “Business Relation Contacts” (source table)
- Page 5135 “Customer Link” (source table)
- Page 5136 “Vendor Link” (source table)
- Page 5137 “Bank Account Link” (source table)
Calls
From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.
- Codeunit 5056 “CustCont-Update” (1 call:
FindOrRestoreContactBusinessRelation → OnInsert) - Codeunit 5057 “VendCont-Update” (1 call:
FindOrRestoreContactBusinessRelation → OnInsert) - Page 21 “Customer Card” (1 call:
ShowRelatedCardPage → (object)) - Page 26 “Vendor Card” (1 call:
ShowRelatedCardPage → (object)) - Page 370 “Bank Account Card” (1 call:
ShowRelatedCardPage → (object)) - Page 5061 “Contact Business Relations” (1 call:
ShowRelatedCardPage → (object)) - Page 5200 “Employee Card” (1 call:
ShowRelatedCardPage → (object))
Ask your agent
Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. 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 Business Relation"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.