CycleCountDefinitions
Manages the definition and configuration of cycle counts for inventory management.
Columns
| Name | Type | Description |
| CycleCountHeaderId [KEY] | Long | The unique system-generated identifier assigned to each cycle count definition. This identifier links the cycle count to related inventory counting processes, ensuring traceability and consistency in inventory reconciliation. |
| CycleCountName | String | The designated name for the cycle count, used to differentiate and manage various cycle count definitions within the inventory system. This name is referenced in reports, scheduling, and execution workflows. |
| Description | String | A detailed narrative describing the purpose and scope of the cycle count. This field provides context on the objectives of the count, such as whether it targets high-value items, frequent movers, or regulatory compliance requirements. |
| OrganizationId | Long | The system-generated identifier for the inventory organization responsible for conducting the cycle count. This identifier ensures that cycle count definitions are correctly assigned to the appropriate business entity. |
| OrganizationCode | String | A unique alphanumeric code assigned to the inventory organization that owns the cycle count definition. This code is used in reporting, processing, and cross-referencing cycle count data with other inventory activities. |
| OrganizationName | String | The full name of the inventory organization conducting the cycle count. This name provides a human-readable reference to identify which entity is responsible for inventory accuracy. |
| AbcAssignmentGroupId | Long | The unique identifier assigned to the ABC classification group that categorizes inventory items for cycle counting. ABC classification prioritizes items based on value and movement frequency, influencing how often items are counted. |
| AbcAssigmentGroup | String | The name of the ABC classification group used in the cycle count to define item classification. ABC categories help warehouses optimize inventory accuracy by scheduling more frequent counts for high-value or fast-moving items. |
| SynchronizationModeCode | String | A system-defined code indicating the ABC synchronization mode, which determines how ABC classifications are updated when new inventory data is introduced. This setting controls whether ABC assignments are automatically refreshed during cycle count processing. |
| SynchronizationMode | String | The method used to synchronize ABC classifications when processing cycle counts. This setting ensures that inventory classifications stay aligned with current stock levels and movement patterns. Accepts values from the lookup type INV_CC_SYNC_MODE. |
| SynchronizeAbcAssociationFlag | Bool | Indicates whether ABC classifications and item assignments should be synchronized during ABC updates. If set to 'true', the system automatically aligns items with their correct ABC categories based on predefined rules. |
| DeleteAdditionalItemsFlag | Bool | Indicates whether additional items should be removed from the cycle count during ABC synchronization. If set to 'true', items that no longer meet the ABC classification criteria will be excluded from future counts. |
| AutomaticallyScheduleCode | Int | A system-generated code determining whether the warehouse system automatically schedules cycle counts at predefined intervals. Accepted values are from the lookup type INV_YES_NO_NUMERIC. |
| AutomaticallySchedule | String | Specifies whether the system automatically schedules cycle counts based on predefined scheduling rules. Automated scheduling ensures consistent and systematic inventory verification. Accepted values are from the lookup type INV_YES_NO_NUMERIC. |
| FrequencyCode | String | A system-defined code representing the predefined time interval between two consecutive cycle count scheduling runs. This code ensures inventory is counted at a frequency aligned with operational and financial accuracy requirements. Accepted values are from the lookup type INV_CC_SCHED_TIME. |
| Frequency | String | The specified time interval governing how often cycle counts are scheduled, ensuring routine inventory verification. Common intervals can include daily, weekly, or monthly cycles. Accepted values are from the lookup type INV_CC_SCHED_TIME. |
| WorkdayScheduleCode | Long | The unique identifier for the workday schedule assigned to the cycle count. This schedule defines which business days are available for conducting inventory counts, avoiding non-operational days. |
| WorkdaySchedule | String | The defined workday schedule that governs when cycle counts can occur. This schedule ensures the cycle counts align with regular business operations and resource availability. |
| LastScheduledDate | Date | The most recent date on which a scheduled cycle count was executed in the warehouse. This field is useful for tracking historical cycle count activities and identifying patterns in execution. |
| NextScheduledDate | Date | The planned date for the next cycle count execution, based on predefined scheduling rules. This date allows warehouse managers to anticipate upcoming counts and allocate resources accordingly. |
| ApprovalRequiredCode | Long | A system-generated code indicating whether approval is required for cycle count adjustments. Approval requirements help enforce financial and compliance controls over inventory changes. |
| ApprovalRequired | String | Specifies whether cycle count adjustments require approval from designated personnel before being applied to inventory records. This field ensures accountability and auditability. Accepted values are from the lookup type INV_YES_NO_NUMERIC. |
| ApprovalTypeCode | String | A system-defined code representing the type of approval required for cycle count adjustments. This code determines the level of authorization needed before an adjustment is finalized. Accepted values are from the lookup type INV_APPROVAL_REQ. |
| ApprovalType | String | The type of approval required for cycle count adjustment transactions. Approval types can vary based on business rules, such as requiring supervisor approval for adjustments exceeding a set threshold. Accepted values are from the lookup type INV_APPROVAL_REQ. |
| PositiveTolerancePercentage | Decimal | The maximum allowable positive variance percentage before requiring approval for a cycle count adjustment. If an item’s counted quantity exceeds the system quantity by more than this percentage, approval is required. |
| NegativeTolerancePercentage | Decimal | The maximum allowable negative variance percentage before requiring approval for a cycle count adjustment. If an item’s counted quantity is lower than the system quantity beyond this threshold, approval is required. |
| PositiveAdjustmentTolerance | Decimal | The maximum allowable positive variance in monetary value before a cycle count adjustment requires approval. This setting prevents unauthorized increases in inventory valuation. |
| NegativeAdjustmentTolerance | Decimal | The maximum allowable negative variance in monetary value before a cycle count adjustment requires approval. This setting ensures financial controls are maintained when reducing inventory valuation. |
| StartingCountSequence | Long | The starting sequence number assigned to counted items in the next scheduled cycle count. This sequence number helps maintain an organized count order and ensures consistency across multiple count executions. |
| MaximumDaysBeforeLate | Long | The number of days after a scheduled cycle count is created before the system considers it late. This number helps warehouse managers identify overdue counts and ensure timely execution of inventory audits. |
| MaximumRecounts | Long | The maximum number of recount attempts allowed for a cycle count. If the counted quantity does not match the expected quantity within this limit, further action might be required, such as an investigation or approval. |
| StartDate | Date | The date when the cycle count becomes active in the warehouse system. Once active, the cycle count can be scheduled and executed as part of routine inventory management. |
| EndDate | Date | The date when the cycle count is deactivated, preventing it from being scheduled or performed. This date defines the lifecycle of a cycle count definition. |
| ManualCountsAllowedCode | Long | A system-generated code indicating whether warehouse personnel are allowed to enter manual, unscheduled cycle counts. Accepted values are from the lookup type INV_YES_NO_NUMERIC. |
| ManualCountsAllowed | String | Specifies whether warehouse personnel are allowed to enter manual, unscheduled cycle counts, enabling flexibility for ad-hoc inventory adjustments based on operational needs. Accepts values are from the lookup type INV_YES_NO_NUMERIC. |
| ManualCountSequencePrefix | String | A prefix applied to manual count sequence numbers to distinguish them from scheduled counts. This prefix helps maintain traceability and organization of cycle count records. |
| CountZeroQuantityCode | Long | A system-generated code indicating whether cycle counts should be scheduled for items when their on-hand quantity reaches zero. Accepted values are from the lookup type INV_YES_NO_NUMERIC. |
| CountZeroQuantity | String | Specifies whether cycle counts should be scheduled when the system detects that an item’s on-hand inventory quantity has reached zero, helping to confirm stock depletion. Accepted values are from the lookup type INV_YES_NO_NUMERIC. |
| DisplaySuggestedQuantityCode | Long | A system-generated code indicating whether the system should display the expected on-hand quantity during a cycle count. Accepted values are from the lookup type INV_YES_NO_NUMERIC. |
| DisplaySuggestedQuantity | String | Specifies whether the expected on-hand quantity is displayed to the user during a cycle count. Hiding this information can help ensure unbiased counting and reduce counting errors. Accepted values are from the lookup type INV_YES_NO_NUMERIC. |
| SerializedItemsAllowedCode | Long | A system-generated code indicating whether serialized inventory items are included in the cycle count process. Accepted values are from the lookup type INV_YES_NO_NUMERIC. |
| SerializedItemsAllowed | String | Specifies whether serialized inventory items can be counted as part of the cycle count process. Serialized items require unique serial number tracking, which affects counting procedures. Accepted values are from the lookup type INV_YES_NO_NUMERIC. |
| SerialCountOptionCode | String | A system-defined code representing whether serialized items are included when generating a cycle count. This ensures proper tracking of high-value or controlled inventory. Accepted values are from the lookup type INV_CC_SERIAL_COUNT_OPTIONS. |
| SerialCountOption | String | Determines whether serial-tracked items are included in a cycle count. Serial tracking requires precise entry and validation of serial numbers to maintain inventory accuracy. Accepted values are from the lookup type INV_CC_SERIAL_COUNT_OPTIONS. |
| SerialNumberAdjustmentCode | String | A system-defined code indicating whether adjustments are allowed for serial-tracked items in a cycle count. Adjustments can be needed due to loss, damage, or misplacement. Accepted values are from the lookup type INV_CC_SERIAL_ADJ_OPTIONS. |
| SerialNumberAdjustment | String | Specifies whether adjustments for serial-tracked items are processed as part of a cycle count. Serial adjustments must comply with inventory tracking regulations and system controls. Accepts values from the lookup type INV_CC_SERIAL_ADJ_OPTIONS. |
| RecordCountSerialsCode | Long | A system-generated code indicating the level of detail recorded when counting serialized items. Higher levels of detail ensure greater accuracy but can require additional labor. Accepted values are from the lookup type INV_YES_NO_NUMERIC. |
| RecordCountSerials | String | Determines the level of detail recorded when counting serialized items, such as individual serial numbers versus summary counts. Accepted values are from the lookup type INV_YES_NO_NUMERIC. |
| SerialDiscrepancyCode | Long | A system-generated code indicating whether discrepancies in serial-tracked item counts are permitted. Discrepancies can require reconciliation procedures. Accepted values are from the lookup type INV_YES_NO_NUMERIC. |
| SerialDiscrepancyAllowed | String | Specifies whether discrepancies are allowed when counting serialized items. Allowing discrepancies may enable faster counting but could introduce errors. Accepted values are from the lookup type INV_YES_NO_NUMERIC. |
| PositiveHitMissPercentage | Decimal | The maximum allowed positive variance percentage in a cycle count before the system flags it as a potential issue. This metric is used for hit-or-miss analysis to assess cycle count accuracy. |
| NegativeHitMissPercentage | Decimal | The maximum allowed negative variance percentage in a cycle count before the system flags it as a potential issue. This metric helps ensure accurate inventory records by highlighting discrepancies. |
| CountByCategoryFlag | Bool | Indicates whether cycle counts can be conducted by item category instead of individual item numbers. Accepted values are 'true' (enabled) or 'false' (disabled). The default value is 'false'. |
| CategorySynchronizationModeCode | String | A system-defined code indicating the synchronization mode for item categories in cycle counts. Accepted values are from the lookup type INV_CC_SYNC_MODE. |
| CategorySynchronizationMode | String | Determines how item categories are synchronized during cycle count processing. This setting ensures consistent classification of items. Accepted values are from the lookup type INV_CC_SYNC_MODE. |
| SynchronizeItemCategoryAssociationFlag | Bool | Indicates whether item categories should be synchronized during cycle count updates. If set to 'true', updates ensure that the latest item categorization rules apply to cycle counts. |
| DeleteAdditionalCategoryItemsFlag | Bool | Indicates whether additional category items should be removed during synchronization. If set to 'true', non-matching items are deleted to maintain accurate cycle count categorization. |
| BindCycleCountName | String | The cycle count name used as a binding reference for linking related cycle count definitions. This name ensures consistency in reporting and execution. |
| BindOrganizationCode | String | The inventory organization code used as a binding reference to associate cycle count definitions with a specific organization’s inventory structure. |
| Finder | String | A system-defined reference field used to facilitate searches and lookups within cycle count definitions. This reference field improves accessibility and data retrieval efficiency. |
| ItemDescription | String | A detailed description of the inventory item included in the cycle count. This description provides context for warehouse personnel performing counts. |
| ItemNumber | String | The unique item number assigned to an inventory item included in the cycle count. This item number ensures precise tracking and identification. |
| Subinventory | String | The specific subinventory location associated with the cycle count. This field allows organizations to manage inventory at a more granular level. |