CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

InventoryOnhandBalanceslotslotSerials

Tracks serial numbers for lot-controlled items, ensuring detailed visibility of inventory.

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'.
LotsLotNumber [KEY] String The unique lot number assigned to a batch of inventory items. This lot number ensures traceability for quality control, expiration tracking, and compliance.
LotsOwningPartySiteId [KEY] Long The unique identifier for the site associated with the owning party of the lot-controlled inventory item. This identifier supports consignment and supplier-managed stock tracking.
SerialNumber [KEY] String The unique serial number assigned to an inventory item for tracking purposes. This serial number supports serialized inventory management and traceability.
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.
InventoryProjectId [KEY] Long The unique identifier for the project associated with the inventory lot. This identifier ensures traceability of stock allocated to project-based transactions.
InventoryTaskId [KEY] Long The unique identifier for the task associated with the inventory lot. This identifier supports tracking of inventory movement within specific project tasks.
CountryOfOriginCode [KEY] String An abbreviation representing the country of origin for the inventory lot. This abbreviation ensures compliance with trade regulations and import/export documentation.
OwningPartySiteId [KEY] Long The unique identifier for the site associated with the owning party of the inventory lot. This identifier supports vendor-managed inventory and consignment tracking.
MaterialStatus String A description of the material status, such as 'Available', 'Hold', or 'Restricted'. This description ensures proper inventory control and compliance.
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.
OwningPartyId Long 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.
InventoryProject String The project name associated with the inventory lot. This project name supports clear project-based inventory tracking.
InventoryTask String The task name associated with the inventory lot. This task name helps track inventory movement at a task-specific level within a project.
CountryOfOrigin String The full name of the country of origin for the inventory lot. This name ensures proper identification for regulatory compliance and supplier tracking.
Finder String The lookup reference used to retrieve and manage inventory on-hand lot tracking attribute 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 revision 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