CycleCountDefinitionscountClasses

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	Double	Positive percent that the warehouse allows the quantity to vary from the requested quantity for this class.
QuantityVarianceNegativePercentage	Double	Negative percent that the warehouse allows the quantity to vary from the requested quantity for this class.
AdjustmentValuePositiveTolerance	Double	Positive percent that the warehouse allows the value to vary for each item that resides in this class.
AdjustmentValueNegativeTolerance	Double	Negative percent that the warehouse allows the value to vary for each item that resides in this class.
HitAndMissPostivePercentage	Double	Positive percent tolerance that the warehouse uses for hit or miss analysis for this count class.
HitAndMissNegativePercentage	Double	Negative percent tolerance that the warehouse uses for hit or miss analysis for this count class.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。