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