ItemsV2ItemRevisionItemRevisionDFF
Handles descriptive flexfields specific to item revisions for contextual customization.
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 revision-level descriptive flexfields (DFFs), allowing customization of attributes specific to item revisions. |
ItemsV2OrganizationId [KEY] | Long | The unique identifier for the organization managing the item. This identifier ensures that item revision-level DFFs are correctly assigned to the appropriate business unit, supporting data governance and access control. |
ItemrevisionInventoryItemId [KEY] | Long | The unique identifier assigned to an inventory-managed part, item, product, or service that has undergone a revision. This identifier ensures proper classification and version tracking within inventory management processes. |
ItemrevisionOrganizationId [KEY] | Long | The identifier representing the organization responsible for managing the item revision. This identifier helps maintain accurate revision tracking and ensures compliance with organizational structures and business rules. |
ItemrevisionRevisionId [KEY] | Long | The unique identifier that links the inventory item to a specific revision. This identifier ensures traceability of changes to the item and aligns with product lifecycle management (PLM) and engineering change order (ECO) processes. |
RevisionId [KEY] | Long | The system-generated identifier that uniquely defines a specific revision of an item. This identifier supports revision control, enabling businesses to manage engineering changes, compliance updates, and version tracking. |
_FLEX_ValidationDate | Date | The date when the DFF attributes for the item revision were validated. This date helps enforce data accuracy and ensures that DFF attributes comply with predefined validation rules. |
_FLEX_Context | String | The DFF context name assigned to the item revision. This context name determines how additional attributes are applied to revisions, allowing flexibility in managing item-specific and industry-specific details. |
_FLEX_NumOfSegments | Int | The total number of segments (fields) configured within the DFF structure for item revisions. This field helps define how much metadata is associated with a revision. |
_FLEX_NumOfVisibleSegments | Int | The number of segments (fields) that are visible to users within the DFF structure. This field determines the level of detail available for viewing or editing revision-specific attributes. |
AcdType | String | The classification type assigned to the item revision, determining how it is processed within the system. This classification type influences business rules such as compliance tracking, product change approvals, and workflow automation. |
ChangeLineId | Long | The unique identifier that links the item revision DFF record to a specific change request or modification. This identifier ensures traceability of revisions and supports audit tracking and compliance verification. |
Finder | String | The reference to an internal search or query mechanism that helps users efficiently locate item revision records within the system. This reference enhances usability and enables quick retrieval of historical revisions. |
InventoryOrganizationId | Long | The unique identifier of the inventory organization responsible for managing the item revision. This identifier ensures that revisions are properly accounted for in inventory tracking, warehouse management, and supply chain operations. |
ItemId | Long | The unique identifier for the item, serving as a reference for inventory, procurement, and product lifecycle management. This identifier is crucial for linking items to their revision-specific DFFs. |
ItemNumber | String | A 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 revision tracking. |
OrganizationCode | String | The standardized alphanumeric code representing the organization responsible for the item revision. This code ensures uniformity across financial reporting, inventory tracking, and business unit operations. |
OrganizationId | Long | The unique identifier representing the organization associated with the item revision DFF record. This identifier ensures proper mapping of revisions within business units and aligns with enterprise reporting standards. |
VersionId | Long | The system-generated identifier representing the version of the item revision DFF record. This identifier allows historical tracking of modifications, ensuring compliance with regulatory and business reporting requirements. |