FireDAC Components for Oracle Sales Cloud

Build 20.0.7654

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 Datetime 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 Datetime 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.

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