InventoryOnhandBalanceslotslotStandardDFFs
Provides descriptive flexfields for managing lot attributes for better 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 storage locator where the inventory item is placed within the warehouse. This identifier ensures precise inventory tracking. |
| InventoryOnhandBalancesOrganizationId [KEY] | Long | The unique identifier for the organization managing the inventory. This identifier supports multi-entity inventory control and stock ownership differentiation. |
| InventoryOnhandBalancesOwningPartySiteId [KEY] | Long | The unique identifier for the site associated with the owning party of the inventory lot. This identifier supports vendor-managed inventory and consignment tracking. |
| InventoryOnhandBalancesRevision [KEY] | String | The revision number of the inventory item, indicating changes in product design, specifications, or packaging. |
| InventoryOnhandBalancesSubinventoryCode [KEY] | String | An abbreviation representing the subinventory where the inventory item is stored. This abbreviation enables tracking of stock movement at a detailed level. |
| InventoryOnhandBalancesSubinventoryGroup [KEY] | String | The classification group for the subinventory storing the inventory item. This classification group allows for logical grouping of inventory locations. |
| InventoryOnhandBalancesSummaryLevel [KEY] | String | Indicates whether the inventory on-hand balance is maintained at a summary level (for example, organization-wide, subinventory-specific, or location-based). |
| LotsLotNumber [KEY] | String | The unique lot number assigned to a batch of inventory items. This lot number ensures traceability for quality control, expiration tracking, and regulatory compliance. |
| LotsOwningPartySiteId [KEY] | Long | The unique identifier for the site associated with the owning party of the lot-controlled inventory. This identifier supports consignment tracking and third-party stock management. |
| InventoryItemId [KEY] | Long | The unique identifier for the inventory item within the on-hand balances record. This identifier ensures accuracy in stock level tracking. |
| OrganizationId [KEY] | Long | The unique identifier for the organization responsible for managing the inventory lot. This identifier supports organization-wide inventory control. |
| LotNumber [KEY] | String | The unique identifier for the lot, enabling tracking of inventory batches across multiple transactions and storage locations. |
| _FLEX_Context | String | A descriptive flexfield (DFF) context name for lot standard attributes. This context name allows for additional attributes specific to business requirements. |
| _FLEX_Context_DisplayValue | String | A display value for the DFF context of lot standard attributes. This value provides a user-friendly label for inventory lot tracking. |
| Finder | String | The lookup reference used for retrieving and managing lot-based inventory tracking records. This reference supports quick searches and reporting. |
| LocatorId | Long | The unique identifier for the storage locator where the inventory lot is placed within the warehouse. This identifier ensures precision in inventory placement tracking. |
| OwningPartySiteId | Long | The unique identifier for the site associated with the owning party of the inventory lot. This identifier supports vendor-managed inventory and third-party tracking. |
| Revision | String | The revision number of the inventory lot, allowing for control over specification or version changes in stored inventory. |
| SubinventoryCode | String | An abbreviation representing the subinventory where the lot-controlled inventory is stored. This abbreviation supports inventory segmentation and tracking. |
| SubinventoryGroup | String | The classification group for the subinventory storing the lot. This classification group enables logical grouping of inventory locations. |
| SummaryLevel | String | Indicates whether the inventory on-hand balance is maintained at a summarized level, such as organization-wide, project-based, or detailed by subinventory. |