---
title: "Table 23 Vendor"
author: "Jonas Paprotka"
url: https://jonas-paprotka.de/ref/table/23-vendor/
type: table
id: 23
name: "Vendor"
app: "Base Application"
namespace: Microsoft.Purchases.Vendor
versions: "17-28"
build: 28.5.54151.54365
source: "https://jonas-paprotka.de/ref/table/23-vendor/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 23 Vendor

Jonas Paprotka, https://jonas-paprotka.de/ref/table/23-vendor/

| | |
| --- | --- |
| App | Base Application |
| Namespace | Microsoft.Purchases.Vendor |
| Versions | 17-28 |
| Source file | Purchases/Vendor/Vendor.Table.al |

## Fields

| Id | Name | Type | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| 1 | No. | Code[20] | 17-28 | - | - |
| 2 | Name | Text[100] | 17-28 | - | - |
| 3 | Search Name | Code[100] | 17-28 | - | - |
| 4 | Name 2 | Text[50] | 17-28 | - | - |
| 5 | Address | Text[100] | 17-28 | - | - |
| 6 | Address 2 | Text[50] | 17-28 | - | - |
| 7 | City | Text[30] | 17-28 | - | - |
| 8 | Contact | Text[100] | 17-28 | - | - |
| 9 | Phone No. | Text[30] | 17-28 | - | - |
| 10 | Telex No. | Text[20] | 17-28 | - | - |
| 14 | Our Account No. | Text[20] | 17-28 | - | - |
| 15 | Territory Code | Code[10] | 17-28 | - | - |
| 16 | Global Dimension 1 Code | Code[20] | 17-28 | - | - |
| 17 | Global Dimension 2 Code | Code[20] | 17-28 | - | - |
| 19 | Budgeted Amount | Decimal | 17-28 | - | - |
| 21 | Vendor Posting Group | Code[20] | 17-28 | - | - |
| 22 | Currency Code | Code[10] | 17-28 | - | - |
| 24 | Language Code | Code[10] | 17-28 | - | - |
| 25 | Registration Number | Text[50] | 21-28 | - | - |
| 26 | Statistics Group | Integer | 17-28 | - | - |
| 27 | Payment Terms Code | Code[10] | 17-28 | - | - |
| 28 | Fin. Charge Terms Code | Code[10] | 17-28 | - | - |
| 29 | Purchaser Code | Code[20] | 17-28 | - | - |
| 30 | Shipment Method Code | Code[10] | 17-28 | - | - |
| 31 | Shipping Agent Code | Code[10] | 17-28 | - | - |
| 33 | Invoice Disc. Code | Code[20] | 17-28 | - | - |
| 35 | Country/Region Code | Code[10] | 17-28 | - | - |
| 38 | Comment | Boolean | 17-28 | - | - |
| 39 | Blocked | Enum Vendor Blocked | 17-28 | - | - |
| 45 | Pay-to Vendor No. | Code[20] | 17-28 | - | - |
| 46 | Priority | Integer | 17-28 | - | - |
| 47 | Payment Method Code | Code[10] | 17-28 | - | - |
| 48 | Format Region | Text[80] | 23-28 | - | - |
| 52 | First Transaction Date | Date | 27-28 | - | - |
| 53 | Last Modified Date Time | DateTime | 17-28 | - | - |
| 54 | Last Date Modified | Date | 17-28 | - | - |
| 55 | Date Filter | Date | 17-28 | - | - |
| 56 | Global Dimension 1 Filter | Code[20] | 17-28 | - | - |
| 57 | Global Dimension 2 Filter | Code[20] | 17-28 | - | - |
| 58 | Balance | Decimal | 17-28 | - | - |
| 59 | Balance (LCY) | Decimal | 17-28 | - | - |
| 60 | Net Change | Decimal | 17-28 | - | - |
| 61 | Net Change (LCY) | Decimal | 17-28 | - | - |
| 62 | Purchases (LCY) | Decimal | 17-28 | - | - |
| 64 | Inv. Discounts (LCY) | Decimal | 17-28 | - | - |
| 65 | Pmt. Discounts (LCY) | Decimal | 17-28 | - | - |
| 66 | Balance Due | Decimal | 17-28 | - | - |
| 67 | Balance Due (LCY) | Decimal | 17-28 | - | - |
| 69 | Payments | Decimal | 17-28 | - | - |
| 70 | Invoice Amounts | Decimal | 17-28 | - | - |
| 71 | Cr. Memo Amounts | Decimal | 17-28 | - | - |
| 72 | Finance Charge Memo Amounts | Decimal | 17-28 | - | - |
| 74 | Payments (LCY) | Decimal | 17-28 | - | - |
| 75 | Inv. Amounts (LCY) | Decimal | 17-28 | - | - |
| 76 | Cr. Memo Amounts (LCY) | Decimal | 17-28 | - | - |
| 77 | Fin. Charge Memo Amounts (LCY) | Decimal | 17-28 | - | - |
| 78 | Outstanding Orders | Decimal | 17-28 | - | - |
| 79 | Amt. Rcd. Not Invoiced | Decimal | 17-28 | - | - |
| 80 | Application Method | Enum Application Method | 17-28 | - | - |
| 82 | Prices Including VAT | Boolean | 17-28 | - | - |
| 84 | Fax No. | Text[30] | 17-28 | - | - |
| 85 | Telex Answer Back | Text[20] | 17-28 | - | - |
| 86 | VAT Registration No. | Text[20] | 17-28 | - | - |
| 88 | Gen. Bus. Posting Group | Code[20] | 17-28 | - | - |
| 89 | Picture | Blob | 17-25 | Removed 18.0 | Replaced by Image field |
| 90 | GLN | Code[13] | 17-28 | - | - |
| 91 | Post Code | Code[20] | 17-28 | - | - |
| 92 | County | Text[30] | 17-28 | - | - |
| 93 | EORI Number | Text[40] | 17-28 | - | - |
| 97 | Debit Amount | Decimal | 17-28 | - | - |
| 98 | Credit Amount | Decimal | 17-28 | - | - |
| 99 | Debit Amount (LCY) | Decimal | 17-28 | - | - |
| 100 | Credit Amount (LCY) | Decimal | 17-28 | - | - |
| 102 | E-Mail | Text[80] | 17-28 | - | - |
| 103 | Home Page | Text[255] | 17-28 | - | - |
| 104 | Reminder Amounts | Decimal | 17-28 | - | - |
| 105 | Reminder Amounts (LCY) | Decimal | 17-28 | - | - |
| 107 | No. Series | Code[20] | 17-28 | - | - |
| 108 | Tax Area Code | Code[20] | 17-28 | - | - |
| 109 | Tax Liable | Boolean | 17-28 | - | - |
| 110 | VAT Bus. Posting Group | Code[20] | 17-28 | - | - |
| 111 | Currency Filter | Code[10] | 17-28 | - | - |
| 113 | Outstanding Orders (LCY) | Decimal | 17-28 | - | - |
| 114 | Amt. Rcd. Not Invoiced (LCY) | Decimal | 17-28 | - | - |
| 116 | Block Payment Tolerance | Boolean | 17-28 | - | - |
| 117 | Pmt. Disc. Tolerance (LCY) | Decimal | 17-28 | - | - |
| 118 | Pmt. Tolerance (LCY) | Decimal | 17-28 | - | - |
| 119 | IC Partner Code | Code[20] | 17-28 | - | - |
| 120 | Refunds | Decimal | 17-28 | - | - |
| 121 | Refunds (LCY) | Decimal | 17-28 | - | - |
| 122 | Other Amounts | Decimal | 17-28 | - | - |
| 123 | Other Amounts (LCY) | Decimal | 17-28 | - | - |
| 124 | Prepayment % | Decimal | 17-28 | - | - |
| 125 | Outstanding Invoices | Decimal | 17-28 | - | - |
| 126 | Outstanding Invoices (LCY) | Decimal | 17-28 | - | - |
| 130 | Pay-to No. Of Archived Doc. | Integer | 17-28 | - | - |
| 131 | Buy-from No. Of Archived Doc. | Integer | 17-28 | - | - |
| 132 | Partner Type | Enum Partner Type | 17-28 | - | - |
| 133 | Intrastat Partner Type | Enum Partner Type | 20-28 | - | - |
| 134 | Exclude from Pmt. Practices | Boolean | 22-28 | - | - |
| 135 | Company Size Code | Code[20] | 22-28 | - | - |
| 140 | Image | Media | 17-28 | - | - |
| 150 | Privacy Blocked | Boolean | 17-28 | - | - |
| 160 | Disable Search by Name | Boolean | 17-28 | - | - |
| 170 | Creditor No. | Code[20] | 17-28 | - | - |
| 175 | Allow Multiple Posting Groups | Boolean | 22-28 | - | - |
| 180 | Self-Billing Agreement | Boolean | 28 | - | - |
| 288 | Preferred Bank Account Code | Code[20] | 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 | - | - |
| 840 | Cash Flow Payment Terms Code | Code[10] | 17-28 | - | - |
| 5049 | Primary Contact No. | Code[20] | 17-28 | - | - |
| 5061 | Mobile Phone No. | Text[30] | 17-28 | - | - |
| 5700 | Responsibility Center | Code[10] | 17-28 | - | - |
| 5701 | Location Code | Code[10] | 17-28 | - | - |
| 5790 | Lead Time Calculation | DateFormula | 17-28 | - | - |
| 7000 | Price Calculation Method | Enum Price Calculation Method | 17-28 | - | - |
| 7177 | No. of Pstd. Receipts | Integer | 17-28 | - | - |
| 7178 | No. of Pstd. Invoices | Integer | 17-28 | - | - |
| 7179 | No. of Pstd. Return Shipments | Integer | 17-28 | - | - |
| 7180 | No. of Pstd. Credit Memos | Integer | 17-28 | - | - |
| 7181 | Pay-to No. of Orders | Integer | 17-28 | - | - |
| 7182 | Pay-to No. of Invoices | Integer | 17-28 | - | - |
| 7183 | Pay-to No. of Return Orders | Integer | 17-28 | - | - |
| 7184 | Pay-to No. of Credit Memos | Integer | 17-28 | - | - |
| 7185 | Pay-to No. of Pstd. Receipts | Integer | 17-28 | - | - |
| 7186 | Pay-to No. of Pstd. Invoices | Integer | 17-28 | - | - |
| 7187 | Pay-to No. of Pstd. Return S. | Integer | 17-28 | - | - |
| 7188 | Pay-to No. of Pstd. Cr. Memos | Integer | 17-28 | - | - |
| 7189 | No. of Quotes | Integer | 17-28 | - | - |
| 7190 | No. of Blanket Orders | Integer | 17-28 | - | - |
| 7191 | No. of Orders | Integer | 17-28 | - | - |
| 7192 | No. of Invoices | Integer | 17-28 | - | - |
| 7193 | No. of Return Orders | Integer | 17-28 | - | - |
| 7194 | No. of Credit Memos | Integer | 17-28 | - | - |
| 7195 | No. of Order Addresses | Integer | 17-28 | - | - |
| 7196 | Pay-to No. of Quotes | Integer | 17-28 | - | - |
| 7197 | Pay-to No. of Blanket Orders | Integer | 17-28 | - | - |
| 7198 | No. of Incoming Documents | Integer | 17-28 | - | - |
| 7600 | Base Calendar Code | Code[10] | 17-28 | - | - |
| 7601 | Document Sending Profile | Code[20] | 17-28 | - | - |
| 7602 | Validate EU Vat Reg. No. | Boolean | 17-28 | - | - |
| 7603 | Copy Buy-from Add. to Qte From | Enum Contact Type | 28 | - | - |
| 8000 | Id | Guid | 17-25 | Removed 22.0 | This functionality will be replaced by the systemID field |
| 8001 | Currency Id | Guid | 17-28 | - | - |
| 8002 | Payment Terms Id | Guid | 17-28 | - | - |
| 8003 | Payment Method Id | Guid | 17-28 | - | - |
| 8510 | Over-Receipt Code | Code[20] | 17-28 | - | - |

