ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175