AccountRelationships
The relationship resource is used to view, create, and update account relationships.
Columns
| Name | Type | ReadOnly | References | Description |
| RelationshipRecId [KEY] | Long | False |
This is the primary key of the relationships table. | |
| PartyNumber [KEY] | String | False |
Accounts.PartyNumber | |
| Comments | String | False |
The user-provided comments for the relationship. | |
| CreatedBy | String | False |
The user who created the record. | |
| CreatedByModule | String | False |
The module that created the account record. | |
| CreationDate | Datetime | False |
The date when the record was created. | |
| EndDate | Date | False |
The date when the relationship ends. | |
| LastUpdateDate | Datetime | False |
The date when the record was last updated. | |
| LastUpdatedBy | String | False |
The user who last updated the record. | |
| LastUpdateLogin | String | False |
The login of the user who last updated the record. | |
| ObjectPartyId | Long | False |
The unique identifier of the object party in this relationship. | |
| ObjectPartyNumber | String | False |
The alternate key identifier for the object party of the relationship. | |
| ObjectSourceSystem | String | False |
The name of the external source system for the object party in the relationship. | |
| ObjectSourceSystemReferenceValue | String | False |
The identifier for the object party in the relationship from the external source system. | |
| RelationshipCode | String | False |
The code of the relationship that specifies if this is a forward or a backward relationship code. A list of valid relationship codes is defined in the lookup PARTY_RELATIONS_TYPE. Review and update the codes using the Setup and Maintenance task, Manage Relationship Lookups. | |
| RelationshipSourceSystem | String | False |
The name of external source system where the relationship is imported from. The values configured in setup task Trading Community Source System. | |
| RelationshipSourceSystemReferenceValue | String | False |
The unique identifier for the relationship from the external source system specified in the attribute RelationshipSourceSystem. | |
| RelationshipType | String | False |
The relationship type such as CUSTOMER_SUPPLIER. A list of valid relationship types is defined in the lookup HZ_RELATIONSHIP_TYPE. Review and update the codes using the Setup and Maintenance task, Manage Relationship Lookups. | |
| StartDate | Date | False |
The date when the relationship was created. | |
| Status | String | False |
Indicates if the relationship is active or inactive, such as A for active and I for inactive. A list of valid values is defined in the lookup HZ_STATUS. Review and update the codes using the Setup and Maintenance work area, Manage Standard Lookups task. | |
| SubjectPartyId | Long | False |
The unique identifier of the subject party in this relationship. | |
| SubjectPartyNumber | String | False |
The alternate key identifier for the subject party of the relationship. | |
| SubjectSourceSystem | String | False |
The name of the external source system for the subject party in the relationship. | |
| SubjectSourceSystemReferenceValue | String | False |
The identifier for the subject party in the relationship from the external source system. | |
| AccountLastUpdateDate | 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. |
| FocusPartyId | String |
The unique identifier of the child account to be returned at the top by the Direct Accounts finder. |
| ParentPartyId | String |
The unique identifier of the account used to search the direct child accounts. |
| BindUserPartyId | String |
The unique identifier of the party. Used in MyAccounts finder. |
| OrganizationProfileId | String |
The unique identifier of the organization. |