JDBC Driver for Oracle Sales Cloud

Build 20.0.7654

ContactRelationships

The relationship resource includes attributes that are used to store values while viewing, creating, or updating a relationship.

Columns

Name Type ReadOnly References Description
RelationshipRecId [KEY] Long False

This is the primary key of the relationships table.

PartyNumber [KEY] String False

Contacts.PartyNumber

Comments String False

User comments for the relationship.

CreatedBy String False

The user who created the relationship record.

CreatedByModule String False

The application module that created this organization record. The default value for CreatedByModule is HZ_WS for all Web service based creation. A list of accepted values is defined in the lookup type HZ_CREATED_BY_MODULES. Review and update the value for this attribute using the Setup and Maintenance task work area, Manage Trading Community Common Lookups task.

CreationDate Datetime False

The date and time when the relationship record was created.

EndDate Datetime False

The date when the relationship ends.

LastUpdateDate Datetime False

The date and time when the relationship data was last updated.

LastUpdatedBy String False

The user who last updated the relationship record.

LastUpdateLogin String False

The session login associated to the user who last updated the relationship record.

ObjectPartyId Long False

The primary key identifier of the contact, in this relationship. One of ObjectPartyId, ObjectPartyNumber and ObjectSourceSystem along with ObjectSourceSystemReferenceValue combination is used to identify the contact party of the relationship.

ObjectPartyNumber String False

The unique alternate identifier for the relationship of the contact party. One of ObjectPartyId, ObjectPartyNumber and ObjectSourceSystem along with ObjectSourceSystemReferenceValue combination is used to identify the object party of the relationship.

ObjectSourceSystem String False

The name of external source system for the contact party in the relationship, which are defined by an admin as part of system setup. One of ObjectPartyId, ObjectPartyNumber and ObjectSourceSystem along with ObjectSourceSystemReferenceValue combination is used to identify the object party of the relationship. A list of accepted values should be pre-defined in the lookup type HZ_ORIG_SYSTEMS_VL. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Source Systems task.

ObjectSourceSystemReferenceValue String False

The identifier from external source system for the relationship of the contact party. One of ObjectPartyId, ObjectPartyNumber and ObjectSourceSystem along with ObjectSourceSystemReferenceValue combination is used to identify the contact party of the relationship.

RelationshipCode String False

The code for a forward or a backward relationship. A list of accepted relationship values is defined in the lookup PARTY_RELATIONS_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Relationship Lookups.

RelationshipSourceSystem String False

The name of external source system for the relationship, which are defined by an Admin as part of system setup.

RelationshipSourceSystemReferenceValue String False

The identifier from external source system for the relationship.

RelationshipType String False

The type of relationship of a contact party, such as CUSTOMER_SUPPLIER. A list of accepted relationship type values is defined in the lookup HZ_RELATIONSHIP_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Relationship Lookups task.

StartDate Datetime False

Date on which this relationship becomes active.

Status String False

The status of the relationship. Indicates if this is an active or inactive relationship. The values A indicate an active relationship and I an inactive relationship. This is an internal column and user is not expected to pass in a value. A list of accepted values is defined in the lookup HZ_STATUS. Review and update the values for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.

SubjectPartyId Long False

The primary key identifier of the subject in this relationship. One of SubjectPartyId, SubjectPartyNumber and SubjectSourceSystem along with SubjectSourceSystemReferenceValue combination is used to identify the subject party of the relationship.

SubjectPartyNumber String False

The alternate unique identifier for the subject party of the relationship. One of SubjectPartyId, SubjectPartyNumber and SubjectSourceSystem along with SubjectSourceSystemReferenceValue combination is used to identify the subject party of the relationship.

SubjectSourceSystem String False

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 SubjectSourceSystem along with SubjectSourceSystemReferenceValue combination is used to identify the subject party of the relationship. A list of accepted values should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Source Systems task.

SubjectSourceSystemReferenceValue String False

The identifier from external source system for the subject party in the relationship. One of SubjectPartyId, SubjectPartyNumber and SubjectSourceSystem along with SubjectSourceSystemReferenceValue combination is used to identify the subject party of the relationship.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654