InventoryOnhandBalancesserialsserialStandardDFFs
Stores standard descriptive flexfields for serials, enabling structured data tracking and reporting.
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 across warehouse locations. |
| 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 tracking at a bin, shelf, or aisle level, facilitating efficient inventory movement and storage. |
| InventoryOnhandBalancesOrganizationId [KEY] | Long | The unique identifier for the organization or business unit responsible for maintaining the inventory on-hand balance. This identifier allows for inventory segregation across multiple organizations, ensuring accurate financial reporting and stock tracking. |
| InventoryOnhandBalancesOwningPartySiteId [KEY] | Long | The identifier for the site associated with the owning party of the inventory. This identifier is used to track inventory ownership at a specific location, which is crucial for managing vendor-owned stock, consignment inventory, and third-party logistics. |
| InventoryOnhandBalancesRevision [KEY] | String | The revision code associated with the inventory item, indicating a specific version or modification of the product. This code is critical for managing engineering changes, tracking product lifecycle updates, and ensuring proper inventory handling based on version control. |
| InventoryOnhandBalancesSubinventoryCode [KEY] | String | The code representing the subinventory location within the organization where the inventory is stored. Subinventories are used to categorize inventory for operational purposes, such as segregating raw materials, finished goods, or quarantine stock. |
| InventoryOnhandBalancesSubinventoryGroup [KEY] | String | The grouping identifier for multiple subinventories, used for classification and streamlined inventory control. This identifier enables organizations to apply bulk inventory policies, replenishment strategies, and consolidated reporting filters across related subinventories. |
| InventoryOnhandBalancesSummaryLevel [KEY] | String | The summary level indicator specifying the granularity at which on-hand balances are recorded and reported. This indicator affects how stock data is aggregated and displayed in reports, impacting decision-making and inventory control strategies. |
| SerialsCountryOfOriginCode [KEY] | String | The standardized country code representing the country where the serialized inventory item was manufactured or sourced. This country code is necessary for trade compliance, customs documentation, and country-of-origin regulations. |
| SerialsInventoryProjectId [KEY] | Long | The unique identifier for the project associated with the serialized inventory item, ensuring that stock is assigned correctly within project-based inventory management. This identifier helps track materials used in specific projects, aiding in cost allocation and reporting. |
| SerialsInventoryTaskId [KEY] | Long | The unique identifier for the specific task within a project linked to the serialized inventory item. This identifier facilitates granular tracking of materials, ensuring that inventory is used efficiently within specific work activities and budget allocations. |
| SerialsOwningPartySiteId [KEY] | Long | The unique identifier for the site associated with the owning party of the serialized inventory item. This identifier is critical for tracking inventory ownership in consignment stock scenarios, supplier-managed inventory, and customer-assigned stock. |
| SerialsSerialNumber [KEY] | String | The unique serial number assigned to a specific inventory item, ensuring traceability throughout its lifecycle. Serial tracking helps in warranty management, recall processes, and regulatory compliance related to serialized inventory. |
| InventoryItemId [KEY] | Long | The unique identifier for the inventory item, linking it to the master item definition and inventory transactions. This identifier serves as the primary reference for inventory management, procurement, and order fulfillment. |
| SerialNumber [KEY] | String | The unique serial number assigned to an inventory item, used for traceability and tracking throughout the supply chain. This serial number is crucial for quality control, warranty verification, and compliance with regulatory requirements. |
| CurrentOrganizationId [KEY] | Long | The unique identifier for the organization currently responsible for the inventory item. This identifier ensures accurate ownership tracking in multi-organization setups, preventing discrepancies in stock movements and financial reporting. |
| _FLEX_Context | String | An attribute defining the context for descriptive flexfields (DFF), enabling the customization of additional attributes within the inventory system. This attribute allows organizations to store business-specific data related to serialized inventory attributes. |
| _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 enables precise location tracking, improving warehouse efficiency and ensuring accurate inventory retrieval. |
| OrganizationId | Long | The unique identifier for the organization or business unit responsible for maintaining the inventory record. This identifier ensures that stock levels, financial ownership, and warehouse transactions are properly assigned in multi-entity environments. |
| OwningPartySiteId | Long | The unique identifier for the site associated with the owning party of the inventory. This identifier is essential for tracking inventory ownership, particularly in cases of vendor consignment, contract manufacturing, and third-party logistics arrangements. |
| Revision | String | The revision code associated with the inventory item, representing a specific version or modification of the product. This code is critical for industries with strict engineering change control processes, ensuring that the correct product version is used in production and sales. |
| SubinventoryCode | String | The code representing the subinventory location within the organization where the inventory is stored. This code allows for better classification and segregation of stock based on operational needs, such as raw materials, finished goods, or repair stock. |
| SubinventoryGroup | String | The grouping identifier for multiple subinventories, used for classification and inventory control. This identifier simplifies warehouse operations by enabling the application of bulk inventory policies and inventory tracking across related subinventories. |
| 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 reports, impacting decision-making in warehouse and supply chain management. |