SupplierProductsproductRelationships
The Product Relationships resource is used to manage product relationships of supplier products.
Columns
| Name | Type | Description |
| SupplierProductsTransactionId | String | SupplierProductsTransactionId of SupplierProductsproductRelationships |
| CreatedBy | String | CreatedBy of SupplierProductsproductRelationships |
| CreationDate | Datetime | CreationDate of SupplierProductsproductRelationships |
| CrossReference | String | Value that uniquely identifies the cross-reference of an item. |
| RelationshipDescription | String | Description of the item relationship. |
| EndDate | Datetime | Date and time when the item relationship ends or is no longer active. |
| EPCGTINSerial | String | Value that uniquely identifies the electronic product code (EPC) or global trade item number (GTIN) identifier for the GTIN item relationship. |
| InterfaceTableUniqueId | String | Value that uniquely identifies the product relationship row in staging. |
| FromItemNumber | String | Name or number of the item from which the relationship is created. |
| ItemRelationshipType | String | Value that indicates the type of trading partner item relationship. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| LastUpdateDate | Datetime | LastUpdateDate of SupplierProductsproductRelationships |
| LastUpdatedBy | String | LastUpdatedBy of SupplierProductsproductRelationships |
| MasterOrganizationCode | String | Abbreviation that identifies the organization. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task. |
| MasterOrganizationId | String | Value that uniquely identifies the organization. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task. |
| OrganizationIndependentFlag | Bool | Contains one of the following values: true or false. If true, then the item relationship is applicable across all organizations. If false, then the item relationship is not applicable across all organizations. This attribute does not have a default value. |
| OrganizationCode | String | Abbreviation that identifies the item cross-reference relationship organization. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task. |
| OrganizationId | String | Value that uniquely identifies the item cross-reference relationship organization. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task. |
| PlanningEnabledFlag | Bool | Contains one of the following values: true or false. If true, then planning is enabled for related item. If false, then planning is not enabled for related item. This attribute does not have a default value. |
| PreferenceNumber | String | Number that indicates the rank of the trading partner item relationship. |
| ReciprocalFlag | Bool | Contains one of the following values: true or false. If true, then a reciprocal relationship exists in the item relationship. If false, then a reciprocal relationship does not exists in the item relationship. This attribute does not have a default value. |
| ToItemNumber | String | Name or number of the item for which the relationship is created. |
| SpokeSystemId | String | Value that uniquely identifies the spoke system. Review and update the value for this attribute using the Product Information Management work area, and the Manage Spoke Systems task. |
| ProductNumber | String | Name or number of the spoke part, item, product, or service. |
| StartDate | Datetime | Date and time when the item relationship begins or becomes active. |
| SubType | String | Abbreviation that identifies the party type of the GTIN in item relationship. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| TradingPartnerItemNumber | String | Name or number of the item from a trading partner. |
| TradingPartnerNumber | String | Number that identifies the trading partner. |
| TransactionId | String | Value that identifies the product row in the staging interface. |
| TransactionType | String | Type of action to be taken when importing a record. Valid values include SYNC and DELETE. |
| UOMCode | String | Unit of measure code of the global trade item number (GTIN) relationship. |
| UOMName | String | Unit of measure name of the global trade item number (GTIN) relationship. |
| SubTypeValue | String | Value that indicates the party type of the global trade item number (GTIN) in item relationship. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| CrossReferenceTypeValue | String | Value that indicates the type of cross-reference relationship. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| RelationshipTypeValue | String | Value that indicates the type of related item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| UOMCodeValue | String | Unit of measure of the global trade item number (GTIN) relationship. |
| SpokeSystemCode | String | Abbreviation that identifies the spoke system. Review and update the value for this attribute using the Product Information Management work area, and the Manage Spoke Systems task. |
| CompetitorSubTypeValue | String | Value that indicates the type of the competitor trading partner item in the item relationship. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| SupplierId | String | Value that uniquely identifies the supplier. Review and update the value for this attribute using the Supplier Portal work area, and the Manage Suppliers task. |
| SupplierName | String | Name of the supplier. Review and update the value for this attribute using the Supplier Portal work area, and the Manage Suppliers task. |
| RelationshipStatusCode | String | Abbreviation that uniquely identifies the status of trading partner item relationship. A list of accepted values is defined in the lookup type ORA_ACA_AML_STATUS. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Product Development Lookups task. |
| RelationshipStatusValue | String | Status of trading partner item relationship. A list of accepted values is defined in the lookup type ORA_ACA_AML_STATUS. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Product Development Lookups task. |
| RelatedItemRelationshipRank | String | Rank of the related item relationship. |