JDBC Driver for Oracle SCM

Build 22.0.8462

ItemsLOVTradingPartnerItemRelationships

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
ItemsLOVItemId String Value that uniquely identifies the organization. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task.
ItemsLOVOrganizationId String Find items according to the specified primary key criteria.
ItemRelationshipId String Value that uniquely identifies the trading partner item relationship.
OrganizationId String Value that uniquely identifies the organization.
OrganizationCode String Abbreviation that identifies the organization.
InventoryItemId String 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 String 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 String 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 Date and time when the user created the trading partner item relationship.
LastUpdateDateTime Datetime Date when the user most recently updated the trading partner item relationship.
CreatedBy String User who created the trading partner item relationship.
LastUpdateLogin String Login that the user used when updating the trading partner item relationship.
LastUpdatedBy String User who most recently updated the trading partner item relationship.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462