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. |