## Keys

| Name | Fields | Versions |
| --- | --- | --- |
| Key1, clustered | No. | 17-28 |
| Key2 | Search Name | 17-28 |
| Key3 | Vendor Posting Group | 17-28 |
| Key4 | Currency Code | 17-28 |
| Key5 | Priority | 17-28 |
| Key6 | Country/Region Code | 17-28 |
| Key7 | Gen. Bus. Posting Group | 17-28 |
| Key8 | VAT Registration No. | 17-28 |
| Key9 | Name | 17-28 |
| Key10 | City | 17-28 |
| Key11 | Post Code | 17-28 |
| Key12 | Phone No. | 17-28 |
| Key13 | Contact | 17-28 |
| Key14 | Blocked | 17-28 |
| Key15 | SystemModifiedAt | 17-28 |
| Key16 | Coupled to CRM | 19-25 |
| Key21 | IC Partner Code | 19-28 |

## Procedures

| Name | Parameters | Returns | Access | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- | --- |
| AssistEdit | (Record Vendor) | Boolean | public | 17-28 | - | - |
| ValidateShortcutDimCode | (Integer, var Code[20]) | - | public | 17-28 | - | - |
| ShowContact | () | - | public | 17-28 | - | - |
| SetInsertFromContact | (Boolean) | - | public | 17-28 | - | - |
| CheckBlockedVendOnDocs | (Record Vendor, Boolean) | - | public | 17-28 | - | - |
| CheckBlockedVendOnJnls | (Record Vendor, Enum Gen. Journal Document Type, Boolean) | - | public | 17-28 | - | - |
| CreateAndShowNewInvoice | () | - | public | 17-28 | - | - |
| CreateAndShowNewCreditMemo | () | - | public | 17-28 | - | - |
| CreateAndShowNewPurchaseOrder | () | - | public | 17-28 | - | - |
| VendBlockedErrorMessage | (Record Vendor, Boolean) | - | public | 17-28 | - | - |
| VendPrivacyBlockedErrorMessage | (Record Vendor, Boolean) | - | public | 17-28 | - | - |
| GetPrivacyBlockedGenericErrorText | (Record Vendor) | Text[250] | public | 17-28 | - | - |
| DisplayMap | () | - | public | 17-28 | - | - |
| CalcOverDueBalance | () | Decimal | public | 17-28 | - | - |
| GetInvoicedPrepmtAmountLCY | () | Decimal | public | 17-28 | - | - |
| GetPriceCalculationMethod | () | Enum Price Calculation Method | public | 17-28 | - | - |
| GetTotalAmountLCY | () | Decimal | public | 17-28 | - | - |
| HasAddress | () | Boolean | public | 17-28 | - | - |
| GetVendorNo | (Text[100]) | Code[20] | public | 17-28 | - | - |
| GetVendorNoOpenCard | (Text[100], Boolean) | Code[20] | public | 17-28 | - | - |
| SelectVendor | (var Record Vendor) | Boolean | public | 17-28 | - | - |
| LookupVendor | (var Record Vendor) | Boolean | public | 17-26 | Pending 24.0 | Use SelectVendor(var Vendor: Record Vendor): Boolean instead. |
| OpenVendorLedgerEntries | (Boolean) | - | public | 17-28 | - | - |
| GetInsertFromContact | () | Boolean | public | 17-28 | - | - |
| GetInsertFromTemplate | () | Boolean | public | 17-28 | - | - |
| SetInsertFromTemplate | (Boolean) | - | public | 17-28 | - | - |
| SetAddress | (Text[100], Text[50], Code[20], Text[30], Text[30], Code[10], Text[100]) | - | public | 17-28 | - | - |
| UpdateCurrencyId | () | - | public | 17-28 | - | - |
| UpdatePaymentTermsId | () | - | public | 17-28 | - | - |
| UpdatePaymentMethodId | () | - | public | 17-28 | - | - |
| UpdateReferencedIds | () | - | public | 17-28 | - | - |
| GetReferencedIds | (var Record Field) | - | public | 17-28 | - | - |
| ValidatePricesIncludingVATOnAfterGetVATPostingSetup | (var Record VAT Posting Setup) | - | public | 17-28 | - | - |
| ToPriceSource | (var Record Price Source) | - | public | 18-28 | - | - |
| SetDefaultPurchaser | () | - | protected | 19-28 | - | - |
| VATRegistrationValidation | () | - | public | 19-28 | - | - |
| GetBalanceAsCustomer | (var Code[20]) | Decimal | public | 20-28 | - | - |
| GetLinkedCustomer | () | Code[20] | public | 20-28 | - | - |
| SetLastModifiedDateTime | () | - | protected | 20-28 | - | - |
| CheckAllowMultiplePostingGroups | () | - | public | 22-28 | - | - |
| SetForceUpdateContact | (Boolean) | - | public | 24-28 | - | - |
| FindVendorByVATRegistrationNo | (Text[20]) | Code[20] | public | 26-28 | - | - |
| FormatVATRegistrationNo | (Text, Code[10]) | Text | public | 28 | - | - |

