Excel Add-In for Oracle Fusion Cloud SCM

Build 23.0.8839

CycleCountDefinitionscountCategoryItems

CycleCountDefinitionscountCategoryItems

Columns

Name Type Description
CycleCountDefinitionsCycleCountHeaderId [KEY] Long CycleCountDefinitionsCycleCountHeaderId of CycleCountDefinitionscountCategoryItems
CountCategoryItemId [KEY] Long Value that uniquely identifies the category item that the cycle count definition references.
InventoryItemId Long Value that uniquely identifies the category item.
ItemNumber String Number that identifies the category item.
ItemDescription String ItemDescription of CycleCountDefinitionscountCategoryItems
CategoryId Long Value that uniquely identifies the count category that the category item references.
CategoryName String Name of the count category that the category item references.
CategoryDescription String Description of the count category that the category item references.
AdjustmentValuePositiveTolerance Double Positive adjustment that the warehouse allows the value to vary for the category item.
AdjustmentValueNegativeTolerance Double Negative adjustment that the warehouse allows the value to vary for the category item.
QuantityVariancePositivePercentage Double Positive percent that the warehouse allows the quantity to vary from the requested quantity for the category item.
QuantityVarianceNegativePercentage Double Negative percent that the warehouse allows the quantity to vary from the requested quantity for the category item.
LastScheduledDate Datetime Date when the warehouse scheduled this category item for counting.
IncludeInScheduleFlag Bool Contains one of the following values: true or false. If true, then schedule this category item. If false, then do not schedule this category item. The default value is false.

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