JDBC Driver for Oracle SCM

Build 22.0.8462

CycleCountSchedules

The Cycle Count Schedules resource manages the cycle count schedules.

Columns

Name Type Description
CycleCountScheduleId [KEY] String Value that uniquely identifies the cycle count schedule.
CycleCountHeaderId String Value that uniquely identifies the cycle count definition.
CycleCountName String Name of the cycle count.
OrganizationId String Value that uniquely identifies the inventory organization.
OrganizationCode String Value that identifies the inventory organization.
InventoryItemId String Value that uniquely identifies the inventory item number.
ItemNumber String Number that identifies the inventory item.
Subinventory String Value that identifies the physical or logical area in the inventory organization where you store material.
LocatorId String Value that uniquely identifies the locator.
Locator String Value that identifies physical area, such as a row, rack, aisle, bin, or shelf in the subinventory that stores material.
Revision String Value that identifies the version of the item.
LotNumber String Number that identifies a set of items that are being counted, which are produced together and share the same production costs and specifications.
SerialNumber String Number that identifies a single quantity of an item being counted.
ScheduleDate Date Date when the count was scheduled.
CountZeroQuantityFlag Bool Contains one of the following values: true or false. If true, then count the locations that contains zero quantity. If false, then do not count the locations that contains zero quantity. The default value is false.
ScheduleStatusCode String Value that indicates the schedule status. A list of possible values is defined in the lookup type ORA_INV_CC_SCHEDULE_STATUS.
ScheduleStatus String ScheduleStatus of CycleCountSchedules
CountDueDate Date CountDueDate of CycleCountSchedules
RequestSourceTypeCode String Value that indicates the manner in which the count schedule was created. A list of possible values is defined in the lookup type INV_CC_APPROVAL_TYPES.
RequestSourceType String RequestSourceType of CycleCountSchedules

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