CycleCountDefinitionscountCategoryItems
Manages specific items within categories to be included in cycle counts.
Columns
| Name | Type | Description |
| CycleCountDefinitionsCycleCountHeaderId [KEY] | Long | The unique identifier linking the cycle count definition to its associated category items. This identifier ensures that inventory items are accurately tracked and categorized within the cycle counting process. |
| CountCategoryItemId [KEY] | Long | The unique identifier for the specific inventory item within a count category that is included in the cycle count definition. This identifier ensures each item is properly classified and accounted for during the cycle count. |
| InventoryItemId | Long | The unique identifier assigned to the inventory item within the count category. This identifier ensures precise tracking of stock levels, classification, and compliance with inventory control policies. |
| ItemNumber | String | The alphanumeric code that uniquely identifies the inventory item within the count category. This code is used for stock tracking, reporting, and facilitating item identification during physical inventory checks. |
| 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 identifying and verifying stock during cycle counts. |
| CategoryId | Long | The unique identifier for the count category to which this inventory item belongs. This identifier ensures proper classification and accurate tracking in cycle counting operations. |
| CategoryName | String | The name of the count category that includes this inventory item. This name defines how it is grouped for cycle counting. Examples include 'High-Value Items', 'Fast-Moving Stock', or 'Critical Parts'. |
| CategoryDescription | String | A brief description of the count category that includes this inventory item,. This description explains the count category's role in classification, stock management, and cycle counting strategies. |
| AdjustmentValuePositiveTolerance | Decimal | The maximum positive variance allowed in the inventory valuation for this category item before requiring approval. This metric ensures financial accuracy and prevents overstatement of inventory value. |
| AdjustmentValueNegativeTolerance | Decimal | The maximum negative variance allowed in the inventory valuation for this category item before requiring approval. This metric control helps prevent inventory devaluation errors and unauthorized stock adjustments. |
| QuantityVariancePositivePercentage | Decimal | The maximum positive percentage variance allowed between the expected and actual quantity counted for this category item before triggering an exception. This metric helps in detecting overstatements in stock counts. |
| QuantityVarianceNegativePercentage | Decimal | The maximum negative percentage variance allowed between the expected and actual quantity counted for this category item before triggering an exception. This metric is useful for identifying potential stock shortages or losses. |
| LastScheduledDate | Datetime | The date when this category item was last scheduled for a cycle count. This date provides a historical reference for past inventory audits and helping plan future cycle count schedules. |
| IncludeInScheduleFlag | Bool | Indicates whether this category item should be included in the cycle count schedule. If set to 'true', the item is scheduled for counting; if set to 'false', it is excluded. The default value is 'false', ensuring manual control over inventory counting schedules. |
| BindCycleCountName | String | The cycle count name associated with the bound record, ensuring proper linkage between cycle count definitions and count category items. This name supports structured tracking and reporting in cycle counting workflows. |
| BindOrganizationCode | String | The organization code 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 category item. This linkage ensures that inventory adjustments and stock reconciliations are properly recorded in cycle counting configurations. |
| Finder | String | A searchable reference key used to locate specific cycle count category items within the system. This reference key improves lookup efficiency, allowing users to quickly retrieve relevant records for auditing and reporting. |
| 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 ensures that inventory adjustments are accurately attributed to the correct stock location. |