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	Address
Contains	E-Mail
Contains	Source System Reference
Contains	Instant Messaging
Contains	Usage Assignment
Contains	Trading Community Relationship Additional Information
Contains	Web
Contains	Phone
Contains	Customer Contact Profile
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	Company and User Registration
Handled by	Sales Account Service
Handled by	Sales Party
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	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type. For operating unit and legal entity to bank relationships, the 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	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation11	string	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation12	string	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation13	string	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation14	string	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation15	string	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation16	string	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation17	string	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation18	string	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation19	string	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation2	string	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation20	string	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation21	string	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation22	string	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation23	string	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation24	string	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation25	string	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation26	string	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation27	string	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation28	string	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation29	string	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation3	string	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation30	string	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation4	string	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation5	string	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation6	string	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation7	string	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation8	string	This is a developer extensible attribute and is reserved for application-specific functionality. The column values depend on relationship type.
AdditionalInformation9	string	This is a developer extensible attribute and is reserved 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 for the relationship direction. It is validated by the DIRECTION_CODE lookup type. The accepted values are Parent, Child, and Not Directional.
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	E-mail of the object party in relationship.
ObjectId	long	The identifier of the object in this relationship.
ObjectPartyName	string	Name of the object party in this relationship.
ObjectTableName	string	Source table name for the object.
ObjectType	string	Object type of the relationship.
ObjectUsageCode	string	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	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	Address information related to the relationship.
PartyUsageAssignment	Usage Assignment	Party usage assignment information for the relationship.
PercentageOwnership	decimal	Percentage of child entity owned by its parent entity.
Phone	Phone	The phone information for the entity.
PreferredContactFlag	boolean	Indicates if this contact person is primary contact for the e customer.
PrimaryCustomerFlag	boolean	Indicates if this customer is primary customer for the contact.
RelationshipCode	string	Either a forward or a backward relationship code.
RelationshipId	long	The relationship identifier for the record.
RelationshipInformation	Trading Community Relationship Additional Information	Relationship type Information.
RelationshipRecId	long	The sequence generated unique identifier of the relationship record. Primary Key
RelationshipType	string	The relationship type name. For example, CUSTOMER_SUPPLIER.
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	E-mail of the subject party in relationship.
SubjectId	long	The identifier of the subject in this relationship.
SubjectPartyUsageAssignment	Usage Assignment	Subject party usage assignment information for the relationship.
SubjectTableName	string	Source table name for the subject.
SubjectType	string	Subject type of the relationship.
SubjectUsageCode	string	Usage code of subject party in the relationship.
Web	Web	The web information related to the record.