JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9062

CycleCountDefinitionscountItems

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

Columns

Name Type Description
CycleCountDefinitionsCycleCountHeaderId [KEY] Long CycleCountDefinitionsCycleCountHeaderId of CycleCountDefinitionscountItems
CycleCountItemId [KEY] Long Value that uniquely identifies the item that the cycle count definition references.
InventoryItemId Long Value that uniquely identifies the item.
ItemNumber String Number that identifies the item.
ItemDescription String Description of the item.
AbcClassId Long Value that uniquely identifies the ABC class that the item references.
AbcClass String Name of the ABC class that the item references.
IncludeInScheduleCode Long 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 Decimal Positive adjustment that the warehouse allows the value to vary for the item.
AdjustmentValueNegativeTolerance Decimal Negative adjustment that the warehouse allows the value to vary for the item.
QuantityVariancePositivePercentage Decimal Positive percent that the warehouse allows the quantity to vary from the requested quantity for the item.
QuantityVarianceNegativePercentage Decimal 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.
LotControlCode Int LotControlCode of CycleCountDefinitionscountItems
SerialNumberControlCode Int SerialNumberControlCode of CycleCountDefinitionscountItems
CountUOMCode String CountUOMCode of CycleCountDefinitionscountItems
CountUOM String CountUOM of CycleCountDefinitionscountItems
PrimaryImageURL String PrimaryImageURL of CycleCountDefinitionscountItems
BindCycleCountName String BindCycleCountName of CycleCountDefinitionscountItems
BindOrganizationCode String BindOrganizationCode of CycleCountDefinitionscountItems
CycleCountHeaderId Long CycleCountHeaderId of CycleCountDefinitionscountItems
Finder String Finder of CycleCountDefinitionscountItems
Subinventory String Subinventory of CycleCountDefinitionscountItems

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062