ItemsV2ItemRevisionItemRevisionEffCategory
Manages extensible flexfields for item revisions, capturing custom attributes related to changes.
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-effective categories, ensuring structured classification and version control. |
ItemsV2OrganizationId [KEY] | Long | The unique identifier for the organization managing the item. This identifier ensures that item revision-effective categories are correctly mapped to the appropriate business unit, supporting governance, access control, and reporting. |
ItemrevisionInventoryItemId [KEY] | Long | The unique identifier assigned to an inventory-managed part, item, product, or service that has undergone a revision. This identifier plays a crucial role in ensuring that revised items are accurately tracked within inventory management. |
ItemrevisionOrganizationId [KEY] | Long | The identifier representing the organization responsible for managing the item revision. This identifier at the revision is assigned to the correct organization, maintaining data integrity across business units. |
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 supports version tracking across engineering, procurement, and inventory processes. |
RevisionId [KEY] | Long | The system-generated identifier that uniquely defines a specific revision of an item. This identifier is essential for revision control, enabling businesses to manage product lifecycle changes, compliance updates, and engineering modifications. |
CategoryCode | String | The standardized category code assigned to the item revision, determining how the revised item is classified. Categories help group similar revisions together, enabling structured management of versioned products and components. |
VersionId | Long | The system-generated identifier representing the version of the item revision-effective category record. This identifier supports historical tracking of changes to item classification, ensuring compliance with regulatory and business reporting standards. |
AcdType | String | The classification type assigned to the item revision, defining how it is processed within the system. This classification type affects workflows such as compliance tracking, approval processes, and category-specific business rules. |
ChangeLineId | Long | The unique identifier that links the item revision record to a specific change request or engineering change order (ECO). This identifier ensures traceability of revisions and supports controlled change management processes. |
Finder | String | The reference to an internal search or query mechanism that allows users to efficiently locate item revision-effective category records within the system. This reference enhances usability and enables quick retrieval of classified 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 operations, and supply chain workflows. |
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-effective category assignments. |
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 to provide quick reference and ensure consistency in revision tracking. |
OrganizationCode | String | The standardized alphanumeric code representing the organization responsible for the item revision. This code ensures consistency across financial reporting, inventory tracking, and business unit operations. |
OrganizationId | Long | The unique identifier representing the organization associated with the item revision-effective category. This identifier ensures proper mapping of revisions within business units and aligns with enterprise reporting standards. |