JDBC Driver for Oracle SCM

Build 22.0.8462

ItemsLOVRelatedItemRelationships

The Related Item Relationships resource manages relationship between two 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 related item relationship.
OrganizationId String Value that uniquely identifies the organization.
OrganizationCode String Abbreviation that identifies the organization.
MasterControlledFlag Bool Contains one of the following values: true or false. If true, then the relationship is master controlled. If false, the relationship is organization controlled. The default value is true.
FromInventoryItemId String Value that uniquely identifies the from item in the related item relationship.
FromItem String Value that identifies the from item in the related item relationship.
FromItemDescription String Description of the from item in the related item relationship.
FromItemPrimaryUOM String Primary unit of measure of the from item in the related item relationship.
FromItemClass String Item class of the from item in the related item relationship.
FromItemLifecyclePhase String Lifecycle phase of the from item in the related item relationship.
FromItemApprovalStatus String Approval status of the from item in the related item relationship.
FromItemStatus String Status of the from item in the related item relationship.
ToInventoryItemId String Value that uniquely identifies the to item in the related item relationship.
ToItem String Value that identifies the to item in the related item relationship.
ToItemDescription String Description of the to item in the related item relationship.
ToItemPrimaryUOM String Primary unit of measure of the to item in the related item relationship.
ToItemClass String Item class of the to item in the related item relationship.
ToItemLifecyclePhase String Lifecycle phase of the to item in the related item relationship.
ToItemApprovalStatus String Approval status of the to item in the related item relationship.
ToItemStatus String Status of the to item in the related item relationship.
RelationshipType String Type of the related item relationship. A list of accepted values is defined in the lookup type EGP_RELATIONSHIP_TYPES. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is Null.
RelationshipDescription String Description of the related item relationship.
Rank String Rank of the related item relationship.
StartDateTime Datetime Date when the related item relationship becomes effective.
EndDateTime Datetime Date when the related item relationship becomes ineffective.
ReciprocalFlag Bool Contains one of the following values: true or false. If true, then the relationship is mutual. If false, the relationship is not mutual. The default value is false.
PlanningEnabledFlag Bool Contains one of the following values: true or false. If true, then planning is enabled for the relationship. If false, planning is not enabled. The default value is false.
CreationDateTime Datetime Date and time when the user created the related item relationship.
LastUpdateDateTime Datetime Date when the user most recently updated the related item relationship.
CreatedBy String User who created the related item relationship.
LastUpdateLogin String Login that the user used when updating the related item relationship.
LastUpdatedBy String User who most recently updated the related item relationship.

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