ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

OnhandQuantityDetailsConsignedQuantityDetails

Provides detailed consigned quantity tracking using specified item and location data.

Columns

Name Type Description
OnhandQuantityDetailsInventoryItemId [KEY] Long The unique identifier for the inventory item in the OnhandQuantityDetailsConsignedQuantityDetails table.
OnhandQuantityDetailsLocatorId [KEY] Long The locator identifier that indicates the physical location within a warehouse or storage area for the inventory item in the OnhandQuantityDetailsConsignedQuantityDetails table.
OnhandQuantityDetailsLotNumber [KEY] String The lot number associated with the inventory item in the OnhandQuantityDetailsConsignedQuantityDetails table, used for tracking purposes.
OnhandQuantityDetailsOrganizationId [KEY] Long The identifier for the organization managing the inventory in the OnhandQuantityDetailsConsignedQuantityDetails table.
OnhandQuantityDetailsSerialNumber [KEY] String The unique serial number for the specific instance of the inventory item in the OnhandQuantityDetailsConsignedQuantityDetails table.
OnhandQuantityDetailsSubinventoryCode [KEY] String The code for the subinventory within the organization where the inventory item is stored, used for better categorization in the OnhandQuantityDetailsConsignedQuantityDetails table.
ConsignedQuantity Decimal The quantity of inventory that has been consigned, meaning it is owned by a third party but held in the organization’s possession, within the OnhandQuantityDetailsConsignedQuantityDetails table.
SecondaryConsignedQuantity Decimal The secondary quantity of consigned inventory, which may refer to a different party or a secondary storage location within the OnhandQuantityDetailsConsignedQuantityDetails table.
PartyName [KEY] String The name of the party associated with the consigned inventory item, such as a supplier or distributor, within the OnhandQuantityDetailsConsignedQuantityDetails table.
PartyType [KEY] String The type of party associated with the consigned inventory, such as a supplier, customer, or other business partner, within the OnhandQuantityDetailsConsignedQuantityDetails table.
PartyNumber [KEY] String A unique identifier for the party, such as a supplier number or customer ID, linked to the consigned inventory within the OnhandQuantityDetailsConsignedQuantityDetails table.
Finder String A reference or identifier for the finder, which could be a person or system responsible for locating or identifying the consigned inventory item within the OnhandQuantityDetailsConsignedQuantityDetails table.
InventoryItemId Long The inventory item identifier that refers to the specific product or asset within the OnhandQuantityDetailsConsignedQuantityDetails table.
LocatorId Long The identifier for the specific storage location or warehouse slot of the inventory item within the OnhandQuantityDetailsConsignedQuantityDetails table.
LotNumber String The lot number associated with the batch or group of inventory items, typically used for traceability in the OnhandQuantityDetailsConsignedQuantityDetails table.
OrganizationId Long The identifier for the organization that owns or manages the inventory, used in the OnhandQuantityDetailsConsignedQuantityDetails table.
SerialNumber String The unique serial number identifying a specific unit of the inventory, which can be traced and tracked in the OnhandQuantityDetailsConsignedQuantityDetails table.
SubinventoryCode String The code identifying the subinventory within the organization where the item is stored, providing further categorization in the OnhandQuantityDetailsConsignedQuantityDetails table.

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