CycleCountSequenceDetails
Tracks sequence details for cycle counts, including processing and tracking data.
Columns
| Name | Type | Description |
| CycleCountEntryId [KEY] | Long | The unique identifier assigned to the cycle count sequence. This identifier trackseach individual count entry within the cycle count process. |
| CycleCountHeaderId [KEY] | Long | 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 | 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 | The cycle count name associated with the bound record. This name ensures proper linkage between cycle count definitions and count sequences. |
| BindOrganizationCode | String | 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 | The starting serial-number range for the counted inventory. This range ensures accurate tracking of serialized items. |
| ToSerialNumber | String | The ending serial number range for the counted inventory. This range defines the range of serialized items included in the cycle count. |