CycleCountDefinitionscountCategories
Handles item categories available for use in cycle count processes within the warehouse.
Columns
| Name | Type | Description |
| CycleCountDefinitionsCycleCountHeaderId [KEY] | Long | The unique identifier linking the cycle count definition to its associated count categories. This identifier ensures that inventory items are properly classified and counted according to predefined cycle counting rules. |
| CountCategoryId [KEY] | Long | The unique identifier for the specific cycle count category. This identifier groups inventory items based on predefined classification criteria, such as high-value items, fast-moving stock, or specific product types. |
| CategoryId | Long | The unique identifier for the inventory category included in the cycle count. This identifier ensures accurate classification, reporting, and application of cycle counting rules. |
| CategoryName | String | The name of the inventory category included in the cycle count.This name provides a recognizable label that helps in organizing and analyzing stock based on business-defined classifications. |
| CategoryDescription | String | A brief description of the inventory category included in the cycle count, explaining its purpose and relevance, such as 'High-Value Items' or 'Critical Spare Parts' to guide warehouse operations. |
| CountsPerYear | Long | The number of times per year that inventory items in this category are scheduled for cycle counting. This information ensures periodic stock verification to maintain accurate inventory records and reduce discrepancies. |
| QuantityVariancePositivePercentage | Decimal | The maximum positive percentage variance allowed between the expected and actual quantity counted for this category before triggering an exception. This metric helps enforce accuracy in inventory audits and prevent overstatements of stock levels. |
| QuantityVarianceNegativePercentage | Decimal | The maximum negative percentage variance allowed between the expected and actual quantity counted for this category before triggering an exception. This metric helps identify inventory shrinkage, potential theft, or miscounts. |
| AdjustmentValuePositiveTolerance | Decimal | The maximum positive percentage variation allowed in the inventory value for items in this category before requiring approval or an adjustment. This metric control helps ensure financial accuracy and prevent overvaluation of stock. |
| AdjustmentValueNegativeTolerance | Decimal | The maximum negative percentage variation allowed in the inventory value for items in this category before requiring approval or an adjustment. This metric helps identify understatements in inventory valuation and supports accurate financial reporting. |
| HitAndMissPostivePercentage | Decimal | The maximum positive percentage tolerance used in hit-or-miss analysis for this count category. This metric defines acceptable overages in inventory counts before requiring further investigation or system adjustments. |
| HitAndMissNegativePercentage | Decimal | The maximum negative percentage tolerance used in hit-or-miss analysis for this count category. This metric defines acceptable shortfalls before triggering alerts for review and corrective action. |
| BindCycleCountName | String | The cycle count name associated with the bound record. This name ensures proper linkage of cycle count definitions and count categories. This helps maintain structured cycle counting practices within inventory management. |
| BindOrganizationCode | String | The unique alphanumeric code for the organization associated with the bound record. This code ensures accurate reference in cycle count definitions for businesses operating in multi-organization environments. |
| CycleCountHeaderId | Long | The unique identifier linking the cycle count header to the count category. This identifier ensures a structured association between the cycle count configuration and the categorized inventory items being counted. |
| Finder | String | A searchable reference key used to quickly locate specific cycle count categories within the system. This reference key improves operational efficiency and navigation during stock auditing and reconciliation. |
| ItemDescription | String | A brief description of the inventory item included in the cycle count category. This description provides additional details for warehouse personnel to assist in physical verification and stock classification. |
| ItemNumber | String | The unique alphanumeric identifier assigned to an inventory item in the cycle count category. This identifier ensures accurate product tracking and validation against system records during cycle counts. |
| Subinventory | String | The subinventory location where the cycle count is performed, defining the specific warehouse, storage area, or bin where categorized items are counted. This information supports accurate location-based inventory tracking and reconciliation. |