CData Python Connector for Oracle Fusion Cloud SCM

Build 23.0.8839

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

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