JDBC Driver for Oracle SCM

Build 22.0.8462

CycleCountDefinitionscountItems

The Items resource manages the items that the warehouse can use in the cycle count.

Columns

Name Type Description
CycleCountDefinitionsCycleCountHeaderId String CycleCountDefinitionsCycleCountHeaderId of CycleCountDefinitionscountItems
CycleCountItemId String Value that uniquely identifies the item that the cycle count definition references.
InventoryItemId String Value that uniquely identifies the item.
ItemNumber String Number that identifies the item.
ItemDescription String Description of the item.
AbcClassId String Value that uniquely identifies the ABC class that the item references.
AbcClass String Name of the ABC class that the item references.
IncludeInScheduleCode String Value that indicates whether or not to schedule this item. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC.
IncludeInSchedule String Value that determines whether or not to schedule this item. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC.
AdjustmentValuePositiveTolerance String Positive adjustment that the warehouse allows the value to vary for the item.
AdjustmentValueNegativeTolerance String Negative adjustment that the warehouse allows the value to vary for the item.
QuantityVariancePositivePercentage String Positive percent that the warehouse allows the quantity to vary from the requested quantity for the item.
QuantityVarianceNegativePercentage String Negative percent that the warehouse allows the quantity to vary from the requested quantity for the item.
LastScheduledDate Datetime Value that indicates the most recent date that the warehouse scheduled this item for counting.

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