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 |