CycleCountDefinitionscountCategories

Columns


Name	Type	Description
CycleCountDefinitionsCycleCountHeaderId [KEY]	Long	CycleCountDefinitionsCycleCountHeaderId of CycleCountDefinitionscountCategories
CountCategoryId [KEY]	Long	Value that uniquely identifies the category of the cycle count.
CategoryId	Long	Value that uniquely identifies the category name that the cycle count includes.
CategoryName	String	Name of the category that the cycle count includes.
CategoryDescription	String	Description of the category that the cycle count includes.
CountsPerYear	Long	Number of counts for each year that this category includes.
QuantityVariancePositivePercentage	Double	Positive percent that the warehouse allows the quantity to vary from the requested quantity for this category.
QuantityVarianceNegativePercentage	Double	Negative percent that the warehouse allows the quantity to vary from the requested quantity for this category.
AdjustmentValuePositiveTolerance	Double	Positive percent that the warehouse allows the value to vary for each item that resides in this category.
AdjustmentValueNegativeTolerance	Double	Negative percent that the warehouse allows the value to vary for each item that resides in this category.
HitAndMissPostivePercentage	Double	Positive percent tolerance that the warehouse uses for hit or miss analysis for this count category.
HitAndMissNegativePercentage	Double	Negative percent tolerance that the warehouse uses for hit or miss analysis for this count category.

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