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 | Date | 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 | Date | 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. | |
| ContactLastUpdateDate | Datetime | False |
The date and time when the opportunity was last updated. | |
| PartyId | Long | False |
The unique identifier of the party. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String |
Input specifying the Finder type. |
| BindUserPartyId | String |
The unique identifier of the contact. |
| PersonProfileId | String |
The unique identifier of the contact. |
| SourceSystem | String |
The name of external source system where the contact party is imported from. |
| SourceSystemReferenceValue | String |
The unique identifier for the contact party from the external source system. |