Subscription Product Relationships

The product relationship view object stores information about the subscription product relationships, such as the relationship type, source subscription product PUID, and target subscription product PUID.

Data Store Key : CrmAnalyticsAM.CrmExtractAM.OssBiccExtractAM.ProductRelationshipsExtractPVO

Primary Keys : ProductId, SubscriptionProductId, RelationshipCode

Initial Extract Date : CreationDate

Incremental Extract Date :

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
AmendmentReason	The amendment reason of subscription product relationship.
AmendmentReasonCode	The amendment reason code of subscription product relationship.
CreationDate	The date when the subscription product relationship was created.
EffectiveDate	The effective date of subscription product relationship.
ProductId	The product identifier of subscription product relationship.
ProductPuid	The unique subscription product identifier of subscription product relationship.
RelatedLineName	The related line name of subscription product relationship.
RelatedLineNumber	The related line number of subscription product relationship.
RelatedLinePuid	The unique related line identifier of subscription product relationship.
RelatedLineStatus	The related line status of subscription product relationship.
RelatedLineStatusCode	The related line status code of subscription product relationship.
RelatedLineSubscriptionId	The related line subscription identifier of subscription product relationship.
RelatedSubscriptionNumber	The related line subscription number of subscription product relationship.
Relationship	The name of subscription product relationship.
RelationshipCode	The relationship code of subscription product relationship.
SubscriptionId	The subscription identifier of subscription product relationship.
SubscriptionProductId	The subscription product identifier of subscription product relationship.