Table 23 Vendor in 24

Jonas Paprotka, Base Application 24.5.23489.36097, checked 2026-09-20

App: Base Application
Namespace: Microsoft.Purchases.Vendor

Fields, 145 Keys, 17 Procedures, 41 Events, 44

Versions17 18 19 20 21 22 232425 26 27 28 latest

Source29

Fields, 145

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

Keys, 17

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

Procedures, 41

Name	Parameters	Returns	Access	Obsolete
AssistEdit	(Record Vendor)	Boolean	public	-
ValidateShortcutDimCode	(Integer, var Code[20])		public	-
ShowContact	()		public	-
SetInsertFromContact	(Boolean)		public	-
CheckBlockedVendOnDocs	(Record Vendor, Boolean)		public	-
CheckBlockedVendOnJnls	(Record Vendor, Enum Gen. Journal Document Type, Boolean)		public	-
CreateAndShowNewInvoice	()		public	-
CreateAndShowNewCreditMemo	()		public	-
CreateAndShowNewPurchaseOrder	()		public	-
VendBlockedErrorMessage	(Record Vendor, Boolean)		public	-
VendPrivacyBlockedErrorMessage	(Record Vendor, Boolean)		public	-
GetPrivacyBlockedGenericErrorText	(Record Vendor)	Text[250]	public	-
DisplayMap	()		public	-
CalcOverDueBalance	()	Decimal	public	-
GetInvoicedPrepmtAmountLCY	()	Decimal	public	-
GetPriceCalculationMethod	()	Enum Price Calculation Method	public	-
GetTotalAmountLCY	()	Decimal	public	-
HasAddress	()	Boolean	public	-
GetVendorNo	(Text[100])	Code[20]	public	-
GetVendorNoOpenCard	(Text[100], Boolean)	Code[20]	public	-
SelectVendor	(var Record Vendor)	Boolean	public	-
LookupVendor	(var Record Vendor)	Boolean	public	Pending 24.0
Use SelectVendor(var Vendor: Record Vendor): Boolean instead.
OpenVendorLedgerEntries	(Boolean)		public	-
GetInsertFromContact	()	Boolean	public	-
GetInsertFromTemplate	()	Boolean	public	-
SetInsertFromTemplate	(Boolean)		public	-
SetAddress	(Text[100], Text[50], Code[20], Text[30], Text[30], Code[10], Text[100])		public	-
UpdateCurrencyId	()		public	-
UpdatePaymentTermsId	()		public	-
UpdatePaymentMethodId	()		public	-
UpdateReferencedIds	()		public	-
GetReferencedIds	(var Record Field)		public	-
ValidatePricesIncludingVATOnAfterGetVATPostingSetup	(var Record VAT Posting Setup)		public	Pending 16.0
Replaced by the new implementation (V16) of price calculation.
ToPriceSource	(var Record Price Source)		public	-
SetDefaultPurchaser	()		protected	-
VATRegistrationValidation	()		public	-
GetBalanceAsCustomer	(var Code[20])	Decimal	public	-
GetLinkedCustomer	()	Code[20]	public	-
SetLastModifiedDateTime	()		protected	-
CheckAllowMultiplePostingGroups	()		public	-
SetForceUpdateContact	(Boolean)		public	-

Events, 44