## Events

| Kind | Name | Parameters | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| Integration event | OnAfterValidateCity | (var Record Vendor, Record Vendor) | 17-28 | - | - |
| Integration event | OnAfterValidatePostCode | (var Record Vendor, Record Vendor) | 17-28 | - | - |
| Integration event | OnAfterValidateShortcutDimCode | (var Record Vendor, Record Vendor, Integer, var Code[20]) | 17-28 | - | - |
| Integration event | OnAssistEditOnBeforeExit | (var Record Vendor) | 17-28 | - | - |
| Integration event | OnBeforeIsContactUpdateNeeded | (Record Vendor, Record Vendor, var Boolean) | 17-23 | - | - |
| Integration event | OnBeforeCheckBlockedVend | (Record Vendor, Option, Option, Boolean, var Boolean) | 17-28 | - | - |
| Integration event | OnBeforeCheckOutstandingPurchaseDocuments | (Record Vendor, var Boolean) | 17-28 | - | - |
| Integration event | OnBeforeGetVendorNoOpenCard | (Text, Boolean, var Code[20], var Boolean) | 17-23 | - | - |
| Integration event | OnBeforeCalcOverdueBalance | (var Record Vendor, var Decimal, var Boolean) | 17-28 | - | - |
| Integration event | OnBeforeGetInvoicedPrepmtAmountLCY | (var Record Vendor, var Decimal, var Boolean) | 17-28 | - | - |
| Integration event | OnBeforeGetTotalAmountLCY | (var Record Vendor, var Decimal, var Boolean) | 17-28 | - | - |
| Integration event | OnBeforeOnInsert | (var Record Vendor, var Boolean) | 17-28 | - | - |
| Integration event | OnBeforeOpenVendorLedgerEntries | (var Record Vendor, var Record Detailed Vendor Ledg. Entry) | 17-28 | - | - |
| Integration event | OnBeforeLookupCity | (var Record Vendor, var Record Post Code) | 17-28 | - | - |
| Integration event | OnBeforeLookupPostCode | (var Record Vendor, var Record Post Code) | 17-28 | - | - |
| Integration event | OnBeforeSetDefaultPurchaser | (var Record Vendor, var Boolean) | 17-28 | - | - |
| Integration event | OnBeforeValidateCity | (var Record Vendor, var Record Post Code) | 17-20 | - | - |
| Integration event | OnBeforeValidatePostCode | (var Record Vendor, var Record Post Code) | 17-20 | - | - |
| Integration event | OnBeforeValidateShortcutDimCode | (var Record Vendor, var Record Vendor, Integer, var Code[20], var Boolean) | 17-28 | - | - |
| Integration event | OnBeforeVATRegistrationValidation | (var Record Vendor, var Boolean) | 17-18 | - | - |
| Integration event | OnGetVendorNoOpenCardOnBeforeVendorFindSet | (var Record Vendor) | 17-28 | - | - |
| Integration event | OnGetVendorNoOpenCardOnAfterVendorSetFilterFromStart | (var Record Vendor) | 17-28 | - | - |
| Integration event | OnGetVendorNoOpenCardOnAfterSetVendorWithoutQuote | (var Record Vendor) | 17-28 | - | - |
| Integration event | OnGetVendorNoOpenCardonAfterSetvendorFilters | (var Record Vendor, var Text) | 17-28 | - | - |
| Integration event | OnMarkVendorsWithSimilarNameOnBeforeVendorFindSet | (var Record Vendor) | 17-28 | - | - |
| Integration event | OnShowContactOnBeforeOpenContactCard | (var Record Contact, var Integer) | 17-28 | - | - |
| Integration event | OnShowContactOnBeforeOpenContactList | (var Record Contact, var Integer) | 17-28 | - | - |
| Integration event | OnValidatePricesIncludingVATOnAfterGetVATPostingSetup | (var Record VAT Posting Setup) | 17-28 | - | - |
| Integration event | OnAfterOnInsert | (var Record Vendor) | 18-28 | - | - |
| Integration event | OnBeforeCreateNewVendor | (Text[100], Boolean, var Code[20], var Boolean) | 18-28 | - | - |
| Integration event | OnBeforeValidateVATRegistrationNo | (var Record Vendor, Record Vendor, Integer, var Boolean) | 18-28 | - | - |
| Integration event | OnBeforeVATRegistrationValidation | (var Record Vendor, var Boolean, Integer) | 19-28 | - | - |
| Integration event | OnAfterHasAddress | (Record Vendor, var Boolean) | 20-28 | - | - |
| Integration event | OnAfterValidateNo | (var Record Vendor, Record Vendor) | 20-28 | - | - |
| Integration event | OnBeforeOnRename | (var Record Vendor, Record Vendor, var Boolean) | 20-28 | - | - |
| Integration event | OnGetBalanceAsCustomerOnBeforeCalcBalance | (var Record Customer) | 20-28 | - | - |
| Integration event | OnAfterLookupCity | (var Record Vendor, var Record Post Code) | 21-28 | - | - |
| Integration event | OnAfterLookupPostCode | (var Record Vendor, var Record Post Code) | 21-28 | - | - |
| Integration event | OnAfterSetLastModifiedDateTime | (var Record Vendor) | 21-28 | - | - |
| Integration event | OnBeforeValidateCity | (var Record Vendor, var Record Post Code, Integer, var Boolean) | 21-28 | - | - |
| Integration event | OnBeforeValidatePostCode | (var Record Vendor, var Record Post Code, Integer, var Boolean) | 21-28 | - | - |
| Integration event | OnBeforeValidateRegistrationNumber | (var Record Vendor, var Boolean) | 21-28 | - | - |
| Integration event | OnShowContactOnAfterCalcShouldExit | (var Record Vendor, var Integer, var Boolean) | 22-28 | - | - |
| Integration event | OnBeforeCheckAllowMultiplePostingGroups | (var Boolean) | 22-28 | - | - |
| Integration event | OnGetVendorNoOpenCardOnAfterMarkCustomersWithSimilarName | (var Record Vendor) | 22-28 | - | - |
| Integration event | OnGetVendorNoOpenCardOnBeforeSelectVendor | (var Record Vendor) | 22-28 | - | - |
| Integration event | OnOpenVendorLedgerEntriesOnBeforeDrillDownEntries | (var Record Detailed Vendor Ledg. Entry, Boolean, var Boolean) | 23-28 | - | - |
| Integration event | OnBeforeIsContactUpdateNeeded | (Record Vendor, Record Vendor, var Boolean, Boolean) | 24-28 | - | - |
| Integration event | OnBeforeGetVendorNoOpenCard | (Text, Boolean, var Code[20], var Boolean, var Boolean) | 24-28 | - | - |
| Integration event | OnBeforeShowContact | (var Record Vendor) | 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.