Table 13 "Salesperson/Purchaser"

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

Learn documents this table through its pages: Page 30075 “APIV2 - Salesperson/Purchaser” (5 Learn pages), Page 14 “Salespersons/Purchasers” (1), Page 5116 “Salesperson/Purchaser Card” (1).

Properties

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.

Keys

• Key1: Code (clustered)
• Key2: Search E-Mail
• Key3: SystemModifiedAt

Events published

• OnAfterValidateShortcutDimCode(var SalespersonPurchaser: Record "Salesperson/Purchaser"; var xSalespersonPurchaser: Record "Salesperson/Purchaser"; FieldNumber: Integer; var ShortcutDimCode: Code[20]) (integration)
• OnBeforeValidateShortcutDimCode(var SalespersonPurchaser: Record "Salesperson/Purchaser"; var xSalespersonPurchaser: Record "Salesperson/Purchaser"; FieldNumber: Integer; var ShortcutDimCode: Code[20]) (integration)

Trigger event subscribers

• OnAfterDeleteEvent: Codeunit 7205 “CDS Int. Table. Subscriber” DeleteCouplingOnAfterDeleteSalesperson

Procedures

• CreateInteraction()
• ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])
• GetPrivacyBlockedTransactionText(SalespersonPurchaser2: Record "Salesperson/Purchaser"; IsPostAction: Boolean; IsSalesperson: Boolean): Text[150]
• GetPrivacyBlockedGenericText(SalespersonPurchaser2: Record "Salesperson/Purchaser"; IsSalesperson: Boolean): Text[150]
• VerifySalesPersonPurchaserPrivacyBlocked(SalespersonPurchaser2: Record "Salesperson/Purchaser"): Boolean

Plus 1 local procedures.

Triggers

OnDelete, OnInsert, OnModify, OnRename

Relations

• lookup page Page 14 “Salespersons/Purchasers”
• Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
• Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
• Contact Company Filter: TableRelation Table 5050 “Contact”
• Contact Filter: TableRelation Table 5050 “Contact”
• Cost (LCY): CalcFormula Table 5065 “Interaction Log Entry”
• Duration (Min.): CalcFormula Table 5065 “Interaction Log Entry”
• No. of Interactions: CalcFormula Table 5065 “Interaction Log Entry”
• Campaign Filter: TableRelation Table 5071 “Campaign”
• Next Task Date: CalcFormula Table 5080 “To-do”
• Task Entry Exists: CalcFormula Table 5080 “To-do”
• Team Filter: TableRelation Table 5083 “Team”
• Sales Cycle Filter: TableRelation Table 5090 “Sales Cycle”
• Sales Cycle Stage Filter: TableRelation Table 5091 “Sales Cycle Stage”
• Avg. Estimated Value (LCY): CalcFormula Table 5093 “Opportunity Entry”
• Avg.Calcd. Current Value (LCY): CalcFormula Table 5093 “Opportunity Entry”
• Calcd. Current Value (LCY): CalcFormula Table 5093 “Opportunity Entry”
• Estimated Value (LCY): CalcFormula Table 5093 “Opportunity Entry”
• No. of Opportunities: CalcFormula Table 5093 “Opportunity Entry”
• Opportunity Entry Exists: CalcFormula Table 5093 “Opportunity Entry”
• Close Opportunity Filter: TableRelation Table 5094 “Close Opportunity Code”
• Coupled to Dataverse: CalcFormula Table 5331 “CRM Integration Record”

Referenced by

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

