RelatedItemRelationships
The Related Item Relationships resource manages relationship between two items.
Columns
| Name | Type | Description |
| ItemRelationshipId [KEY] | 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. |