Cmdlets for Oracle Sales

Build 25.0.9434

AccountHierarchy

The account hierarchy summaries resource is used to view the account hierarchy information.

Columns

Name Type References Description
PartyId [KEY] Long The unique identifier of the party associated to the given account.
PartyNumber [KEY] String

Accounts.PartyNumber

The unique alternate identifier for the account party.
CreatedBy String The user who created the account hierarchy summary.
CreationDate Datetime The date and time when the account hierarchy summary was created.
LastUpdateDate Datetime The date and time when the account hierarchy summary was last updated.
LastUpdatedBy String The user who last updated the account hierarchy summary.
ParentAccountList String List of all the parent accounts till the top node in the account hierarchy.
ParentAccountName String The parent account name of the given account.
ParentAccountPartyId Long The parent account identifier of the given account.
ParentAccountPartyNumber String The parent account registry identifier of given account.
PartyUniqueName String The unique party name of the party record.
TotalChildAccounts Int The total number of child accounts.
TotalImmediateChildAccounts Int Total number of immediate child of given account.
UltimateParentName String The ultimate parent account name of given account.
UltimateParentPartyId Long The ultimate parent account identifier of given account.
UltimateParentPartyNumber String The ultimate parent account registry identifier of given account.
AccountLastUpdateDate Datetime The date and time when the opportunity was last updated.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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.
SourceSystem String Name of external source system.
SourceSystemReferenceValue String Identifier for this record from external source system.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434