ItemsV2ItemSupplierAssociationItemSupplierEffCategory
Handles extensible flexfields for item-supplier associations, enabling custom attribute management.
Columns
| Name | Type | Description |
| ItemsV2ItemId [KEY] | Long | The unique identifier for an item within the ItemsV2 module. This identifier links item records to their supplier association category, ensuring structured supplier management and classification. |
| ItemsV2OrganizationId [KEY] | Long | The unique identifier for the organization managing the item. This identifier ensures that supplier associations and their corresponding categories are correctly mapped to the appropriate business unit, supporting procurement and compliance workflows. |
| ItemsupplierassociationAcdType [KEY] | String | The classification type assigned to the supplier-item association, determining how the supplier relationship is processed within procurement, sourcing, and supply chain management workflows. |
| ItemsupplierassociationChangeLineId [KEY] | Int | The unique identifier that links the supplier association category record to a specific change request. This identifier ensures traceability of modifications related to supplier classification updates. |
| ItemsupplierassociationInventoryItemId [KEY] | Long | The unique identifier assigned to an inventory-managed item, product, or service associated with a supplier. This identifier plays a key role in managing supplier sourcing and inventory tracking. |
| ItemsupplierassociationItemId [KEY] | Long | The unique identifier for the item that is associated with the supplier. This identifier ensures correct linkage between suppliers and their assigned items within procurement and sourcing systems. |
| ItemsupplierassociationOrganizationId [KEY] | Long | The unique identifier representing the organization that manages the supplier association. This identifier ensures that supplier relationships align with the correct business unit and regulatory requirements. |
| ItemsupplierassociationOrganizationId1 [KEY] | Long | An additional identifier for the organization that manages the supplier association. This identifier can be used for hierarchical or multi-entity supplier relationships. |
| ItemsupplierassociationSupplierId [KEY] | Long | The unique identifier for the supplier associated with the item. This identifier is a key reference for managing supplier relationships, purchase agreements, and sourcing decisions. |
| ItemsupplierassociationSupplierSiteId [KEY] | Long | The unique identifier assigned to the supplier's specific site location. This identifier ensures that purchase orders, deliveries, and payments are correctly associated with the right supplier site. |
| ItemsupplierassociationVersionId [KEY] | Long | The system-generated identifier representing the version of the supplier association category record. This identifier enables historical tracking of supplier classifications and version control. |
| AcdType [KEY] | String | The classification type assigned to the item-supplier association category. This classification type determines how supplier-related transactions and business rules are applied. |
| AssociationId | Long | The unique identifier defining the relationship between an item and its supplier. This identifier is essential for tracking supplier agreements, preferred sourcing, and supplier qualification processes. |
| OrganizationId [KEY] | Long | The unique identifier representing the organization that manages the supplier relationship. This identifier ensures supplier classification is correctly aligned with company structures and regulatory policies. |
| VersionId [KEY] | Long | The system-generated identifier representing the version of the supplier-item association record. This identifier enables audit tracking and version control of supplier relationships. |
| MasterOrganizationId | Long | The unique identifier for the master organization overseeing the supplier association. This identifier is used in global supplier management to ensure consistency across multiple business units. |
| SupplierId [KEY] | Long | The unique identifier assigned to the supplier. This identifier plays a key role in procurement, contract management, and financial transactions with the supplier. |
| SupplierSiteId [KEY] | Long | The unique identifier for a specific supplier site. This identifier ensures that supplier transactions, including shipments and invoices, are assigned to the correct location. |
| CategoryCode | String | The category assigned to the supplier-item association. This categorization enables businesses to classify suppliers based on factors such as commodity type, regulatory status, or business impact. |
| ChangeLineId | Long | The unique identifier that links the supplier association category record to a specific change request. This identifier ensures traceability of modifications related to supplier classification updates. |
| Finder | String | The reference to an internal search or query mechanism that allows users to efficiently locate supplier association category records. This reference enhances usability and data retrieval in procurement processes. |
| InventoryOrganizationId | Long | The unique identifier of the inventory organization responsible for managing the supplier association. This identifier ensures that supplier sourcing rules align with inventory planning and procurement strategies. |
| ItemId | Long | The unique identifier for the item linked to the supplier association category. This identifier ensures correct classification of supplier-item relationships within the sourcing system. |
| ItemNumber | String | A human-readable item number assigned to the product, part, or service. This item number is used in procurement transactions and supplier catalogs to ensure consistency in sourcing and supplier classification. |
| OrganizationCode | String | The standardized alphanumeric code representing the organization responsible for managing the supplier association category. This code ensures uniformity across procurement reporting and compliance tracking. |