Customer

Dimension table for customers

DE: Kunde

Columns

Column (EN)	Column (DE)	Type	Description
Customer	Kunde	string	Shows the name or number used to identify a customer in the system. This helps users find or select the correct customer when managing sales, invoices, or customer records.
Customer No.	Kundennr.	string	Shows the unique number used to identify each customer in the system. This number helps users track customer accounts and related transactions.
Customer Name	Kd. Name	string	Shows the full name of the customer. Used to identify each customer in sales, invoices, and other customer-related transactions.
Customer Address	Kd. Adresse	string	Stores the full address details of a customer, such as street, city, and postal code. Used to identify where the customer is located for shipping, billing, and communication purposes.
Customer City	Kd. Ort	string	Shows the city where the customer is located. This information helps identify the customer's address for deliveries, billing, or communication purposes.
Customer State	Kd. Staat	string	Shows the state or province where the customer is located. This helps identify the customer's address for shipping, billing, or reporting purposes.
Customer Street	Kd. Straße	string	Stores the street address of the customer, used for identifying the physical location for deliveries, billing, or correspondence. This helps ensure accurate communication and service to the customer.
Zip Code	PLZ	string	Stores the postal or ZIP code for the customer’s address, which helps identify their location for shipping and billing purposes. Commonly used when sending invoices or deliveries to customers.
Country Region Id	Kd. Land/Region Id	string	Shows the code that identifies the customer's country or region. This helps determine the customer's location for shipping, tax, and reporting purposes.
ISO Code	ISO-Code	string	Stores the international standard country or region code for the customer. This helps identify the customer's location for purposes such as shipping, taxation, or reporting.
Cust. Posting Grp.	Kd. Buchungs Grp.	string	Groups customers based on how their transactions are posted in the general ledger. This helps determine which accounts are used for sales, receivables, and other postings related to the customer.
Cust. Posting Grp. Id	Kd. Buchungsgrp. Id	string	Identifies the posting group assigned to a customer, which determines how sales transactions for that customer are posted in the accounting system. Used to group customers with similar accounting needs for easier financial management and reporting.
Cust. Posting Grp. Descr.	Kd. Buchungs Grp. Bez.	string	This field shows the description of the posting group assigned to the customer, which helps determine how transactions for this customer are recorded in the general ledger. It provides a clear label for the posting group used in financial reporting and analysis.
Cust. Price Grp.	Kd. Preisgrp.	string	Groups customers together for special pricing or discounts. Useful for managing price agreements or campaigns for sets of customers with similar pricing terms in Business Central.
Cust. Price Grp. Id	Kd. Preisgrp. Id	string	Identifies the price group assigned to a customer, which determines the special pricing or discounts they receive. This helps group customers with similar pricing agreements for easier management.
Cust. Price Grp. Descr.	Kd. Preisgrp. Bez.	string	This field shows the description of the customer's price group. It helps users identify and manage special pricing or discount groups assigned to customers for sales and pricing purposes.
Cust. Disc. Grp.	Kd. Rabattgrp.	string	Groups customers together for discount purposes. Used to apply the same special pricing or discount terms to multiple customers in sales transactions.
Cust. Disc. Grp. Id	Kd. Rabattgrp. Id	string	This field identifies the discount group that a customer belongs to, which is used to determine special pricing or discounts for that customer. It helps group customers with similar discount agreements for easier management of sales pricing.
Cust. Disc. Grp. Descr.	Kd. Rabattgrp. Bez.	string	Shows the description of the customer's discount group, which helps identify and manage special pricing or discount arrangements for specific groups of customers. This is useful for organizing customers based on the discounts they receive.
Cust. Region	Kd. Region	string	Shows the geographical region assigned to each customer. This helps group customers by location for reporting, filtering, or targeted sales activities.
Cust. Region Id	Kd. Region Id	string	Shows the unique identifier for the region assigned to a customer, helping businesses group and manage customers by their geographic area for reporting or sales analysis.
Cust. Region Descr.	Kd. Region Bez.	string	Shows the description of the customer's assigned region, helping to identify and group customers based on their geographic area for reporting or sales analysis.
Customer County	Kd. Landkreis	string	Shows the name of the county where the customer is located. This helps identify the customer's geographic area for sales, shipping, or reporting purposes.
Cust. County	Kd. Landkreis	string	Shows the county where the customer is located. Useful for identifying the customer's regional location for sales, service, or reporting purposes.
Customer County	Kd. Landkreis	string	Shows the full name of the county where the customer is located. Useful for identifying the customer's geographic area for sales, delivery, or reporting purposes.
Customer City	Kd. Ort	string	Shows the city where the customer is located. This information helps identify the customer's address for shipping, billing, or communication purposes.
Customer City	Kd. Ort	string	Shows the city where the customer is located. Useful for identifying a customer's location for shipping, billing, or sales analysis in Business Central.
Customer City	Kd. Stadt	string	Shows the full name of the city where the customer is located. This helps identify the customer's location for shipping, billing, or sales analysis purposes.
Cust. Statistics Grp.	Kd. Statistik Grp.	string	Groups customers based on their sales and transaction statistics. Useful for analyzing customer performance and segmenting customers for reporting or marketing purposes.
Cust. Statistics Grp.	Kd. Statistikgrp.	string	Groups customers for statistical analysis and reporting purposes. Useful for segmenting customers based on shared characteristics to better understand sales trends or customer behavior.
Cust. Statistics Grp.	Kd. Statistik Grp.	string	Groups customers based on similar sales or statistical patterns to help organize and analyze customer-related data, such as sales performance or purchasing behavior. This grouping supports easier reporting and targeted business strategies in customer management.
First Order Date	Erstbestelldatum	dateTime	Shows the date when a customer placed their first order. Useful for understanding customer history and identifying new or long-term clients.
Last Order Date	Letzte Bestelldatum	dateTime	Shows the date when the customer last placed an order. This helps track recent sales activity for each customer.