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