TradingPartnerItemRelationships
Manages relationships between internal items and trading partner items for better collaboration.
Columns
| Name | Type | Description |
| ItemRelationshipId [KEY] | Long | Specifies the unique identifier for the trading partner item relationship. This identifier is used to establish and track the association between an organization's item and a trading partner's corresponding item. |
| OrganizationId | Long | Defines the unique identifier for the organization that manages the item relationship. This identifier ensures that item trading relationships are properly assigned to the correct business entity. |
| OrganizationCode | String | Represents the abbreviated code that uniquely identifies the organization. This code helps link trading partner item relationships to specific business units. |
| InventoryItemId | Long | Contains the unique identifier for the inventory item in the organization's system. This identifier ensures that the correct internal item is linked to its external trading partner equivalent. |
| Item | String | Specifies the name or number of the part, item, product, or service within the organization’s inventory. This value is commonly used in procurement, sales, and inventory tracking. |
| TradingPartnerType | String | Indicates the type of trading partner, such as 'supplier', 'customer', 'distributor', 'manufacturer', or 'competitor'. This classification helps in managing item relationships with different business entities. |
| TradingPartnerId | String | Defines the unique identifier for the trading partner. This identifier ensures accurate mapping between the organization's items and the external trading partner's records. |
| TradingPartnerName | String | Represents the name of the trading partner associated with the item relationship. This name helps users identify the external entity that supplies, sells, or competes with the organization’s item. |
| RegistryId | String | Specifies the unique identifier for the trading partner within a registry system. This identifier is used for legal, compliance, and supplier/customer relationship management. |
| TradingPartnerItemId | Long | Contains the unique identifier for the trading partner’s item. This identifier ensures that each external item is correctly linked to the corresponding internal item. |
| TradingPartnerItemNumber | String | Represents the number assigned to a trading partner’s item, such as a supplier item number, customer item number, manufacturer part number, or competitor reference number. |
| RelationshipDescription | String | Provides a textual description of the trading partner item relationship. This description helps document the nature of the association, such as supply agreements, resale partnerships, or competitive analysis. |
| StartDateTime | Datetime | Indicates the date and time when the trading partner item relationship becomes active. This information ensures proper tracking of when an item relationship is valid for transactions or reporting. |
| EndDateTime | Datetime | Defines the date and time when the trading partner item relationship expires or becomes inactive. This information ensures proper governance of outdated or terminated relationships. |
| CustomerItemRelationshipRank | Long | Specifies the ranking used within a customer item relationship. This ranking helps prioritize multiple customer item mappings based on importance or usage frequency. |
| CompetitorItemRelationshipType | String | Indicates the type of competitor associated with the item relationship, such as 'direct competitor', 'indirect competitor', or 'substitute provider'. |
| RelationshipStatus | String | Represents the current status of the trading partner item relationship, such as 'Active', 'Inactive', 'Pending Approval', or 'Obsolete'. This status helps in managing the lifecycle of item relationships. |
| CreationDateTime | Datetime | Specifies the date and time when the trading partner item relationship record was created. This information is useful for auditing and historical tracking of item relationships. |
| LastUpdateDateTime | Datetime | Indicates the date and time when the trading partner item relationship was last updated. This information ensures that the latest changes are captured for reporting and analysis. |
| CreatedBy | String | Represents the user who initially created the trading partner item relationship record. This value is important for audit trails and accountability. |
| LastUpdateLogin | String | Defines the user session that last updated the trading partner item relationship record. This information helps track system access and modification history. |
| LastUpdatedBy | String | Specifies the user who made the most recent changes to the trading partner item relationship. This value is useful for maintaining audit logs and security compliance. |
| TradingPartnerItemDescription | String | Provides a detailed description of the trading partner’s item. This description helps users understand the external item’s specifications, features, or intended use. |
| TradingPartnerItemStatus | String | Indicates the status of the trading partner’s item, such as 'Active', 'Discontinued', or 'Pending Approval'. This status ensures that only valid items are used in transactions. |
| TradingPartnerStatus | String | Represents the overall status of the trading partner, such as 'Approved', 'On Hold', or 'Blacklisted'. This status helps in enforcing supplier or customer management policies. |
| EffectiveDate | Datetime | Specifies the date when the trading partner item relationship becomes effective for transactions and reporting. This date ensures proper activation timing for business processes. |
| Finder | String | Defines the search mechanism or query criteria used to locate records in the TradingPartnerItemRelationships module. This value enhances system usability by enabling efficient data retrieval for item relationships. |
| ItemNumber | String | Represents the internal item number used by the organization. This item number ensures that internal records are accurately linked to external trading partner items for seamless integration. |