Item
Dimension table for items
DE: Artikel
Columns
| Column (EN) | Column (DE) | Type | Description |
|---|---|---|---|
| Item | Item | string | |
| ItemId | ItemId | string | |
| ItemDescription | ItemDescription | string | |
| ItemGroup | ItemGroup | string | |
| ItemGroupId | ItemGroupId | string | |
| ItemGroupDescription | ItemGroupDescription | string | |
| ItemPrimaryVendor | ItemPrimaryVendor | string | |
| ItemPrimaryVendorId | ItemPrimaryVendorId | string | |
| ItemPrimaryVendorName | ItemPrimaryVendorName | string | |
| ItemCostGroup | ItemCostGroup | string | |
| ItemCostGroupId | ItemCostGroupId | string | |
| ItemCostGroupDescription | ItemCostGroupDescription | string | |
| ItemCategory | ItemCategory | string | |
| ItemCategoryId | ItemCategoryId | string | |
| ItemCategoryDescription | ItemCategoryDescription | string | |
| ItemType | ItemType | string | |
| ItemTypeId | ItemTypeId | string | |
| ItemTypeDescription | ItemTypeDescription | string | |
| ItemGenPostingGroup | ItemGenPostingGroup | string | |
| ItemGenPostingGroupId | ItemGenPostingGroupId | string | |
| ItemGenPostingGroupDescription | ItemGenPostingGroupDescription | string | |
| ItemInventPostingGroup | ItemInventPostingGroup | string | |
| ItemInventPostingGroupId | ItemInventPostingGroupId | string | |
| ItemInventPostingGroupDescription | ItemInventPostingGroupDescription | string | |
| ReplenishmentSystem | ReplenishmentSystem | string | |
| ReplenishmentSystemId | ReplenishmentSystemId | string | |
| ReplenishmentSystemDescription | ReplenishmentSystemDescription | string | |
| AssemblyPolicy | AssemblyPolicy | string | |
| AssemblyPolicyId | AssemblyPolicyId | string | |
| AssemblyPolicyDescription | AssemblyPolicyDescription | string | |
| ClientBK | ClientBK | string | |
| ReorderingPolicy | ReorderingPolicy | string | |
| ReorderingPolicyId | ReorderingPolicyId | string | |
| ReorderingPolicyDescription | ReorderingPolicyDescription | string | |
| CritialItem | CritialItem | string | |
| SafetyStockQuantity | SafetyStockQuantity | double | |
| SafetyLeadTime | SafetyLeadTime | string | |
| LotSize | LotSize | double | |
| ReorderPoint | ReorderPoint | double | |
| ReorderQuantity | ReorderQuantity | double | |
| LeadTimeCalculation | LeadTimeCalculation | string | |
| Lead Time Date | Lieferzeit-Datum | dateTime | Shows the expected date on which an item becomes available, based on its replenishment lead time. Useful for planning purchasing and availability. |
| Lead Time (Days) | Lieferzeit (Tage) | int64 | Shows the number of days needed to replenish an item, from order to availability. Useful for planning reorder timing and analyzing supplier lead times. |