Sales Cloud Relationship

An object that includes attributes used to store values while creating or updating a relationship. This object stores attributes that defines and categorizes a relationship between 2 entities such as account, contact and household.

QName: {http://xmlns.oracle.com/apps/crmCommon/salesParties/relationshipService/}Relationship

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type	Object or Service
Handled by	Sales Cloud Relationship

Attributes

The following table describes attributes in the service data object.

Name	Type	Description
Comments	string	The comments for the record.
CreatedBy	string	The user who created the record.
CreatedByModule	string	The module that created the record.
CreationDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	The date when the record was created.
EndDate	{http://xmlns.oracle.com/adf/svc/types/}date-Date	Indicates the date till which the entity is active. This date is inclusive and the status of the entity is dependent on this.
LastUpdateDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	The date when the record was last updated.
LastUpdateLogin	string	The login of the user who last updated the record.
LastUpdatedBy	string	The user who last updated the record.
ObjectPartyId	long	The primary key identifier of the object in this relationship. Either one of ObjectPartyId, ObjectPartyNumber, and combination of ObjectSourceSystem and ObjectSourceSystemReferenceValue, is used to identify the object party of the relationship.
ObjectPartyNumber	string	The unique identification number for the object party of the relationship. One of ObjectPartyId, ObjectPartyNumber, and a combination of ObjectSourceSystem and ObjectSourceSystemReferenceValue, is used to identify the object party of the relationship.
ObjectSourceSystem	string	The name of external source system for the object party in the relationship, which are defined by an admin as part of system setup. One of ObjectPartyId, ObjectPartyNumber, and a combination of ObjectSourceSystem and ObjectSourceSystemReferenceValue, is used to identify the object party of the relationship. The value for this attribute should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL using the setup task, Manage Trading Community Source Systems.
ObjectSourceSystemReferenceValue	string	The identifier for the object party in the relationship from external source system. One of ObjectPartyId, ObjectPartyNumber, and a combination of ObjectSourceSystem and ObjectSourceSystemReferenceValue, is used to identify the object party of the relationship.
RelationshipCode	string	Indicates whether this is a forward or a backward relationship code. A list of valid relationship codes is defined in the lookup PARTY_RELATIONS_TYPE. Review and update the codes using the Setup and Maintenance task, Manage Relationship Lookups.
RelationshipSourceSystem	string	The name of external source system for the relationship, which is defined by an admin as part of the system setup.
RelationshipSourceSystemReferenceValue	string	The identifier for the relationship with the external source system.
RelationshipType	string	The relationship type name. For example, CUSTOMER_SUPPLIER. A list of valid relationship types is defined in the lookup HZ_RELATIONSHIP_TYPE. Review and update the codes using the Setup and Maintenance task, Manage Relationship Lookups.
StartDate	{http://xmlns.oracle.com/adf/svc/types/}date-Date	Indicates the date from which this entity is active. This date is inclusive and the status of an entity is dependent on this.
Status	string	The status of the record.
SubjectPartyId	long	The primary key identifier of the subject in this relationship. Either one of SubjectPartyId, SubjectPartyNumber, and a combination of SubjectSourceSystem and SubjectSourceSystemReferenceValue, is used to identify the subject party of the relationship.
SubjectPartyNumber	string	The alternate key identifier for the subject party of the relationship. One of SubjectPartyId, SubjectPartyNumber, and a combination of SubjectSourceSystem and SubjectSourceSystemReferenceValue, is used to identify the subject party of the relationship.
SubjectSourceSystem	string	The name of external source system for the subject party in the relationship, which are defined by an admin as part of system setup. One of SubjectPartyId, SubjectPartyNumber, and a combination of SubjectSourceSystem and SubjectSourceSystemReferenceValue, is used to identify the subject party of the relationship. The value for this attribute should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL using the setup task, Manage Trading Community Source Systems.
SubjectSourceSystemReferenceValue	string	The identifier for the subject party in the relationship from external source system. One of SubjectPartyId, SubjectPartyNumber, and a combination of SubjectSourceSystem and SubjectSourceSystemReferenceValue, is used to identify the subject party of the relationship.