CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

InventoryOnhandBalanceslots

Manages lot numbers linked to inventory balances for lot-controlled items, supporting traceability.

Columns

Name Type Description
InventoryOnhandBalancesInventoryItemId [KEY] Long The unique identifier for the inventory item within the on-hand balances record. This identifier ensures accurate tracking of stock levels at an item level.
InventoryOnhandBalancesLocatorId [KEY] Long The unique identifier for the locator where the inventory item is stored. This identifier supports precise stock placement tracking within warehouses.
InventoryOnhandBalancesOrganizationId [KEY] Long The unique identifier for the organization managing the inventory. This identifier helps differentiate inventory ownership across multiple business units.
InventoryOnhandBalancesOwningPartySiteId [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.
InventoryOnhandBalancesRevision [KEY] String The revision number of the inventory item, indicating version control for items that undergo design or specification changes.
InventoryOnhandBalancesSubinventoryCode [KEY] String An abbreviation representing the subinventory where the inventory item is stored. This abbreviation ensures accurate stock location tracking within the organization.
InventoryOnhandBalancesSubinventoryGroup [KEY] String The classification group for the subinventory storing the inventory item. This classification group enables better categorization of stock locations for operational purposes.
InventoryOnhandBalancesSummaryLevel [KEY] String Indicates whether the inventory on-hand balance is summarized at a specific level, such as 'Organization', 'Subinventory', or 'Project'.
LotNumber [KEY] String The unique number assigned to a specific batch of inventory items. This identifier supports lot tracking for quality control, expiration management, and regulatory compliance.
PrimaryQuantity Decimal The available quantity of the inventory item in the primary unit of measure (UOM). This quantity reflects stock availability for order fulfillment and replenishment.
OwningPartySiteId [KEY] Long The unique identifier for the site associated with the owning party of the inventory item. This identifier supports vendor-managed inventory and consignment tracking.
OwningPartyType String The classification of the owning party, such as 'Supplier' or 'Customer'. This classification helps define the relationship between the inventory owner and the organization storing it.
OwningPartyId Decimal The unique identifier for the owning party of the inventory item. This identifier ensures accurate tracking of consigned and third-party inventory ownership.
OwningParty String The name of the entity that owns the inventory item. This name supports visibility in consignment stock tracking and supplier-managed inventory.
OwningPartySite String The name of the site associated with the owning party of the inventory item. This name helps in tracking inventory that is consigned or managed by third parties.
MaterialStatusId Long The unique identifier for the material status assigned to the inventory item. This identifier helps manage stock availability based on predefined status codes.
MaterialStatus String A description of the material status, such as '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 lot records. This reference enables efficient searching, reporting, and system queries.
InventoryItemId Long The unique identifier for the inventory item. This identifier ensures accurate tracking of stock availability and movement across locations.
LocatorId Long The unique identifier for the specific storage locator within the warehouse. This identifier ensures precision in inventory placement tracking.
OrganizationId Long The unique identifier for the organization managing the inventory. This identifier helps differentiate inventory ownership across different entities.
Revision String The revision number of the inventory item. This number provides visibility into changes in product design or specification over time.
SubinventoryCode String An abbreviation representing the subinventory where the inventory item is stored. This abbreviation ensures accurate tracking of stock location within warehouses.
SubinventoryGroup String The classification group for the subinventory. This classification group supports logical grouping of inventory locations for better organization management.
SummaryLevel String Indicates whether the inventory on-hand balance is maintained at a summarized level, such as organization-wide, project-specific, or detailed at the subinventory level.

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