CycleCountDefinitionscountClasses
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. |
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 |