JDBC Driver for Oracle SCM

Build 22.0.8462

CycleCountSequenceDetails

The Cycle Count Sequence Details resource manages details for the cycle count sequences.

Columns

Name Type Description
CycleCountEntryId String Value that uniquely identifies the cycle count sequence.
CycleCountHeaderId String Value that uniquely identifies the cycle count.
CycleCountName String Name of the cycle count.
OrganizationId String Value that uniquely identifies the inventory organization.
OrganizationCode String Value that identifies the inventory organization.
OrganizationName String Name of the inventory organization.
CountTypeCode String Value that identifies the type of count. A list of accepted values is defined in the lookup type INV_CC_COUNT_TYPES.
CountType String Type of count. A list of accepted values is defined in the lookup type INV_CC_COUNT_TYPES.
InventoryItemId String Value that uniquely identifies the inventory item.
ItemNumber String Name of the inventory item.
ItemDescription String Description of the inventory item.
Subinventory String Name of the subinventory.
LocatorId String Value that uniquely identifies the locator.
Locator String Name of the locator.
LotNumber String Number that identifies an item or group of items.
SerialNumber String Serial number to count.
Revision String Revision of the item.
CountSequence String Number of the cycle count sequence.
CountQuantity String Count quantity for the count sequence.
CountUOMCode String Value that identifies the unit of measure for the current count.
CountUOM String Unit of measure for the current count.
SecondaryCountQuantity String Quantity of the current count in the secondary unit of measure that the item uses.
SecondaryCountUOMCode String Value that identifies the secondary unit of measure that the current count uses.
SecondaryCountUOM String Secondary unit of measure that the current count uses.
OwningType String Contains one of the following values: 1 or 2. If 1, then the item is consigned. If 2, then the item is owned.
OwningEntityId String Value that uniquely identifies the owning entity. If the item is consigned, then this attribute contains the vendor site identifier. If the item is owned, then this attribute contains the owning organization identifier.
OwningPartySite String Name of the owning party site.
OwningParty String Name of the owning party.
Reason String Reason for the adjustment transaction.
Comments String Comments that describe the current count.
CountedByEmployeeId String Value that uniquely identifies the employee who performed the current count.
CountedBy String Name of the employee who performed the current count.
CountDate Date Date when the warehouse counted this sequence.
ReviewedByEmployeeId String Value that uniquely identifies the employee who approved the adjustment.
ReviewedBy String Name of the employee who approved the adjustment.
ReviewDate Date Date when the employee approved the adjustment.
CountSequenceStatusCode String Value that indicates the current status of the count sequence.
CountSequenceStatus String Current status of the count sequence. A list of accepted values is defined in the lookup type INV_CC_ENTRY_STATUSES.
ExportCode String Value that determines whether to export the count sequence to the interface.
Exported String Indicates whether the warehouse exported the count sequence to the interface.
ReasonId String Value that uniquely identifies the reason.
OwningTypeCode String Name that uniquely identifies the owning entity. If the item is consigned, then this attribute contains the vendor site identifier. If the item is owned, then this attribute contains the owning organization identifier.
ManualCountPrefix String ManualCountPrefix of CycleCountSequenceDetails
PrimarySuggestedQuantity String PrimarySuggestedQuantity of CycleCountSequenceDetails
PrimaryAdjustmentQuantity String PrimaryAdjustmentQuantity of CycleCountSequenceDetails
SecondarySuggestedQuantity String SecondarySuggestedQuantity of CycleCountSequenceDetails
SecondaryAdjustmentQuantity String SecondaryAdjustmentQuantity of CycleCountSequenceDetails
AdjustmentValue String AdjustmentValue of CycleCountSequenceDetails
AdjustmentDate Date AdjustmentDate of CycleCountSequenceDetails
Recounts String Recounts of CycleCountSequenceDetails
ItemUnitCost String ItemUnitCost of CycleCountSequenceDetails
DeviationPercentage String DeviationPercentage of CycleCountSequenceDetails
ProcessingFlag Bool Contains one of the following values: true or false. If true, then the request was processed. If false, then the request was not processed. The default value is false.
ProcurementBU String Business unit that manages and owns the purchasing document.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462