Table 23 "Vendor"
Base Application · Microsoft.Purchases.Vendor
- 148fields
- 101procedures
- 45events
- 28Learn pages
- 17countries replace it
- 188fields reference it
- 19event subscribers
- 18objects it calls
Across versions
- BC23present
- BC243 fields changed, 2 events added
- BC2520 fields changed
- BC263 procedures added, 2 fields removed
- BC274 fields changed, 1 fields added
- BC28107 fields changed, 2 fields added
- BC294 fields changed, 2 fields added
- BC30unchanged
Neighbourhood 259 connected objects and pages
Base Application · Microsoft.Purchases.Vendor · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 26 “Vendor Card” (10 Learn pages), Page 30010 “APIV2 - Vendors” (9), Page 20010 “APIV1 - Vendors” (8), Page 27 “Vendor List” (7), Page 34 “Vendor Lookup” (1), Page 786 “Vendor Picture” (1).
Properties
| Property | Value |
|---|---|
| Caption | Vendor |
| DataClassification | CustomerContent |
| Permissions | TableData “Vendor Ledger Entry” = r, TableData “Price List Header” = rd, TableData “Price List Line” = rd, TableData “Purchase Price” = rd, TableData “Purchase Line Discount” = rd, TableData “Purchase Price Access” = rd, TableData “Purchase Discount Access” = rd, tabledata Language = r, tabledata “L… |
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.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | No. Δ BC25 Δ BC28 | Code[20] | Specifies the number of the vendor. The field is either filled automatically from a defined number series, or you enter the number manually because you have enabled manual number entry in the number-series setup. | |
| 2 | Name Δ BC25 Δ BC28 | Text[100] | Specifies the vendor’s name. You can enter a maximum of 30 characters, both numbers and letters. | |
| 3 | Search Name Δ BC27 Δ BC28 | Code[100] | Specifies an alternate name that you can use to search for the record in question when you cannot remember the value in the Name field. | |
| 4 | Name 2 Δ BC25 Δ BC28 | Text[50] | Specifies an additional part of the name. | |
| 5 | Address Δ BC25 Δ BC28 | Text[100] | Specifies the vendor street address. | |
| 6 | Address 2 Δ BC25 Δ BC28 | Text[50] | Specifies additional address information. | |
| 7 | City Δ BC25 Δ BC28 | Text[30] | Specifies the vendor’s city. | TableRelation Table 225 “Post Code” (if (“Country/Region Code” = const(‘’)) “Post Code”.City else if (“Country/Region Code” = filter(<> ‘’)) “Post Code”.City where(“Country/Region Code” = field(“Country/Region Code”))) |
| 8 | Contact Δ BC25 Δ BC28 | Text[100] | Specifies the name of the person you regularly contact when you do business with this vendor. | |
| 9 | Phone No. Δ BC25 Δ BC28 | Text[30] | Specifies the vendor’s telephone number. | |
| 10 | Telex No. Δ BC25 | Text[20] | — | |
| 14 | Our Account No. Δ BC25 Δ BC28 Δ BC29 | Text[20] | Specifies your account number with the vendor, if you have one. | |
| 15 | Territory Code | Code[10] | — | TableRelation Table 286 “Territory” |
| 16 | Global Dimension 1 Code | Code[20] | — | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false))) |
| 17 | Global Dimension 2 Code | Code[20] | — | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false))) |
| 19 | Budgeted Amount | Decimal | — | |
| 21 | Vendor Posting Group Δ BC28 | Code[20] | Specifies the vendor’s market type to link business transactions made for the vendor with the appropriate account in the general ledger. | TableRelation Table 93 “Vendor Posting Group” (Vendor Posting Group) |
| 22 | Currency Code Δ BC28 | Code[10] | Specifies the currency code that is inserted by default when you create purchase documents or journal lines for the vendor. | TableRelation Table 4 “Currency” |
| 24 | Language Code Δ BC28 | Code[10] | Specifies the language that is used when translating specified text on documents to foreign business partner, such as an item description on an order confirmation. | TableRelation Table 8 “Language” |
| 25 | Registration Number Δ BC25 Δ BC28 | Text[50] | Specifies the registration number of the vendor. You can enter a maximum of 20 characters, both numbers and letters. | |
| 26 | Statistics Group Δ BC27 | Integer | Specifies the statistics group. | |
| 27 | Payment Terms Code Δ BC28 | Code[10] | Specifies a formula that calculates the payment due date, payment discount date, and payment discount amount. | TableRelation Table 3 “Payment Terms” (Payment Terms) |
| 28 | Fin. Charge Terms Code Δ BC28 | Code[10] | Specifies the code for the involved finance charges in case of late payment. | TableRelation Table 5 “Finance Charge Terms” (Finance Charge Terms) |
| 29 | Purchaser Code Δ BC28 | Code[20] | Specifies which purchaser is assigned to the vendor. | TableRelation Table 13 “Salesperson/Purchaser” (“Salesperson/Purchaser” where(Blocked = const(false))) |
| 30 | Shipment Method Code Δ BC28 | Code[10] | Specifies the delivery conditions of the related shipment, such as free on board (FOB). | TableRelation Table 10 “Shipment Method” (Shipment Method) |
| 31 | Shipping Agent Code | Code[10] | — | TableRelation Table 291 “Shipping Agent” (Shipping Agent) |
| 33 | Invoice Disc. Code Δ BC28 | Code[20] | Specifies the vendor’s invoice discount code. When you set up a new vendor card, the number you have entered in the No. field is automatically inserted. | TableRelation Table 23 “Vendor” |
| 35 | Country/Region Code Δ BC28 | Code[10] | Specifies the country/region of the address. | TableRelation Table 9 “Country/Region” (Country/Region) |
| 38 | Comment | Boolean | — | FlowField: exist(“Comment Line” where(“Table Name” = const(Vendor), “No.” = field(“No.”))); not editable |
| 39 | Blocked Δ BC28 | Enum “Vendor Blocked” | Specifies whether transactions with this vendor are restricted. Use this field to control vendor activity, such as temporarily halting payments or fully blocking a vendor due to compliance or business decisions. The field can have one of the following values: (blank) - No restrictions, all transacti… | enum Enum 140 “Vendor Blocked” |
| 45 | Pay-to Vendor No. Δ BC27 Δ BC28 | Code[20] | Specifies the number of a different vendor whom you pay for products delivered by the vendor on the vendor card. | TableRelation Table 23 “Vendor” |
| 46 | Priority Δ BC28 | Integer | Specifies the importance of the vendor when suggesting payments using the Suggest Vendor Payments function. | |
| 47 | Payment Method Code Δ BC28 | Code[10] | Specifies how to make payment, such as with bank transfer, cash, or check. | TableRelation Table 289 “Payment Method” (Payment Method) |
| 48 | Format Region Δ BC25 Δ BC28 | Text[80] | Specifies the region format to be used on printouts for this vendor. | TableRelation “Language Selection”.“Language Tag” |
| 52 | First Transaction Date + BC27 | Date | Specifies the date of the first transaction with the vendor. | FlowField: min(“Vendor Ledger Entry”.“Posting Date” where(“Vendor No.” = field(“No.”))) |
| 53 | Last Modified Date Time | DateTime | — | not editable |
| 54 | Last Date Modified Δ BC28 | Date | Specifies when the vendor card was last modified. | not editable |
| 55 | Date Filter | Date | — | FlowFilter |
| 56 | Global Dimension 1 Filter | Code[20] | — | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1))); FlowFilter |
| 57 | Global Dimension 2 Filter | Code[20] | — | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2))); FlowFilter |
| 58 | Balance Δ BC29 | Decimal | — | FlowField: - sum(“Detailed Vendor Ledg. Entry”.Amount where(“Vendor No.” = field(“No.”), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter”), “Currency Code” = field(“Currency Filter”), “Excluded from calculation” = const(false)…; not editable |
| 59 | Balance (LCY) Δ BC28 Δ BC29 | Decimal | Specifies the total value of your completed purchases from the vendor in the current fiscal year. It is calculated from amounts including VAT on all completed purchase invoices and credit memos. via Page 26 “Vendor Card” | FlowField: - sum(“Detailed Vendor Ledg. Entry”.“Amount (LCY)” where(“Vendor No.” = field(“No.”), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter”), “Currency Code” = field(“Currency Filter”), “Excluded from calculation” = cons…; not editable |
| 60 | Net Change Δ BC29 | Decimal | — | FlowField: - sum(“Detailed Vendor Ledg. Entry”.Amount where(“Vendor No.” = field(“No.”), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date Filter”), “Currency Code” = field(“Currency Filter”), “Ex…; not editable |
| 61 | Net Change (LCY) Δ BC28 | Decimal | — | FlowField: - sum(“Detailed Vendor Ledg. Entry”.“Amount (LCY)” where(“Vendor No.” = field(“No.”), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date Filter”), “Currency Code” = field(“Currency Filte…; not editable |
| 62 | Purchases (LCY) Δ BC28 | Decimal | — | FlowField: - sum(“Vendor Ledger Entry”.“Purchase (LCY)” where(“Vendor No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date Filter”), “Currency Code” = field(“Currency Filter”))); not editable |
| 64 | Inv. Discounts (LCY) Δ BC28 | Decimal | — | FlowField: - sum(“Vendor Ledger Entry”.“Inv. Discount (LCY)” where(“Vendor No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date Filter”), “Currency Code” = field(“Currency Filter”))); not editable |
| 65 | Pmt. Discounts (LCY) Δ BC28 | Decimal | — | FlowField: sum(“Detailed Vendor Ledg. Entry”.“Amount (LCY)” where(“Vendor No.” = field(“No.”), “Entry Type” = filter(“Payment Discount” .. “Payment Discount (VAT Adjustment)”), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter”)…; not editable |
| 66 | Balance Due Δ BC24 | Decimal | — | FlowField: - sum(“Detailed Vendor Ledg. Entry”.Amount where(“Vendor No.” = field(“No.”), “Initial Entry Due Date” = field(upperlimit(“Date Filter”)), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter”), “Currency Code” = field(“…; not editable |
| 67 | Balance Due (LCY) Δ BC24 Δ BC28 | Decimal | Specifies the total value of your unpaid purchases from the vendor in the current fiscal year. It is calculated from amounts including VAT on all open purchase invoices and credit memos. via Page 26 “Vendor Card” | FlowField: - sum(“Detailed Vendor Ledg. Entry”.“Amount (LCY)” where(“Vendor No.” = field(“No.”), “Initial Entry Due Date” = field(upperlimit(“Date Filter”)), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter”), “Currency Code” =…; not editable |
| 69 | Payments | Decimal | — | FlowField: sum(“Detailed Vendor Ledg. Entry”.Amount where(“Initial Document Type” = const(Payment), “Entry Type” = const(“Initial Entry”), “Vendor No.” = field(“No.”), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter”), “Postin…; not editable |
| 70 | Invoice Amounts | Decimal | — | FlowField: - sum(“Detailed Vendor Ledg. Entry”.Amount where(“Initial Document Type” = const(Invoice), “Entry Type” = const(“Initial Entry”), “Vendor No.” = field(“No.”), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter”), “Post…; not editable |
| 71 | Cr. Memo Amounts | Decimal | — | FlowField: sum(“Detailed Vendor Ledg. Entry”.Amount where(“Initial Document Type” = const(“Credit Memo”), “Entry Type” = const(“Initial Entry”), “Vendor No.” = field(“No.”), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter”), “…; not editable |
| 72 | Finance Charge Memo Amounts | Decimal | — | FlowField: - sum(“Detailed Vendor Ledg. Entry”.Amount where(“Initial Document Type” = const(“Finance Charge Memo”), “Entry Type” = const(“Initial Entry”), “Vendor No.” = field(“No.”), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 F…; not editable |
| 74 | Payments (LCY) Δ BC28 | Decimal | Specifies the sum of payments paid to the vendor. via Page 27 “Vendor List” | FlowField: sum(“Detailed Vendor Ledg. Entry”.“Amount (LCY)” where(“Initial Document Type” = const(Payment), “Entry Type” = const(“Initial Entry”), “Vendor No.” = field(“No.”), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter”),…; not editable |
| 75 | Inv. Amounts (LCY) Δ BC28 | Decimal | — | FlowField: - sum(“Detailed Vendor Ledg. Entry”.“Amount (LCY)” where(“Initial Document Type” = const(Invoice), “Entry Type” = const(“Initial Entry”), “Vendor No.” = field(“No.”), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter”…; not editable |
| 76 | Cr. Memo Amounts (LCY) Δ BC28 | Decimal | — | FlowField: sum(“Detailed Vendor Ledg. Entry”.“Amount (LCY)” where(“Initial Document Type” = const(“Credit Memo”), “Entry Type” = const(“Initial Entry”), “Vendor No.” = field(“No.”), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Fil…; not editable |
| 77 | Fin. Charge Memo Amounts (LCY) Δ BC28 | Decimal | — | FlowField: - sum(“Detailed Vendor Ledg. Entry”.“Amount (LCY)” where(“Initial Document Type” = const(“Finance Charge Memo”), “Entry Type” = const(“Initial Entry”), “Vendor No.” = field(“No.”), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimen…; not editable |
| 78 | Outstanding Orders | Decimal | — | FlowField: sum(“Purchase Line”.“Outstanding Amount” where(“Document Type” = const(Order), “Pay-to Vendor No.” = field(“No.”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Currency Code” = field(“Currency Filter”))); not editable |
| 79 | Amt. Rcd. Not Invoiced | Decimal | — | FlowField: sum(“Purchase Line”.“Amt. Rcd. Not Invoiced” where(“Document Type” = const(Order), “Pay-to Vendor No.” = field(“No.”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Currency Code” = field(“Currency Filter”))); not editable |
| 80 | Application Method Δ BC28 | Enum “Application Method” | Specifies how to apply payments to entries for this vendor. | enum Enum 1381 “Application Method” |
| 82 | Prices Including VAT Δ BC28 | Boolean | Specifies if the Unit Price and Line Amount fields on document lines should be shown with or without VAT. | |
| 84 | Fax No. Δ BC25 Δ BC28 | Text[30] | Specifies the vendor’s fax number. | |
| 85 | Telex Answer Back Δ BC25 | Text[20] | — | |
| 86 | VAT Registration No. Δ BC25 Δ BC28 | Text[20] | Specifies the vendor’s VAT registration number. | |
| 88 | Gen. Bus. Posting Group Δ BC28 | Code[20] | Specifies the vendor’s trade type to link transactions made for this vendor with the appropriate general ledger account according to the general posting setup. | TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group) |
| 90 | GLN Δ BC28 | Code[13] | Specifies the vendor in connection with electronic document receiving. | |
| 91 | Post Code Δ BC28 | Code[20] | Specifies the postal code. | TableRelation Table 225 “Post Code” (if (“Country/Region Code” = const(‘’)) “Post Code” else if (“Country/Region Code” = filter(<> ‘’)) “Post Code” where(“Country/Region Code” = field(“Country/Region Code”))) |
| 92 | County Δ BC25 Δ BC28 | Text[30] | Specifies the state, province or county as a part of the address. | |
| 93 | EORI Number Δ BC25 Δ BC28 | Text[40] | Specifies the Economic Operators Registration and Identification number that is used when you exchange information with the customs authorities due to trade into or out of the European Union. | |
| 97 | Debit Amount | Decimal | — | FlowField: sum(“Detailed Vendor Ledg. Entry”.“Debit Amount” where(“Vendor No.” = field(“No.”), “Entry Type” = filter(<> Application), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date Filter”), “C…; not editable |
| 98 | Credit Amount | Decimal | — | FlowField: sum(“Detailed Vendor Ledg. Entry”.“Credit Amount” where(“Vendor No.” = field(“No.”), “Entry Type” = filter(<> Application), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date Filter”), “…; not editable |
| 99 | Debit Amount (LCY) Δ BC28 | Decimal | — | FlowField: sum(“Detailed Vendor Ledg. Entry”.“Debit Amount (LCY)” where(“Vendor No.” = field(“No.”), “Entry Type” = filter(<> Application), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date Filter…; not editable |
| 100 | Credit Amount (LCY) Δ BC28 | Decimal | — | FlowField: sum(“Detailed Vendor Ledg. Entry”.“Credit Amount (LCY)” where(“Vendor No.” = field(“No.”), “Entry Type” = filter(<> Application), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date Filte…; not editable |
| 102 | E-Mail Δ BC25 Δ BC28 | Text[80] | Specifies the vendor’s email address. | |
| 103 | Home Page Δ BC24 Δ BC25 Δ BC27 Δ BC28 | Text[255] | Specifies the vendor’s web site. | |
| 104 | Reminder Amounts | Decimal | — | FlowField: - sum(“Detailed Vendor Ledg. Entry”.Amount where(“Initial Document Type” = const(Reminder), “Entry Type” = const(“Initial Entry”), “Vendor No.” = field(“No.”), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter”), “Pos…; not editable |
| 105 | Reminder Amounts (LCY) Δ BC28 | Decimal | — | FlowField: - sum(“Detailed Vendor Ledg. Entry”.“Amount (LCY)” where(“Initial Document Type” = const(Reminder), “Entry Type” = const(“Initial Entry”), “Vendor No.” = field(“No.”), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter…; not editable |
| 107 | No. Series | Code[20] | — | TableRelation Table 308 “No. Series” (No. Series); not editable |
| 108 | Tax Area Code Δ BC28 | Code[20] | Specifies a tax area code for the company. | TableRelation Table 318 “Tax Area” (Tax Area) |
| 109 | Tax Liable Δ BC28 | Boolean | Specifies if the customer is liable for sales tax. | |
| 110 | VAT Bus. Posting Group Δ BC28 | Code[20] | Specifies the VAT specification of the involved customer or vendor to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup. | TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group) |
| 111 | Currency Filter | Code[10] | — | TableRelation Table 4 “Currency”; FlowFilter |
| 113 | Outstanding Orders (LCY) Δ BC28 | Decimal | Specifies the sum of outstanding orders (in LCY) to this vendor. via Page 152 “Vendor Statistics” | FlowField: sum(“Purchase Line”.“Outstanding Amount (LCY)” where(“Document Type” = const(Order), “Pay-to Vendor No.” = field(“No.”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Currency Code” = field(“Currency Filter”))); not editable |
| 114 | Amt. Rcd. Not Invoiced (LCY) Δ BC28 | Decimal | Specifies the total invoice amount (in LCY) for the items you have received but not yet been invoiced for. via Page 152 “Vendor Statistics” | FlowField: sum(“Purchase Line”.“Amt. Rcd. Not Invoiced (LCY)” where(“Document Type” = const(Order), “Pay-to Vendor No.” = field(“No.”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Currency Code” = field(“Currency Filter”))…; not editable |
| 116 | Block Payment Tolerance Δ BC28 | Boolean | Specifies if the vendor allows payment tolerance. | |
| 117 | Pmt. Disc. Tolerance (LCY) Δ BC28 | Decimal | — | FlowField: sum(“Detailed Vendor Ledg. Entry”.“Amount (LCY)” where(“Vendor No.” = field(“No.”), “Entry Type” = filter(“Payment Discount Tolerance” | “Payment Discount Tolerance (VAT Adjustment)” | “Payment Discount Tolerance (VAT Excl.)”), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Ini…; not editable |
| 118 | Pmt. Tolerance (LCY) Δ BC28 | Decimal | — | FlowField: sum(“Detailed Vendor Ledg. Entry”.“Amount (LCY)” where(“Vendor No.” = field(“No.”), “Entry Type” = filter(“Payment Tolerance” | “Payment Tolerance (VAT Adjustment)” | “Payment Tolerance (VAT Excl.)”), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” =…; not editable |
| 119 | IC Partner Code Δ BC28 | Code[20] | Specifies the vendor’s intercompany partner code. | TableRelation Table 413 “IC Partner” (IC Partner) |
| 120 | Refunds Δ BC28 | Decimal | — | FlowField: - sum(“Detailed Vendor Ledg. Entry”.Amount where(“Initial Document Type” = const(Refund), “Entry Type” = const(“Initial Entry”), “Vendor No.” = field(“No.”), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter”), “Posti… |
| 121 | Refunds (LCY) Δ BC28 | Decimal | Specifies the sum of refunds paid to the vendor. via Page 9094 “Vendor Statistics FactBox” | FlowField: - sum(“Detailed Vendor Ledg. Entry”.“Amount (LCY)” where(“Initial Document Type” = const(Refund), “Entry Type” = const(“Initial Entry”), “Vendor No.” = field(“No.”), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter”)… |
| 122 | Other Amounts Δ BC28 | Decimal | — | FlowField: - sum(“Detailed Vendor Ledg. Entry”.Amount where(“Initial Document Type” = const(” “), “Entry Type” = const(“Initial Entry”), “Vendor No.” = field(“No.”), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter”), “Posting … |
| 123 | Other Amounts (LCY) Δ BC28 | Decimal | — | FlowField: - sum(“Detailed Vendor Ledg. Entry”.“Amount (LCY)” where(“Initial Document Type” = const(” “), “Entry Type” = const(“Initial Entry”), “Vendor No.” = field(“No.”), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter”), “… |
| 124 | Prepayment % Δ BC28 | Decimal | Specifies a prepayment percentage that applies to all orders for this vendor, regardless of the items or services on the order lines. | |
| 125 | Outstanding Invoices | Decimal | — | FlowField: sum(“Purchase Line”.“Outstanding Amount” where(“Document Type” = const(Invoice), “Pay-to Vendor No.” = field(“No.”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Currency Code” = field(“Currency Filter”))); not editable |
| 126 | Outstanding Invoices (LCY) Δ BC28 | Decimal | Specifies the sum of the vendor’s outstanding purchase invoices in LCY. via Page 152 “Vendor Statistics” | FlowField: sum(“Purchase Line”.“Outstanding Amount (LCY)” where(“Document Type” = const(Invoice), “Pay-to Vendor No.” = field(“No.”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Currency Code” = field(“Currency Filter”))); not editable |
| 130 | Pay-to No. Of Archived Doc. | Integer | — | FlowField: count(“Purchase Header Archive” where(“Document Type” = const(Order), “Pay-to Vendor No.” = field(“No.”))) |
| 131 | Buy-from No. Of Archived Doc. | Integer | — | FlowField: count(“Purchase Header Archive” where(“Document Type” = const(Order), “Buy-from Vendor No.” = field(“No.”))) |
| 132 | Partner Type Δ BC28 | Enum “Partner Type” | Specifies if the vendor is a person or a company. | enum Enum 134 “Partner Type” |
| 133 | Intrastat Partner Type Δ BC28 | Enum “Partner Type” | Specifies for Intrastat reporting if the vendor is a person or a company. | enum Enum 134 “Partner Type” |
| 134 | Exclude from Pmt. Practices Δ BC28 | Boolean | Specifies that the vendor must be excluded from Payment Practices calculations. | |
| 135 | Company Size Code Δ BC28 | Code[20] | Specifies the size of the vendor’s company. | TableRelation Table 532 “Company Size” (Company Size) |
| 140 | Image Δ BC28 | Media | Specifies the picture of the vendor, for example, a logo. | |
| 150 | Privacy Blocked Δ BC28 | Boolean | Specifies whether to limit access to data for the data subject during daily operations. This is useful, for example, when protecting data from changes while it is under privacy review. | |
| 160 | Disable Search by Name Δ BC28 | Boolean | Specifies that you can change the vendor name on open purchase documents. The change applies only to the documents. | DataClassification SystemMetadata |
| 170 | Creditor No. Δ BC28 | Code[20] | Specifies the number of the vendor. | |
| 175 | Allow Multiple Posting Groups Δ BC28 | Boolean | Specifies if multiple posting groups can be used for posting business transactions for this vendor. | DataClassification SystemMetadata |
| 180 | Self-Billing Agreement + BC28 | Boolean | Specifies the value of the Self-Billing Agreement field. | |
| 181 | Self-Billing Invoice Nos. + BC29 | Code[20] | Specifies the number series that is used to assign numbers to self-billed purchase invoices for this vendor. If it is empty, the number series from the Posted Self-Billing Inv. Nos. field in Purchases & Payables Setup is used. | TableRelation Table 308 “No. Series” (No. Series) |
| 288 | Preferred Bank Account Code Δ BC28 | Code[20] | Specifies the vendor bank account that will be used by default on payment journal lines for export to a payment bank file. | TableRelation Table 288 “Vendor Bank Account” (“Vendor Bank Account”.Code where(“Vendor No.” = field(“No.”))) |
| 720 | Coupled to CRM Δ BC26 | Boolean | Coupled to Dataverse caption | obsolete Removed 26.0; #if not CLEANSCHEMA26; not editable |
| 721 | Coupled to Dataverse Δ BC28 | Boolean | Specifies that the vendor is coupled to an account in Dataverse. | FlowField: exist(“CRM Integration Record” where(“Integration ID” = field(SystemId), “Table ID” = const(Database::Vendor))); not editable |
| 840 | Cash Flow Payment Terms Code Δ BC28 | Code[10] | Specifies a payment term that will be used for calculating cash flow. | TableRelation Table 3 “Payment Terms” (Payment Terms) |
| 5049 | Primary Contact No. Δ BC28 | Code[20] | Specifies the primary contact number for the vendor. | TableRelation Table 5050 “Contact” |
| 5061 | Mobile Phone No. Δ BC25 Δ BC28 | Text[30] | Specifies the vendor’s mobile telephone number. | |
| 5700 | Responsibility Center Δ BC28 | Code[10] | Specifies the code of the responsibility center, such as a distribution hub, that is associated with the involved user, company, customer, or vendor. | TableRelation Table 5714 “Responsibility Center” (Responsibility Center) |
| 5701 | Location Code Δ BC28 | Code[10] | Specifies the warehouse location where items from the vendor must be received by default. | TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false))) |
| 5790 | Lead Time Calculation Δ BC28 | DateFormula | Specifies a date formula for the amount of time it takes to replenish the item. | |
| 7000 | Price Calculation Method Δ BC28 | Enum “Price Calculation Method” | Specifies the default price calculation method. | enum Enum 7000 “Price Calculation Method” |
| 7177 | No. of Pstd. Receipts Δ BC28 | Integer | Specifies the number of posted purchase receipts that exist for the vendor. | FlowField: count(“Purch. Rcpt. Header” where(“Buy-from Vendor No.” = field(“No.”))); not editable |
| 7178 | No. of Pstd. Invoices Δ BC28 | Integer | Specifies the number of posted purchase invoices that exist for the vendor. | FlowField: count(“Purch. Inv. Header” where(“Buy-from Vendor No.” = field(“No.”))); not editable |
| 7179 | No. of Pstd. Return Shipments Δ BC28 | Integer | Specifies the number of posted return shipments that exist for the vendor. | FlowField: count(“Return Shipment Header” where(“Buy-from Vendor No.” = field(“No.”))); not editable |
| 7180 | No. of Pstd. Credit Memos Δ BC28 | Integer | Specifies the number of posted purchase credit memos that exist for the vendor. | FlowField: count(“Purch. Cr. Memo Hdr.” where(“Buy-from Vendor No.” = field(“No.”))); not editable |
| 7181 | Pay-to No. of Orders Δ BC28 | Integer | Specifies the number of posted orders that exist for the customer. | FlowField: count(“Purchase Header” where(“Document Type” = const(Order), “Pay-to Vendor No.” = field(“No.”))); not editable |
| 7182 | Pay-to No. of Invoices Δ BC28 | Integer | Specifies the amount that relates to invoices. | FlowField: count(“Purchase Header” where(“Document Type” = const(Invoice), “Pay-to Vendor No.” = field(“No.”))); not editable |
| 7183 | Pay-to No. of Return Orders Δ BC28 | Integer | Specifies how many return orders have been registered for the customer when the customer acts as the pay-to customer. | FlowField: count(“Purchase Header” where(“Document Type” = const(“Return Order”), “Pay-to Vendor No.” = field(“No.”))); not editable |
| 7184 | Pay-to No. of Credit Memos Δ BC28 | Integer | Specifies the amount that relates to credit memos. | FlowField: count(“Purchase Header” where(“Document Type” = const(“Credit Memo”), “Pay-to Vendor No.” = field(“No.”))); not editable |
| 7185 | Pay-to No. of Pstd. Receipts Δ BC28 | Integer | Specifies the number of posted receipts that exist for the vendor. | FlowField: count(“Purch. Rcpt. Header” where(“Pay-to Vendor No.” = field(“No.”))); not editable |
| 7186 | Pay-to No. of Pstd. Invoices Δ BC28 | Integer | Specifies the amount that relates to posted invoices. | FlowField: count(“Purch. Inv. Header” where(“Pay-to Vendor No.” = field(“No.”))); not editable |
| 7187 | Pay-to No. of Pstd. Return S. Δ BC28 | Integer | Specifies the number of posted return shipments that exist for the vendor. | FlowField: count(“Return Shipment Header” where(“Pay-to Vendor No.” = field(“No.”))); not editable |
| 7188 | Pay-to No. of Pstd. Cr. Memos Δ BC28 | Integer | Specifies the amount that relates to credit memos. | FlowField: count(“Purch. Cr. Memo Hdr.” where(“Pay-to Vendor No.” = field(“No.”))); not editable |
| 7189 | No. of Quotes Δ BC28 | Integer | Specifies the number of purchase quotes that exist for the vendor. | FlowField: count(“Purchase Header” where(“Document Type” = const(Quote), “Buy-from Vendor No.” = field(“No.”))); not editable |
| 7190 | No. of Blanket Orders Δ BC28 | Integer | Specifies the number of purchase blanket orders that exist for the vendor. | FlowField: count(“Purchase Header” where(“Document Type” = const(“Blanket Order”), “Buy-from Vendor No.” = field(“No.”))); not editable |
| 7191 | No. of Orders Δ BC28 | Integer | Specifies the number of purchase orders that exist for the vendor. | FlowField: count(“Purchase Header” where(“Document Type” = const(Order), “Buy-from Vendor No.” = field(“No.”))) |
| 7192 | No. of Invoices Δ BC28 | Integer | Specifies the number of unposted purchase invoices that exist for the vendor. | FlowField: count(“Purchase Header” where(“Document Type” = const(Invoice), “Buy-from Vendor No.” = field(“No.”))); not editable |
| 7193 | No. of Return Orders Δ BC28 | Integer | Specifies the number of purchase return orders that exist for the vendor. | FlowField: count(“Purchase Header” where(“Document Type” = const(“Return Order”), “Buy-from Vendor No.” = field(“No.”))); not editable |
| 7194 | No. of Credit Memos Δ BC28 | Integer | Specifies the number of unposted purchase credit memos that exist for the vendor. | FlowField: count(“Purchase Header” where(“Document Type” = const(“Credit Memo”), “Buy-from Vendor No.” = field(“No.”))); not editable |
| 7195 | No. of Order Addresses | Integer | — | FlowField: count(“Order Address” where(“Vendor No.” = field(“No.”))); not editable |
| 7196 | Pay-to No. of Quotes Δ BC28 | Integer | Specifies the number of quotes that exist for the vendor. | FlowField: count(“Purchase Header” where(“Document Type” = const(Quote), “Pay-to Vendor No.” = field(“No.”))); not editable |
| 7197 | Pay-to No. of Blanket Orders Δ BC28 | Integer | Specifies the number of blanket orders. | FlowField: count(“Purchase Header” where(“Document Type” = const(“Blanket Order”), “Pay-to Vendor No.” = field(“No.”))) |
| 7198 | No. of Incoming Documents Δ BC28 | Integer | Specifies incoming documents, such as vendor invoices in PDF or as image files, that you can manually or automatically convert to document records, such as purchase invoices. The external files that represent incoming documents can be attached at any process stage, including to posted documents and … | FlowField: count(“Incoming Document” where(“Vendor No.” = field(“No.”))); not editable |
| 7600 | Base Calendar Code Δ BC28 | Code[10] | Specifies a customizable calendar for delivery planning that holds the vendor’s working days and holidays. | TableRelation Table 7600 “Base Calendar” (Base Calendar) |
| 7601 | Document Sending Profile Δ BC28 | Code[20] | Specifies the preferred method of sending documents to this vendor, so that you do not have to select a sending option every time that you post and send a document to the vendor. Documents to this vendor will be sent using the specified sending profile and will override the default document sending … | TableRelation Table 60 “Document Sending Profile” (“Document Sending Profile”.Code) |
| 7602 | Validate EU Vat Reg. No. | Boolean | Validate EU VAT Reg. No. caption | |
| 7603 | Copy Buy-from Add. to Qte From + BC28 | Enum “Contact Type” | Specifies which vendor address is inserted on purchase quotes that you create for the vendor. | enum Enum 5050 “Contact Type” |
| 8001 | Currency Id | Guid | — | TableRelation Currency.SystemId |
| 8002 | Payment Terms Id | Guid | — | TableRelation Table 3 “Payment Terms” (“Payment Terms”.SystemId) |
| 8003 | Payment Method Id | Guid | — | TableRelation Table 289 “Payment Method” (“Payment Method”.SystemId) |
| 8510 | Over-Receipt Code Δ BC28 | Code[20] | Specifies the policy that will be used for the vendor if more items than ordered are received. | TableRelation Table 8510 “Over-Receipt Code” (Over-Receipt Code) |
| 8551 | Receipt on Invoice Policy + BC29 | Enum “Receipt on Invoice Policy” | Specifies whether receipt on invoice is enabled automatically for new purchase orders from this vendor. | enum Enum 5820 “Receipt on Invoice Policy” |
Keys
- Key1: No. (clustered)
- 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
- Key21: IC Partner Code
Events published
OnAfterHasAddress(Vendor: Record Vendor; var Result: Boolean)(integration)OnAfterValidateCity(var Vendor: Record Vendor; xVendor: Record Vendor)(integration)OnAfterValidateNo(var Vendor: Record Vendor; xVendor: Record Vendor)(integration)OnAfterValidatePostCode(var Vendor: Record Vendor; xVendor: Record Vendor)(integration)OnAfterValidateShortcutDimCode(var Vendor: Record Vendor; xVendor: Record Vendor; FieldNumber: Integer; var ShortcutDimCode: Code[20])(integration)OnAfterLookupCity(var Vendor: Record Vendor; var PostCodeRec: Record "Post Code")(integration)OnAfterLookupPostCode(var Vendor: Record Vendor; var PostCodeRec: Record "Post Code")(integration)OnAfterOnInsert(var Vendor: Record Vendor)(integration)OnAssistEditOnBeforeExit(var Vendor: Record Vendor)(integration)OnBeforeIsContactUpdateNeeded(Vendor: Record Vendor; xVendor: Record Vendor; var UpdateNeeded: Boolean; ForceUpdateContact: Boolean)+ BC24 − BC24 (integration)OnBeforeCheckBlockedVend(Vendor: Record Vendor; Source: Option Journal,Document; DocType: Option; Transaction: Boolean; var IsHandled: Boolean)(integration)OnBeforeCheckOutstandingPurchaseDocuments(Vendor: Record Vendor; var IsHandled: Boolean)(integration)OnBeforeCreateNewVendor(VendorName: Text[100]; ShowVendorCard: Boolean; var Result: Code[20]; var IsHandled: Boolean)(integration)OnBeforeGetVendorNoOpenCard(VendorText: Text; ShowVendorCard: Boolean; var VendorNo: Code[20]; var IsHandled: Boolean; var ShowCreateVendorOption: Boolean)+ BC24 − BC24 (integration)OnBeforeCalcOverdueBalance(var Vendor: Record Vendor; var OverdueBalance: Decimal; var IsHandled: Boolean)(integration)OnBeforeGetInvoicedPrepmtAmountLCY(var Vendor: Record Vendor; var InvoicedPrepmtAmountLCY: Decimal; var IsHandled: Boolean)(integration)OnBeforeGetTotalAmountLCY(var Vendor: Record Vendor; var TotalAmountLCY: Decimal; var IsHandled: Boolean)(integration)OnAfterSetLastModifiedDateTime(var Vendor: Record Vendor)(integration)OnBeforeOnInsert(var Vendor: Record Vendor; var IsHandled: Boolean)(integration)OnBeforeOnRename(var Vendor: Record Vendor; xVendor: Record Vendor; var IsHandled: Boolean)(integration)OnBeforeOpenVendorLedgerEntries(var Vendor: Record Vendor; var DetailedVendorLedgEntry: Record "Detailed Vendor Ledg. Entry")(integration)OnBeforeLookupCity(var Vendor: Record Vendor; var PostCodeRec: Record "Post Code")(integration)OnBeforeLookupPostCode(var Vendor: Record Vendor; var PostCodeRec: Record "Post Code")(integration)OnBeforeSetDefaultPurchaser(var Vendor: Record Vendor; var IsHandled: Boolean)(integration)OnBeforeValidateCity(var Vendor: Record Vendor; var PostCodeRec: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean)(integration)OnBeforeValidatePostCode(var Vendor: Record Vendor; var PostCodeRec: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean)(integration)OnBeforeValidateVATRegistrationNo(var Rec: Record "Vendor"; xRec: Record "Vendor"; CurrFieldNo: Integer; var IsHandled: Boolean)(integration)OnBeforeValidateShortcutDimCode(var Vendor: Record Vendor; var xVendor: Record Vendor; FieldNumber: Integer; var ShortcutDimCode: Code[20]; var IsHandled: Boolean)(integration)OnBeforeVATRegistrationValidation(var Vendor: Record Vendor; var IsHandled: Boolean; CurrFieldNo: Integer)(integration)OnGetVendorNoOpenCardOnBeforeVendorFindSet(var Vendor: Record Vendor)(integration)OnGetVendorNoOpenCardOnAfterVendorSetFilterFromStart(var Vendor: Record Vendor)(integration)OnGetVendorNoOpenCardOnAfterSetVendorWithoutQuote(var Vendor: Record Vendor)(integration)OnGetVendorNoOpenCardonAfterSetvendorFilters(var Vendor: Record Vendor; var VendorFilterContains: Text)(integration)OnMarkVendorsWithSimilarNameOnBeforeVendorFindSet(var Vendor: Record Vendor)(integration)OnBeforeShowContact(var Vendor: Record Vendor)+ BC28 (integration)OnShowContactOnAfterCalcShouldExit(var Vendor: Record Vendor; var ContactPageID: Integer; var ShouldExit: Boolean)(integration)OnShowContactOnBeforeOpenContactCard(var Contact: Record Contact; var ContactPageID: Integer)(integration)OnShowContactOnBeforeOpenContactList(var Contact: Record Contact; var ContactPageID: Integer)(integration)OnGetBalanceAsCustomerOnBeforeCalcBalance(var Customer: Record Customer)(integration)OnValidatePricesIncludingVATOnAfterGetVATPostingSetup(var VATPostingSetup: Record "VAT Posting Setup")Δ BC28 (integration)OnBeforeValidateRegistrationNumber(var Vendor: Record Vendor; var IsHandled: Boolean)(integration)OnBeforeCheckAllowMultiplePostingGroups(var IsHandled: Boolean)(integration)OnGetVendorNoOpenCardOnAfterMarkCustomersWithSimilarName(var Vendor: Record Vendor)(integration)OnGetVendorNoOpenCardOnBeforeSelectVendor(var Vendor: Record Vendor)(integration)OnOpenVendorLedgerEntriesOnBeforeDrillDownEntries(var DetailedVendorLedgEntry: Record "Detailed Vendor Ledg. Entry"; FilterOnDueEntries: Boolean; var IsHandled: Boolean)(integration)
Trigger event subscribers
- OnAfterDeleteEvent: Codeunit 1173 “Document Attachment Mgmt” DeleteAttachedDocumentsOnAfterDeleteVendor, Codeunit 1535 “Approvals Mgmt.” DeleteApprovalEntriesAfterDeleteVendor, Codeunit 20531 “Subc. Vendor Extension” OnAfterDeleteVendor, Codeunit 5702 “Dist. Integration” VendorOnAfterDelete, Codeunit 7006 “Price Helper - V16” AfterDeleteVendor, Codeunit 7019 “Price Helper - V15” AfterDeleteVendor, Codeunit 882 “OCR - Sync Master Data” OnAfterDeleteVendor
- OnAfterInsertEvent: Codeunit 882 “OCR - Sync Master Data” OnAfterInsertVendor
- OnAfterModifyEvent: Codeunit 1520 “Workflow Event Handling” RunWorkflowOnVendorChanged, Codeunit 882 “OCR - Sync Master Data” OnAfterModifyVendor
- OnAfterRenameEvent: Codeunit 1173 “Document Attachment Mgmt” MoveAttachedDocumentsOnAfterRenameVendor, Codeunit 1520 “Workflow Event Handling” RunWorkflowOnVendorRenamed, Codeunit 7006 “Price Helper - V16” AfterRenameVendor, Codeunit 882 “OCR - Sync Master Data” OnAfterRenameVendor
- OnAfterValidateEvent(Prices Including VAT): Codeunit 7019 “Price Helper - V15” AfterValidatePricesIncludingVATOnVendor
- OnBeforeDeleteEvent: Codeunit 1550 “Record Restriction Mgt.” RemoveVendorRestrictionsBeforeDelete, Codeunit 8059 “Sub. Contracts General Mgt.” CheckIfVendorContractExistWhenDeleteVendor
- OnBeforeInsertEvent: Codeunit 5152 “API - Update Referenced Fields” UpdateReferencedIdsVendorOnInsert
- OnBeforeModifyEvent: Codeunit 5152 “API - Update Referenced Fields” UpdateReferencedIdsVendorOnModify
Procedures
AssistEdit(OldVend: Record Vendor): BooleanValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])ShowContact()SetInsertFromContact(FromContact: Boolean)CheckBlockedVendOnDocs(Vend2: Record Vendor; Transaction: Boolean)CheckBlockedVendOnJnls(Vend2: Record Vendor; DocType: Enum "Gen. Journal Document Type"; Transaction: Boolean)CreateAndShowNewInvoice()CreateAndShowNewCreditMemo()CreateAndShowNewPurchaseOrder()VendBlockedErrorMessage(Vend2: Record Vendor; Transaction: Boolean)VendPrivacyBlockedErrorMessage(Vend2: Record Vendor; Transaction: Boolean)GetPrivacyBlockedGenericErrorText(Vend2: Record Vendor): Text[250]DisplayMap()CalcOverDueBalance(): DecimalGetInvoicedPrepmtAmountLCY(): DecimalGetPriceCalculationMethod(): Enum "Price Calculation Method"GetTotalAmountLCY(): DecimalHasAddress(): BooleanGetBalanceAsCustomer(var LinkedCustomerNo: Code[20]): DecimalGetLinkedCustomer(): Code[20]GetVendorNo(VendorText: Text[100]): Code[20]GetVendorNoOpenCard(VendorText: Text[100]; ShowVendorCard: Boolean): Code[20]SelectVendor(var Vendor: Record Vendor): BooleanOpenVendorLedgerEntries(FilterOnDueEntries: Boolean)GetInsertFromContact(): BooleanGetInsertFromTemplate(): BooleanSetInsertFromTemplate(FromTemplate: Boolean)SetAddress(VendorAddress: Text[100]; VendorAddress2: Text[50]; VendorPostCode: Code[20]; VendorCity: Text[30]; VendorCounty: Text[30]; VendorCountryCode: Code[10]; VendorContact: Text[100])SetDefaultPurchaser()(protected)SetLastModifiedDateTime()(protected)ToPriceSource(var PriceSource: Record "Price Source")VATRegistrationValidation()UpdateCurrencyId()UpdatePaymentTermsId()UpdatePaymentMethodId()SetForceUpdateContact(NewForceUpdateContact: Boolean)+ BC24FindVendorByVATRegistrationNo(VATRegistrationNo: Text[20]): Code[20]+ BC26UpdateReferencedIds()GetReferencedIds(var TempField: Record "Field" temporary)CheckAllowMultiplePostingGroups()FormatVATRegistrationNo(VATRegistrationNo: Text; CountryCode: Code[10]): Text+ BC28ValidatePricesIncludingVATOnAfterGetVATPostingSetup(var VATPostingSetup: Record "VAT Posting Setup")Δ BC28
Plus 14 local procedures.
Triggers
OnDelete, OnInsert, OnModify, OnRename
Relations
- drill-down page Page 27 “Vendor List”
- lookup page Page 34 “Vendor Lookup”
- Shipment Method Code: TableRelation Table 10 “Shipment Method”
- No. of Pstd. Receipts: CalcFormula Table 120 “Purch. Rcpt. Header”
- Pay-to No. of Pstd. Receipts: CalcFormula Table 120 “Purch. Rcpt. Header”
- No. of Pstd. Invoices: CalcFormula Table 122 “Purch. Inv. Header”
- Pay-to No. of Pstd. Invoices: CalcFormula Table 122 “Purch. Inv. Header”
- No. of Pstd. Credit Memos: CalcFormula Table 124 “Purch. Cr. Memo Hdr.”
- Pay-to No. of Pstd. Cr. Memos: CalcFormula Table 124 “Purch. Cr. Memo Hdr.”
- Purchaser Code: TableRelation Table 13 “Salesperson/Purchaser”
- No. of Incoming Documents: CalcFormula Table 130 “Incoming Document”
- Location Code: TableRelation Table 14 “Location”
- No. of Order Addresses: CalcFormula Table 224 “Order Address”
- City: TableRelation Table 225 “Post Code” (conditional)
- Post Code: TableRelation Table 225 “Post Code” (conditional)
- Invoice Disc. Code: TableRelation Table 23 “Vendor”
- Pay-to Vendor No.: TableRelation Table 23 “Vendor”
- First Transaction Date: CalcFormula Table 25 “Vendor Ledger Entry”
- Inv. Discounts (LCY): CalcFormula Table 25 “Vendor Ledger Entry”
- Purchases (LCY): CalcFormula Table 25 “Vendor Ledger Entry”
- Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
- Territory Code: TableRelation Table 286 “Territory”
- Preferred Bank Account Code: TableRelation Table 288 “Vendor Bank Account”
- Payment Method Code: TableRelation Table 289 “Payment Method”
- Payment Method Id: TableRelation Table 289 “Payment Method”
- Shipping Agent Code: TableRelation Table 291 “Shipping Agent”
- Cash Flow Payment Terms Code: TableRelation Table 3 “Payment Terms”
- Payment Terms Code: TableRelation Table 3 “Payment Terms”
- Payment Terms Id: TableRelation Table 3 “Payment Terms”
- No. Series: TableRelation Table 308 “No. Series”
- Self-Billing Invoice Nos.: TableRelation Table 308 “No. Series”
- Tax Area Code: TableRelation Table 318 “Tax Area”
- VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
- Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Global Dimension 1 Filter: TableRelation Table 349 “Dimension Value”
- Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Global Dimension 2 Filter: TableRelation Table 349 “Dimension Value”
- No. of Blanket Orders: CalcFormula Table 38 “Purchase Header”
- No. of Credit Memos: CalcFormula Table 38 “Purchase Header”
- No. of Invoices: CalcFormula Table 38 “Purchase Header”
- No. of Orders: CalcFormula Table 38 “Purchase Header”
- No. of Quotes: CalcFormula Table 38 “Purchase Header”
- No. of Return Orders: CalcFormula Table 38 “Purchase Header”
- Pay-to No. of Blanket Orders: CalcFormula Table 38 “Purchase Header”
- Pay-to No. of Credit Memos: CalcFormula Table 38 “Purchase Header”
- Pay-to No. of Invoices: CalcFormula Table 38 “Purchase Header”
- Pay-to No. of Orders: CalcFormula Table 38 “Purchase Header”
- Pay-to No. of Quotes: CalcFormula Table 38 “Purchase Header”
- Pay-to No. of Return Orders: CalcFormula Table 38 “Purchase Header”
- Balance: CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
- Balance (LCY): CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
- Balance Due: CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
- Balance Due (LCY): CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
- Cr. Memo Amounts: CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
- Cr. Memo Amounts (LCY): CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
- Credit Amount: CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
- Credit Amount (LCY): CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
- Debit Amount: CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
- Debit Amount (LCY): CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
- Fin. Charge Memo Amounts (LCY): CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
- Finance Charge Memo Amounts: CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
- Inv. Amounts (LCY): CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
- Invoice Amounts: CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
- Net Change: CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
- Net Change (LCY): CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
- Other Amounts: CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
- Other Amounts (LCY): CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
- Payments: CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
- Payments (LCY): CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
- Pmt. Disc. Tolerance (LCY): CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
- Pmt. Discounts (LCY): CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
- Pmt. Tolerance (LCY): CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
- Refunds: CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
- Refunds (LCY): CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
- Reminder Amounts: CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
- Reminder Amounts (LCY): CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
- Amt. Rcd. Not Invoiced: CalcFormula Table 39 “Purchase Line”
- Amt. Rcd. Not Invoiced (LCY): CalcFormula Table 39 “Purchase Line”
- Outstanding Invoices: CalcFormula Table 39 “Purchase Line”
- Outstanding Invoices (LCY): CalcFormula Table 39 “Purchase Line”
- Outstanding Orders: CalcFormula Table 39 “Purchase Line”
- Outstanding Orders (LCY): CalcFormula Table 39 “Purchase Line”
- Currency Code: TableRelation Table 4 “Currency”
- Currency Filter: TableRelation Table 4 “Currency”
- IC Partner Code: TableRelation Table 413 “IC Partner”
- Fin. Charge Terms Code: TableRelation Table 5 “Finance Charge Terms”
- Primary Contact No.: TableRelation Table 5050 “Contact”
- Buy-from No. Of Archived Doc.: CalcFormula Table 5109 “Purchase Header Archive”
- Pay-to No. Of Archived Doc.: CalcFormula Table 5109 “Purchase Header Archive”
- Company Size Code: TableRelation Table 532 “Company Size”
- Coupled to Dataverse: CalcFormula Table 5331 “CRM Integration Record”
- Responsibility Center: TableRelation Table 5714 “Responsibility Center”
- Document Sending Profile: TableRelation Table 60 “Document Sending Profile”
- No. of Pstd. Return Shipments: CalcFormula Table 6650 “Return Shipment Header”
- Pay-to No. of Pstd. Return S.: CalcFormula Table 6650 “Return Shipment Header”
- Base Calendar Code: TableRelation Table 7600 “Base Calendar”
- Language Code: TableRelation Table 8 “Language”
- Over-Receipt Code: TableRelation Table 8510 “Over-Receipt Code”
- Country/Region Code: TableRelation Table 9 “Country/Region”
- Vendor Posting Group: TableRelation Table 93 “Vendor Posting Group”
- Comment: CalcFormula Table 97 “Comment Line”
Referenced by
188 fields in 138 objects relate to this table (TableRelation or CalcFormula).
- Table 181 “Posted Gen. Journal Line”: Account No., Bal. Account No., Bill-to/Pay-to No., Sell-to/Buy-from No., Source No.
- Table 751 “Standard General Journal Line”: Account No., Bal. Account No., Bill-to/Pay-to No., Sell-to/Buy-from No., Source No.
- Table 81 “Gen. Journal Line”: Account No., Bal. Account No., Bill-to/Pay-to No., Sell-to/Buy-from No., Source No.
- Table 123 “Purch. Inv. Line”: Buy-from Vendor Name, Buy-from Vendor No., Pay-to Vendor No.
- Table 125 “Purch. Cr. Memo Line”: Buy-from Vendor Name, Buy-from Vendor No., Pay-to Vendor No.
- Table 25 “Vendor Ledger Entry”: Bal. Account No., Buy-from Vendor No., Vendor No.
- Table 39 “Purchase Line”: Buy-from Vendor Name, Buy-from Vendor No., Pay-to Vendor No.
- Table 6651 “Return Shipment Line”: Buy-from Vendor Name, Buy-from Vendor No., Pay-to Vendor No.
- Table 120 “Purch. Rcpt. Header”: Buy-from Vendor No., Pay-to Vendor No.
- Table 121 “Purch. Rcpt. Line”: Buy-from Vendor No., Pay-to Vendor No.
- Table 122 “Purch. Inv. Header”: Buy-from Vendor No., Pay-to Vendor No.
- Table 124 “Purch. Cr. Memo Hdr.”: Buy-from Vendor No., Pay-to Vendor No.
- Table 1251 “Text-to-Account Mapping”: Bal. Source No., Vendor No.
- Table 1383 “Vendor Templ.”: Invoice Disc. Code, Pay-to Vendor No.
- Table 1570 “G/L Entry Posting Preview”: Bal. Account No., Source No.
- Table 17 “G/L Entry”: Bal. Account No., Source No.
- Table 179 “Reversal Entry”: Bal. Account No., Source No.
- Table 23 “Vendor”: Invoice Disc. Code, Pay-to Vendor No.
- Table 246 “Requisition Line”: Supply From, Vendor No.
- Table 38 “Purchase Header”: Buy-from Vendor No., Pay-to Vendor No.
- Table 428 “IC Outbox Purchase Header”: Buy-from Vendor No., Pay-to Vendor No.
- Table 432 “Handled IC Outbox Purch. Hdr”: Buy-from Vendor No., Pay-to Vendor No.
- Table 436 “IC Inbox Purchase Header”: Buy-from Vendor No., Pay-to Vendor No.
- Table 440 “Handled IC Inbox Purch. Header”: Buy-from Vendor No., Pay-to Vendor No.
- Table 5109 “Purchase Header Archive”: Buy-from Vendor No., Pay-to Vendor No.
- Table 5110 “Purchase Line Archive”: Buy-from Vendor No., Pay-to Vendor No.
- Table 5477 “Purch. Inv. Entity Aggregate”: Buy-from Vendor No., Pay-to Vendor No.
- Table 5496 “Purchase Order Entity Buffer”: Buy-from Vendor No., Pay-to Vendor No.
- Table 5508 “Purch. Cr. Memo Entity Buffer”: Buy-from Vendor No., Pay-to Vendor No.
- Table 5600 “Fixed Asset”: Maintenance Vendor No., Vendor No.
- Table 5940 “Service Item”: Vendor Name, Vendor No.
- Table 6650 “Return Shipment Header”: Buy-from Vendor No., Pay-to Vendor No.
- Table 7114 “Analysis Line”: Range, Source No. Filter
- Table 8063 “Vendor Subscription Contract”: Buy-from Vendor No., Pay-to Vendor No.
- Table 8072 “Vend. Sub. Contract Deferral”: Pay-to Vendor No., Vendor No.
- Table 83 “Item Journal Line”: Invoice-to Source No., Source No.
- Table 1206 “Credit Transfer Entry”: Account No.
- Table 1293 “Payment Application Proposal”: Account No.
- Table 1294 “Applied Payment Entry”: Account No.
- Table 1296 “Posted Payment Recon. Line”: Account No.
- Table 130 “Incoming Document”: Vendor No.
- Table 1382 “Item Templ.”: Vendor No.
- Table 156 “Resource”: Vendor No.
- Table 1571 “VAT Entry Posting Preview”: Bill-to/Pay-to No.
- Table 1626 “Office Contact Details”: No.
- Table 1692 “Posted Bank Deposit Line”: Account No.
- Table 175 “Standard Vendor Purchase Code”: Vendor No.
- Table 182 “Posted Gen. Journal Batch”: Bal. Account No.
- Table 186 “Exch. Rate Adjmt. Ledg. Entry”: Account No.
- Table 20500 “Subcontractor Price”: Vendor No.
- and 88 more objects (88 fields): data/code/relations/29.json
Pages and codeunits on this table
- Page 152 “Vendor Statistics” (source table)
- Page 156 “Vendor Purchases” (source table)
- Page 1621 “Office Vendor Details” (source table)
- Page 20010 “APIV1 - Vendors” (source table)
- Page 26 “Vendor Card” (source table)
- Page 27 “Vendor List” (source table)
- Page 30010 “APIV2 - Vendors” (source table)
- Page 303 “Vendor Entry Statistics” (source table)
- Page 30308 “API Finance - Vendor” (source table)
- Page 34 “Vendor Lookup” (source table)
- Page 36959 “Vendors - PBI API” (source table)
- Page 5855 “Posted Purchase Document Lines” (source table)
- Page 6410 “Workflow - Vendor Entity” (source table)
- Page 769 “Aged Acc. Payable Chart” (source table)
- Page 786 “Vendor Picture” (source table)
- Page 9093 “Vendor Details FactBox” (source table)
- Page 9094 “Vendor Statistics FactBox” (source table)
- Page 9095 “Vendor Hist. Buy-from FactBox” (source table)
- Page 9096 “Vendor Hist. Pay-to FactBox” (source table)
Extended by
- Table extension 20507 “Subc. Vendor”
- Table extension 4813 “Intrastat Report Vendor”
- Table extension 6165 “E-Document Vendor”
- Table extension 6219 “Sust. Vendor”
- Table extension 6784 “Withholding Vendor Ext”
- Table extension 7245 “MDM Vendor”
- Table extension 8002 “Vendor”
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 5057 “VendCont-Update” (6 calls:
IsContactUpdateNeeded → ContactNameIsBlank,OnDelete → OnDelete,OnInsert → OnInsert, …) - Codeunit 408 “DimensionManagement” (5 calls:
OnDelete → DeleteDefaultDim,OnInsert → UpdateDefaultDim,OnRename → RenameDefaultDim, …) - Codeunit 249 “VAT Registration Log Mgt.” (3 calls:
OnDelete → DeleteVendorLog,VATRegistrationValidation → LogVendor,VATRegistrationValidation → ValidateVATRegNoWithVIES) - Codeunit 1535 “Approvals Mgmt.” (2 calls:
OnDelete → OnCancelVendorApprovalRequest,OnRename → OnRenameRecordInApprovalRequest) - Codeunit 7600 “Calendar Management” (2 calls:
OnDelete → DeleteCustomizedBaseCalendarData,OnRename → RenameCustomizedBaseCalendarData) - Page 456 “No. Series” (2 calls:
AssistEdit → (object),OnInsert → (object)) - Codeunit 10 “Type Helper” (1 call:
MarkVendorsWithSimilarName → TextDistance) - Codeunit 1385 “Vendor Templ. Mgt.” (1 call:
CreateNewVendor → InsertVendorFromTemplate) - Codeunit 1520 “Workflow Event Handling” (1 call:
CreateNewVendor → RunWorkflowOnVendorChanged) - Codeunit 1630 “Office Management” (1 call:
ShowContact → GetContact) - Codeunit 27 “Confirm Management” (1 call:
ShowContact → GetResponseOrDefault) - Codeunit 361 “MoveEntries” (1 call:
OnDelete → MoveVendorEntries) - Codeunit 5465 “Graph Mgt - General Tools” (1 call:
UpdateReferencedIds → IsApiEnabled) - Codeunit 701 “Data Type Management” (1 call:
GetReferencedIds → InsertFieldToBuffer) - Codeunit 802 “Online Map Management” (1 call:
DisplayMap → MakeSelectionIfMapEnabled) - Page 50 “Purchase Order” (1 call:
CreateAndShowNewPurchaseOrder → (object)) - Page 51 “Purchase Invoice” (1 call:
CreateAndShowNewInvoice → (object)) - Page 52 “Purchase Credit Memo” (1 call:
CreateAndShowNewCreditMemo → (object))
Recent changes
- 2026-09-01 #10700 29.x: PO matching API, E-Documents integration and receipt-on-invoice line tracking (releases/29.x, BC29, feature)
- 2026-08-31 #10528 Track receipt on invoice per purchase order line (main, BC30, feature)
- 2026-08-27 #10559 Ruleset hardening: promote AL0659 and AL0685 to Error (main, BC30, refactor)
- 2026-08-16 #9067 Production Definition Wizard - Implementation (main, BC30, feature)
- 2026-08-11 #9723 [Master] - Slice 626320: [Self-billing][VENDOR] Vendor‑specific Number Series for Self‑Billed Purchase Invoices (main, BC30, feature)
- 2026-07-20 #9089 Merge-ES-Excluded-from-Calculation-to-W1 (main, BC30, feature)
Countries that replace it
AT, AU, BE, CA, CH, DE, ES, FI, FR, GB, IT, MX, NL, NO, NZ, RU, US
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: "Vendor"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.