Item Relationships
The Item Relationships view object contains information on item relationships such as trading partner item relationships, related item relationships, GTIN relationships, cross-references and source system item relationships.
Data Store Key : FscmTopModelAM.ScmExtractAM.EgpBiccExtractAM.ItemRelationshipExtractPVO
Primary Keys : ItemRelationshipBasePEOItemRelationshipId
Initial Extract Date : ItemRelationshipBasePEOCreationDate
Incremental Extract Date : ItemRelationshipBasePEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| EndDateTimeActive | Date and time when the relationship becomes ineffective. |
| ItemRelationshipBasePEOAcdType | Indicates whether this is a production row, change row or change history row. |
| ItemRelationshipBasePEOApprovalStatus | Approval status of the from item in the related item relationship. |
| ItemRelationshipBasePEOAttribute1 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute10 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute11 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute12 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute13 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute14 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute15 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute16 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute17 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute18 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute19 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute2 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute20 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute21 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute22 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute23 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute24 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute25 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute26 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute27 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute28 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute29 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute3 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute30 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute4 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute5 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute6 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute7 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute8 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttribute9 | Segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttributeCategory | Context name for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttributeDate1 | Date segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttributeDate2 | Date segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttributeDate3 | Date segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttributeDate4 | Date segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttributeDate5 | Date segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttributeNumber1 | Number segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttributeNumber10 | Number segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttributeNumber2 | Number segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttributeNumber3 | Number segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttributeNumber4 | Number segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttributeNumber5 | Number segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttributeNumber6 | Number segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttributeNumber7 | Number segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttributeNumber8 | Number segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttributeNumber9 | Number segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttributeTimestamp1 | Date and time segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttributeTimestamp2 | Date and time segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttributeTimestamp3 | Date and time segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttributeTimestamp4 | Date and time segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOAttributeTimestamp5 | Date and time segment for the Item Relationship descriptive flexfield. |
| ItemRelationshipBasePEOChangeLineId | Value that uniquely identifies the change order line. |
| ItemRelationshipBasePEOCreatedBy | User who created the relationship. |
| ItemRelationshipBasePEOCreationDate | Date when the user created the relationship. |
| ItemRelationshipBasePEOCrossReference | Value that identifies the cross-reference. |
| ItemRelationshipBasePEODescription | Description of the relationship. |
| ItemRelationshipBasePEOEndDateActive | Date when the relationship becomes ineffective. |
| ItemRelationshipBasePEOEpcGtinSerial | Value that identifies the electronic product code or the GTIN serial number. |
| ItemRelationshipBasePEOImplementationDate | Date when the change was implemented. |
| ItemRelationshipBasePEOInventoryItemId | Value that uniquely identifies an item. |
| ItemRelationshipBasePEOItemRelationshipId | Value that uniquely identifies the item relationship. |
| ItemRelationshipBasePEOItemRelationshipType | Type of the related item relationship. |
| ItemRelationshipBasePEOLastUpdateDate | Date when the user most recently updated the relationship. |
| ItemRelationshipBasePEOLastUpdateLogin | Login that the user used when updating the relationship last. |
| ItemRelationshipBasePEOLastUpdatedBy | User who most recently updated the relationship translatable attribute. |
| ItemRelationshipBasePEOMasterOrganizationId | Value that uniquely identifies the master organization of the item for which the cross-reference relationship is defined. |
| ItemRelationshipBasePEOOrgIndependentFlag | Indicates if the relationship is applicable to all organizations. |
| ItemRelationshipBasePEOOrganizationId | Value that uniquely identifies the organization in the ItemRelationshipExtractPVO. |
| ItemRelationshipBasePEOPlanningEnabledFlag | Indicates if Planning is enabled for the relationship. |
| ItemRelationshipBasePEOPreferenceNumber | Rank used within the customer item relationship. |
| ItemRelationshipBasePEOReciprocalFlag | Reciprocal status of the relationship. Contains one of the following values: Y or N. If Y, then the related item relationship is reciprocal. If N, it's not reciprocal. |
| ItemRelationshipBasePEORelatedItemId | Value that uniquely identifies the to item in the related item relationship. |
| ItemRelationshipBasePEORelationshipRank | Value that identifies the rank of the related item relationship. |
| ItemRelationshipBasePEORevisionId | Value that uniquely identifies the revision of the item. |
| ItemRelationshipBasePEOSourceSystemId | Value that uniquely identifies the spoke system. |
| ItemRelationshipBasePEOStartDateActive | Date when the relationship becomes effective. |
| ItemRelationshipBasePEOStatusCode | Status of the trading partner item relationship. |
| ItemRelationshipBasePEOSubType | Type of the related item relationship. |
| ItemRelationshipBasePEOTpItemId | Value that uniquely identifies the trading partner item. |
| ItemRelationshipBasePEOTradingPartnerId | Value that uniquely identifies the trading partner. |
| ItemRelationshipBasePEOUomCode | Unit of measure for the GTIN relationship. |
| ItemRelationshipBasePEOVersionEndDate | Date when the version of the item becomes ineffective. |
| ItemRelationshipBasePEOVersionId | Value that uniquely identifies the item version. |
| ItemRelationshipBasePEOVersionStartDate | Date when the new version of the item comes into effect. |
| ItemRelationshipTLPEODescription | Description of the item relationship. |
| ItemRelationshipTLPEOItemRelationshipId | Value that uniquely identifies the item relationship. |
| ItemRelationshipTLPEOLanguage | Value that identifies the language used for the relationship description. |
| StartDateTimeActive | Date and time when the relationship becomes effective. |