• Table 5080 “To-do”: Salesperson Name, Completed By, Salesperson Code
• Table 5050 “Contact”: Salesperson Code, Salesperson Filter
• Table 5071 “Campaign”: Salesperson Code, Salesperson Filter
• Table 5084 “Team Salesperson”: Salesperson Name, Salesperson Code
• Table 5092 “Opportunity”: Salesperson Name, Salesperson Code
• Table 110 “Sales Shipment Header”: Salesperson Code
• Table 112 “Sales Invoice Header”: Salesperson Code
• Table 114 “Sales Cr.Memo Header”: Salesperson Code
• Table 120 “Purch. Rcpt. Header”: Purchaser Code
• Table 122 “Purch. Inv. Header”: Purchaser Code
• Table 124 “Purch. Cr. Memo Hdr.”: Purchaser Code
• Table 1381 “Customer Templ.”: Salesperson Code
• Table 1383 “Vendor Templ.”: Purchaser Code
• Table 1572 “Approval Entry Buffer”: Salespers./Purch. Name
• Table 18 “Customer”: Salesperson Code
• Table 181 “Posted Gen. Journal Line”: Salespers./Purch. Code
• Table 21 “Cust. Ledger Entry”: Salesperson Code
• Table 222 “Ship-to Address”: Salesperson Code
• Table 23 “Vendor”: Purchaser Code
• Table 246 “Requisition Line”: Purchaser Code
• Table 25 “Vendor Ledger Entry”: Purchaser Code
• Table 270 “Bank Account”: Our Contact Code
• Table 271 “Bank Account Ledger Entry”: Our Contact Code
• Table 281 “Phys. Inventory Ledger Entry”: Salespers./Purch. Code
• Table 30136 “Shpfy Staff Member”: Salesperson Code
• Table 36 “Sales Header”: Salesperson Code
• Table 38 “Purchase Header”: Purchaser Code
• Table 382 “CV Ledger Entry Buffer”: Salesperson Code
• Table 454 “Approval Entry”: Salespers./Purch. Name
• Table 456 “Posted Approval Entry”: Salespers./Purch. Name
• Table 5065 “Interaction Log Entry”: Salesperson Code
• Table 5072 “Campaign Entry”: Salesperson Code
• Table 5076 “Segment Header”: Salesperson Code
• Table 5077 “Segment Line”: Salesperson Code
• Table 5079 “Marketing Setup”: Default Salesperson Code
• Table 5083 “Team”: Salesperson Filter
• Table 5093 “Opportunity Entry”: Salesperson Code
• Table 5096 “Segment Wizard Filter”: Salesperson Code Filter
• Table 5102 “RM Matrix Management”: Salesperson Filter
• Table 5106 “Interaction Merge Data”: Salesperson Code
• Table 5107 “Sales Header Archive”: Salesperson Code
• Table 5109 “Purchase Header Archive”: Purchaser Code
• Table 5199 “Attendee”: Attendee No.
• Table 5200 “Employee”: Salespers./Purch. Code
• Table 5222 “Employee Ledger Entry”: Salespers./Purch. Code
• Table 5475 “Sales Invoice Entity Aggregate”: Salesperson Code
• Table 5477 “Purch. Inv. Entity Aggregate”: Purchaser Code
• Table 5495 “Sales Order Entity Buffer”: Salesperson Code
• Table 5496 “Purchase Order Entity Buffer”: Purchaser Code
• Table 5505 “Sales Quote Entity Buffer”: Salesperson Code
• and 29 more objects (29 fields): data/code/relations/29.json

Pages and codeunits on this table

• Page 14 “Salespersons/Purchasers” (source table)
• Page 30075 “APIV2 - Salesperson/Purchaser” (source table)
• Page 36958 “Salesperson/Purchasers” (source table)
• Page 5108 “Salesperson/Purchaser Picture” (source table)
• Page 5116 “Salesperson/Purchaser Card” (source table)
• Page 5117 “Salesperson Statistics” (source table)
• Page 8050 “Sales Person API” (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 408 “DimensionManagement” (5 calls: OnDelete → DeleteDefaultDim, OnInsert → UpdateDefaultDim, OnRename → RenameDefaultDim, …)

Deprecations

• field Coupled to CRM: Removed 26.0 (#if not CLEANSCHEMA26), “Replaced by flow field Coupled to Dataverse”

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