Stockkeeping Unit
The Stockkeeping Unit dimension of the Demand Planning semantic model.
DE: Lagerhaltungseinheiten
Columns
| Column (EN) | Column (DE) | Type | Description |
|---|---|---|---|
| Item Id | Artikelnr. | string | This field shows the unique identification code for each item in a specific location or variant. It is used to track and manage inventory items individually within the Stockkeeping Unit (SKU) records in Business Central. |
| Item Description | Artikelbeschreibung | string | Shows the name or short description of the item for this stockkeeping unit, helping users quickly identify what the item is. This is useful for understanding what is being managed or tracked in inventory records. |
| Location Id | Lagercode | string | Identifies the specific warehouse or location where a particular inventory item is stored. Used to track and manage stock levels for each item at different locations within the company. |
| Location | Lagerort | string | Shows the name or description of the location where the stock is stored. Useful for identifying where inventory for a specific stockkeeping unit (SKU) is kept within the warehouse or business. |
| Replenishment System | Beschaffungsmethode | string | Shows the method used to restock this item, such as purchasing, production, or transfer. Helps determine how inventory for this item will be replenished in the warehouse. |
| Replenishment System Id | Beschaffungsmethoden Id | string | Shows the type of method used to restock inventory for a specific item in a location, such as purchase, transfer, or production. This helps determine how and where new stock for the item will be supplied when needed. |
| Replenishment System Descr. | Beschaffungsmethode (Name) | string | Shows the method used to restock this item, such as purchasing or production. Helps determine how inventory is replenished for this specific stockkeeping unit in the system. |
| Manufacturing Policy | Produktionsart | string | Shows the production method set for the item in this location, such as whether it is made to order or made to stock. This helps determine how inventory is planned and managed for each item in the warehouse. |
| Manufacturing Policy Id | Produktionsart Id | string | This field shows which manufacturing policy is assigned to the specific stockkeeping unit (SKU). It helps determine how the item is produced or replenished, such as whether it is made to stock or made to order. |
| Manufacturing Policy Desc. | Produktionsart (Name) | string | Shows the description of the manufacturing policy for a stockkeeping unit (SKU). This helps identify how the item is produced or replenished, such as whether it is made to order or made to stock, supporting planning and inventory decisions in Business Central. |
| Reordering Policy | Wiederbeschaffungsverfahren | string | Shows the method used to determine how and when inventory for this item should be replenished, such as Fixed Order Quantity or Maximum Quantity. Helps businesses manage stock levels by defining the rules for ordering new inventory. |
| Reordering Policy Id | Wiederbeschaffungsverfahrens Id | string | Identifies the type of reordering policy used for a specific stockkeeping unit (SKU), such as Fixed Reorder Quantity or Maximum Quantity. This helps determine how inventory is managed and replenished for the item in Business Central. |
| Reordering Policy Description | Wiederbeschaffungsverfahren (Name) | string | Describes the method used to determine how and when new inventory should be ordered for a specific item at a location. This helps businesses manage stock levels efficiently by explaining the replenishment approach set for each stockkeeping unit. |
| Safety Stock Quantity | Sicherheitsbestand | double | Shows the minimum quantity of an item that should be kept in stock to avoid running out. Used for planning inventory levels and making sure there is always enough supply to meet demand. |
| Safety Lead Time | Sicherh. Vorlaufzeit | string | Shows the number of days added to the usual delivery time to help prevent stock shortages. This is used to ensure items are available in time by accounting for possible delays in the supply process. |
| Reorder Point | Meldebestand | double | Shows the minimum quantity of an item that should be in stock before a new order is triggered. This helps ensure you reorder items before running out, supporting smooth inventory management. |
| Reorder Qty | Bestellmenge | double | Shows the minimum number of units to order when replenishing inventory for a specific item and location. Used to help manage stock levels efficiently and reduce ordering costs in Business Central. |
| Order Multiple | Bestellmultipl. | double | Shows the minimum quantity of an item that should be ordered at one time for a specific location or variant. Helps ensure that purchase or production orders meet supplier or internal batch requirements. |
| Max. Inventory | Maximalbestand | double | Shows the highest quantity of an item that should be kept in stock for a specific location or variant. Helps manage inventory levels and avoid overstocking in Business Central’s Stockkeeping Unit (SKU) records. |
| Max. Order Qty | Max. Losgröße | double | Shows the largest quantity of an item that can be ordered at one time for a specific location or variant. This helps control inventory levels and prevents ordering more than what is practical or allowed for each stockkeeping unit. |
| Min. Order Qty | Min. Losgröße | double | Shows the smallest number of units you can order for a specific item at a given location or variant. Useful for managing purchasing or production quantities in line with supplier or internal requirements. |
| Lot Size | Losgröße | double | Shows the standard quantity of an item that is usually produced, purchased, or transferred at one time for a specific location or variant. This helps plan and manage inventory by setting typical order or production amounts for each stockkeeping unit. |
| Lot Accumulation Period | Loskumulierungsperiode | string | Shows the number of days during which demand is grouped together to create a single lot for purchasing or production. Used in inventory planning to optimize order quantities and reduce costs in Business Central. |
| Lead Time Calc. | Lieferzeitkalk. | string | Shows the time needed to replenish or produce an item in a specific location or variant. Used to plan when inventory will be available based on supply processes in Business Central. |
| Client BK | Client BK | string | Shows the unique code or reference for the client associated with this stockkeeping unit (SKU). Useful for identifying which customer a specific SKU is linked to in inventory management. |
| 'ABC Group' = | 'ABC Group' = | ||
| CV = | CV = | ||
| 'CV Rank' = | 'CV Rank' = | ||
| 'XYZ Group' = | 'XYZ Group' = | ||
| 'ABC Rank' = | 'ABC Rank' = | ||
'ABC Rank (Qty)' = | 'ABC Rank (Qty)' = |
|||
'cum % of ClientTTL (Qty)' = | 'cum % of ClientTTL (Qty)' = |
|||
| 'ABC Group (Qty)' = IF(StockkeepingUnit[cum % of ClientTTL (Qty)] <= 70, "A", IF(StockkeepingUnit[cum % of ClientTTL (Qty)] <= 90, "B", "C")) | 'ABC Group (Qty)' = IF(StockkeepingUnit[cum % of ClientTTL (Qty)] <= 70, "A", IF(StockkeepingUnit[cum % of ClientTTL (Qty)] <= 90, "B", "C")) | ||
'cum % of ClientTTL (Amount)' = | 'cum % of ClientTTL (Amount)' = |
|||
| 'ABC Rank (Amount)' = RANKX(FILTER(StockkeepingUnit, StockkeepingUnit[ClientBK]=EARLIER(StockkeepingUnit[ClientBK])), StockkeepingUnit[cum % of ClientTTL (Amount)], ,ASC, Dense) | 'ABC Rank (Amount)' = RANKX(FILTER(StockkeepingUnit, StockkeepingUnit[ClientBK]=EARLIER(StockkeepingUnit[ClientBK])), StockkeepingUnit[cum % of ClientTTL (Amount)], ,ASC, Dense) | ||
| 'ABC Group (Amount)' = IF(StockkeepingUnit[cum % of ClientTTL (Amount)] <= 70, "A", IF(StockkeepingUnit[cum % of ClientTTL (Amount)] <= 90, "B", "C")) | 'ABC Group (Amount)' = IF(StockkeepingUnit[cum % of ClientTTL (Amount)] <= 70, "A", IF(StockkeepingUnit[cum % of ClientTTL (Amount)] <= 90, "B", "C")) | ||
| SKU | SKU | string | Stockkeeping Unit (Item | [Variant] | [Location]) |
| 'ABC-XYZ Group' = StockkeepingUnit[ABC Group] & "-" & StockkeepingUnit[XYZ Group] | 'ABC-XYZ Group' = StockkeepingUnit[ABC Group] & "-" & StockkeepingUnit[XYZ Group] | string | |
| Lot-Accumulation period | Los-Akkumulierungsperiode | int64 | |
| Earliest date of replenishment | Ehest. Wiederbeschaffungstermin | dateTime | |
| LT (d) acc. ERP | VZ (T) lt. ERP | int64 | Lead Time in Days acc. ERP |