TradingPartnerItemRelationshipsLinkedSupplierItemRelationships
Contains linked supplier item 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 the supplier item relationship linkage. | |
| RelationshipId | Long | Value that uniquely identifies the linked supplier item relationship. | |
| PrimaryLinkageFlag | Bool | Value that identifies whether the linked supplier item relationship is primary. The default value is False. | |
| CreatedBy | String | User who created the linked supplier item relationship. | |
| CreationDate | Datetime | Date when the user created the linked supplier item relationship. | |
| LastUpdateDate | Datetime | Date when the user most recently updated the linked supplier item relationship. | |
| LastUpdateLogin | String | Login associated with the user who most recently updated the linked supplier item relationship. | |
| LastUpdatedBy | String | User who most recently updated the linked supplier item relationship. | |
| RelationshipStatus | String | Status of the linked supplier item relationship. | |
| SupplierRegistryId | String | Value that uniquely identifies the supplier party. | |
| SupplierId | Long | Value that uniquely identifies the linked supplier. | |
| SupplierName | String | Name of the linked supplier. | |
| SupplierPartId | Long | Value that uniquely identifies the supplier trading partner item. | |
| SupplierPartNumber | String | Number that identifies a supplier 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. |