JDBC Driver for Oracle SCM

Build 22.0.8462

InventoryCountTasks

The Inventory Count Tasks resource manages the count tasks. Oracle Supply Chain for Healthcare Cloud publishes the quantity details for a recalled item to Oracle Inventory Management Cloud. The count quantity is entered by the counter. This resource is not currently used. The resource is associated with a feature that requires opt in.

Columns

Name Type Description
InvCountTaskId [KEY] String Value that uniquely identifies the inventory count task.
RecallHeaderId String Value that uniquely identifies the recall header.
RecallHeaderNumber String Number that indicates the recall header.
RecallLineId String Value that uniquely identifies the recall line.
RecallLineNumber String Number that indicates the recall line.
LocationId String LocationId of InventoryCountTasks
LocationCode String LocationCode of InventoryCountTasks
LocationName String LocationName of InventoryCountTasks
CountTaskSourceHeaderId String CountTaskSourceHeaderId of InventoryCountTasks
CountTaskSourceLineId String CountTaskSourceLineId of InventoryCountTasks
CountTaskSourceLineTypeCode String CountTaskSourceLineTypeCode of InventoryCountTasks
CountTaskSourceLineType String CountTaskSourceLineType of InventoryCountTasks
OrganizationId String Value that uniquely identifies the inventory organization.
OrganizationCode String Abbreviation that identifies the inventory organization.
OrganizationName String Name of the inventory organization.
InventoryItemId String Value that uniquely identifies the inventory item.
ItemNumber String Number that indicates the inventory item.
ItemDescription String ItemDescription of InventoryCountTasks
ManufacturerPartNumber String ManufacturerPartNumber of InventoryCountTasks
Subinventory String Name of the subinventory.
LocatorId String Value that uniquely identifies the locator.
Locator String Name of the locator.
Revision String Revision of the item.
LotNumber String Number that identifies an item or group of items.
SerialNumber String Number that indicates the serial to count.
OwningTypeCode String Contains one of the following values: 1 or 2. If 1, then the item is consigned. If 2, then the item is owned. The default value is 2.
OwningType String Type of owning entity. If the item is consigned, then this attribute contains the vendor site identifier. If the item is owned, then this attribute contains the owning organization identifier.
OwningEntityId String Value that uniquely identifies the owning entity. If the item is consigned, then this attribute contains the vendor site identifier. If the item is owned, then this attribute contains the owning organization identifier.
OwningPartySite String Name of the owning party site.
OwningParty String Name of the owning party.
ProcurementBU String Business unit that manages and owns the purchasing document.
CountStatusCode String CountStatusCode of InventoryCountTasks
CountStatus String CountStatus of InventoryCountTasks
CountDate Date Date when the count was performed.
CountedByEmployeeId String Value that uniquely identifies the employee who performed the current count.
CountedByEmployee String Name of the employee who performed the current count.
CountUOMCode String Abbreviation that identifies the unit of measure for the current count.
CountUnitOfMeasure String Unit of measure for the current count.
CountSecondaryUOMCode String CountSecondaryUOMCode of InventoryCountTasks
CountSecondaryUnitOfMeasure String CountSecondaryUnitOfMeasure of InventoryCountTasks
CountQuantity String Count quantity for the count task.
SecondaryUOMQuantity String Quantity of the current count in the secondary unit of measure used by the item.
ExpectedUOMCode String ExpectedUOMCode of InventoryCountTasks
ExpectedUnitOfMeasure String ExpectedUnitOfMeasure of InventoryCountTasks
ExpectedQuantity String Expected quantity of the current count in the primary unit of measure used by the item.
SecondaryExpectedQuantity String Expected quantity of the current count in the secondary unit of measure used by the item.
ErrorCode String ErrorCode of InventoryCountTasks
ErrorMessage String ErrorMessage of InventoryCountTasks
TransactionReasonId String Value that uniquely identifies the transaction reason.
TransactionReason String Name of the transaction reason.
TransactionDate Date TransactionDate of InventoryCountTasks
DestinationSubinventory String DestinationSubinventory of InventoryCountTasks
DestinationLocatorId String DestinationLocatorId of InventoryCountTasks
DestinationLocator String DestinationLocator of InventoryCountTasks
PickSubinventory String Name of the pick subinventory.
PickLocatorId String Value that uniquely identifies the pick locator.
PickLocator String Name of the pick locator.
Comments String Comments that describe the current count.
AccountAliasId String Value that uniquely identifies the account alias.
AccountAlias String Name of the account alias.
AccountId String Value that uniquely identifies the account.
Account String Value that identifies the account.
CostCenterCode String CostCenterCode of InventoryCountTasks
CostCenterDescription String CostCenterDescription of InventoryCountTasks
SequenceNumber String SequenceNumber of InventoryCountTasks
RequesterId String RequesterId of InventoryCountTasks
RequesterName String RequesterName of InventoryCountTasks
UseItemCostFlag Bool Contains one of the following values: true or false. If true, then use the current item cost. If false, then do not use the current item cost. This attribute defaults from the use current item cost attribute for the inventory organization. This attribute is mandatory.
ProcessingModeCode String Abbreviation that identifies the mode in which the count is performed.
ProcessingMode String Mode of processing.

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