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 item in your inventory. This is used to track, manage, and reference products or materials throughout your business processes. |
| Item No. | Artikelnr. | string | This field shows the unique number assigned to each item in your inventory. It helps you identify and track specific products in Business Central. |
| Itemname | Artikelname | string | Shows the name or description of the item. This helps users quickly identify what each item is in inventory or sales documents. |
| Item Grp. | Artikelgruppe | string | Groups items into categories for easier management and reporting. Useful for organizing inventory and analyzing item sales or usage by group. |
| Item Grp. Id | Artikelgrp. Id | string | Shows the code for the item group that an item belongs to. This helps organize items into categories for reporting and inventory management in Business Central. |
| Item Grp. Descr. | Artikelgrp. Bez. | string | Shows the description of the item group to which the item belongs. This helps users identify and categorize items based on their group in inventory and sales processes. |
| Primary Vendor | Hauptlieferant | string | Shows the main vendor associated with an item. This is useful for identifying which supplier is usually used for purchasing the item in Business Central. |
| Item Prim. Vendor Id | Hauptlieferant Id | string | Shows the main vendor linked to an item, helping users identify which supplier is typically used for purchasing this product. This is useful for managing supplier relationships and streamlining the purchasing process in Business Central. |
| Primary Vendor Name | Hauptlieferant Name | string | Shows the name of the main vendor who supplies this item. Useful for identifying where the item is usually purchased from in procurement and inventory management processes. |
| Item Cost Grp. | Artikel Kosten Grp. | string | Groups items together based on similar costing methods or cost calculation rules. Useful for tracking and analyzing costs for related products in inventory. |
| Item Cost Grp. Id | Artikel Kosten Grp. Id | string | Groups items together based on cost calculation or costing rules, making it easier to manage and analyze item costs in inventory. Used to apply consistent costing methods or reporting to similar items in the system. |
| Item Cost Grp. Descr. | Artikel Kosten Grp. Bez. | string | This field shows the description of the cost group assigned to the item. It helps users understand which cost category the item belongs to for inventory valuation and reporting purposes. |
| Item Category | Artikelkategorie | string | Shows the group or category an item belongs to, helping organize and manage items in inventory for easier tracking and reporting. Used to classify products in Business Central for analysis and filtering. |
| Item Category Id | Artikelkategorie Id | string | Shows the code or identifier for the item category assigned to a product. Used to group and organize items for easier management, reporting, and filtering in the inventory. |
| Item Category Descr. | Artikelkategorie Bez. | string | Shows the name or description of the item category, helping users group and identify similar items in inventory and reporting. Used to organize items for easier searching and analysis in Business Central. |
| Item Type | Artikeltyp | string | Shows the type of item, such as inventory, service, or non-inventory. Used to identify how the item is managed and tracked in the system. |
| Item Type Id | Artikeltyp Id | string | Identifies the type or category of the item, such as inventory, service, or non-inventory. This helps businesses organize and manage items according to how they are used or tracked in the system. |
| Item Type Descr. | Artikeltyp Bez. | string | Shows the type of item, such as inventory, service, or non-inventory. This helps identify how the item is managed and used in business processes like sales, purchasing, and stock control. |
| Item Gen. Posting Grp. | Artikel Allg. Buchungs Grp. | string | This field shows which general posting group is assigned to the item. It helps define how transactions for this item are recorded in the general ledger, ensuring correct financial reporting and integration with accounting processes in Business Central. |
| Item Gen. Posting Grp. Id | Artikel Allg. Buchungs Grp. Id | string | Shows which general posting group is assigned to the item, helping determine how sales, purchases, and inventory transactions are recorded in the accounting system. Used to group items with similar accounting requirements for financial reporting in Business Central. |
| Item Gen. Posting Grp. Descr. | Artikel Buchungs Grp. Bez. | string | Shows the description of the item's general posting group, which helps define how the item is posted in financial transactions. Useful for understanding the accounting category assigned to the item. |
| Item Invent. Posting Grp. | Artikel Inventur Buchungs Grp. | string | Shows which inventory posting group is assigned to the item. This determines how inventory transactions for the item are recorded in the general ledger for accounting purposes. |
| Item Invent. Posting Grp. Id | Artikel Inventur Buchungs Grp. Id | string | This field identifies the inventory posting group assigned to the item, which determines how inventory transactions for this item are recorded in the company's general ledger. It helps link items to the correct inventory accounts for financial reporting and analysis in Business Central. |
| Item Invent. Posting Grp. Descr. | Artikel Inventur Buchungs Grp. Bez. | string | This shows the description of the inventory posting group linked to the item. It helps identify how the item’s inventory transactions are grouped and posted in the general ledger. |
| Replenishment System | Wiederbeschaff. System | string | Shows how an item is restocked, such as by purchasing, producing, or transferring. This helps decide how inventory is managed and how new stock is ordered in the system. |
| Replenishment System Id | Wiederbeschaff. Sys. Id | string | Shows which method is used to restock or reorder the item, such as purchase, production, or transfer. This helps determine how inventory for the item is managed in the system. |
| Replenishment System Descr. | Wiederbeschaff. Sys. Bez. | string | Shows the method used to restock or refill this item, such as purchasing, producing, or transferring. This helps businesses manage how each item is supplied and maintained in inventory. |
| Assembly Policy | Fertigungsrichtlinie | string | Shows the rules for how an item is assembled, such as whether it is assembled to order or to stock. This helps determine how inventory is managed and how customer orders are fulfilled in Business Central. |
| Assembly Policy Id | Fertigungsrichtl. Id | string | Shows the ID number for the assembly policy assigned to the item. This helps identify how the item is managed or assembled in production processes. |
| Assembly Policy Descr. | Fertigungsrichtl. Bez. | string | Shows a brief explanation of the assembly policy assigned to the item, helping users understand how the item is assembled or produced within the company’s processes. This can be useful for managing inventory and planning production activities. |
| Reordering Policy | Wiederbeschaffungsrichtlinie | string | Shows the method used to determine when and how much of an item should be reordered, such as fixed reorder quantity or maximum inventory. Helps businesses manage inventory levels and automate purchasing or production decisions. |
| Reordering Policy Id | Wiederbeschaffungsrichtl. Id | string | Shows which reordering policy is assigned to an item, helping to determine how inventory levels are managed and when new stock should be ordered. This is used in planning and inventory control to ensure items are replenished appropriately. |
| Reordering Policy Descr. | Wiederbeschaffungsrichtl. Bez. | string | Shows the description of the method used to determine when and how items should be reordered, helping users understand the inventory replenishment strategy set for each item. This information supports planning and restocking decisions in inventory management. |
| Critical Item | Kritischer Artikel | string | Shows whether an item is marked as critical, helping businesses identify products that require special attention or prioritization in inventory and purchasing processes. |
| Safety Stock Qty. | Sicherheitsbestand Menge | double | Shows the minimum quantity of an item that should be kept in inventory to avoid running out of stock. Used to help plan inventory levels and prevent shortages in Business Central. |
| Safety Lead Time | Sicherh.-Vorlaufzeit | string | Shows the extra days added to the usual delivery time for an item to help prevent stock shortages. Used in planning to ensure there’s enough time to receive or produce items before they are needed. |
| Lot Size | Losgröße | double | Shows the standard quantity of items to be produced or purchased in each batch. Used to plan and manage inventory levels efficiently in the item record. |
| Reorder Point | Meldebestand | double | Shows the minimum inventory level at which you should consider ordering more of the item. Helps ensure you restock before running out of stock in your business. |
| Reorder Qty. | Wiedereink.menge | double | Shows the standard amount of an item that should be ordered when stock is replenished. Used to help manage inventory levels and automate purchasing decisions in Business Central. |
| Lead Time Calc. | Lieferzeitberechnung | string | Shows how the lead time for an item is calculated, helping businesses estimate how long it will take to receive or produce the item after placing an order. This is useful for planning inventory and meeting customer delivery expectations. |
| LeadTimeDate | LeadTimeDate | dateTime | |
| LeadTimeDays | LeadTimeDays | int64 |