Customer

The Customer dimension of the Demand Planning semantic model.

DE: Kunde

Columns

Column (EN)	Column (DE)	Type	Description
Address	Adresse	string	Shows the address details for each customer, such as street and number. This information helps businesses know where to send orders, invoices, or other communications.
City	Stadt	string	Shows the city where the customer is located. Useful for identifying the customer's address and grouping customers by region.
State	Bundesland	string	Shows the state or province where the customer is located, useful for filtering and organizing customers by their geographic region. Often used for sales analysis, reporting, and shipping purposes in Business Central.
Street	Straße	string	Shows the main street address where the customer is located. This information is used for mailing, delivery, and contact purposes.
Zip Code	PLZ	string	Shows the postal code for a customer’s address. Used to identify the customer’s location for shipping, billing, and reporting purposes in Business Central.
Country/Region Id	Ländercode	string	Shows the code for the customer's country or region, helping identify where the customer is located for reporting, shipping, or compliance purposes.
County	Landkreis (display)	string	Shows the county where the customer is located, helping to identify the customer's geographic area for reporting and analysis. Useful for segmenting customers by location.
County	Landkreis (kurz)	string	Shows the county where the customer is located, which helps in identifying the customer's address and region for sales, shipping, or reporting purposes.
County	Landkreis (lang)	string	Shows the full county name for the customer’s address. Useful for identifying where customers are located and for reporting or filtering by region.
City	Stadt (display)	string	Shows the city where the customer is located. Useful for identifying customer locations and organizing sales or service activities by region.
City	Stadt (kurz)	string	Shows the city where the customer is located. Useful for sorting or filtering customers based on their geographic location.
City	Stadt (lang)	string	Shows the city where the customer is located, helping users identify the customer's address for shipping, billing, or communication purposes. This information is typically used when managing customer records in Business Central.
Cust. Stat. Grp.	Statistikgruppe	string	Shows which statistics group a customer belongs to, helping businesses organize and report customer data based on specific categories for analysis and management in Business Central.
Cust. Stat. Grp.	Statistikgruppe (kurz)	string	Shows the customer statistics group assigned to each customer, which helps organize and analyze customers based on specific business criteria for reporting and decision-making in Business Central.
Cust. Stat. Grp.	Statistikgruppe (lang)	string	Shows the customer statistics group, which helps organize customers for reporting and analysis purposes, such as grouping by sales performance or region. Useful for segmenting customers and understanding their activity within the business.
Customer	Kunde	string	Shows the name or identifier of a customer. Used to track and manage information related to each customer in your business records.
Customer No.	Kundennr.	string	This field stores the unique number assigned to each customer in the system. It helps identify and track individual customers for sales, invoicing, and reporting purposes.
Customer Name	Kd. Name	string	Stores the full name of a customer as recorded in the system. This information is used to identify and display customer details in sales and reporting processes.
Cust. Posting Grp.	Kd. Buchungs Grp.	string	Shows the posting group assigned to the customer, which determines how transactions are recorded in the financial accounts. Used to organize customers by accounting rules for reporting and posting purposes in Business Central.
Cust. Posting Grp. Id	Kd. Buchungs Grp. Id	string	Identifies which posting group is assigned to the customer, helping to determine how transactions for this customer are recorded in accounting. Useful for managing how sales and receivables are posted in financial reports.
Cust. Posting Grp. Descr.	Kd. Buchungs Grp. Bez.	string	Shows the description of the posting group assigned to a customer. This helps identify how financial transactions for the customer are categorized in accounting records.
Cust. Price Grp.	Kd. Preisgrp.	string	Shows the price group assigned to the customer, which helps determine special pricing or discounts for sales. Used to manage customer-specific pricing agreements in sales transactions.
Cust. Price Grp. Id	Kd. Preisgrp. Id	string	Shows the price group assigned to the customer, which is used to determine special pricing or discounts for sales orders. This helps manage customer-specific pricing arrangements in Business Central.
Cust. Price Grp. Descr.	Kd. Preisgrp. Bez.	string	Shows the description of the customer's price group, which helps identify the pricing category assigned to the customer for sales transactions. This information can be used to understand and manage customer-specific pricing policies.
Cust. Disc. Grp.	Kd. Rabattgrp.	string	Shows the discount group assigned to the customer, which helps determine the discounts they are eligible for on sales orders and invoices in Business Central. This is used to group customers with similar pricing agreements.
Cust. Disc. Grp. Id	Kd. Rabattgrp. Id	string	Shows the discount group assigned to a customer, which helps determine which price discounts or offers apply to their sales transactions. This is used to group customers for easier management of sales discounts in Business Central.
Cust. Disc. Grp. Descr.	Kd. Rabattgrp. Bez.	string	Shows the description of the customer's discount group, which helps identify the type of discounts or pricing group assigned to a customer. Useful for understanding which discount policies apply when selling to this customer.
Cust. Region	Kd. Region	string	Shows the geographic region assigned to a customer. This helps businesses group customers by location for reporting or targeted marketing.
Cust. Region Id	Kd. Region Id	string	Shows the region code assigned to the customer, helping identify where the customer is located for sales analysis or reporting. Used to group customers by geographic region in Business Central.
Cust. Region Descr.	Kd. Region Bez.	string	Shows the description of the customer’s assigned region, which helps group customers based on their geographic location for reporting or sales analysis. Useful for understanding where customers are located and managing regional sales strategies.
ISO Code	ISO-Code	string	Shows the international code for the customer's country or region, often used for identifying country standards in shipping, reporting, or compliance. This helps businesses manage customers across different locations in a consistent way.
First Order Date	Erstauftragsdatum	dateTime	Shows the date when a customer placed their first order. This helps track customer relationships and analyze how long customers have been buying from your company.
Last Order Date	Letzte Auftrag Dat.	dateTime	Shows the date when the customer placed their most recent order. Useful for tracking customer activity and identifying recent purchasing trends.