SSIS Components for Oracle Fusion Cloud SCM

Build 24.0.9060

CycleCountDefinitionscountClasses

The Classes resource manages the count classes that the warehouse can use in the cycle count.

Columns

Name Type Description
CycleCountDefinitionsCycleCountHeaderId [KEY] Long CycleCountDefinitionsCycleCountHeaderId of CycleCountDefinitionscountClasses
CycleCountClassId [KEY] Long Value that uniquely identifies the class of the cycle count.
AbcClassId Long Value that uniquely identifies the ABC class that the cycle count includes.
AbcClass String Name of the ABC class that the cycle count includes.
CountsPerYear Long Number of counts for each year that this class includes.
QuantityVariancePositivePercentage Decimal Positive percent that the warehouse allows the quantity to vary from the requested quantity for this class.
QuantityVarianceNegativePercentage Decimal Negative percent that the warehouse allows the quantity to vary from the requested quantity for this class.
AdjustmentValuePositiveTolerance Decimal Positive percent that the warehouse allows the value to vary for each item that resides in this class.
AdjustmentValueNegativeTolerance Decimal Negative percent that the warehouse allows the value to vary for each item that resides in this class.
HitAndMissPostivePercentage Decimal Positive percent tolerance that the warehouse uses for hit or miss analysis for this count class.
HitAndMissNegativePercentage Decimal Negative percent tolerance that the warehouse uses for hit or miss analysis for this count class.
BindCycleCountName String BindCycleCountName of CycleCountDefinitionscountClasses
BindOrganizationCode String BindOrganizationCode of CycleCountDefinitionscountClasses
CycleCountHeaderId Long CycleCountHeaderId of CycleCountDefinitionscountClasses
Finder String Finder of CycleCountDefinitionscountClasses
ItemDescription String ItemDescription of CycleCountDefinitionscountClasses
ItemNumber String ItemNumber of CycleCountDefinitionscountClasses
Subinventory String Subinventory of CycleCountDefinitionscountClasses

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