CycleCountSequenceDetails
Tracks sequence details for cycle counts, including processing and tracking data.
Columns
| Name | Type | SupportedFinders | Description |
| CycleCountEntryId [KEY] | Long | PrimaryKey | The unique identifier assigned to the cycle count sequence. This identifier trackseach individual count entry within the cycle count process. |
| CycleCountHeaderId [KEY] | Long | PrimaryKey | The unique identifier for the cycle count associated with this sequence. This identifier ensures accurate linking of count entries to cycle count definitions. |
| CycleCountName | String | The name of the cycle count. This name provides a recognizable reference for inventory counting activities. | |
| OrganizationId [KEY] | Long | PrimaryKey | The unique identifier for the inventory organization responsible for the cycle count. This identifier ensures proper assignment of counted items to the correct business unit. |
| OrganizationCode | String | The alphanumeric code identifying the inventory organization. This code provides a concise reference for use in reporting and transactions. | |
| OrganizationName | String | The full name of the inventory organization conducting the cycle count. This name ensures clear identification in multi-organization environments. | |
| CountTypeCode | String | The code representing the type of cycle count being performed. Accepted values are defined in the lookup type INV_CC_COUNT_TYPES. | |
| CountType | String | The description of the type of cycle count being performed (for example 'Scheduled' or 'Unscheduled'). Accepted values are defined in the lookup type INV_CC_COUNT_TYPES. | |
| InventoryItemId | Long | The unique identifier for the inventory item included in the cycle count sequence. This identifier ensures accurate tracking and validation. | |
| ItemNumber | String | The unique alphanumeric code assigned to the inventory item. This code is used for product identification and stock tracking. | |
| ItemDescription | String | A brief description of the inventory item being counted. This description provides additional details for warehouse personnel. | |
| ItemPrimaryImageURL | String | The Uniform Resource Locator (URL) linking to the primary image of the inventory item. This URL provides a visual reference to assist with cycle counting. | |
| Subinventory | String | The name of the subinventory where the counted item is stored. This name defines the specific storage location within the warehouse. | |
| LocatorId | Long | The unique identifier for the locator within the warehouse where the item is stored. This identifier ensures precise location tracking. | |
| Locator | String | The name of the locator within the subinventory where the counted item is stored. This name provides warehouse personnel with accurate storage details. | |
| LotNumber | String | The lot number assigned to the inventory item. This lot number enables traceability and tracking of items grouped by production batches. | |
| SerialNumber | String | The serial number of the inventory item, allowing for unique identification and tracking of serialized stock. | |
| Revision | String | The revision identifier of the inventory item, capturing version-specific changes for controlled items. | |
| CountSequence | Long | The sequence number assigned to the count entry. This number ensures that cycle count records are maintained in a structured order. | |
| CountQuantity | Decimal | The actual quantity counted during the cycle count sequence. This quantity represents the recorded stock level at the time of counting. | |
| CountUOMCode | String | The code representing the unit of measure (UOM) for the counted item. This code ensures consistency in inventory tracking. | |
| CountUOM | String | The full name of the UOM associated with the counted quantity. This name provides a clear reference for warehouse personnel. | |
| SecondaryCountQuantity | Decimal | The counted quantity of the item in its secondary UOM. This quantity is used when dual UOM tracking is required. | |
| SecondaryCountUOMCode | String | The code identifying the secondary UOM for the counted item. This code ensures accurate unit conversions. | |
| SecondaryCountUOM | String | The full name of the secondary UOM for the counted item. This name ensures consistency in stock calculations. | |
| OwningType | String | Indicates whether the item is owned or consigned. Accepted values are '1' for consigned inventory and '2' for owned inventory. | |
| OwningEntityId | Long | The unique identifier for the entity that owns the inventory. If the item is consigned, this field contains the vendor site identifier; if owned, it contains the owning organization identifier. | |
| OwningPartySite | String | The name of the owning party site. This name provides additional context for consigned inventory ownership. | |
| OwningParty | String | The name of the owning party responsible for the inventory. This name ensures clear distinction between consigned and owned stock. | |
| Reason | String | The reason for the adjustment transaction. This reason captures why a discrepancy was recorded and whether corrective action is required. | |
| Comments | String | Additional comments describing the count entry, providing further details on the count process or discrepancies found. | |
| CountedByEmployeeId | Long | The unique identifier for the employee who performed the cycle count. This identifier enables tracking of count accountability. | |
| CountedBy | String | The name of the employee responsible for conducting the cycle count. This name ensures visibility into personnel performing inventory checks. | |
| CountDate | Date | The date when the cycle count sequence was performed. This date provides a timestamp for inventory reconciliation and auditing. | |
| ReviewedByEmployeeId | Long | The unique identifier for the employee who reviewed and approved the adjustment. This identifier ensures accountability in the cycle count process. | |
| ReviewedBy | String | The name of the employee responsible for reviewing and approving the cycle count adjustment. | |
| ReviewDate | Date | The date when the cycle count adjustment was reviewed and approved. This date provides a reference for auditing and validation. | |
| CountSequenceStatusCode | String | The code representing the current status of the cycle count sequence, determining its stage in the cycle count workflow. | |
| CountSequenceStatus | String | The description of the current status of the cycle count sequence. Accepted values are defined in the lookup type INV_CC_ENTRY_STATUSES. | |
| ExportCode | Long | A code indicating whether the cycle count sequence should be exported to the interface for further processing. | |
| Exported | String | Specifies whether the cycle count sequence was successfully exported to the interface, ensuring data integration between inventory and external systems. | |
| ItemLotControlCode | String | A code that identifies lot-controlled items within the cycle count definition. This code ensures compliance with lot tracking requirements. | |
| ItemSerialControlCode | String | A code that identifies serial-controlled items within the cycle count definition. This code ensures compliance with serialized inventory tracking. | |
| ReasonId | Long | The unique identifier for the reason associated with the cycle count adjustment. This identifier provides context for recorded discrepancies. | |
| OwningTypeCode | String | Indicates whether the item is owned or consigned. If consigned, this field contains the vendor site identifier. If owned, it contains the owning organization identifier. | |
| ManualCountPrefix | String | A prefix used for manual cycle count entries, distinguishing them from system-generated cycle counts. | |
| PrimarySuggestedQuantity | Decimal | The suggested quantity in the primary UOM for the cycle count. This quantity serves as a reference for expected stock levels. | |
| PrimaryAdjustmentQuantity | Decimal | The adjustment quantity applied to the inventory in the primary UOM. This adjustment quantity reflects corrections based on the cycle count. | |
| SecondarySuggestedQuantity | Decimal | The suggested quantity in the secondary UOM for the cycle count. This suggested quantity ensures accurate dual-UOM tracking. | |
| SecondaryAdjustmentQuantity | Decimal | The adjustment quantity applied to the inventory in the secondary UOM. This adjustment quantity reflects corrections based on the cycle count. | |
| AdjustmentValue | Decimal | The total financial adjustment value resulting from the cycle count discrepancy. This value ensuraccurate cost and valuation tracking. | |
| AdjustmentDate | Date | The date when the cycle count adjustment was applied. This date serves as a reference for inventory reconciliation and audit tracking. | |
| Recounts | Long | The number of recount attempts made for this cycle count sequence. This number ensures accuracy before finalizing inventory adjustments. | |
| ItemUnitCost | Decimal | The unit cost of the inventory item being counted. This cost provides context for valuation adjustments and financial impact analysis. | |
| DeviationPercentage | Decimal | The percentage deviation between the expected and actual counted quantity. This metric helps determine acceptable variance thresholds. | |
| ProcessingFlag | Bool | Indicates whether the cycle count sequence was processed. If set to 'true', the request was processed successfully; if set to 'false', it was not processed. The default value is 'false'. | |
| ProcurementBU | String | The business unit responsible for managing and owning the purchasing document related to the inventory item being counted. | |
| BindCycleCountName | String | FindByOrganizationAndCountName | The cycle count name associated with the bound record. This name ensures proper linkage between cycle count definitions and count sequences. |
| BindOrganizationCode | String | FindByOrganizationAndCountName | The organization code associated with the bound record. This code ensures accurate reference for cycle count sequences in multi-organization environments. |
| Finder | String | A searchable reference key used to locate specific cycle count sequences within the system. This reference key improves lookup efficiency and navigation. | |
| FromSerialNumber | String | FindBySerialNumber | The starting serial-number range for the counted inventory. This range ensures accurate tracking of serialized items. |
| ToSerialNumber | String | FindBySerialNumber | The ending serial number range for the counted inventory. This range defines the range of serialized items included in the cycle count. |