JDBC Driver for Oracle SCM

Build 22.0.8462

CycleCountDefinitions

The Cycle Count Definitions resource manages the cycle count definitions.

Columns

Name Type Description
CycleCountHeaderId [KEY] String Value that uniquely identifies the cycle count definition.
CycleCountName String Name of the cycle count.
Description String Description of the cycle count.
OrganizationId String Value that uniquely identifies the inventory organization.
OrganizationCode String Value that identifies the inventory organization.
OrganizationName String Name of the inventory organization.
AbcAssignmentGroupId String Value that uniquely identifies the ABC group that the warehouse uses to initialize the item classification.
AbcAssigmentGroup String Name of the ABC group that the warehouse uses to initialize the item classification in the cycle count.
SynchronizationModeCode String Name of the ABC group that the warehouse uses to initialize the item classification in the cycle count.
SynchronizationMode String Value that determines the ABC synchronization mode. A list of accepted values is defined in the lookup type INV_CC_SYNC_MODE.
SynchronizeAbcAssociationFlag Bool Contains one of the following values: true or false. If true, then synchronize the ABC classes and items during ABC synchronization. If false, then do not synchronize the ABC classes and items during ABC synchronization. This attribute does not have a default value.
DeleteAdditionalItemsFlag Bool Contains one of the following values: true or false. If true, then delete the additional items during ABC synchronization. If false, then do not delete the additional items during ABC synchronization. This attribute does not have a default value.
AutomaticallyScheduleCode Long Value that indicates whether or not the warehouse schedules the counts. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC.
AutomaticallySchedule String Value that determines whether or not the warehouse schedules the counts. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC.
FrequencyCode String Value that indicates the time interval to use between two consecutive scheduling runs for a cycle count. A list of accepted values is defined in the lookup type INV_CC_SCHED_TIME.
Frequency String Value that determines the time interval to use between two consecutive scheduling runs for a cycle count. A list of accepted values is defined in the lookup type INV_CC_SCHED_TIME.
WorkdayScheduleCode String Value that identifies the workday schedule that the cycle count references.
WorkdaySchedule String Workday schedule that the count references.
LastScheduledDate Date Date when the last cycle count was scheduled to run by the warehouse.
NextScheduledDate Date Date when the next cycle count is scheduled to run by the warehouse.
ApprovalRequiredCode String Value that indicates whether or not the warehouse requires approval.
ApprovalRequired String Value that determines whether or not the warehouse requires approval. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC.
ApprovalTypeCode String Value that determines the type of approval that the warehouse requires for adjustment transactions. A list of accepted values is defined in the lookup type INV_APPROVAL_REQ.
ApprovalType String Type of approval that the warehouse requires for an adjustment transaction. A list of accepted values is defined in the lookup type INV_APPROVAL_REQ.
PositiveTolerancePercentage String Positive percent tolerance. If the adjustment exceeds this tolerance, then the warehouse requires approval for the adjustment transaction.
NegativeTolerancePercentage String Negative percent tolerance. If the adjustment falls below this tolerance, then the warehouse requires approval for the adjustment transaction.
PositiveAdjustmentTolerance String Positive currency tolerance. If the currency exceeds this tolerance, then the warehouse requires approval for the adjustment transaction.
NegativeAdjustmentTolerance String Negative currency tolerance. If the currency falls below this tolerance, then the warehouse requires approval for the adjustment transaction.
StartingCountSequence String Starting number that the warehouse uses for the count sequence for the next scheduling run of the cycle count.
MaximumDaysBeforeLate String Number of days after creation before the warehouse considers a scheduled count as late.
MaximumRecounts String Maximum number of recounts that the warehouse uses on a cycle count.
StartDate Date Date when this cycle count becomes active.
EndDate Date Date when this cycle count becomes inactive.
ManualCountsAllowedCode String Value that indicates whether or not the warehouse can use this cycle count to enter an unscheduled count. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC.
ManualCountsAllowed String Value that determines whether or not the warehouse can use this cycle count to enter an unscheduled count. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC.
ManualCountSequencePrefix String Prefix for a manual count sequence.
CountZeroQuantityCode String Value that indicates whether the warehouse schedules a cycle count for an item when the on-hand quantity is zero. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC.
CountZeroQuantity String Value that determines whether the warehouse schedules a cycle count for an item when the on-hand quantity is zero. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC.
DisplaySuggestedQuantityCode String Value that indicates whether or not to display the on-hand quantity for the cycle count sequence. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC.
DisplaySuggestedQuantity String Value that determines whether or not to display the on-hand quantity for the cycle count sequence. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC.
SerializedItemsAllowedCode String Value that indicates whether or not to use the cycle count to count serial items. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC.
SerializedItemsAllowed String Value that determines whether or not to use the cycle count to count serial items. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC.
SerialCountOptionCode String Value that indicates whether or not to include serial items when creating the count. A list of accepted values is defined in the lookup type INV_CC_SERIAL_COUNT_OPTIONS.
SerialCountOption String Value that determines whether or not to include serial items when creating the count. A list of accepted values is defined in the lookup type INV_CC_SERIAL_COUNT_OPTIONS.
SerialNumberAdjustmentCode String Value that indicates whether or not to adjust for serial items. A list of accepted values is defined in the lookup type INV_CC_SERIAL_ADJ_OPTIONS.
SerialNumberAdjustment String Value that determines whether or not to adjust for serial items. A list of accepted values is defined in the lookup type INV_CC_SERIAL_ADJ_OPTIONS.
RecordCountSerialsCode String Value that indicates the detail level to use when counting serial items. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC.
RecordCountSerials String Value that determines the detail level to use when counting serial items. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC.
SerialDiscrepancyCode String Value that indicates whether or not to allow discrepancy when counting serial items. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC.
SerialDiscrepancyAllowed String Value that determines whether or not to allow discrepancy when counting serial items. A list of accepted values is defined in the lookup type INV_YES_NO_NUMERIC.
PositiveHitMissPercentage String Positive percent tolerance that the warehouse uses for hit or miss analysis.
NegativeHitMissPercentage String Negative percent tolerance that the warehouse uses for hit or miss analysis.
CountByCategoryFlag Bool Contains one of the following values: true or false. If true, then enable the cycle count by item category. If false, then do not enable the cycle count by item category. The default value is false.
CategorySynchronizationModeCode String Abbreviation that identifies the item category synchronization mode. A list of accepted values is defined in the lookup type INV_CC_SYNC_MODE.
CategorySynchronizationMode String Mode of item category synchronization. A list of accepted values is defined in the lookup type INV_CC_SYNC_MODE.
SynchronizeItemCategoryAssociationFlag Bool Contains one of the following values: true or false. If true, then synchronize the count category items during item category synchronization. If false, then do not synchronize the count category items during item category synchronization. This attribute does not have a default value.
DeleteAdditionalCategoryItemsFlag Bool Contains one of the following values: true or false. If true, then delete the additional items during item category synchronization. If false, then do not delete the additional items during item category synchronization. This attribute does not have a default value.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462