CycleCountDefinitionscountCategories
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. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| CycleCountHeaderId | Long | CycleCountHeaderId |
| ItemDescription | String | ItemDescription |
| ItemNumber | String | ItemNumber |
| Subinventory | String | Subinventory |
| BindCycleCountName | String | bindCycleCountName |
| BindOrganizationCode | String | bindOrganizationCode |
| Finder | String | finder |