Vendor
The Vendor dimension of the Demand Planning semantic model.
DE: Lieferant
Columns
| Column (EN) | Column (DE) | Type | Description |
|---|---|---|---|
| Vendor Address | Adresse | string | Stores the vendor’s full address, such as street, city, and postal code. Used to identify where to send payments or correspondence related to the vendor. |
| City | Stadt | string | Stores the name of the city where the vendor is located. This helps identify the vendor’s location for shipping, billing, and communication purposes. |
| State | Bundesland | string | This field shows the state or province where the vendor is located. It helps identify the vendor’s address for shipping, billing, and tax purposes in the purchasing process. |
| Vendor Street | Straße | string | Shows the street address for the vendor, which is used for mailing, billing, or shipping purposes. This helps identify where the vendor is located or where correspondence should be sent. |
| Zip Code | PLZ | string | Shows the postal code for the vendor’s address, helping identify the vendor’s location for shipping, billing, or tax purposes. Used to ensure accurate vendor records in Business Central. |
| Country Region Id | Ländercode | string | Shows the code for the country or region where the vendor is located. Used to identify the vendor's location for tax, shipping, and reporting purposes. |
| Vendor City | Stadt (display) | string | Shows the city where the vendor is located. Useful for identifying the vendor’s location when reviewing or filtering vendor records. |
| Vendor City | Stadt (kurz) | string | Shows the city where the vendor is located. Useful for identifying or filtering vendors based on their location in business transactions. |
| Vendor City | Stadt (lang) | string | Shows the full city name where the vendor is located. Useful for identifying and grouping vendors based on their city in business reports and communications. |
| Vendor | Lieferant | string | Shows the name or number of the vendor, representing the company or person supplying goods or services. Used to identify and manage suppliers in purchasing and accounts payable processes. |
| Vendor No. | Lieferantennr. | string | This field contains the unique number assigned to each vendor. It helps identify and manage vendors for purchasing and accounts payable processes. |
| Vendor Name | Lieferantenname | string | Shows the name of the vendor, which helps identify the supplier for purchases or payments in your business records. Use this to quickly see who you are buying from or managing payments for. |
| Vendor Posting Grp. | Lief. Buchungs Grp. | string | This field shows which vendor posting group is assigned to the vendor. It is used to determine how transactions with this vendor are posted in the accounting system, grouping vendors for financial reporting and ledger purposes. |
| Vendor Posting Grp. Id | Lief. Buchungs Grp. Id | string | Shows which vendor posting group is assigned to the vendor. This helps determine how transactions with the vendor are recorded in the accounting system, such as which accounts will be used for payables and purchases. |
| Vendor Posting Grp. Descr. | Lief. Buchungsgrp. Bez. | string | This field shows the description of the vendor posting group, which helps identify how transactions with the vendor are recorded in the accounting system. It provides context for grouping vendors for posting purposes, such as assigning them to the correct accounts in the general ledger. |
| Vendor Region | Lieferant Region | string | Shows the geographic region or area assigned to a vendor. This helps group vendors by location for reporting or analysis purposes in purchasing and supplier management. |
| Vendor Region Id | Lief. Region Id | string | Shows the identification code for the region assigned to the vendor. This helps group and manage vendors based on their geographical area for reporting and analysis purposes. |
| Vendor Region Descr. | Lief. Region Bez. | string | Shows the name or description of the region where the vendor is located. This helps group vendors by geographic area for reporting or analysis purposes. |
| Vendor County | Lieferant Landkreis | string | Shows the county where the vendor is located. Useful for identifying the vendor’s geographical area for reporting or communication purposes. |
| Vendor County Id | Lieferant Kreis Id | string | Identifies the specific county where the vendor is located. Useful for sorting or filtering vendors based on their geographic region. |
| Vendor County Descr. | Lief. Landkreis Bez. | string | Shows the name of the county where the vendor is located. This helps identify the vendor’s geographic area for reporting or communication purposes. |
| Vendor Statistics Grp. | Lief. Statistikgrp. | string | Groups vendors based on specific statistics for easier analysis and reporting. Useful for segmenting vendors by performance or other business criteria in purchasing and supplier management. |
| Vendor Statistics Grp. Id | Ld. Statistikgrp. Id | string | This field identifies the statistics group assigned to a vendor, which is used to categorize vendors for reporting and analysis purposes in Business Central. It helps businesses group vendors based on similar characteristics to track and compare their purchasing statistics. |
| Vendor Stat. Grp. Descr. | Lief. Stat. Grp. Bez. | string | Shows the description of the vendor statistics group assigned to a vendor, which helps categorize vendors for reporting and analysis purposes. This information is used to group vendors with similar characteristics or purchasing patterns. |
| ISO Code | Liefer. ISO-Code | string | Shows the international ISO code for the vendor's country or region. This helps identify the vendor's location for tax, shipping, and compliance purposes in Business Central. |