TradingPartnerItemRelationshipsLinkedMPNRelationships
Contains linked manufacturer part number (MPN) relationships for trading partner items.
Columns
| Name | Type | SupportedFinders | Description |
| TradingPartnerItemRelationshipsItemRelationshipId [KEY] | Long | Value that uniquely identifies the trading partner item relationship. | |
| TPILinkageId [KEY] | Long | Value that uniquely identifies MPN relationship linkage. | |
| RelationshipId | Long | Value that uniquely identifies the linked MPN relationship. | |
| PrimaryLinkageFlag | Bool | Value that identifies whether the linked MPN relationship is primary. The default value is False. | |
| CreatedBy | String | User who created the linked MPN relationship. | |
| CreationDate | Datetime | Date when the user created the linked MPN relationship. | |
| LastUpdateDate | Datetime | Date when the user most recently updated the linked MPN relationship. | |
| LastUpdateLogin | String | Login that the user used when updating the linked MPN relationship. | |
| LastUpdatedBy | String | User who most recently updated the linked MPN relationship. | |
| RelationshipStatus | String | Status of the linked MPN relationship. | |
| ManufacturerRegistryId | String | Value that uniquely identifies the manufacturer party. | |
| ManufacturerId | Long | Value that uniquely identifies the linked manufacturer. | |
| ManufacturerName | String | Name of the linked manufacturer. | |
| ManufacturerPartId | Long | Value that uniquely identifies the manufacturer trading partner item. | |
| ManufacturerPartNumber | String | Number that identifies a manufacturer part number. | |
| EffectiveDate | Datetime | FindAMLByEffectiveDate, findPendingRelationships, findTPIRelationshipsByRevisionEffectivity | Effective date of the relationship. |
| Finder | String | Finder attribute for the relationship. | |
| ItemId | Long | FindPendingRelationships, findTPIRelationshipsByRevisionEffectivity | Item identifier. |
| ItemNumber | String | FindAMLByEffectiveDate, findPendingRelationships, findTPIRelationshipsByRevisionEffectivity | Item number. |
| ItemRelationshipId | Long | PrimaryKey | Item relationship identifier. |
| PendingChangeLineId | Long | FindPendingRelationships | Pending change line identifier. |