InvoiceCustomer

Dimension table for invoice customers

DE: Rechnungskunde

Columns

Column (EN)	Column (DE)	Type	Description
Customer Address	Adresse	string	Stores the customer's address as shown on the invoice. Used to identify where goods or services are billed or delivered for this specific customer.
City	Stadt	string	Shows the city where the customer being invoiced is located. Useful for identifying the customer's address details on sales invoices.
State	Bundesland	string	Shows the state or region for the customer’s address on the invoice. This helps identify where the customer is located for billing and shipping purposes.
Street	Straße	string	Shows the street address for the customer linked to the invoice. This information is used to identify where the customer is located for billing and correspondence purposes.
Zip Code	PLZ	string	Shows the postal code for the customer's billing address on the invoice. This helps identify the location for mailing and record-keeping purposes.
Country Region Id	Ländercode	string	Shows the code for the customer's country or region, helping to identify where the customer is located for invoicing and reporting purposes. This is useful for sorting, filtering, and compliance with tax or shipping requirements.
Cust. County	Landkreis (display)	string	Shows the county or region where the customer is located. Useful for identifying the geographic location of customers on sales invoices.
Cust. County	Landkreis (kurz)	string	Shows the county or region for the customer related to the invoice. Useful for identifying where a customer is located for reporting or tax purposes.
Cust. County	Landkreis (lang)	string	Shows the full name of the county where the customer is located, which helps identify the customer's geographical area for sales or delivery purposes.
Cust. City	Stadt (display)	string	Shows the city where the customer is located. Useful for identifying the customer’s location on invoices and for reporting or filtering by city.
Cust. City	Stadt (kurz)	string	Shows the city where the customer is located, which helps identify the customer’s address for invoicing and shipping purposes. This information is typically used to ensure accurate billing and delivery.
Cust. City	Stadt (lang)	string	Shows the full name of the city where the customer is located. This helps identify the customer's location for billing and delivery purposes on invoices.
Cust. Statistics Grp.	Statistikgruppe	string	Groups customers based on their sales and statistics settings. Useful for organizing customers for reporting and analysis in sales and customer management.
Cust. Statistics Grp.	Statistikgruppe (kurz)	string	Groups customers based on their sales statistics, making it easier to analyze and report on customer sales trends in invoices. This helps in categorizing customers for better sales tracking and reporting in Business Central.
Cust. Statistics Grp.	Statistikgruppe (lang)	string	Groups customers based on their sales statistics, helping to categorize and analyze customers for reporting or pricing purposes in sales and invoicing. This supports better segmentation and decision-making when reviewing customer-related data.
Customer	Kunde	string	Shows the customer related to the invoice, helping identify who the invoice is billed to. This is useful for tracking sales and managing customer accounts in Business Central.
Customer No.	Kundennr.	string	Shows the unique number assigned to each customer for invoicing purposes. This number helps identify and track customer transactions in the system.
Customer Name	Kd. Name	string	Shows the full name of the customer related to the invoice. Useful for identifying which customer the invoice is for in reports and lists.
ISO Code	ISO-Code	string	Shows the international standard code for the customer's country or region, used to identify where the invoice is being sent or the customer's location. This helps with country-specific processing and reporting in Business Central.
Cust. Posting Grp.	Kd. Buchungs Grp.	string	Groups customers for accounting purposes, helping to determine which general ledger accounts are used for sales, receivables, and other transactions related to each customer. Used to manage and organize financial posting in Business Central.
Cust. Posting Grp. Id	Kd. Buchungs Grp. Id	string	This field identifies the customer posting group used for accounting purposes. It helps determine how transactions for this customer are recorded in the general ledger.
Cust. Posting Grp. Descr.	Kd. Buchungs Grp. Bez.	string	Shows the description of the customer posting group used for the invoice. This helps identify how transactions for this customer are categorized in accounting and reporting.
Cust. Price Grp.	Kd. Preisgrp.	string	Groups customers together who receive the same pricing agreements or discounts. Used to manage special pricing or offers for sets of customers in sales and invoicing.
Cust. Price Grp. Id	Kd. Preisgrp. Id	string	Shows the code for the customer price group assigned to the customer. This helps identify which pricing rules or discounts apply to the customer’s sales invoices in Business Central.
Cust. Price Grp. Descr.	Kd. Preisgrp. Bez.	string	Shows the description of the price group assigned to the customer on the invoice. This helps identify which customer price group’s pricing rules apply for the transaction.
Cust. Disc. Grp.	Kd. Rabattgrp.	string	Groups customers together for special discount offers. Used to apply specific pricing or discount rules to customers in the same group during sales and invoicing.
Cust. Disc. Grp. Id	Kd. Rabattgrp. Id	string	Identifies the discount group assigned to the customer for sales transactions. Used to determine which sales discounts apply to the customer when processing invoices in the system.
Cust. Disc. Grp. Descr.	Kd. Rabattgrp. Bez.	string	Shows the description of the customer discount group. This helps identify the type of discount applied to the customer on sales invoices.
Cust. Region	Kd. Region	string	Shows the region or area assigned to the customer for this invoice, which helps categorize customers by their location for reporting and analysis purposes. Typically used to group sales and customer data by region in Business Central.
Cust. Region Id	Kd. Region Id	string	Shows the code for the customer's region, helping to identify where the customer is located. Useful for grouping or filtering invoices by customer regions in reports.
Cust. Region Descr.	Kd. Region Bez.	string	Shows the name or description of the customer’s region. This helps identify where the customer is located for reporting and analysis purposes, such as grouping invoices by region.
First Order Date	Kd. Erstbestelldatum	dateTime	Shows the date when the customer placed their first order. Useful for understanding the length of the customer relationship and tracking new customer activity.
Last Order Date	Letztes Auftragsdatum	dateTime	Shows the date when the customer last placed an order, helping users track recent customer activity and identify when the most recent sales interaction occurred. This can be useful for monitoring customer engagement and planning follow-up actions.