CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

OnhandQuantityDetailsInboundQuantityDetails

Tracks inbound quantity details for specified items and locations, aiding in receiving and inventory planning.

Columns

Name Type Description
OnhandQuantityDetailsInventoryItemId [KEY] Long The unique identifier for the inventory item in the OnhandQuantityDetailsInboundQuantityDetails table, representing a specific product or item.
OnhandQuantityDetailsLocatorId [KEY] Long The identifier for the storage location within the warehouse where the inventory item is stored in the OnhandQuantityDetailsInboundQuantityDetails table.
OnhandQuantityDetailsLotNumber [KEY] String The lot number assigned to a batch of inventory items within the OnhandQuantityDetailsInboundQuantityDetails table. It helps track the production or receipt batch of items.
OnhandQuantityDetailsOrganizationId [KEY] Long The identifier of the organization that owns the inventory items in the OnhandQuantityDetailsInboundQuantityDetails table, usually linked to a company or business unit.
OnhandQuantityDetailsSerialNumber [KEY] String The unique serial number assigned to an individual inventory item within the OnhandQuantityDetailsInboundQuantityDetails table for traceability and warranty purposes.
OnhandQuantityDetailsSubinventoryCode [KEY] String The code representing the subinventory where the inventory item is located within the OnhandQuantityDetailsInboundQuantityDetails table, typically linked to a specific storage area.
InboundQuantity Decimal The quantity of the inventory item being received or inbound in the OnhandQuantityDetailsInboundQuantityDetails table, reflecting incoming stock or shipments.
SecondaryInboundQuantity Decimal An additional quantity field for inbound items in the OnhandQuantityDetailsInboundQuantityDetails table, typically used for different units of measure or secondary tracking purposes.
DocumentNumber [KEY] String The document number associated with the transaction or shipment in the OnhandQuantityDetailsInboundQuantityDetails table, used for tracking and reference purposes.
LineNumber [KEY] Decimal The line number in the document or shipment for the OnhandQuantityDetailsInboundQuantityDetails table, often used for distinguishing between multiple items in a single shipment.
Schedule String A schedule identifier in the OnhandQuantityDetailsInboundQuantityDetails table, potentially indicating the planned date or timing of the inbound inventory transaction.
DocumentType String The type of document (for example, purchase order, transfer) associated with the transaction in the OnhandQuantityDetailsInboundQuantityDetails table, providing context for the inbound inventory.
Finder String A reference to the system or tool used to search for or locate the inventory item in the OnhandQuantityDetailsInboundQuantityDetails table, potentially representing a user or software.
InventoryItemId Long The identifier for the inventory item in the OnhandQuantityDetailsInboundQuantityDetails table, representing the specific product or item in the system.
LocatorId Long The identifier for the location of the inventory item within the warehouse, typically a shelf or bin, in the OnhandQuantityDetailsInboundQuantityDetails table.
LotNumber String The lot number or batch identifier assigned to a group of items in the OnhandQuantityDetailsInboundQuantityDetails table, useful for managing product recalls or quality control.
OrganizationId Long The organization identifier representing the business or entity managing the inventory in the OnhandQuantityDetailsInboundQuantityDetails table.
SerialNumber String A unique serial number used to identify individual units of inventory within the OnhandQuantityDetailsInboundQuantityDetails table, ensuring traceability and detailed management.
SubinventoryCode String A code representing the subinventory where the items are located in the OnhandQuantityDetailsInboundQuantityDetails table, typically corresponding to specific areas within a warehouse.

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