CycleCountDefinitionscountItems
Tracks individual items designated for cycle counting within the warehouse.
Columns
Name | Type | Description |
CycleCountDefinitionsCycleCountHeaderId [KEY] | Long | The unique identifier linking the cycle count definition to its associated inventory items. This identifier ensures accurate tracking and organization. |
CycleCountItemId [KEY] | Long | The unique identifier assigned to the specific inventory item included in the cycle count definition. |
InventoryItemId | Long | The unique identifier for the inventory item being counted. This identifier ensures precise-item tracking and stock reconciliation. |
ItemNumber | String | The alphanumeric code that uniquely identifies the inventory item. This code is used for product tracking, reporting, and validation. |
ItemDescription | String | A brief description of the inventory item included in the cycle count. This description provides details for warehouse personnel. |
AbcClassId | Long | The unique identifier for the ABC classification assigned to the item. This classification categorizes it based on movement frequency, value, or importance. |
AbcClass | String | The name of the ABC classification that this inventory item is assigned to. This classification determines its cycle count priority and frequency. |
IncludeInScheduleCode | Long | A code indicating whether this item should be scheduled for a cycle count. Accepted values are defined in the lookup type INV_YES_NO_NUMERIC. |
IncludeInSchedule | String | Specifies whether this item should be included in the cycle count schedule. Accepted values are defined in the lookup type INV_YES_NO_NUMERIC. |
AdjustmentValuePositiveTolerance | Decimal | The maximum positive percentage adjustment allowed in the inventory value for this item before requiring approval. |
AdjustmentValueNegativeTolerance | Decimal | The maximum negative percentage adjustment allowed in the inventory value for this item before requiring approval. |
QuantityVariancePositivePercentage | Decimal | The maximum positive percentage variance allowed between the expected and actual quantity counted for this item before triggering an exception. |
QuantityVarianceNegativePercentage | Decimal | The maximum negative percentage variance allowed between the expected and actual quantity counted for this item before requiring further review. |
LastScheduledDate | Datetime | The most recent date when the warehouse scheduled this item for counting, providing a historical reference for stock validation. |
LotControlCode | Int | A code indicating whether the item is lot controlled. This code determines whether inventory is managed based on lot numbers for traceability. |
SerialNumberControlCode | Int | A code indicating whether serial-number tracking is required for this item. This code ensures compliance with inventory traceability requirements. |
CountUOMCode | String | The code representing the unit of measure (UOM) used for counting this inventory item. This code ensures consistency in cycle count reporting. |
CountUOM | String | The full name of the UOM used in the cycle count for this item, providing clarity on measurement standards. |
PrimaryImageURL | String | The Uniform Resource Locator (URL) linking to the primary image of the item. This URL provides a visual reference for warehouse personnel during cycle counting. |
BindCycleCountName | String | The cycle count name associated with the bound record. This name ensures proper linkage between cycle count definitions and inventory items. |
BindOrganizationCode | String | The organization code associated with the bound record. This code ensures accurate reference for cycle count definitions in multi-organization environments. |
CycleCountHeaderId | Long | The unique identifier linking the cycle count header to the inventory item. This identifier ensures proper association between the cycle count configuration and individual stock items. |
Finder | String | A searchable reference key used to locate specific inventory items within the cycle count. This reference key improves lookup efficiency and navigation. |
Subinventory | String | The subinventory location where the cycle count is performed, specifying the warehouse, storage area, or bin where this item is counted. |