JDBC Driver for Oracle SCM

Build 22.0.8462

TradingPartnerItems

The Trading Partner Items resource manages the trading partner items such as customer items, competitor items, supplier items and manufacturer part numbers. The trading partner item is an Identifier used by a trading partner to refer to an internal item.

Columns

Name Type Description
TradingPartnerItemId [KEY] 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.
TradingPartnerItemDescription String Description of the trading partner item.
TradingPartnerItemStatus String Status of the trading partner item. A list of accepted values is defined in the lookup type ORA_ACA_MFR_PART_STATUS. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is Null.
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.
StartDate Date Date when the trading partner item becomes effective.
EndDate Date Date when the trading partner item becomes ineffective.
CreationDateTime Datetime Date when the user created the trading partner item.
LastUpdateDateTime Datetime Date when the user most recently updated the trading partner item.
CreatedBy String User who created the trading partner item.
LastUpdateLogin String Login that the user used when updating the trading partner item.
LastUpdatedBy String User who most recently updated the trading partner item.

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