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 |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contained by |
|
Contained by |
|
Contained by |
|
Handled by |
|
Handled by |
|
Handled by |
|
Handled by |
|
Handled by |
|
Handled by |
|
Handled by |
|
Handled by |
|
Handled by |
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. |
|
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 |
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 |
The organization contact information. |
|
OriginalSystemReference |
The identifier for the record from the original system. |
|
PartyName |
string |
The name of the party. |
PartySite |
The party site associated with the relationship. |
|
PartyUsageAssignment |
The party usage assigned to the relationship. |
|
PercentageOwnership |
decimal |
The percentage of the child entity owned by the parent entity. |
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 |
The relationship type information. |
|
RelationshipRecId |
long |
The unique identifier of the contact's relationship record.
|
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 |
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 |
The web information related to the record. |