Kind	Name	Parameters	Obsolete
Integration event	OnAfterValidateCity	(var Record Vendor, Record Vendor)	-
Integration event	OnAfterValidatePostCode	(var Record Vendor, Record Vendor)	-
Integration event	OnAfterValidateShortcutDimCode	(var Record Vendor, Record Vendor, Integer, var Code[20])	-
Integration event	OnAssistEditOnBeforeExit	(var Record Vendor)	-
Integration event	OnBeforeCheckBlockedVend	(Record Vendor, Option, Option, Boolean, var Boolean)	-
Integration event	OnBeforeCheckOutstandingPurchaseDocuments	(Record Vendor, var Boolean)	-
Integration event	OnBeforeCalcOverdueBalance	(var Record Vendor, var Decimal, var Boolean)	-
Integration event	OnBeforeGetInvoicedPrepmtAmountLCY	(var Record Vendor, var Decimal, var Boolean)	-
Integration event	OnBeforeGetTotalAmountLCY	(var Record Vendor, var Decimal, var Boolean)	-
Integration event	OnBeforeOnInsert	(var Record Vendor, var Boolean)	-
Integration event	OnBeforeOpenVendorLedgerEntries	(var Record Vendor, var Record Detailed Vendor Ledg. Entry)	-
Integration event	OnBeforeLookupCity	(var Record Vendor, var Record Post Code)	-
Integration event	OnBeforeLookupPostCode	(var Record Vendor, var Record Post Code)	-
Integration event	OnBeforeSetDefaultPurchaser	(var Record Vendor, var Boolean)	-
Integration event	OnBeforeValidateShortcutDimCode	(var Record Vendor, var Record Vendor, Integer, var Code[20], var Boolean)	-
Integration event	OnGetVendorNoOpenCardOnBeforeVendorFindSet	(var Record Vendor)	-
Integration event	OnGetVendorNoOpenCardOnAfterVendorSetFilterFromStart	(var Record Vendor)	-
Integration event	OnGetVendorNoOpenCardOnAfterSetVendorWithoutQuote	(var Record Vendor)	-
Integration event	OnGetVendorNoOpenCardonAfterSetvendorFilters	(var Record Vendor, var Text)	-
Integration event	OnMarkVendorsWithSimilarNameOnBeforeVendorFindSet	(var Record Vendor)	-
Integration event	OnShowContactOnBeforeOpenContactCard	(var Record Contact, var Integer)	-
Integration event	OnShowContactOnBeforeOpenContactList	(var Record Contact, var Integer)	-
Integration event	OnValidatePricesIncludingVATOnAfterGetVATPostingSetup	(var Record VAT Posting Setup)	Pending 16.0
Replaced by the new implementation (V16) of price calculation.
Integration event	OnAfterOnInsert	(var Record Vendor)	-
Integration event	OnBeforeCreateNewVendor	(Text[100], Boolean, var Code[20], var Boolean)	-
Integration event	OnBeforeValidateVATRegistrationNo	(var Record Vendor, Record Vendor, Integer, var Boolean)	-
Integration event	OnBeforeVATRegistrationValidation	(var Record Vendor, var Boolean, Integer)	-
Integration event	OnAfterHasAddress	(Record Vendor, var Boolean)	-
Integration event	OnAfterValidateNo	(var Record Vendor, Record Vendor)	-
Integration event	OnBeforeOnRename	(var Record Vendor, Record Vendor, var Boolean)	-
Integration event	OnGetBalanceAsCustomerOnBeforeCalcBalance	(var Record Customer)	-
Integration event	OnAfterLookupCity	(var Record Vendor, var Record Post Code)	-
Integration event	OnAfterLookupPostCode	(var Record Vendor, var Record Post Code)	-
Integration event	OnAfterSetLastModifiedDateTime	(var Record Vendor)	-
Integration event	OnBeforeValidateCity	(var Record Vendor, var Record Post Code, Integer, var Boolean)	-
Integration event	OnBeforeValidatePostCode	(var Record Vendor, var Record Post Code, Integer, var Boolean)	-
Integration event	OnBeforeValidateRegistrationNumber	(var Record Vendor, var Boolean)	-
Integration event	OnShowContactOnAfterCalcShouldExit	(var Record Vendor, var Integer, var Boolean)	-
Integration event	OnBeforeCheckAllowMultiplePostingGroups	(var Boolean)	-
Integration event	OnGetVendorNoOpenCardOnAfterMarkCustomersWithSimilarName	(var Record Vendor)	-
Integration event	OnGetVendorNoOpenCardOnBeforeSelectVendor	(var Record Vendor)	-
Integration event	OnOpenVendorLedgerEntriesOnBeforeDrillDownEntries	(var Record Detailed Vendor Ledg. Entry, Boolean, var Boolean)	-
Integration event	OnBeforeIsContactUpdateNeeded	(Record Vendor, Record Vendor, var Boolean, Boolean)	-
Integration event	OnBeforeGetVendorNoOpenCard	(Text, Boolean, var Code[20], var Boolean, var Boolean)	-