InventoryOnhandBalancesserialsserialAttributeDFFs
Customizes serial attributes using descriptive flexfields to support item-specific tracking needs.
Columns
| Name | Type | Description |
| InventoryOnhandBalancesInventoryItemId [KEY] | Long | The unique identifier for the inventory item in the on-hand balances record, linking to the master item definition. This identifier is essential for tracking stock levels, item availability, and transaction history within the inventory system. |
| InventoryOnhandBalancesLocatorId [KEY] | Long | The identifier for the specific locator within a warehouse or storage facility where the inventory item is stored. This identifier ensures precise inventory tracking at a bin, shelf, or aisle level, supporting efficient warehouse operations. |
| InventoryOnhandBalancesOrganizationId [KEY] | Long | The unique identifier for the organization or business unit responsible for maintaining the inventory on-hand balance. This identifier enables inventory segregation across different entities for accurate financial reporting and stock management. |
| InventoryOnhandBalancesOwningPartySiteId [KEY] | Long | The identifier for the physical site associated with the owning party of the inventory. This identifier is particularly useful for tracking consignment stock, supplier-managed inventory, and third-party logistics inventory ownership. |
| InventoryOnhandBalancesRevision [KEY] | String | The revision code associated with the inventory item, indicating a specific version or modification of the product. This code is crucial for managing engineering changes, product lifecycle tracking, and ensuring correct product versions are used. |
| InventoryOnhandBalancesSubinventoryCode [KEY] | String | The code representing the subinventory location within the organization where the inventory is stored. Subinventories are used to segregate inventory for different purposes, such as raw materials, finished goods, or quarantined stock. |
| InventoryOnhandBalancesSubinventoryGroup [KEY] | String | The grouping identifier for multiple subinventories, used for classification and inventory control. This identifier allows organizations to define bulk inventory policies and implement efficient warehouse management strategies. |
| InventoryOnhandBalancesSummaryLevel [KEY] | String | The summary level indicator specifying the granularity at which on-hand balances are recorded and reported. This indicator affects stock aggregation and visibility within warehouse operations and reporting. |
| SerialsCountryOfOriginCode [KEY] | String | The standardized country code representing the country where the serialized inventory item was manufactured or sourced. This country code is critical for customs compliance, regulatory documentation, and trade regulations. |
| SerialsInventoryProjectId [KEY] | Long | The unique identifier for the project associated with the serialized inventory item, enabling project-based inventory allocations. This identifier ensures that stock is assigned to the correct project for accurate costing and reporting. |
| SerialsInventoryTaskId [KEY] | Long | The unique identifier for the specific task within a project linked to the serialized inventory item. This identifier helps in tracking material consumption at a granular level, ensuring accurate cost distribution in project-driven industries. |
| SerialsOwningPartySiteId [KEY] | Long | The unique identifier for the site associated with the owning party of the serialized inventory item. This identifier is important for tracking inventory that is consigned, vendor-managed, or stored in third-party locations. |
| SerialsSerialNumber [KEY] | String | The unique serial number assigned to an individual inventory item, ensuring traceability and tracking. This serial number is critical for lifecycle management, warranty tracking, and compliance with serialized inventory regulations. |
| InventoryItemId [KEY] | Long | The unique identifier for the inventory item, linking it to the master item definition and inventory transactions. This identifier is the primary reference for stock management, procurement, and order fulfillment processes. |
| SerialNumber [KEY] | String | The unique serial number assigned to an inventory item for traceability and compliance purposes. Serial tracking helps in product recall management, warranty verification, and regulatory adherence. |
| CurrentOrganizationId [KEY] | Long | The unique identifier for the organization currently responsible for the inventory item. This identifier is useful in multi-organization environments to ensure proper tracking of stock movements and ownership. |
| _FLEX_Context | String | The attribute defining the context for descriptive flexfields (DFFs), enabling the customization of additional attributes within the inventory system. This allows organizations to store business-specific data related to serialized inventory. |
| _FLEX_Context_DisplayValue | String | A display value associated with the DFF context, providing a user-friendly description of the additional attributes stored in the DFF configuration. |
| Finder | String | A reference attribute used for searching and retrieving inventory records based on specific criteria. This attribute enhances system usability by allowing users to locate stock using various identifiers, descriptions, or classification codes. |
| LocatorId | Long | The identifier for the specific locator within a warehouse or storage facility where the inventory item is stored. This identifier ensures precise location tracking within the warehouse, aiding in inventory retrieval and replenishment. |
| OrganizationId | Long | The unique identifier for the organization or business unit responsible for maintaining the inventory record. This identifier allows for proper inventory segregation and financial tracking within multi-entity enterprises. |
| OwningPartySiteId | Long | The unique identifier for the site associated with the owning party of the inventory. This identifier ensures proper tracking of inventory ownership, which is important for consignment stock and vendor-managed inventory agreements. |
| Revision | String | The revision code associated with the inventory item, representing a specific version or modification of the product. This code is critical for engineering change control, ensuring the correct version of a product is used in manufacturing and sales. |
| SubinventoryCode | String | The code representing the subinventory location within the organization where the inventory is stored. This code allows for better segregation of inventory based on operational needs, such as raw materials, finished goods, or quarantined stock. |
| SubinventoryGroup | String | The grouping identifier for multiple subinventories, used for classification and inventory management. This identifier simplifies warehouse operations by enabling the application of bulk inventory policies and replenishment strategies. |
| SummaryLevel | String | The summary level indicator specifying the granularity at which on-hand balances are recorded and reported. This indicator determines how inventory data is aggregated and displayed in stock reports, affecting decision-making in supply chain management. |