TradingPartnerItemRelationships
The Trading Partner Item Relationships resource manages the trading partner item relationships that are relationships between internal items and trading partner items.
Columns
| Name | Type | Description |
| ItemRelationshipId [KEY] | Long | Value that uniquely identifies the trading partner item relationship. |
| OrganizationId | Long | Value that uniquely identifies the organization. |
| OrganizationCode | String | Abbreviation that identifies the organization. |
| InventoryItemId | Long | Value that uniquely identifies an item. |
| Item | String | Name or number of the part, item, product, or service. |
| TradingPartnerType | String | Type of the trading partner. |
| TradingPartnerId | String | Value that uniquely identifies the trading partner. |
| TradingPartnerName | String | Name of the trading partner. |
| RegistryId | String | Value that uniquely identifies the party. |
| TradingPartnerItemId | Long | Value that uniquely identifies the trading partner item. |
| TradingPartnerItemNumber | String | Number that identifies a trading partner item, such as supplier item, customer item, competitor item, and manufacturer part number. |
| RelationshipDescription | String | Description of the trading partner item relationship. |
| StartDateTime | Datetime | Date when the trading partner item relationship becomes effective. |
| EndDateTime | Datetime | Date when the trading partner item relationship becomes ineffective. |
| CustomerItemRelationshipRank | Long | Rank used within the customer item relationship. |
| CompetitorItemRelationshipType | String | Type of competitor for the item relationship. |
| RelationshipStatus | String | Status of the trading partner item relationship. |
| CreationDateTime | Datetime | CreationDateTime of TradingPartnerItemRelationships |
| LastUpdateDateTime | Datetime | LastUpdateDateTime of TradingPartnerItemRelationships |
| CreatedBy | String | CreatedBy of TradingPartnerItemRelationships |
| LastUpdateLogin | String | LastUpdateLogin of TradingPartnerItemRelationships |
| LastUpdatedBy | String | LastUpdatedBy of TradingPartnerItemRelationships |
| TradingPartnerItemDescription | String | TradingPartnerItemDescription of TradingPartnerItemRelationships |
| TradingPartnerItemStatus | String | TradingPartnerItemStatus of TradingPartnerItemRelationships |
| TradingPartnerStatus | String | TradingPartnerStatus of TradingPartnerItemRelationships |
| EffectiveDate | Datetime | EffectiveDate of TradingPartnerItemRelationships |
| Finder | String | Finder of TradingPartnerItemRelationships |
| ItemNumber | String | ItemNumber of TradingPartnerItemRelationships |