CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

InventoryOnhandBalances

Provides a summary of on-hand quantities at various levels, such as organization, subinventory, and locator.

Columns

Name Type Description
ItemNumber String The unique identifier for the inventory item. This identifier ensures accurate tracking of on-hand stock levels across locations.
ItemDescription String A full description of the inventory item. This description helps in identifying items in reports and user interfaces.
ItemPrimaryImageURL String The URL link to the primary image of the inventory item. This URL allows visual identification of items in inventory management systems.
PrimaryUOMCode String The unit of measure (UOM) code representing the primary measurement unit of the inventory item, such as 'EA' for each or 'KG' for kilograms.
OrganizationCode String An abbreviation representing the organization responsible for managing the inventory item. This abbreviation supports multi-organization inventory tracking.
SummaryLevel [KEY] String Indicates whether the inventory on-hand balance is summarized at a specific level, such as organization or subinventory.
InventoryItemId [KEY] Long The unique identifier for the inventory item in the system. This identifier ensures precise tracking and reporting of stock levels.
OrganizationId [KEY] Long The unique identifier for the organization managing the inventory. This identifier helps differentiate inventory ownership across multiple organizations.
Revision [KEY] String The revision number of the inventory item, indicating version control for items that undergo design or specification changes.
SubinventoryGroup [KEY] String A group classification for the subinventory storing the inventory item. This classification enables better categorization of stock locations.
SubinventoryCode [KEY] String An abbreviation representing the specific subinventory where the inventory item is stored. This abbreviation supports stock location tracking.
LocatorId [KEY] Long The unique identifier for the specific locator within the subinventory. This identifier ensures precise tracking of stock placement within warehouses.
ParLocation Long Indicates whether the inventory location is a periodic automatic replenishment (PAR) location. This field supports automated inventory replenishment processes.
OwningPartySiteId [KEY] Long The unique identifier for the site associated with the owning party of the inventory item. This identifier supports consignment and third-party inventory tracking.
PrimaryQuantity Decimal The available quantity of the inventory item in the primary UOM. This quantity reflects stock availability for order fulfillment.
ConsignedQuantity Decimal The quantity of inventory held under consignment. This quantity represents stock owned by a supplier but stored at the organization’s location.
StockingUOMCode String The UOM code representing how the inventory item is stocked, ensuring consistency in stockkeeping units.
StockingUnitOfMeasure String The full name of the stocking UOM, providing clarity in inventory storage and transactions.
StockingOnhandQuantity Decimal The available quantity of the inventory item in the stocking UOM. This quantity ensures accurate stock level tracking.
CategoryId Long The unique identifier for the category assigned to the inventory item. This identifier enables classification for reporting and tracking purposes.
CreationDate Datetime The date and time when the inventory on-hand record was created. This timestamp supports audit tracking and historical reporting.
LastUpdateDate Datetime The date and time when the inventory on-hand record was last updated. This timestamp ensures visibility into recent changes in stock levels.
Category String The category assigned to the inventory item. This category supports grouping and classification for inventory management.
OwningPartySite String The name of the site associated with the owning party of the inventory item. This name helps in tracking consigned inventory ownership.
OwningPartyId Long The unique identifier for the owning party of the inventory item. This identifier ensures accurate tracking of consigned inventory ownership.
OwningParty String The name of the owning party responsible for the inventory item. This name supports visibility in consignment and third-party stock tracking.
Locator String The specific storage location within the warehouse where the inventory item is placed. This storage location supports detailed stock placement tracking.
PrimaryUnitOfMeasure String The name of the primary UOM used for the inventory item, ensuring consistency in stock calculations.
MaterialStatusId Long The unique identifier for the material status assigned to the inventory item. This identifier helps manage stock availability based on status codes.
MaterialStatus String A description of the material status (for example, 'Available', 'Hold', or 'Restricted'). This description ensures proper inventory control and compliance.
Finder String The lookup reference used to retrieve and manage inventory on-hand balance records. This reference enables efficient searching, reporting, and system queries.

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