InventoryOnhandBalanceslotslotSerialslotSerialAttributeDFFs
Customizes attributes of lot-serial items using descriptive flexfields for granular control.
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'. |
| 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 compliance. |
| LotsOwningPartySiteId [KEY] | Long | The unique identifier for the site associated with the owning party of the lot-controlled inventory item. This identifier supports consignment and supplier-managed stock tracking. |
| LotserialsCountryOfOriginCode [KEY] | String | An abbreviation representing the country of origin for the serial-tracked inventory item. This abbreviation ensures compliance with trade regulations and import/export documentation. |
| LotserialsInventoryProjectId [KEY] | Long | The unique identifier for the project associated with the serialized inventory lot. This identifier supports traceability of stock allocated to project-based transactions. |
| LotserialsInventoryTaskId [KEY] | Long | The unique identifier for the task associated with the serialized inventory lot. This identifier supports tracking of inventory movement within specific project tasks. |
| LotserialsOwningPartySiteId [KEY] | Long | The unique identifier for the site associated with the owning party of the serialized inventory lot. This identifier supports vendor-managed inventory and consignment tracking. |
| LotserialsSerialNumber [KEY] | String | The unique serial number assigned to an inventory item for tracking purposes. This serial number ensures serialized inventory management, traceability, and compliance. |
| InventoryItemId [KEY] | Long | The unique identifier for the inventory item. This identifier ensures accurate tracking of stock availability and movement across locations. |
| SerialNumber [KEY] | String | The unique serial number assigned to an inventory item for identification and tracking throughout its lifecycle. |
| CurrentOrganizationId [KEY] | Long | The unique identifier for the organization currently managing the serialized inventory. This identifier supports tracking of stock transfers across organizations. |
| _FLEX_Context | String | A descriptive flexfield (DFF) context name for serial number attributes. This context name allows for additional custom attributes specific to business needs. |
| _FLEX_Context_DisplayValue | String | A display value for the DFF context of serial number attributes. This value provides a user-friendly label for serial-specific tracking. |
| Finder | String | The lookup reference used to retrieve and manage serialized inventory lot tracking records. This reference enables efficient searching, reporting, and system queries. |
| 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. |
| OwningPartySiteId | 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. |
| Revision | String | The revision number of the inventory item. This revision 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. |