---
title: "Table 13 Salesperson/Purchaser"
author: "Jonas Paprotka"
url: https://jonas-paprotka.de/ref/table/13-salesperson-purchaser/
type: table
id: 13
name: "Salesperson/Purchaser"
app: "Base Application"
namespace: Microsoft.CRM.Team
versions: "17-28"
build: 28.5.54151.54365
source: "https://jonas-paprotka.de/ref/table/13-salesperson-purchaser/source/29/"
checked: 2026-09-20
subject: "Microsoft Dynamics 365 Business Central"
license: "Content © 2026 Jonas Paprotka. Quote freely with attribution and a link."
---

# Table 13 Salesperson/Purchaser

Jonas Paprotka, https://jonas-paprotka.de/ref/table/13-salesperson-purchaser/

| | |
| --- | --- |
| App | Base Application |
| Namespace | Microsoft.CRM.Team |
| Versions | 17-28 |
| Source file | CRM/Team/SalespersonPurchaser.Table.al |

## Fields

| Id | Name | Type | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| 1 | Code | Code[20] | 17-28 | - | - |
| 2 | Name | Text[50] | 17-28 | - | - |
| 3 | Commission % | Decimal | 17-28 | - | - |
| 140 | Image | Media | 17-28 | - | - |
| 150 | Privacy Blocked | Boolean | 17-28 | - | - |
| 720 | Coupled to CRM | Boolean | 19-28 | Removed 26.0 | Replaced by flow field Coupled to Dataverse |
| 721 | Coupled to Dataverse | Boolean | 22-28 | - | - |
| 5050 | Global Dimension 1 Code | Code[20] | 17-28 | - | - |
| 5051 | Global Dimension 2 Code | Code[20] | 17-28 | - | - |
| 5052 | E-Mail | Text[80] | 17-28 | - | - |
| 5053 | Phone No. | Text[30] | 17-28 | - | - |
| 5054 | Next Task Date | Date | 17-28 | - | - |
| 5055 | No. of Opportunities | Integer | 17-28 | - | - |
| 5056 | Estimated Value (LCY) | Decimal | 17-28 | - | - |
| 5057 | Calcd. Current Value (LCY) | Decimal | 17-28 | - | - |
| 5058 | Date Filter | Date | 17-28 | - | - |
| 5059 | No. of Interactions | Integer | 17-28 | - | - |
| 5060 | Cost (LCY) | Decimal | 17-28 | - | - |
| 5061 | Duration (Min.) | Decimal | 17-28 | - | - |
| 5062 | Job Title | Text[30] | 17-28 | - | - |
| 5063 | Action Taken Filter | Enum Opportunity Action Taken | 17-28 | - | - |
| 5064 | Sales Cycle Filter | Code[10] | 17-28 | - | - |
| 5065 | Sales Cycle Stage Filter | Integer | 17-28 | - | - |
| 5066 | Probability % Filter | Decimal | 17-28 | - | - |
| 5067 | Completed % Filter | Decimal | 17-28 | - | - |
| 5068 | Avg. Estimated Value (LCY) | Decimal | 17-28 | - | - |
| 5069 | Avg.Calcd. Current Value (LCY) | Decimal | 17-28 | - | - |
| 5070 | Contact Filter | Code[20] | 17-28 | - | - |
| 5071 | Contact Company Filter | Code[20] | 17-28 | - | - |
| 5072 | Campaign Filter | Code[20] | 17-28 | - | - |
| 5073 | Estimated Value Filter | Decimal | 17-28 | - | - |
| 5074 | Calcd. Current Value Filter | Decimal | 17-28 | - | - |
| 5075 | Chances of Success % Filter | Decimal | 17-28 | - | - |
| 5076 | Task Status Filter | Enum Task Status | 17-28 | - | - |
| 5077 | Closed Task Filter | Boolean | 17-28 | - | - |
| 5078 | Priority Filter | Option | 17-28 | - | - |
| 5079 | Team Filter | Code[10] | 17-28 | - | - |
| 5082 | Opportunity Entry Exists | Boolean | 17-28 | - | - |
| 5083 | Task Entry Exists | Boolean | 17-28 | - | - |
| 5084 | Close Opportunity Filter | Code[10] | 17-28 | - | - |
| 5085 | Search E-Mail | Code[80] | 17-28 | - | - |
| 5086 | E-Mail 2 | Text[80] | 17-28 | - | - |
| 5087 | Blocked | Boolean | 21-28 | - | - |

## Keys

| Name | Fields | Versions |
| --- | --- | --- |
| Key1, clustered | Code | 17-28 |
| Key2 | Search E-Mail | 17-28 |
| Key3 | SystemModifiedAt | 17-28 |
| Key4 | Coupled to CRM | 19-25 |

## Procedures

| Name | Parameters | Returns | Access | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- | --- |
| CreateInteraction | () | - | public | 17-28 | - | - |
| ValidateShortcutDimCode | (Integer, var Code[20]) | - | public | 17-28 | - | - |
| GetPrivacyBlockedTransactionText | (Record Salesperson/Purchaser, Boolean, Boolean) | Text[150] | public | 17-28 | - | - |
| GetPrivacyBlockedGenericText | (Record Salesperson/Purchaser, Boolean) | Text[150] | public | 17-28 | - | - |
| VerifySalesPersonPurchaserPrivacyBlocked | (Record Salesperson/Purchaser) | Boolean | public | 17-28 | - | - |

## Events

| Kind | Name | Parameters | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| Integration event | OnAfterValidateShortcutDimCode | (var Record Salesperson/Purchaser, var Record Salesperson/Purchaser, Integer, var Code[20]) | 17-28 | - | - |
| Integration event | OnBeforeValidateShortcutDimCode | (var Record Salesperson/Purchaser, var Record Salesperson/Purchaser, Integer, var Code[20]) | 17-28 | - | - |

## Source

Symbols: Microsoft.BaseApplication.symbols.437dbf0e-84ff-417a-965d-ed2bb9650972, https://dynamicssmb2.pkgs.visualstudio.com/DynamicsBCPublicFeeds/_packaging/MSSymbols/nuget/v3/index.json, highest build per major on 2026-09-20.
AL source 29: https://github.com/microsoft/BCApps, MIT, releases/29.x at a66254c3b8b5bb1cea290dc8f9d097aec4381153.

Jonas Paprotka, 2026-09-20.