ItemsV2ItemDFF
Manages contextual descriptive flexfields specific to items, allowing for tailored attribute definitions.
Columns
Name | Type | Description |
ItemsV2ItemId [KEY] | Long | The unique identifier for an item within the ItemsV2 module. This identifier serves as a primary key that links item records to their associated descriptive flexfields (DFFs), ensuring accurate classification, reporting, and business rule enforcement. |
ItemsV2OrganizationId [KEY] | Long | The unique identifier for the organization managing the item. This identifier ensures that item-related DFFs are correctly mapped to the relevant business unit, supporting access control and data segregation. |
InventoryItemId [KEY] | Long | The unique identifier assigned to a specific inventory part, item, product, or service. This identifier is critical for tracking products across procurement, warehouse management, sales, and financial reporting. |
OrganizationId [KEY] | Long | The identifier representing the organization to which the item belongs. This identifier is essential for maintaining accurate inventory and financial records and should be reviewed and updated using the Setup and Maintenance work area under the Manage Inventory Organizations task. |
_FLEX_Context | String | The DFF context name assigned to the item. This field is used to capture additional custom attributes that vary based on business requirements, allowing greater flexibility in item classification and reporting. |
_FLEX_Context_DisplayValue | String | The human-readable display value of the DFF context. This value provides a user-friendly label for custom attributes associated with the item. |
AcdType | String | The classification type assigned to the item, which determines how it is processed within the system. This classification type is essential for defining item behavior, influencing workflows such as pricing models, tax applicability, and supply chain rules. |
ChangeLineId | Long | The unique identifier that links the item record to a specific change request or modification. This identifier ensures traceability of changes made to items, supporting version control and audit tracking. |
Finder | String | The reference to an internal search or query mechanism that helps users efficiently locate item records within the system. This field improves navigation and usability, particularly in environments with large datasets. |
InventoryOrganizationId | Long | The unique identifier of the inventory organization responsible for managing the item. This identifier is critical for aligning inventory transactions, ensuring stock availability, and managing warehouse operations. |
ItemId | Long | The unique identifier for the item, serving as a key reference for inventory, procurement, and product lifecycle management. This identifier is crucial for linking items to DFFs and ensuring accurate data tracking. |
ItemNumber | String | The human-readable item number assigned to a product, part, or service. This item number is used across procurement, sales, and inventory management for quick reference and item identification. |
OrganizationCode | String | The standardized alphanumeric code representing the organization responsible for the item. This code ensures consistency across financial reporting, inventory tracking, and business unit operations. |
VersionId | Long | The system-generated identifier representing the version of the item record. This identifier allows historical tracking of changes, ensuring compliance with regulatory and business reporting requirements. |