InventoryOnhandBalanceslots
Manages lot numbers linked to inventory balances for lot-controlled items, supporting traceability.
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'. |
LotNumber [KEY] | String | The unique number assigned to a specific batch of inventory items. This identifier supports lot tracking for quality control, expiration management, and regulatory compliance. |
PrimaryQuantity | Decimal | The available quantity of the inventory item in the primary unit of measure (UOM). This quantity reflects stock availability for order fulfillment and replenishment. |
OwningPartySiteId [KEY] | Long | The unique identifier for the site associated with the owning party of the inventory item. This identifier supports vendor-managed inventory and consignment tracking. |
OwningPartyType | String | The classification of the owning party, such as 'Supplier' or 'Customer'. This classification helps define the relationship between the inventory owner and the organization storing it. |
OwningPartyId | Decimal | 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. |
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. |
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. |
MaterialStatus | String | A description of the material status, such as '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 lot 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 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. |