Item

Dimension table for items

DE: Artikel

Columns

Column (EN)	Column (DE)	Type	Description
Item	Artikel	string	Shows the unique identifier or code for each product or item in your inventory. Useful for tracking, managing, and referencing specific items throughout your business processes.
Item id	Artikelnr	string	This field contains the unique identifier for each item in your inventory. It helps to track, manage, and reference specific products throughout the system.
Item description	Artikelbeschreibung	string	Shows the name or description of an item, helping users identify products in lists, sales orders, and reports. This information is useful for selecting and managing items in inventory or sales processes.
Item Grp.	Artikelgrp.	string	Groups items into categories for easier organization and reporting. Useful for tracking and analyzing inventory by item group in Business Central.
Item Grp. Id	Artikelgrp. Id	string	This field shows the identifier for the group to which an item belongs. It helps organize and categorize items for easier management and reporting in inventory and sales processes.
Item Grp. Descr.	Artikelgrp. Bez.	string	This shows a short description of the item group to which an item belongs. It helps users quickly identify the category or classification of the item in inventory or sales processes.
Primary Vendor	Hauptlieferant	string	Shows the main vendor assigned to an item, indicating from whom the item is usually purchased. This helps purchasing staff know the preferred supplier for reordering stock.
Primary Vendor Id	Hauptlieferant Id	string	Shows the ID of the main vendor for the item. This helps track which supplier is usually used for purchasing the item in your system.
Item Primary Vendor Name	Hauptlieferant Name	string	Shows the name of the main vendor who supplies the item. Useful for identifying the preferred supplier when purchasing or managing inventory.
Item Cost Grp.	Artikel Kosten Grp.	string	Groups items by their cost category, which helps organize and analyze inventory costs in Business Central. This is useful for reporting and managing different types of item costs.
Item Cost Grp. Id	Artikel Kosten Grp. Id	string	Groups items based on how their costs are managed, making it easier to track and analyze item costs for reporting and accounting purposes. Often used to apply specific costing rules or methods to related items in the system.
Item Cost Grp. Descr.	Artikel Kosten Grp. Bez.	string	Shows the description of the cost group assigned to an item. This helps users understand how the item’s costs are categorized for inventory and reporting purposes in Business Central.
Item category	Artikelkategorie	string	Shows the group or category assigned to an item, helping to organize and classify products for easier management and reporting in your inventory. Commonly used to filter and sort items in sales, purchasing, and inventory processes.
Item category id	ArtikelkategorieId	string	This field stores the unique identifier for the item’s category, helping group similar items together for easier organization and reporting in inventory management. It is useful when filtering or analyzing items by their assigned category in Business Central.
Item category description	Artikelkategoriebeschreibung	string	Shows the description or name of the category assigned to an item. Helps group and identify items based on their category for easier management and reporting.
Item type	Artikeltyp	string	Shows whether the item is a product, service, or resource. This helps users categorize and manage different types of inventory or offerings in the system.
Item type id	Artikeltyp Id	string	Identifies the type of item, such as inventory, service, or non-inventory, to help categorize and manage items in the system. This is useful for tracking how each item should be handled in purchasing, sales, and inventory processes.
Item type description	Artikeltyp Beschreibung	string	Shows the type of item, such as inventory, service, or non-inventory. Helps users understand how the item is managed in the system and its purpose in business processes.
Item Gen. Posting Grp.	Artikel Gen. Buchungs Grp.	string	Groups items for general posting purposes, helping to determine how inventory transactions are recorded in the general ledger. Used to assign the correct accounts for inventory, sales, and purchase postings in Business Central.
Item Gen. Posting Grp. Id	Artikel Gen. Buchungs Grp. Id	string	Shows which inventory posting group is linked to the item. Used to determine how the item’s transactions are posted in the general ledger for inventory accounting purposes.
Item Gen. Posting Grp. Descr.	Artikel Gen. Buchungsgrp. Bez.	string	Shows the description of the general posting group assigned to the item, which helps determine how sales, purchases, and inventory transactions for this item are posted in the general ledger. This information is useful for accounting and financial reporting purposes.
Item Invent. Posting Grp.	Artikel Inventur Buchungs Grp.	string	Shows which inventory posting group the item belongs to. This determines how inventory transactions for the item are posted to the general ledger in Business Central.
Item Invent. Posting Grp. Id	Artikel Invent. Buchungsgrp. Id	string	This field stores the code for the Inventory Posting Group assigned to the item. It determines how inventory transactions for this item are posted to the general ledger, helping organize and track inventory value in financial accounts.
Item Invent. Posting Grp. Descr.	Artikel Buchungsgrp. Bez.	string	This field shows a description of the inventory posting group assigned to the item. It helps users understand how the item is categorized for inventory posting purposes in financial and inventory transactions.
Replenishment System	Beschaffungsmethode	string	Shows how items are restocked, such as by purchasing, producing, or transferring from another location. Helps determine the method used to ensure inventory is available when needed.
Replenishment System Id	Beschaffungsmethoden Id	string	Shows which method is used to restock or refill an item, such as purchase, production, or transfer. This helps businesses manage how inventory is replenished in Business Central.
Replenishment System Descr.	Beschaffungsmethode	string	Shows the method used to restock or supply the item, such as purchasing, production, or transfer. This helps users understand how inventory for the item is managed in the system.
Assembly Policy	Montage-Richtlinie	string	Shows how an item is handled for assembly, such as whether it is assembled to order or to stock. This helps businesses manage how and when items are put together based on sales or inventory needs.
Assembly Policy Id	Montagepolicy Id	string	Shows the identifier for the assembly policy linked to an item. Used to define how the item is assembled, which helps manage inventory and production processes in the business.
Assembly Policy Descr.	Assembly-Policy Bez.	string	Shows the description of the assembly policy for the item, indicating how the item is handled in assembly orders. Useful for understanding if the item is assembled to order or to stock.
Reordering Policy	Wiederbeschaffungsverfahren	string	Shows how inventory is managed for an item, such as whether stock is reordered based on a fixed quantity or other rules. Helps determine how and when to restock items to meet demand.
Reordering Policy Id	Umlagerungsrichtl. Id	string	Shows the type of reordering method set for an item, which helps determine how inventory levels are maintained and when to reorder stock. Used to guide inventory planning and automatic replenishment decisions.
Reordering Policy Descr.	Wiederbeschaffungsrichtl. Bez.	string	This field shows the method used to decide when and how much of an item to reorder, such as Fixed Reorder Quantity or Maximum Quantity. It helps businesses manage their inventory by describing the rule that guides replenishment for each item.
Critical Item	Krit. Artikel	string	Shows whether an item is considered critical for business operations, which can help prioritize purchasing, inventory, or production decisions in Business Central. This helps users quickly identify important items that may need special attention.
Safety Stock Quantity	Sicherheitsbestand	double	Shows the minimum quantity of an item that should be kept in stock to avoid running out. Used to help plan inventory levels and prevent shortages.
Safety Lead Time	Sicherh. Vorlaufzeit	string	Shows the number of days added to the expected delivery or production time to help prevent stock shortages. This value is used to ensure items are available when needed by allowing extra time for unexpected delays.
Lot Size	Losgröße	double	Shows the typical quantity used for ordering or producing an item in one batch. Helps businesses plan inventory and production more efficiently by grouping items into manageable lots.
Reorder Point	Meldebestand	double	Shows the minimum stock level for an item before you need to reorder. Helps businesses ensure they have enough inventory by signaling when it's time to restock.
Reorder Quantity	Bestellmenge	double	Shows the minimum quantity of an item that should be ordered when replenishing stock. This helps ensure efficient inventory management by avoiding frequent small orders.
Lead Time Calculation	Beschaffungszeit	string	Shows the amount of time it usually takes to receive or produce an item after ordering. This helps businesses plan when to order or make items to avoid running out of stock.
Client BK	Client BK	string	Shows the unique identifier or code for the client related to the item. This helps track which client an item is associated with for sales or inventory purposes.
LeadTimeDate	LeadTimeDate	dateTime
LeadTimeDays	LeadTimeDays	int64