Table 23 Vendor

Base Application, Microsoft.Purchases.Vendor

149 fields

IdNameTypeVersions
1No.Code[20]17-29
2NameText[100]17-29
3Search NameCode[100]17-29
4Name 2Text[50]17-29
5AddressText[100]17-29
6Address 2Text[50]17-29
7CityText[30]17-29
8ContactText[100]17-29
9Phone No.Text[30]17-29
10Telex No.Text[20]17-29
14Our Account No.Text[20]17-29
15Territory CodeCode[10]17-29
16Global Dimension 1 CodeCode[20]17-29
17Global Dimension 2 CodeCode[20]17-29
19Budgeted AmountDecimal17-29
21Vendor Posting GroupCode[20]17-29
22Currency CodeCode[10]17-29
24Language CodeCode[10]17-29
25Registration NumberText[50]new in 21
26Statistics GroupInteger17-29
27Payment Terms CodeCode[10]17-29
28Fin. Charge Terms CodeCode[10]17-29
29Purchaser CodeCode[20]17-29
30Shipment Method CodeCode[10]17-29
31Shipping Agent CodeCode[10]17-29
33Invoice Disc. CodeCode[20]17-29
35Country/Region CodeCode[10]17-29
38CommentBoolean17-29
39BlockedEnum "Vendor Blocked"17-29
45Pay-to Vendor No.Code[20]17-29
46PriorityInteger17-29
47Payment Method CodeCode[10]17-29
48Format RegionText[80]new in 23
52First Transaction DateDatenew in 27
53Last Modified Date TimeDateTime17-29
54Last Date ModifiedDate17-29
55Date FilterDate17-29
56Global Dimension 1 FilterCode[20]17-29
57Global Dimension 2 FilterCode[20]17-29
58BalanceDecimal17-29
59Balance (LCY)Decimal17-29
60Net ChangeDecimal17-29
61Net Change (LCY)Decimal17-29
62Purchases (LCY)Decimal17-29
64Inv. Discounts (LCY)Decimal17-29
65Pmt. Discounts (LCY)Decimal17-29
66Balance DueDecimal17-29
67Balance Due (LCY)Decimal17-29
69PaymentsDecimal17-29
70Invoice AmountsDecimal17-29
71Cr. Memo AmountsDecimal17-29
72Finance Charge Memo AmountsDecimal17-29
74Payments (LCY)Decimal17-29
75Inv. Amounts (LCY)Decimal17-29
76Cr. Memo Amounts (LCY)Decimal17-29
77Fin. Charge Memo Amounts (LCY)Decimal17-29
78Outstanding OrdersDecimal17-29
79Amt. Rcd. Not InvoicedDecimal17-29
80Application MethodEnum "Application Method"17-29changed in 18
82Prices Including VATBoolean17-29
84Fax No.Text[30]17-29
85Telex Answer BackText[20]17-29
86VAT Registration No.Text[20]17-29
88Gen. Bus. Posting GroupCode[20]17-29
90GLNCode[13]17-29
91Post CodeCode[20]17-29
92CountyText[30]17-29
93EORI NumberText[40]17-29
97Debit AmountDecimal17-29
98Credit AmountDecimal17-29
99Debit Amount (LCY)Decimal17-29
100Credit Amount (LCY)Decimal17-29
102E-MailText[80]17-29
103Home PageText[255]17-29changed in 27
104Reminder AmountsDecimal17-29
105Reminder Amounts (LCY)Decimal17-29
107No. SeriesCode[20]17-29
108Tax Area CodeCode[20]17-29
109Tax LiableBoolean17-29
110VAT Bus. Posting GroupCode[20]17-29
111Currency FilterCode[10]17-29
113Outstanding Orders (LCY)Decimal17-29
114Amt. Rcd. Not Invoiced (LCY)Decimal17-29
116Block Payment ToleranceBoolean17-29
117Pmt. Disc. Tolerance (LCY)Decimal17-29
118Pmt. Tolerance (LCY)Decimal17-29
119IC Partner CodeCode[20]17-29
120RefundsDecimal17-29
121Refunds (LCY)Decimal17-29
122Other AmountsDecimal17-29
123Other Amounts (LCY)Decimal17-29
124Prepayment %Decimal17-29
125Outstanding InvoicesDecimal17-29
126Outstanding Invoices (LCY)Decimal17-29
130Pay-to No. Of Archived Doc.Integer17-29
131Buy-from No. Of Archived Doc.Integer17-29
132Partner TypeEnum "Partner Type"17-29
133Intrastat Partner TypeEnum "Partner Type"new in 20
134Exclude from Pmt. PracticesBooleannew in 22
135Company Size CodeCode[20]new in 22
140ImageMedia17-29
150Privacy BlockedBoolean17-29
160Disable Search by NameBoolean17-29
170Creditor No.Code[20]17-29
175Allow Multiple Posting GroupsBooleannew in 22
180Self-Billing AgreementBooleannew in 28
181Self-Billing Invoice Nos.Code[20]new in 29
288Preferred Bank Account CodeCode[20]17-29
720Coupled to CRMBooleannew in 19
Removed, tag 26.0, obsolete since 22.1: Replaced by flow field Coupled to Dataverse
721Coupled to DataverseBooleannew in 22
840Cash Flow Payment Terms CodeCode[10]17-29
5049Primary Contact No.Code[20]17-29
5061Mobile Phone No.Text[30]17-29
5700Responsibility CenterCode[10]17-29
5701Location CodeCode[10]17-29
5790Lead Time CalculationDateFormula17-29
7000Price Calculation MethodEnum "Price Calculation Method"17-29
7177No. of Pstd. ReceiptsInteger17-29
7178No. of Pstd. InvoicesInteger17-29
7179No. of Pstd. Return ShipmentsInteger17-29
7180No. of Pstd. Credit MemosInteger17-29
7181Pay-to No. of OrdersInteger17-29
7182Pay-to No. of InvoicesInteger17-29
7183Pay-to No. of Return OrdersInteger17-29
7184Pay-to No. of Credit MemosInteger17-29
7185Pay-to No. of Pstd. ReceiptsInteger17-29
7186Pay-to No. of Pstd. InvoicesInteger17-29
7187Pay-to No. of Pstd. Return S.Integer17-29
7188Pay-to No. of Pstd. Cr. MemosInteger17-29
7189No. of QuotesInteger17-29
7190No. of Blanket OrdersInteger17-29
7191No. of OrdersInteger17-29
7192No. of InvoicesInteger17-29
7193No. of Return OrdersInteger17-29
7194No. of Credit MemosInteger17-29
7195No. of Order AddressesInteger17-29
7196Pay-to No. of QuotesInteger17-29
7197Pay-to No. of Blanket OrdersInteger17-29
7198No. of Incoming DocumentsInteger17-29
7600Base Calendar CodeCode[10]17-29
7601Document Sending ProfileCode[20]17-29
7602Validate EU Vat Reg. No.Boolean17-29
7603Copy Buy-from Add. to Qte FromEnum "Contact Type"new in 28
8001Currency IdGuid17-29
8002Payment Terms IdGuid17-29
8003Payment Method IdGuid17-29
8510Over-Receipt CodeCode[20]17-29
8551Receipt on Invoice PolicyEnum "Receipt on Invoice Policy"new in 29
11000Registration No.Text[20]17-29
Removed, tag 25.0, obsolete since 21.5: Replaced with Registration Number