Table 1383 "Vendor Templ."
Base Application · Microsoft.Purchases.Vendor
Across versions
- BC23present
- BC241 fields changed
- BC25-26unchanged
- BC272 fields changed
- BC2853 fields changed, 1 fields added
- BC29-30unchanged
Neighbourhood 31 connected objects and pages
Base Application · Microsoft.Purchases.Vendor · captioned “Vendor Template” · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 1379 “Select Vendor Templ. List” (1 Learn page), Page 1385 “Vendor Templ. List” (1), Page 1386 “Vendor Templ. Card” (1).
Properties
| Property | Value |
|---|---|
| Caption | Vendor Template |
| DataClassification | CustomerContent |
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 | Code Δ BC28 | Code[20] | Specifies the code of the template. | NotBlank |
| 2 | Description Δ BC28 | Text[100] | Specifies the description of the template. | |
| 5 | Address Δ BC28 | Text[100] | Specifies the vendor’s address. | |
| 6 | Address 2 Δ BC28 | Text[50] | Specifies additional address information. | |
| 7 | City Δ BC28 | Text[30] | Specifies the vendor’s city. | |
| 9 | Phone No. Δ BC28 | Text[30] | Specifies the vendor’s telephone number. | |
| 10 | Telex No. | Text[20] | — | |
| 14 | Our Account No. Δ BC28 | 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 default currency on purchase documents or journal lines that you create 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” |
| 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 how the vendor calculates finance charges. | 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) |
| 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. Δ 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 payments, such as with bank transfers or by cash or check. | TableRelation Table 289 “Payment Method” (Payment Method) |
| 48 | Format Region Δ BC28 | Text[80] | Specifies the region format to be used on printouts for this vendor. | TableRelation “Language Selection”.“Language Tag” |
| 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. Δ BC28 | Text[30] | Specifies the vendor’s fax number. | |
| 85 | Telex Answer Back | Text[20] | — | |
| 86 | VAT Registration No. Δ 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. | |
| 92 | County Δ BC28 | Text[30] | Specifies the state, province or county as a part of the address. | |
| 93 | EORI Number Δ 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. | |
| 102 | E-Mail Δ BC28 | Text[80] | Specifies the vendor’s email address. | |
| 103 | Home Page Δ BC24 Δ BC27 Δ BC28 | Text[255] | Specifies the vendor’s web site. | |
| 107 | No. Series Δ BC28 | Code[20] | Specifies the number series that will be used to assign numbers to vendors. | TableRelation Table 308 “No. Series” (No. Series) |
| 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) |
| 116 | Block Payment Tolerance Δ BC28 | Boolean | Specifies whether to allow a payment tolerance for the vendor. | |
| 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. | |
| 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 vendor name in the document. | DataClassification SystemMetadata |
| 170 | Creditor No. Δ BC28 | Code[20] | Specifies the number of the vendor. | |
| 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) |
| 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” |
| 5050 | Contact Type Δ BC28 | Enum “Contact Type” | Specifies the type of contact that will be used to create a vendor with the template. | enum Enum 5050 “Contact Type” |
| 5061 | Mobile Phone No. Δ 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))) |
| 7000 | Price Calculation Method Δ BC28 | Enum “Price Calculation Method” | Specifies the default price calculation method. | enum Enum 7000 “Price Calculation Method” |
| 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. | TableRelation Table 60 “Document Sending Profile” (“Document Sending Profile”.Code) |
| 7602 | Validate EU Vat Reg. No. Δ BC28 | Boolean | Specifies if the VAT registration number will be specified in the EU VAT Registration No. Check page so that it is validated against the VAT registration number validation service. | |
| 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” |
| 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) |
Keys
- Key1: Code (clustered)
Events published
OnAfterCopyFromTemplate(SourceVendorTempl: Record "Vendor Templ."; var VendorTempl: Record "Vendor Templ.")(integration)OnCopyTemplateOnBeforeModify(SourceVendorTempl: Record "Vendor Templ."; SavedVendorTempl: Record "Vendor Templ."; var VendorTempl: Record "Vendor Templ.")(integration)
Procedures
CopyFromTemplate(SourceVendorTempl: Record "Vendor Templ.")
Plus 3 local procedures.
Triggers
OnDelete, OnRename
Relations
- drill-down page Page 1385 “Vendor Templ. List”
- lookup page Page 1385 “Vendor Templ. List”
- Shipment Method Code: TableRelation Table 10 “Shipment Method”
- Purchaser Code: TableRelation Table 13 “Salesperson/Purchaser”
- Location Code: TableRelation Table 14 “Location”
- Invoice Disc. Code: TableRelation Table 23 “Vendor”
- Pay-to Vendor No.: TableRelation Table 23 “Vendor”
- Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
- Territory Code: TableRelation Table 286 “Territory”
- Payment Method Code: 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”
- No. Series: 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 2 Code: TableRelation Table 349 “Dimension Value”
- Currency Code: TableRelation Table 4 “Currency”
- Fin. Charge Terms Code: TableRelation Table 5 “Finance Charge Terms”
- Responsibility Center: TableRelation Table 5714 “Responsibility Center”
- Document Sending Profile: TableRelation Table 60 “Document Sending Profile”
- 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”
Referenced by
2 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table 38 “Purchase Header”: Buy-from Vendor Templ. Code, Pay-to Vendor Templ. Code
Pages and codeunits on this table
- Page 1379 “Select Vendor Templ. List” (source table)
- Page 1385 “Vendor Templ. List” (source table)
- Page 1386 “Vendor Templ. Card” (source table)
Extended by
- Table extension 4827 “Intrastat Report Vendor Templ.”
- Table extension 6108 “E-Document Vendor Template”
- Table extension 6805 “Withholding Vendor Templ.”
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 408 “DimensionManagement” (3 calls:
OnRename → RenameDefaultDim,ValidateShortcutDimCode → SaveDefaultDim,ValidateShortcutDimCode → ValidateDimValueCode)
Countries that replace it
AT, AU, BE, CA, CH, DE, ES, FI, FR, GB, IT, MX, NL, NO, NZ, US
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 Templ."), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.