TradingPartnerItemRelationshipsLinkedMPNRelationships
Contains linked manufacturer part number (MPN) relationships for trading partner items.
Columns
| Name | Type | 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 | Effective date of the relationship. |
| Finder | String | Finder attribute for the relationship. |
| ItemId | Long | Item identifier. |
| ItemNumber | String | Item number. |
| ItemRelationshipId | Long | Item relationship identifier. |
| PendingChangeLineId | Long | Pending change line identifier. |