OrderCustomer
Dimension table for order customers
DE: Auftragskunde
Columns
| Column (EN) | Column (DE) | Type | Description |
|---|---|---|---|
| Customer Address | Adresse | string | Stores the street address of the customer related to the sales order. This helps identify where goods or services should be delivered or billed. |
| City | Stadt | string | Shows the city where the customer is located. Useful for identifying the customer's location on sales orders and for delivery or billing purposes. |
| State | Bundesland | string | Shows the state or province of the customer’s address for an order. Useful for identifying the location of customers for shipping and reporting purposes. |
| Street | Straße | string | Stores the street address for the customer associated with the order. This is used to identify the main location for delivery or correspondence. |
| Zip Code | PLZ | string | Shows the postal code for the customer associated with the order. This information helps identify the customer's delivery or billing location. |
| Country Region Id | Ländercode | string | Shows the code or identifier for the country or region linked to the customer on the order. Useful for tracking where customers are located or for grouping orders by country or region. |
| Cust. County | Landkreis (display) | string | Shows the county or region for the customer related to the order. Useful for identifying the customer's location for sales or delivery purposes. |
| Cust. County | Landkreis (kurz) | string | Shows the short name of the county where the customer is located. Useful for identifying a customer's geographic area for shipping, reporting, or sales analysis. |
| Cust. County | Landkreis (lang) | string | Shows the full name of the county where the customer is located. This helps identify the customer's region for orders and reporting purposes. |
| Customer City | Stadt (display) | string | Shows the city where the customer is located. Useful for identifying the customer’s location on sales or service orders. |
| Cust. City | Stadt (kurz) | string | Shows the city where the customer is located. Useful for identifying the customer's location related to a specific order. |
| Customer City | Stadt (lang) | string | Shows the full name of the city where the customer is located. Useful for identifying the customer's location for orders and deliveries. |
| Cust. Stat. Grp. | Statistikgruppe | string | Shows the customer statistics group assigned to the customer on the sales order. This group helps organize and analyze customers based on shared characteristics for reporting and tracking purposes in Business Central. |
| Cust. Stat. Grp. | Statistikgruppe (kurz) | string | Shows the customer statistics group, which helps categorize customers for reporting and analysis purposes. This is often used to group customers with similar sales patterns or characteristics in Business Central. |
| Cust. Stat. Grp. | Statistikgruppe (lang) | string | Groups customers based on their statistics for reporting or analysis. Useful for segmenting customers to review sales trends or customer activity in Business Central. |
| Customer | Kunde | string | Shows the customer linked to an order, helping identify which company or person placed the order. This is useful for tracking sales and managing customer relationships. |
| Customer No. | Kundennr. | string | This field shows the unique number assigned to each customer. It helps identify and track customers when managing sales orders and related transactions. |
| Customer Name | Kundenname | string | Shows the name of the customer associated with the order. Useful for identifying which customer placed or is linked to a specific order. |
| ISO Code | ISO Code | string | Shows the international code for the customer's country or region on the order. This helps identify the customer's location for shipping and reporting purposes. |
| Cust. Posting Grp. | Kd. Buchungs Grp. | string | Shows which customer posting group is assigned to the customer for the order. Used to determine how sales and receivables transactions are posted in the accounting system. |
| Cust. Posting Grp. Id | Kd. Buchungs Grp. Id | string | Identifies the posting group assigned to the customer, which determines how sales transactions for this customer are categorized in the company's financial accounts. Used to ensure correct financial posting and reporting for sales and receivables. |
| Cust. Posting Grp. Descr. | Kd. Buchungs Grp. Bez. | string | This field shows the description of the customer posting group assigned to the sales order. It helps users understand how the transaction will be categorized in accounting and which accounts will be used for posting related entries. |
| Cust. Price Grp. | Kd. Preisgrp. | string | This field indicates the price group assigned to the customer, which helps determine special pricing or discounts for sales orders. It is used to group customers with similar pricing terms in Business Central. |
| Cust. Price Grp. Id | Kd. Preisgrp. Id | string | Shows the code for the customer price group linked to the order. This helps identify which pricing rules or discounts apply to the customer when processing the order in Business Central. |
| Cust. Price Grp. Descr. | Kd. Preisgrp. Bez. | string | Describes the customer price group assigned to the order, which helps determine the pricing and discounts that apply for the customer. Useful for understanding which pricing rules are being used for this transaction. |
| Cust. Disc. Grp. | Kd. Rabattgrp. | string | Shows the discount group assigned to the customer, which helps determine which sales discounts apply to their orders. This is used to group customers for special pricing or promotions in sales processes. |
| Cust. Disc. Grp. Id | Kd. Rabattgrp. Id | string | Identifies the discount group assigned to the customer, which is used to determine special pricing or discount agreements for sales orders in Business Central. This helps apply consistent discounts to customers who belong to the same group. |
| Cust. Disc. Grp. Descr. | Kd. Rabattgrp. Bez. | string | Shows the description of the customer discount group assigned to the order. This helps identify the type of discount or pricing group that applies to the customer for this transaction. |
| Country | Land | string | Customer Region (=Country) |
| Cust. Region Id | Kd. Region Id | string | Identifies the region assigned to the customer for the order. This is useful for grouping sales or analyzing customer activity by geographic area. |
| Country Description | Land (Name) | string | Shows the full name of the country or region for the customer on the order. This helps identify where the customer is located, which can be useful for shipping, reporting, or compliance purposes. |
| First Order | Erster Auftrag | dateTime | Shows the date when the customer placed their very first order. This helps businesses identify when a customer started buying from them. |
| FirstOrderMonth = IF(OrderCustomer[FirstOrderDate]=BLANK(),date(1900,01,01), DATE(YEAR(OrderCustomer[FirstOrderDate]), MONTH(OrderCustomer[FirstOrderDate]), 1)) | FirstOrderMonth = IF(OrderCustomer[FirstOrderDate]=BLANK(),date(1900,01,01), DATE(YEAR(OrderCustomer[FirstOrderDate]), MONTH(OrderCustomer[FirstOrderDate]), 1)) | ||
| Last Order | Letzter Auftrag | dateTime | Date of last order |