Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

InventoryOnhandBalancesserials

Tracks serial numbers for serial-controlled inventory items for improved visibility and accountability.

Columns

Name Type Description
InventoryOnhandBalancesInventoryItemId [KEY] Long The unique identifier for the inventory item in the on-hand balances record, linking to the master item definition. This identifier is crucial for tracking stock levels, item availability, and transaction history within the inventory management system.
InventoryOnhandBalancesLocatorId [KEY] Long The identifier for the specific locator within a warehouse or storage facility where the inventory item is stored. This identifier ensures precise inventory tracking at a bin, shelf, or aisle level, facilitating efficient retrieval and restocking operations.
InventoryOnhandBalancesOrganizationId [KEY] Long The unique identifier for the organization or business unit responsible for maintaining the inventory on-hand balance. This identifier is essential for multi-organization inventory management, allowing for accurate financial reporting and stock movement tracking across entities.
InventoryOnhandBalancesOwningPartySiteId [KEY] Long The identifier for the physical site associated with the owning party of the inventory. This identifier is used to track where inventory ownership is maintained, which is especially important for consignment stock, supplier-managed inventory, and third-party logistics providers.
InventoryOnhandBalancesRevision [KEY] String The revision code associated with the inventory item, indicating a specific version or modification of the product. This code is critical for managing engineering changes, product lifecycle tracking, and ensuring the correct version of an item is used in manufacturing or sales orders.
InventoryOnhandBalancesSubinventoryCode [KEY] String The code representing the subinventory location within the organization where the inventory is stored. This subinventory classification is used to segregate inventory by purpose, such as raw materials, finished goods, or quarantined stock, supporting better warehouse management.
InventoryOnhandBalancesSubinventoryGroup [KEY] String The grouping identifier for multiple subinventories, used for classification and streamlined inventory control. This identifier enables organizations to apply bulk inventory policies, replenishment strategies, and reporting filters across related subinventories.
InventoryOnhandBalancesSummaryLevel [KEY] String The summary level indicator specifying the granularity at which on-hand balances are recorded and reported. This indicator can include detail levels such as lot, locator, or subinventory, which affect how stock levels are calculated and displayed in reporting.
SerialNumber [KEY] String The unique serial number assigned to an individual inventory item for traceability and tracking. Serial numbers enable lifecycle tracking, warranty management, and compliance with regulatory requirements related to serialized inventory.
MaterialStatusId Long The system-generated identifier for the material status, defining whether the inventory is available, restricted, or obsolete. Material status codes help enforce inventory policies such as reserving stock for specific customers or preventing the issuance of expired goods.
InventoryProjectId [KEY] Long The unique identifier for the project associated with the inventory item, used for tracking project-based inventory allocations. This identifier allows organizations to allocate stock to specific contracts, construction projects, or research-and-development initiatives, ensuring proper costing and resource planning.
InventoryTaskId [KEY] Long The unique identifier for the specific task within a project linked to the inventory item, ensuring proper tracking and costing. This identifier is commonly used in project-driven industries where materials are allocated and consumed based on defined work breakdown structures.
CountryOfOriginCode [KEY] String The standardized country code representing the country where the inventory item was manufactured or sourced. This country code is crucial for customs compliance, trade regulations, and accurate reporting on country-of-origin-based tariffs or restrictions.
OwningPartySiteId [KEY] Long The unique identifier for the site associated with the owning party of the inventory, supporting ownership tracking. This identifier is particularly important for organizations handling consigned inventory, contract manufacturing, or vendor-managed stock.
MaterialStatus String The status of the material indicating availability, hold status, or restricted use within inventory control processes. Material statuses prevent unauthorized use of inventory, ensure quality control compliance, and facilitate warehouse efficiency.
OwningPartyId String The unique identifier for the entity that owns the inventory, which may be a supplier, customer, or business division. This identifier ensures clear accountability for stock, especially in cases of loaned, consigned, or shared inventory.
OwningPartyType String The classification of the owning party, distinguishing whether the inventory is owned by a supplier, customer, or internal business unit. This classification helps organizations manage inventory obligations, contract terms, and financial reporting of stock ownership.
OwningPartySite String The specific location associated with the owning party, used for tracking and accountability of inventory ownership. This location is critical in supply chain operations where inventory is stored at customer sites, vendor warehouses, or third-party logistics centers.
OwningParty String The name or designation of the entity that owns the inventory, facilitating identification and reporting. This entity helps distinguish between internally owned stock, vendor consigned inventory, and customer-managed stock in shared supply chain models.
InventoryProject String The name or code of the project associated with the inventory item, aiding in project-based cost and stock tracking. Project-level inventory control ensures that allocated stock is used appropriately and aligns with budgeted material requirements.
InventoryTask String The name or description of the task linked to the inventory, providing additional detail for project-based inventory assignments. This task is crucial for industries like construction and engineering, where materials are allocated to specific work activities.
CountryOfOrigin String The full name of the country where the inventory item was manufactured or sourced, used for compliance and reporting. This information is necessary for regulatory documentation, preferential trade agreements, and country-of-origin labeling.
Finder String A reference attribute used for searching and retrieving inventory records based on specific criteria. This attribute enhances system usability by allowing users to locate stock using various identifiers, descriptions, or classification codes.
InventoryItemId Long The unique identifier for the inventory item, linking it to the master item definition and inventory transactions. This identifier is the primary reference for stock management, procurement, and order fulfillment processes.
LocatorId Long The identifier for the specific locator within a warehouse or storage facility where the inventory item is stored. Locators define precise storage locations, such as rack and bin numbers, ensuring efficient inventory movement and picking operations.
OrganizationId Long The unique identifier for the organization or business unit responsible for maintaining the inventory record. This identifier ensures that stock levels, financial ownership, and warehouse transactions are correctly assigned within a multi-entity enterprise.
Revision String The revision code associated with the inventory item, indicating a specific version or modification of the product. Revision control is essential for industries with strict compliance requirements, ensuring the correct product version is used in manufacturing and sales.
SubinventoryCode String The code representing the subinventory location within the organization where the inventory is stored. Subinventories categorize inventory into meaningful segments, such as raw materials, finished goods, or repair stock, for better tracking and reporting.
SubinventoryGroup String The grouping identifier for multiple subinventories, used for classification and inventory management. Subinventory groups allow organizations to apply bulk inventory policies, simplifying inventory replenishment and warehouse operations.
SummaryLevel String The summary level indicator specifying the granularity at which on-hand balances are recorded and reported. This indicator determines how inventory data is aggregated and displayed in stock reports, affecting decision-making in supply chain management.

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