Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

OnhandQuantityDetails

Tracks detailed on-hand quantity metrics, supporting various scenarios like inbound, reserved, and consigned quantities.

Columns

Name Type Description
OrganizationId [KEY] Long The unique identifier for the organization in the OnhandQuantityDetails table.
OrganizationCode String The code representing the organization in the OnhandQuantityDetails table.
InventoryItemId [KEY] Long The unique identifier for the inventory item in the OnhandQuantityDetails table.
ItemNumber String The item number associated with the inventory item in the OnhandQuantityDetails table.
SubinventoryCode [KEY] String The code representing the subinventory within the organization for the item in the OnhandQuantityDetails table.
LocatorId [KEY] Long The unique identifier for the locator where the item is stored within the subinventory in the OnhandQuantityDetails table.
LotNumber [KEY] String The lot number associated with the inventory item, which groups items for tracking purposes in the OnhandQuantityDetails table.
OnhandQuantity Decimal The quantity of the item currently available and on hand in the OnhandQuantityDetails table.
SecondaryOnhandQuantity Long The secondary unit of measure (UOM) quantity of the item currently available and on hand in the OnhandQuantityDetails table.
ReceivingQuantity Decimal The quantity of the item received but not yet fully processed or stocked in the OnhandQuantityDetails table.
SecondaryReceivingQuantity Decimal The quantity of the item received in the secondary unit of measure, not yet fully processed or stocked in the OnhandQuantityDetails table.
ReservedQuantity Decimal The quantity of the item that is reserved for future use, preventing it from being used in other transactions, in the OnhandQuantityDetails table.
SecondaryReservedQuantity Decimal The quantity of the item reserved in the secondary unit of measure, preventing it from being used in other transactions, in the OnhandQuantityDetails table.
InboundQuantity Decimal The quantity of the item in transit or expected to be received into the subinventory in the OnhandQuantityDetails table.
SecondaryInboundQuantity Decimal The quantity of the item in transit in the secondary unit of measure, expected to be received into the subinventory in the OnhandQuantityDetails table.
ConsignedQuantity Decimal The quantity of consigned inventory, which belongs to an external supplier but is stored within the organization, in the OnhandQuantityDetails table.
SecondaryConsignedQuantity Decimal The quantity of consigned inventory in the secondary unit of measure, belonging to an external supplier but stored within the organization, in the OnhandQuantityDetails table.
OwningOrganizationId Long The unique identifier for the owning organization, typically the supplier or internal department, in the OnhandQuantityDetails table.
OwningOrganization String The name or code of the organization that owns the inventory in the OnhandQuantityDetails table.
SerialNumber [KEY] String The unique serial number identifying a specific unit of the inventory item in the OnhandQuantityDetails table.
PrimaryUOMCode String The primary unit of measure used for the inventory item in the OnhandQuantityDetails table.
SecondaryUOMCode String The secondary unit of measure used for the inventory item, if applicable, in the OnhandQuantityDetails table.
Finder String An additional identifier or code used to help locate or identify the inventory item in the OnhandQuantityDetails table.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175