Relationship

The relationship between two trading community members. For example, John Doe is the spouse of Jane Doe or Michael Smith is a contact of Oracle Corporation.

QName: {http://xmlns.oracle.com/apps/cdm/foundation/parties/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
Contains	Trading Community Relationship Additional Information
Contains	Instant Messaging
Contains	Phone
Contains	Address
Contains	Customer Contact Profile
Contains	Email
Contains	Source System Reference
Contains	Usage Assignment
Contains	Web
Contained by	Trading Community Person Details
Contained by	Household
Contained by	Trading Community Organization Details
Handled by	Trading Community Group
Handled by	Trading Community Organization
Handled by	Sales Account Service
Handled by	Sales Party
Handled by	Company and User Registration
Handled by	Sales Party Resource Service
Handled by	Sales Party Territory service
Handled by	Partner Service
Handled by	Trading Community Person Information

Attributes

The following table describes attributes in the service data object.

Name	Type	Description
AdditionalInformation1	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type. For operating unit and legal entity to bank relationships, column stores communication agreement ID, which identifies agreement between payer and bank on type of EDIFACT documents that can be sent for processing payments.
AdditionalInformation10	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation11	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation12	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation13	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation14	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation15	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation16	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation17	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation18	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation19	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation2	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation20	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation21	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation22	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation23	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation24	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation25	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation26	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation27	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation28	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation29	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation3	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation30	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation4	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation5	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation6	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation7	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation8	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
AdditionalInformation9	string	The extensible attribute used for application-specific functionality. The column values depend on relationship type.
Comments	string	The comments for the record.
CorpCurrencyCode	string	The corporate currency code associated with the record. This attribute is used by CRM Extensibility framework.
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.
CurcyConvRateType	string	The currency conversion rate associated with the record. This attribute is used by CRM Extensibility framework.
CurrencyCode	string	The currency code. This attribute is used by CRM Extensibility framework.
DirectionCode	string	The code of the relationship direction. The list of accepted values are defined in the lookup DIRECTION_CODE.
Email	E-Mail	The email address associated with the record.
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.
InstantMessaging	Instant Messaging	The instant messaging information related to the record.
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.
ObjectEmailAddress	string	The e-mail address of the object party in the relationship.
ObjectId	long	The unique identifier of the object party in this relationship.
ObjectPartyName	string	The name of the object party in this relationship.
ObjectTableName	string	The source table name of the object party in this relationship.
ObjectType	string	The object type of the relationship.
ObjectUsageCode	string	The usage code of object party in the relationship.
ObjectVersionNumber	int	The number used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row.
OrganizationContact	Customer Contact Profile	The organization contact information.
OriginalSystemReference	Source System Reference	The identifier for the record from the original system.
PartyName	string	The name of the party.
PartySite	Address	The party site associated with the relationship.
PartyUsageAssignment	Usage Assignment	The party usage assigned to the relationship.
PercentageOwnership	decimal	The percentage of the child entity owned by the parent entity.
Phone	Phone	The phone information for the entity.
PreferredContactFlag	boolean	Indicates if this contact person is primary contact for the customer.
PrimaryCustomerFlag	boolean	Indicates if this customer is primary customer for the contact.
RelationshipCode	string	The code for a forward or a backward relationship. A list of accepted relationship values is defined in the lookup PARTY_RELATIONS_TYPE.
RelationshipId	long	The relationship identifier for the record.
RelationshipInformation	Trading Community Relationship Additional Information	The relationship type information.
RelationshipRecId	long	The unique identifier of the contact's relationship record. Primary Key
RelationshipType	string	The relationship type name. For example, CUSTOMER_SUPPLIER. A list of valid relationship types is defined in the lookup HZ_RELATIONSHIP_TYPE.
RequestId	long	A system-generated read-only attribute used by the application framework.
Role	string	The role between the subject and object party in this relationship.
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.
SubjectEmailAddress	string	The e-mail address of the subject party in relationship.
SubjectId	long	The unique identifier of the subject in this relationship.
SubjectPartyUsageAssignment	Usage Assignment	The usage assignment of the subject party in the relationship.
SubjectTableName	string	The source table of the subject.
SubjectType	string	The subject type of the relationship.
SubjectUsageCode	string	The usage code of subject party in the relationship.
Web	Web	The web information related to the record.