JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9060

CycleCountDefinitionscountCategories

The Categories resource manages the item categories that the warehouse can use in the cycle count.

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 Decimal Positive percent that the warehouse allows the quantity to vary from the requested quantity for this category.
QuantityVarianceNegativePercentage Decimal Negative percent that the warehouse allows the quantity to vary from the requested quantity for this category.
AdjustmentValuePositiveTolerance Decimal Positive percent that the warehouse allows the value to vary for each item that resides in this category.
AdjustmentValueNegativeTolerance Decimal Negative percent that the warehouse allows the value to vary for each item that resides in this category.
HitAndMissPostivePercentage Decimal Positive percent tolerance that the warehouse uses for hit or miss analysis for this count category.
HitAndMissNegativePercentage Decimal Negative percent tolerance that the warehouse uses for hit or miss analysis for this count category.
BindCycleCountName String BindCycleCountName of CycleCountDefinitionscountCategories
BindOrganizationCode String BindOrganizationCode of CycleCountDefinitionscountCategories
CycleCountHeaderId Long CycleCountHeaderId of CycleCountDefinitionscountCategories
Finder String Finder of CycleCountDefinitionscountCategories
ItemDescription String ItemDescription of CycleCountDefinitionscountCategories
ItemNumber String ItemNumber of CycleCountDefinitionscountCategories
Subinventory String Subinventory of CycleCountDefinitionscountCategories

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060